My Oracle Support Banner

RMS Does Not Always Create Consignment ORDER TRAN_CODE 20 and 24 (Doc ID 2797932.1)

Last updated on SEPTEMBER 06, 2021

Applies to:

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


When processing sales in a sales file, if there are multiples of the same THEAD information for consignment items (same item, same quantity, same TOTAL_RETAIL occurring multiple times in the file), RMS correctly generates all necessary Transaction Code 1 (TC1) sale/return records for the THEAD consignment multiples.
However, RMS only produces a single TC20 or TC24 consignment Order record for the first occurrence of any given set of like consignment lines.

An RMS POSU sales file contains two sales occurrences for consignment Item <ITEM_VALUE_1> 4 quantity @ extended retail of $79.96.
1. RMS records two TC1 records showing a sale of 4quantity @ TOTAL_RETAIL of $79.96
2. RMS records only one TC20 Consignment Order record showing a receipt of 4 quantities @ TOTAL_RETAIL of $79.96.

By not recording a second TC20 consignment Order record, RMS shortens the consignment vendor by 4 quantity/$79.96 in sales.

Steps to Reproduce

1. Prepare a store sales file for consignment items containing:
1a. 2 THEAD lines, for the same sales data for a distinct consignment item, same quantity, and same TOTAL_RETAIL
1b. 2 THEAD lines, but otherwise same return data of a distinct consignment item (different item from 1a), same quantity, and same TOTAL_RETAIL
2. Process the sales file through RMS
3. Review TRAN_DATA:
3a. The item from 1a has two TC1 records created, mimicking the data in the THEAD lines.
3b. An item from 1a, incorrectly, only has one TC20 consignment Order receipt corresponding to only one of the two THEAD sales lines
3c. The item from 1b’s returns will have two TC1 records for negative units, negative TOTAL_COST, NEGATIVE_TOTAL_RETAIL, exactly as expected for the returns
3d. The item from 1b’s returns will lonely have one TC24 consignment Order credit, which corresponds to only one of the two consignment returns.




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.