ReIM Consignment Invoice Rejection
(Doc ID 2677575.1)
Last updated on JUNE 11, 2020
Applies to:Oracle Retail Merchandising System - Version 14.1 and later
Information in this document applies to any platform.
There is a difference of header and detail units,INVC_DETAIL(INVC_QTY) is not matching with INVC_HEAD(TOTAL_QTY).
Sales process is missing few transactions while inserting into INVC_DETAIL.
With regular sales, a sale transaction without discount ( Eg: 20$) and a subsequent transaction for the same item/loc with a discount record (Sale Price, 15$, Discount amount = 5$), total cost and qty in the Header (invc_head) is updating properly, but not creating a child record for the second transaction which is causing discrepancy between invc_head and invc_detail.
Steps To Recreate:
1. Load a Sale (POSU File) - For store - STORE_A, Date - 10/28/18, with Sku (Item setup with inventory_ind = 'N' and merchandise_ind = 'Y' in Item Master). Qty = 1
A tran code 1 and tran code - 20 created and an entry is made in invc_head and invc_detail. Invc Head, Total qty = 1
Day = 1, Tran date= 10/28, Load the POSU without Discount Record
Run Batch Jobs:
$RETAIL_HOME/oracle/proc/src/uploadsales.ksh $UP /batch/rms/data/in/ss/POSU_STORE_A_20191028000001_20191028.1
2. Move the vdate, load another sale for same Store, item, but tran date = 10/29/18 (same week). This file has 2 transactions for the same item each with Qty = 1
a. transaction 1, has no discounts, price in file matches to price in price hist
b. transaction 2, has a discount (discount type = 1005, Employee discount)
Now, both transactions are loaded into tran data, each with tran code - 1 and tran code. But, when it comes to invc* table, only invc_head updates with total qty = 3, but invc_detail, has only with qty = 2, missing a record for different price.
Day = 2, 10/29, LOad the POSU with SKU, first record no Disc Record, second record for same SKU, but with Discount record
Run Batch Jobs:
$RETAIL_HOME/oracle/proc/src/uploadsales.ksh $UP /batch/rms/data/in/ss/POSU_STORE_A_20191029000001_20191029.1
3. Check Data
select * from invc_head where invc_id = XXXX;
select * from invc_detail where invc_id =XXXX;
Header details do not match with Detail level details. It is supposed to create another record with a cost from transaction with discount record, but it didn't.
Items are with merchandise_ind = 'Y' and inventory_ind = 'N'
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