Our company receives money before we actually pay the supplier and we are looking to get our sage automatic, however, when we receive a payment I have to raise a purchase/supplier invoice and then when we pay the supplier this is marked as paid. Does anybody know of any software that we can use to allow Sage to automatically raise a purchase invoice for 10% less each time?
There may well be possibilities for doing what you want with a paid for product such as Excel2Sage.
Another possibility, free but requiring a bit of up front effort, would be to use Excel to create an XML file that looks like an incoming Transaction Email invoice from a supplier for 90% of the value of the money received. Sage would create the Purchase Invoice(s) automatically from the XML file(s).