Vat Tax On Earned Discount Being Calculated As 0.00 (Doc ID 395643.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Receivables - Version 11.5.10.0 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
FORM:ARXSYSPA.FMB - Define System Options
FORM:RAXSUTRM.FMB - Define Payment Terms
FORM:ARXRWMAI.FMB - Receipts
FORM:ARXTWMAI.FMB - Transactions


Symptoms

Vat Tax On Earned Discount Being Calculated As 0.00

The following setups may have caused this issue:

a)  System Options > Transactions and Customers System Options > Discount Basis is on Invoice.

b)  Tax Codes & Rates >Tax Basis > VAT before discount.

c)  Miscellaneous System Options > Enter the Discount Basis - Lines

d)  Miscellaneous System Options >  Application Rule Set > Line First--Tax After

c) Payment term > allow discount on partial payments > Lines

Create an invoice with the Discount Payment Terms and calculate tax..
Apply a cash receipt to the invoice within the discount payment terms, and run General Ledger Interface.

a) AR_RECEIVABLE_APPLICATIONS_ALL has one line that shows tax_applied correctly.

b) AR_DISTRIBUTIONS_ALL ( Source = Receivable Applications ) has tax_accounted_dr = to the amount of the discount, which is incorrect.

c) GL_JE_LINES: Accounted_dr - Tax = zero.


Changes

Fresh installation 11.5.10 and new setups.

Cause

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