Sales Returns - Incorrect Credit Memo PIS/COFINS Tax Calculation (Based on Amount Instead of Quantity) When Inclusive Tax is Present (Doc ID 2927116.1)

Last updated on MAY 15, 2023

Applies to:

Symptoms

While creating Sales Returns, after the receipt in Inventory module, the Credit Memo is calculating PIS/COFINS (taxes) based on the 'amount' (quantity x unit price) instead of 'quantity' as defined in Latin Tax codes setup. This happens when Inclusive Tax setup is used.
The taxable_amount is incorrect in both ra_customer_trx_lines_all and zx_lines tables. When the Credit Memo reaches the Oracle Receivables (AR) interface (ra_interface_lines_all), the tax group is the same as for the original sales order while the tax codes are setup for Taxable Basis = Quantity.
If the goods are returned, the tax calculation must be the same as in original invoice: PIS and COFINS must be based on quantity for such cases.

STEPS TO REPRODUCE:

1. Order Management responsibility > Orders Workbench > Orders, Returns > Create Return Material Authorization (RMA)
2. Oracle Receivables responsibility > Transactions > Create a return invoice
3. Integrated Receiving > Create invoice receipt
4. Inventory responsibility > Transactions > Receiving > Create physical receipt
5. The Credit Memo is created in ar_interface_lines_all > Observe that the tax group is the same as for the original sales order
6. Oracle Receivables responsibility > Import this data from the interface > Verify ra_customer_trx_lines_all and zx_lines tables, the taxable_amount is incorrect
   
7. Observe PIS/COFINS (taxes) are incorrectly calculated based on the 'amount' (quantity x unit price) instead of 'quantity' (expected per setups)

WORKAROUND

The PIS/COFINS taxes differences can be manually calculated in Oracle Receivables and General Ledger modules.

Changes

 None

Cause

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