Skip to Content
0
Former Member
Dec 13, 2013 at 01:56 AM

VAT

26 Views

Hi experts!

We are trying to integrate a front office system with SAP. However, we get discrepancies with the vat amounts. We first uploaded the Net amount (total lc) then tag which vat group to use. We also tried uploading both Net & Gross amounts, but still with same result.. 😔

Sample data:

front office system: Gross php1,400; Net php1,250; Vat php150

uploaded to SAP: Gross php1,400; Net php1,250; Vat php149.99

We tried testing the data by manually encoding them to SAP, then saw inconsistencies:

1st try: encoded php2,000 @ gross price = Net php1,785.72; Vat php214.28

2nd try: encoded php1,785.71 @ total (lc) = Gross php2,000; Vat php214.28

3rd try: encoded php2,000 @ gross price = Net php1,785.71; Vat php214.29

i expected the same results with the 1st & 3rd tries, but they're not.. why is this?

Attachments

vat scrnshot.png (61.8 kB)