Purchase Invoices - Multiple tax codes (1 reply)
David, correct. There are two ways to handle tax on both the Purchase & Sales Invoices: line by line; or as a summary.
Line By Line
When setting tax on a line there are three fields (Tax Code, Discount Amount & Tax Amount). When setting these you can specify tax on a line basis.
The tax for each of the lines will be totalled by tax code and entered as a summed tax line; the goods amount comes from the line amount.
We've done this as it greatly simplifies the data structure needed to create invoices; it naturally matches the data you may receive from an external solution.
Summary
When setting tax as a summary amount, this matches how tax is entered in Sage.
It allows you to specify all fields as per the UI.
It does requires a separate child transaction to the detail lines, thus making the data structure more complex.
I have attached screenshots for both.
In Sage 200, a purchaseInvoiceInstrument can have multiple tax analysis items to support the posting of invoices which have more than one vat/tax code.
According to your online documentation, tax can be posted on a line-by-line basis. Am I right in thinking that IMan's 200 connector can support purchase invoices where the invoice lines are taxed differently? For example, a purchase invoice may have one line taxed at 20% VAT and another line which is zero-rated for VAT.