Allowance Charge Total Exclusive from VAT at document level

XML and business rules
1

I’m attempting to apply a discount Exclusive from VAT at document level, but the rules are not allowing me. invoice containing three invoice lines with a VAT category of ‘S’. this is my example:

“allowanceCharge”: {
“allowanceReason”: “discount”,
“amount”: “100.00”,
“taxCategory”: {
“id”: “O”,
“percent”: “0.00”
}
},
“legalMonetaryTotal”: {
“lineExtensionAmount”: “300”,
“allowanceTotalAmount”: “100.00”,
“taxExclusiveAmount”: “300.0”,
“taxInclusiveAmount”: “345.00”,
“prePaidAmount”: “0.00”,
“payableAmount”: “245.00”
},

and the calculation is totally correct following this formula:

  • 300 SAR * 15%(VAT) = 345 SAR - 100 SAR(DISC.) = 245 SAR *
2

Dear @integration ,

please share with us the invoice through the relationship manager, as the VAT categories are not fully clear S or O also multiple fields are included in the calculations.

Regards,

1 Like
3

Dear @kiaziz
my question is totally simple:
there are two types of discounts in KSA. one is a discount including the vat and one is a discount excluding the vat, I’m asking about the second one is the **discount excluding of vat **.
how we can integrate it in the xml!

**this is an example: **

"allowanceCharge": {
"allowanceReason": "discount",
"amount": "100.00",
"taxCategory": {
"id": "O",
"percent": "0.00"
}
},
"legalMonetaryTotal": {
"lineExtensionAmount": "300",
"taxExclusiveAmount": "300.0",
"taxInclusiveAmount": "345.00",
"prePaidAmount": "0.00",
"allowanceTotalAmount": "100.00",
"payableAmount": "245.00"
},

and the calculation is totally correct following this formula:

300 SAR * 15% (VAT) = 300 SAR + 45 VAT = 345 SAR ( taxInclusiveAmount )

So, the discount will be after like

345.00 - 100.00 ( allowanceTotalAmount ) = 245.00 ("payableAmount")
(NB : VAT Still 45.00)
4

yes it’s correct like this.

we asked for the invoice to check the invoice lines calculations as well,
but if you are asking about this one only, then no need to share the invoice.
it’s correct.

Regards,

5

I have a similar scenario and could not have a valid XML.

I have a line level discount that need to be excluded from VAT amount calculation.

Example:
Qty = 1
Price = 100
Line Level Allowance = 10 (%10)

But I need the VAT Amount to be calculated on 100 (Qty * Price) = 15

The output should be like this:
TaxInclusiveAmount = (Qty * Price) + Tax Amount - Discount
TaxInclusiveAmount = 100 + 15 - 10 = 105

What is the correct XML for the above scenario ?

6

Do you have a solution to this problem and perhaps an example of an XML file? Thank you.