Hi,

Has anyone come across a problem positing invoices to Sage50 2012 using the SDATA interface, with regard to VAT calculation? I'm finding that if a discount is applied to an invoice line, the VAT is incorrectly calculated. I can't find any reason for this - so thinking it's a bug. Any ideas or similar experiences?

Attached is a screen shot of a line that should be 20% VAT.

Brian Mcnally attached the following image(s):

Sorry, I'm not entirely clear on what the problem is. Is it that the 0.64 VAT is not what you were expecting?

It would be worth trying to create an invoice manually in the Accounts application using the same customer and product as you are using via the Sdata feeds and confirm the values that you see there. They should match as the Accounts Sdata adapter uses the same code to calculate discounts, VAT, etc as used in the main application.

There are things such as settlement discount that would affect the VAT which would be worth checking. For example if the customer had a 5% settlement discount that would give you a 0.64 VAT value:

Price: 3.72
Manual discount: 10% = 0.37
Settlement discount: 5% = 0.17
Final price: 3.72 - 0.37 - 0.17 = 3.18
VAT: 20% = 0.64

Hope that helps.