In our ERP system, the invoice line calculation is done in reverse. Users enter the quantity, total amount (including VAT), and discount amount. The system then calculates the unit price, amount before discount, amount after discount and VAT amount.
We face a recurring rounding issue with the formula:
Net Amount (BT-131) =
(Quantity (BT-129) * (Net Price (BT-146) / Price Base Quantity (BT-149))) + Charge Amount (BT-141) - Allowance Amount (BT-136)
To resolve this, we are considering setting the quantity as 1 and using the amount after discount as the unit price. This change would only apply in the XML sent to ZATCA, while the PDF would still display the original calculation.
Example 1: Current Method
- Quantity: 5
- Unit Price: 20
- Amount: 100
- Discount Amount: 10
- Amount After Discount: 90
- VAT Amount (15%): 13.50
- Net Amount: 103.50
Example 2: Proposed Method (Quantity as 1)
- Quantity: 1 (Constant)
- Unit Price: 90 (Same as Amount After Discount)
- Amount: 90
- Discount Amount: 10
- Amount After Discount: 90
- VAT Amount (15%): 13.50
- Net Amount: 103.50
Questions:
- Is this method valid for ZATCA compliance?
- Could using this method in XML while keeping the old method in the PDF cause any issues?
Any insights would be greatly appreciated!