“Invoice total amount without VAT (BT-109) = S Invoice line net amount (BT-131) - Sum of allowances on document level (BT-107) + Sum of charges on document level (BT-108)… Allowance/Charge amount (BT-92, BT-99, BT-136, BT-141) must equal base amount (BT-93, BT-100, BT-137, BT-142) * percentage (BT-94, BT-101, BT-138, BT-143) / 100 if base amount and percentage exists.”
I’m experiencing some confusion regarding BT-109 and BT-147 in the Invoice XML Implementation Standard. I attempted to apply the formula outlined in the standard to calculate discounts for individual products and the total invoice amount, but it seems to be yielding incorrect results. Could you please provide examples of e-invoices that include discounts for both individual products and the entire invoice? This would help me better understand how to properly implement these elements.
as an IDEA … Item net price (BT-146) must equal (Gross price (BT-148) - Allowance amount (BT-147)) when gross price is provided
the condition is " WHEN GROSS PRICE IS PROVIDED"
Gross price like List price …which is always is greater than selling price
selling price … still you have another chance for item discount to get ITEM NET PRICE.
SO you can ignore wsing gross price & use net price
and net price for an item can be discounted in the Items Lines with Reason “Discount”
In the sample you provided, the discount is on the invoice-line level, not the document level. You can find the sample for the document level attached by @lalomar.
In your case, the TaxExclusiveAmount = 145.64, which is true if you have a document-level discount of 2.18.
If you require any additional information, please do not hesitate to reach out.
The example I shared with you is the one that resulted in the error, which I believe stemmed from a misunderstanding of how to properly discounts in invoices. Could you provide examples of invoices containing both invoice-line level and document level discounts? Additionally, when you refer to “document level,” does it imply the discount applies to the entire invoice?
Although I’ve reviewed the Electronic Invoice XML Implementation Standard in the E-Invoicing resolution, I still require further examples and explanations to grasp it fully.