Warning VAT message (BR-S-09 - BR-CO-17)

XML and business rules
1

We are receiving such the below error message, can you please let me know what the issue exactly?

"warningMessages": [
                {
                    "category": "EN_16931",
                    "code": "BR-CO-17",
                    "message": "VAT category tax amount (BT-117) = VAT category taxable amount (BT-116) x (VAT category rate (BT-119) / 100), rounded to two decimals.",
                    "status": "WARNING",
                    "type": "WARNING"
                },
                {
                    "category": "EN_16931",
                    "code": "BR-S-09",
                    "message": "The VAT category tax amount (BT-117) in a VAT breakdown (BG-23) where VAT category code (BT-118) is 'Standard rated' shall equal the VAT category taxable amount (BT-116) multiplied by the VAT category rate (BT-119).",
                    "status": "WARNING",
                    "type": "WARNING"
                }
            ]

because i made two examples with the exact rounding & exact decimal one is get accepted and one with higher value doesn’t get accepted.

this is a screenshot of the line items table and also the totals values for the two invoices.

cleared one:
image

**

cleared one with this bellow warnings:
image

**

2 Likes
2

xml is required to advise

3

I had the same problem with a different large value without decimal.

image
image933×896 54.8 KB

4

@Embro I’m receiving the same warning messages;

the invoice that has the warning:

Screenshot from 2024-04-30 09-59-08
Screenshot from 2024-04-30 09-59-08634×930 92.2 KB

While this invoice has a lesser amount and has been accepted:

Screenshot from 2024-04-30 10-01-45
Screenshot from 2024-04-30 10-01-45658×924 92.6 KB

5

image
image893×575 126 KB

Acctually there is a Rounding error here …503,103.375 … It suppose to be 503103.38

So just follow the rules … For invoice lines … Round up to 2 Decimal numbers… … line by line
for Tax category … Get total taxable amount under that category … and Multiply by TaxPerc … the result for the tax amount to be rounded to 2 decimal numbers
same for Invoice Tax total …
for any total tax …Don’t make summing for Tax Lines Details

6

Hello, We are facing a similar issue that caused a warning message to appear with xml invoice and don’t know the cause of it because the invoice totals seems correct , and it appears with some price amount values and not others

<?xml version="1.0" encoding="UTF-8"?>
<Invoice
	xmlns="urn:oasis:names:specification:ubl:schema:xsd:Invoice-2"
	xmlns:cac="urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2"
	xmlns:cbc="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2"
	xmlns:ext="urn:oasis:names:specification:ubl:schema:xsd:CommonExtensionComponents-2">
	<!-- Code omitted for clarity--> 
	<cac:TaxTotal>
		<cbc:TaxAmount currencyID="SAR">1650000.00</cbc:TaxAmount>
		<cac:TaxSubtotal>
			<cbc:TaxableAmount currencyID="SAR">11000000</cbc:TaxableAmount>
			<cbc:TaxAmount currencyID="SAR">1650000.00</cbc:TaxAmount>
			<cac:TaxCategory>
				<cbc:ID>S</cbc:ID>
				<cbc:Percent>15</cbc:Percent>
				<cac:TaxScheme>
					<cbc:ID>VAT</cbc:ID>
				</cac:TaxScheme>
			</cac:TaxCategory>
		</cac:TaxSubtotal>
	</cac:TaxTotal>
	<cac:TaxTotal>
		<cbc:TaxAmount currencyID="SAR">1650000.00</cbc:TaxAmount>
	</cac:TaxTotal>
	<cac:LegalMonetaryTotal>
		<cbc:LineExtensionAmount currencyID="SAR">11000000</cbc:LineExtensionAmount>
		<cbc:TaxExclusiveAmount currencyID="SAR">11000000</cbc:TaxExclusiveAmount>
		<cbc:TaxInclusiveAmount currencyID="SAR">12650000.00</cbc:TaxInclusiveAmount>
		<cbc:AllowanceTotalAmount currencyID="SAR">0</cbc:AllowanceTotalAmount>
		<cbc:ChargeTotalAmount currencyID="SAR">0</cbc:ChargeTotalAmount>
		<cbc:PrepaidAmount currencyID="SAR">0</cbc:PrepaidAmount>
		<cbc:PayableAmount currencyID="SAR">12650000.00</cbc:PayableAmount>
	</cac:LegalMonetaryTotal>
	<cac:InvoiceLine>
		<cbc:ID>1</cbc:ID>
		<cbc:InvoicedQuantity unitCode="piece">1</cbc:InvoicedQuantity>
		<cbc:LineExtensionAmount currencyID="SAR">11000000</cbc:LineExtensionAmount>
		<cac:TaxTotal>
			<cbc:TaxAmount currencyID="SAR">1650000.00</cbc:TaxAmount>
			<cbc:RoundingAmount currencyID="SAR">12650000.00</cbc:RoundingAmount>
		</cac:TaxTotal>
		<cac:Item>
			<cbc:Name>Sample Item</cbc:Name>
			<cac:ClassifiedTaxCategory>
				<cbc:ID>S</cbc:ID>
				<cbc:Percent>15</cbc:Percent>
				<cac:TaxScheme>
					<cbc:ID>VAT</cbc:ID>
				</cac:TaxScheme>
			</cac:ClassifiedTaxCategory>
		</cac:Item>
		<cac:Price>
			<cbc:PriceAmount currencyID="SAR">11000000</cbc:PriceAmount>
		</cac:Price>
	</cac:InvoiceLine>
</Invoice>

As we notice in the xml invoice there aren’t any charges , allowances , rounding.
Just one item with quantity of 1 and price of 11000000.

However , this xml invoice has only an item with price 15000000 and quantity of 1, it doesn’t give any warning.

<?xml version="1.0" encoding="UTF-8"?>
<Invoice
	xmlns="urn:oasis:names:specification:ubl:schema:xsd:Invoice-2"
	xmlns:cac="urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2"
	xmlns:cbc="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2"
	xmlns:ext="urn:oasis:names:specification:ubl:schema:xsd:CommonExtensionComponents-2">
     <!-- Code omitted for clarity-->
	<cac:TaxTotal>
		<cbc:TaxAmount currencyID="SAR">2250000.00</cbc:TaxAmount>
		<cac:TaxSubtotal>
			<cbc:TaxableAmount currencyID="SAR">15000000</cbc:TaxableAmount>
			<cbc:TaxAmount currencyID="SAR">2250000.00</cbc:TaxAmount>
			<cac:TaxCategory>
				<cbc:ID>S</cbc:ID>
				<cbc:Percent>15</cbc:Percent>
				<cac:TaxScheme>
					<cbc:ID>VAT</cbc:ID>
				</cac:TaxScheme>
			</cac:TaxCategory>
		</cac:TaxSubtotal>
	</cac:TaxTotal>
	<cac:TaxTotal>
		<cbc:TaxAmount currencyID="SAR">2250000.00</cbc:TaxAmount>
	</cac:TaxTotal>
	<cac:LegalMonetaryTotal>
		<cbc:LineExtensionAmount currencyID="SAR">15000000</cbc:LineExtensionAmount>
		<cbc:TaxExclusiveAmount currencyID="SAR">15000000</cbc:TaxExclusiveAmount>
		<cbc:TaxInclusiveAmount currencyID="SAR">17250000.00</cbc:TaxInclusiveAmount>
		<cbc:AllowanceTotalAmount currencyID="SAR">0</cbc:AllowanceTotalAmount>
		<cbc:ChargeTotalAmount currencyID="SAR">0</cbc:ChargeTotalAmount>
		<cbc:PrepaidAmount currencyID="SAR">0</cbc:PrepaidAmount>
		<cbc:PayableAmount currencyID="SAR">17250000.00</cbc:PayableAmount>
	</cac:LegalMonetaryTotal>
	<cac:InvoiceLine>
		<cbc:ID>1</cbc:ID>
		<cbc:InvoicedQuantity unitCode="piece">1</cbc:InvoicedQuantity>
		<cbc:LineExtensionAmount currencyID="SAR">15000000</cbc:LineExtensionAmount>
		<cac:TaxTotal>
			<cbc:TaxAmount currencyID="SAR">2250000.00</cbc:TaxAmount>
			<cbc:RoundingAmount currencyID="SAR">17250000.00</cbc:RoundingAmount>
		</cac:TaxTotal>
		<cac:Item>
			<cbc:Name>Sample Item</cbc:Name>
			<cac:ClassifiedTaxCategory>
				<cbc:ID>S</cbc:ID>
				<cbc:Percent>15</cbc:Percent>
				<cac:TaxScheme>
					<cbc:ID>VAT</cbc:ID>
				</cac:TaxScheme>
			</cac:ClassifiedTaxCategory>
		</cac:Item>
		<cac:Price>
			<cbc:PriceAmount currencyID="SAR">15000000</cbc:PriceAmount>
		</cac:Price>
	</cac:InvoiceLine>
</Invoice>

The same warning appears when the item price is 12000000, 13000000, but the warning
doesn’t appear when the price is 14000000, 15000000, 16000000.

Even more, many complicated numbers with more quantity completed with no warnings.

Can someone elaborate us what is the cause of this warning that appears randomly , even if the number doesn’t have decimals , because it concerns some customers ?

Thanks in advance.

7

Hi every one :
The problem come from compliance checks for reporting and clearance ,
But it success in reporting or clearance direct .

I hope to fix it shortly ,
Best Regards

1 Like
8

Not Exactly … If apears also in core Links
but as advised by e-invoice team …if your invoice is accurate rounding and still receiving these errors nos , ignore the erroe, this will be solved & updated in next release.

1 Like
9

you don’t need to round unit price and quantity

1 Like