Fixing the warning for difference in total amount because of decimals when clearing/validating xml invoice

Clearance and Reporting
1

Dears ,

Hope this finds you well .

we are getting this warning now :

2024-08-27 11:09:18,186 [WARN] ValidationProcessorImpl - CODE : BR-KSA-EN16931-11, MESSAGE : [BR-KSA-EN16931-11]-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).

after investagitng , our ERP system uses 4 decimals for prices and amounts .
the warning was becasue of this :

Quantitiy is : 1500
SYSTEM PRICE : 4.6750
Rounded price in xml : 4.68

Total amount for both xml and system is 7012.5

The total amount is correct and the quantitiy is correct . but this cannot be achived unless the price is 4.675 and not 4.68

any advice

1 Like
2

@Hadi there is no decimal place restriction on two fields “Item Price (BT-146)” and “Quantity (BT-129)”. In your example, try to provide full value 4.6750 in Item Price (BT-146).

3

Rounding should be done at Total Level,
1500 x 4.6750 = 7012.5
while
1500 x 4.68 = 7020

4

Perfect . now it’s working perfectly