Identification Query For Getting Transactions With Wrong Excise Duty Flowing From Original Source Order Line To RMA Order Line

(Doc ID 2199680.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Financials for India - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


On : 12.1.3 version, India OM Localizations

When RMA order is being created with reference, RMA order does not have the
same tax amount as that of original sales order.

1) Original Sales Order Number:- 15160068916

Issue is with order line no:- 3. Item Name:- LDIS09CYUAY1002C006SC001S.
Inventory_Item_id:- 128. Quantity:- 25. Excise tax amount is 0 at header

2)A) This line is split into two.

Delivery Detail Id Qty
856693 1
856835 24

B) This order line has been matched with 2 receipts during receipt matching.

Receipt Number Qty Delivery Detail Id
50000291 1 856693
50000291 6 856835
50000279 2 856835
50000279 16 856835

i) For Receipt Number 50000291, 12.5% rate has been applied. Qty/Rate tax
amount:- 725.79
ii) For Receipt Number 50000279, 12.5% rate has been applied. Qty/Rate tax
amount:- 746.23

Therefore, for this order total tax amount becomes
=(1*725.79+6*725.79+2*746.23+16*746.23) ~ 18513

This is getting calculated correctly.

2) RMA Sales Order

Number:- 15160069443
Total tax amount is showing as 18150 which is not correct.
System has considered only one delivery_detail_id for total quantity i.e

Now, for this delivery_detail_id, Qty/Rate tax amount:- 725.79
total tax amount becomes:- 725.79*25 ~ 18150


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