Tax Value Mismatch In Receivables Base Form And India Tax Details Form OF the Receivable Transactions (Doc ID 3066833.1)

Last updated on JANUARY 15, 2025

Applies to:

Symptoms

Tax value mismatch in Receivables base form and India Tax Details Form. When the taxable and tax values are compared to Sales order level, that are also different.

The taxable and tax values should be the same across all levels in the Order to Cash flow, i.e., it should be the same in Sales Order, Sales Order Delivery and Receivables Transactions.

The issue can be reproduced at will with the following steps:
1. Navigate to India Local Order Management > Oracle Order Management > Pricing > Modifiers.
2. Define multiple Pricing Modifiers for the item. Some of them can be Discounts, some can be surcharges. Below is a sample example of a modifier setup.
  a. 1st modifier is a discount, say with 48% and is setup in Bucket 1.
  b. 2nd modifier is a New Price modifier and setup in Bucket 2. This discount modifier is setup with Application method as "New Price" which enables the user to enter a new price value at the Sales order line level under adjustments.
  c. 3rd is again a discount modifier of 2% and is set up in bucket 3.
  d. 4th can be a surcharge modifier.
3. Setting it up as above will make the 3rd modifier be applicable on the 2nd modified price.
4. Navigate to India Local Order Management > Sales Orders.
5. Create sales order and enter item with a high quantity sale.
6. Apply the Modifiers on the order line. Enter the 2nd price modifier i.e., new price modifier, (for example as 105.6044121). This is a very high decimal precision value.
7. This derives the extended value of the modifier with high decimal precision.
8. Attach Taxes to the order by going to tools > India tax details.
9. Book the order.
10. Go to India Local Order Management > Shipping Transactions.
11. Pick release the line and ship confirm the delivery.
12. Run autoinvoice to Import the AR transaction.
13. Check the Balance due and amounts in India tax details. They are different. They are also different from the tax amount values visible on the Sales order delivery.

Changes

Cause

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