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.. 😔
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?