Tax Calculation Issue: Incorrect Tax Amount is Created When Adjusting Transaction With Inclusive/Exclusive Tax Line
Last updated on FEBRUARY 09, 2018
Applies to:Oracle Receivables - Version 12.1.3 and later
Oracle E-Business Tax - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Transactions Related
Incorrect tax amount was created when adjusting the transaction that has inclusive tax line and exclusive tax line.
Steps to Reproduce:
Navigation: Transactions > Transactions
Create Transaction as follows :
|Amount||Tax Classification Code||GL Account on Distribution|
|100||RATE-A||AAAA.AAAA||* Exclusive Tax 5%|
|1080||RATE-B||BBBB.BBBB||* Inclusive Tax 8%|
Create Journals for this transaction and check the journals.
|Class||GL Account||Accounted DR||Accounted CR|
Create following Receivable Activities :
Name : TEST01
Type : Adjustment
Active : On
GL Account Source : Revenue on Invoice
Tax Rate Code Source : Invoice
Recoverable : On
Activity GL Account :
Distribution Set :
Adjust Transaction as follows :
Create journals for adjustment and check these :
|Account||Accounting Class||Accounted DR||Accounted CR|
* Accounted DR of Account:AAAA.AAAA and Account:BBBB.BBBB is incorrect (highlighted in bold above).
Should be 1000 at Account:AAAA.AAAA line and should be 100 at Account:BBBB.BBBB line.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms