Warning Message Related To Line Extension Amount

XML and business rules
1

Dear ZATCA Team / @Ankit_Tiwari @Embro,

We are receiving a warning message on the Standard Invoice when we have Allowance on document level. This is some thing related to Line Extension Amount in Invoice Lines but we have checked everything, seems amounts are correct. Can you please guide us.

I am attaching the warning message and XML File Content for your reference.
Appreciate your help in this.

Invoice line net amount (BT-131) must equal (Invoiced quantity (BT-129) * (Item net price (BT-146) / item price base quantity (BT-149))) + Sum of invoice line charge amount (BT-141) - Sum of invoice line allowance amount (BT-136)

image
image603×1005 251 KB

urn:oasis:names:specification:ubl:dsig:enveloped:xades urn:oasis:names:specification:ubl:signature:1 urn:oasis:names:specification:ubl:signature:Invoice not(//ancestor-or-self::ext:UBLExtensions) not(//ancestor-or-self::cac:Signature) not(//ancestor-or-self::cac:AdditionalDocumentReference[cbc:ID='QR']) VaCg8UrPDF9OzPOXnDnqlAajJqDH8yPECCV2ISDhvtw= ZTM0M2M2ODJiNjQxMGJmMzMyZjk2NzNlYTNjZWJkMDU4NTM0NmI4OTE3MmE5OWYzY2IzYTgyMTQ4YjA1NWE1MA== MEYCIQCBDIeDb+0ugR+03huUNDZkysWHN2RfD6o1no1o8Ja9GAIhALmNJRyacLa1FY+vz0G2XT92KDhwAA1+xP9AFMtc3TFU MIIE2DCCBH+gAwIBAgITEwAAKS4ItsyO9HMczwABAAApLjAKBggqhkjOPQQDAjBiMRUwEwYKCZImiZPyLGQBGRYFbG9jYWwxEzARBgoJkiaJk/IsZAEZFgNnb3YxFzAVBgoJkiaJk/IsZAEZFgdleHRnYXp0MRswGQYDVQQDExJQRVpFSU5WT0lDRVNDQTItQ0EwHhcNMjMxMjA1MTExNzAxWhcNMjUxMjA1MTEyNzAxWjBPMQswCQYDVQQGEwJTQTESMBAGA1UEChMJU2VpZG9yT25lMRgwFgYDVQQLEw8zMTA0NzQ1MzIzMDAwMDMxEjAQBgNVBAMTCVNlaWRvck9uZTBWMBAGByqGSM49AgEGBSuBBAAKA0IABKU0G99E7n6wYgZyT//pB+/CQkMZwG2NzK52CQwgEZlxor56c+QZAIhH+sOt+FcRmAMxvFR0iWL8QtmQN1bGM5GjggMoMIIDJDCBkgYDVR0RBIGKMIGHpIGEMIGBMSswKQYDVQQEDCIxLVNlaWRvcnwyLTIwMjMxMTE1LjN8My01Q0Q5NTI3TTVDMR8wHQYKCZImiZPyLGQBAQwPMzEwNDc0NTMyMzAwMDAzMQ0wCwYDVQQMDAQxMTAwMQ8wDQYDVQQaDAZSaXlhZGgxETAPBgNVBA8MCFNvZnR3YXJlMB0GA1UdDgQWBBTtRpBf9ust1MSrbO7FHUWjG1wURDAfBgNVHSMEGDAWgBSB8qN7cnu9UKNqn/Ho043We5xwtTCB5QYDVR0fBIHdMIHaMIHXoIHUoIHRhoHObGRhcDovLy9DTj1QRVpFSU5WT0lDRVNDQTItQ0EoMSksQ049UFJaRUlOVk9JQ0VQS0kyLENOPUNEUCxDTj1QdWJsaWMlMjBLZXklMjBTZXJ2aWNlcyxDTj1TZXJ2aWNlcyxDTj1Db25maWd1cmF0aW9uLERDPWV4dHphdGNhLERDPWdvdixEQz1sb2NhbD9jZXJ0aWZpY2F0ZVJldm9jYXRpb25MaXN0P2Jhc2U/b2JqZWN0Q2xhc3M9Y1JMRGlzdHJpYnV0aW9uUG9pbnQwgc4GCCsGAQUFBwEBBIHBMIG+MIG7BggrBgEFBQcwAoaBrmxkYXA6Ly8vQ049UEVaRUlOVk9JQ0VTQ0EyLUNBLENOPUFJQSxDTj1QdWJsaWMlMjBLZXklMjBTZXJ2aWNlcyxDTj1TZXJ2aWNlcyxDTj1Db25maWd1cmF0aW9uLERDPWV4dHphdGNhLERDPWdvdixEQz1sb2NhbD9jQUNlcnRpZmljYXRlP2Jhc2U/b2JqZWN0Q2xhc3M9Y2VydGlmaWNhdGlvbkF1dGhvcml0eTAOBgNVHQ8BAf8EBAMCB4AwPAYJKwYBBAGCNxUHBC8wLQYlKwYBBAGCNxUIgYaoHYTQ+xKG7Z0kh877GdPAVWaBnNgtg+XFXQIBZAIBEDAdBgNVHSUEFjAUBggrBgEFBQcDAgYIKwYBBQUHAwMwJwYJKwYBBAGCNxUKBBowGDAKBggrBgEFBQcDAjAKBggrBgEFBQcDAzAKBggqhkjOPQQDAgNHADBEAiBNbeq934OYukkjqq0RdV26sQPq9QrvPrJU/BcmuTZBPwIgdEURksJv7EEPhAoZHMBhHo9ygPHuygAGbapvP+OCpf0= 2024-06-11T14:17:36 YjJmOWE5NjE0MmU0NDUzMmZjNmY5NzIyM2ZlMTEyYjQ3YTk0MGViZTNlNjdhMTM0MjU2NWJlYWVlZGM5MjQ2Ng== CN=PEZEINVOICESCA2-CA, DC=extgazt, DC=gov, DC=local 423714213509452064473502167434582764491385134 reporting:1.0 1600 be90ab21-de6a-4f02-9b13-bbb3ba25e2ae 2024-06-11 12:08:00 388 ABC SAR SAR ICV 1600 PIH uMVHrIWZmkf5DrrvvXImKv969r2zeZDIhzbt/4TSYh8= QR ARZTZWlkb3IgT25lIE1pZGRsZSBFYXN0Ag8zMTA0NzQ1MzIzMDAwMDMDEzIwMjQtMDYtMTFUMTI6MDg6MDAEBzI4NjMuNTAFBjM3My41MAYsVmFDZzhVclBERjlPelBPWG5EbnFsQWFqSnFESDh5UEVDQ1YySVNEaHZ0dz0HYE1FWUNJUUNCREllRGIrMHVnUiswM2h1VU5EWmt5c1dITjJSZkQ2bzFubzFvOEphOUdBSWhBTG1OSlJ5YWNMYTFGWSt2ejBHMlhUOTJLRGh3QUExK3hQOUFGTXRjM1RGVQhYMFYwEAYHKoZIzj0CAQYFK4EEAAoDQgAEpTQb30TufrBiBnJP/+kH78JCQxnAbY3MrnYJDCARmXGivnpz5BkAiEf6w634VxGYAzG8VHSJYvxC2ZA3VsYzkQ== urn:oasis:names:specification:ubl:signature:Invoice urn:oasis:names:specification:ubl:dsig:enveloped:xades 310474532300003 Clockhouse Place 1233 1234 Feltham Feltham 12345 RY SA 310474532300003 VAT Seidor One Middle East 310474532300003 Hendon Way 1234 1234 Riyadh Riyadh 12345 RY SA VAT عمر نسيم & Umar Naseem 2024-07-11 2024-07-11 10 false Discount 10.00 S 15 VAT 373.50 373.50 2490.00 373.50 S 15 VAT 2500.00 2490.00 2863.50 10.00 2863.50 1 10.00 2500.00 true AAH Discount 0.4 10.00 2500.00 373.50 2873.50 J.B. Officeprint 1420 S 15 VAT 249.00 10.00
2

In your xml, there is a discount of 10SAR that wasn’t reflected in your calculation. You need either to remove the discount tag or reflect this discount on your calculation.

3

Dear Mr @Roohul-Amin-Seidor
My self if there is a List Price 2600 (in your invoice) then I am puting 100 as Allowance to reach to the Unit price 2500 … so 10 as line Discount to reach Net Price 2490
So Alloawance will = 100

If I am not using List Price 2600 and use Unit price 2500 … and 10 as line Discount to reach Net Price 2490
… So allowance will be = 0
I hope it helps