Weighted average cost (WAC) Gets Null When reciever cost adjustment (RCA) Is Done For Cancelled Items
(Doc ID 1641564.1)
Last updated on MARCH 05, 2019
Applies to:
Oracle Retail Merchandising System - Version 13.2.5 and laterInformation in this document applies to any platform.
Symptoms
If as an example you created 3 items, then approved the order. When cancelling 1 item within the order and performing Receiver Cost Adjustment (RCA) in ReIM the weighted average cost (WAC) becomes NULL. for this item in the ITEM_LOC_SOH table.
Steps to Recreate :
Set - BACKPOST_RCA_RUA_IND to 'Y'
1. Create PO (more then 1 item).
ITEM QTY COST
1 10 1
2 20 2
3 30 3
2. Ship Order.
ITEM QTY COST
1 10 1
2 20 2
3. Receive Order.
ITEM QTY COST
1 10 1
2 20 2
4. Cancel Item 3 in PO .
ITEM QTY COST
1 10 1
2 20 2
3 0 3
5. Create Invoice.
6. On Detail screen click Default from Order.
7. Change unit cost for Item 3.
ITEM QTY COST
1 10 1
2 20 2
3 30 4
8. Perfrom RCA for Item 3.
9. Run reimrollup .
10. AV_COST for Item 3 is NULL.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |