Consignment Purchase Record In Tran-data Is Created With Incorrect Total Retail (Doc ID 2933728.1)

Last updated on MARCH 10, 2023

Applies to:

Symptoms

On: 22.1 version, Operations & Maintenance

ACTUAL BEHAVIOR
---------------
When a sales price is manually entered in the POS for consignment item sales, MFCS is creating the tran code 20 in tran data with total retail different to the one in the corresponding tran code 1 Net Sale.

tran_code 1,2 and 20 all have a total cost of 10, but only 1 and 2 have a total_retail of 10, tran_code 20 has a totatl_retail of 0

EXPECTED BEHAVIOR
-----------------------
total retail on tran_code 20 should also be 10 (or should be 0 on 1 and 2)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a consignment item with a unit cost of 0 and a consignment rate of 100%
2. Sell the item in XOCS and input a selling price of 10
3. The sale is processed in RESA and a tran_code 1 is created with a correct total cost and total retail while the tran_code 20 is created with a correct total cost but 0 total retail

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the retail ending balance goes negative.

Cause

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