Distribution - JDE1 (MOSC)

MOSC Banner

Tax rounding off issue on Sales invoices

edited Jun 26, 2025 2:55PM in Distribution - JDE1 (MOSC) 2 commentsAnswered

Could you get someone to investigate VAT rounding issues we are experiencing and we see invoice rejections due to the rounding errors

Example: Order ED 1474224 - Invoice 25031066

I have a discrepancy between the calculated VAT on Invoice versus calculated VAT in XL and I cannot explain the difference coming from rounding. The customer is rejecting the invoices on that basis.

I compare extracts from F42119 file to actual pdf and AR document 

F42119 shows a taxable of 13066 (see detail ) and I added in a column with calculations for VAT at 20% both at 2 decimals versus 4 decimals. 

VAT on Invoice calculates as Taxable 13066.00 - 20% VAT = 2613.23  whereas calculations both at 2 or 4 decimals either at line level or sum of all lines both show the VAT should be 2613.20. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

E1 Distribution Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center