Rounding Not Happening Correctly For Value Added Tax (VAT) In Invoice Header Screen
Last updated on JULY 21, 2017
Applies to:Oracle Retail Invoice Matching - Version 11.0 and later
Information in this document applies to any platform.
While entering an Invoice in the 'Invoice Maintenance Header' screen at Header level, the rounding from 3 decimal places to 2 decimal places is not working correctly for the 'TOTAL VAT COST' field.
When entering a 'TOTAL COST Ex VAT' of 556.5 and then go into the 'TOTAL VAT COST' field and enter the 556.5 figure in the 'Ex VAT Basis' field against a VAT Rate of 21%
The actual figure is 116.865 (556.5 * .21), however the rounding to 2 decimal places rounds the
VAT COST down to 116.86.
This is wrong as it should be rounding up to 116.87 (strict rounding rules) because the user has to enter a figure in the 'TOTAL COST Inc VAT' field that is equal to TOTAL COST Ex VAT + TOTAL VAT COST, then the 'TOTAL COST Inc VAT' = 673.36.
Then, when clicking OK to save the document at Header level, returning to view this invoice the 'TOTAL VAT COST' has re-calculated to 116.87 (correctly rounding up). However, the 'TOTAL COST Inc VAT' has not re-calculated (as this is an input field) and remains at 673.36 instead of 673.37.
There appears to be a difference between the way the 'TOTAL VAT COST' is calculating on the front-end and in the database.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms