My Oracle Support Banner

Rounding Not Happening Correctly For Value Added Tax (VAT) In Invoice Header Screen (Doc ID 412122.1)

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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.