Incorrect Weighted Average Cost (WAC) And Tran Data Cost Calculations for Inter-company and Intra-company Transfers in Case of Partial Receipt

(Doc ID 2235936.1)

Last updated on JULY 17, 2017

Applies to:

Oracle Retail Merchandising System - Version 14.1.2 and later
Information in this document applies to any platform.

Symptoms

The Weighted Average Cost (WAC) and total_cost on TRAN_DATA table are incorrectly calculated for inter-company and intra-company transfers having upcharges in case of partial receipt.

Prerequisite: set tsf_force_close_ind to "SL" on SYSTEM_OPTIONS table.

Scenario 1: Intra-company Transfer

1. Create and approve intracompany transfer from warehouse to store. Ensure that items on transfer have up-charges applied.
2. Ship the transfer from warehouse.
3. Receive items partially.
4. Observe the following issues:
   i. Sending Location WAC is getting updated for the items.
  ii. Total Cost against tran_codes (example 22, 71, 72, 30) for the loss quantity is incorrect.

 

Scenario 2: Inter-company Transfer

1.  Create & approve intercompany transfer from warehouse to store.  Make sure that 2 items are on transfer and up-charges are applied on the transfer.
2.  Ship the transfer from warehouse.
3.  Receive one item fully and second item partially ( may be 50%).
4.  Observe the following issues:
    i. Sending Location WAC is getting updated for the item which was received short.
   ii. Total cost against tran_code 44 is posted wrongly for both the items i.e for the item which was short received and the one that was fully received.
  iii. Total cost against tran_code 37 for loss qty is posted wrongly.
  iv. Total cost against tran_code 22 for the loss qty at sending location is posted wrongly.

 

Scenario 3:

1. Create and approve intercompany transfer in RMS from warehouse to store.
2. Ship the transfer from warehouse.
3. Perform a short receipt. (50% of the quantity shipped).
4. Based on the sending location loss parameter set up, loss was posted at the sending location for the 50% quantity.
5. Observe the following issue:
   i. Total_Cost against tran_code 44 is not populating correctly.

Changes

 

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