My Oracle Support Banner

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

Last updated on MARCH 10, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 22.1 and later
Information in this document applies to any platform.


On: 22.1 version, Operations & Maintenance

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

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

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

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


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

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