SAEXPRMS not Exporting Sales Data Correctly if an Item Has Sale and Void Record Within The Same Transaction (Doc ID 2285858.1)

Last updated on JULY 17, 2017

Applies to:

Oracle Retail Sales Audit - Version 14.0.1 and later
Information in this document applies to any platform.

Symptoms

SAEXPRMS(Sales Export to RMS) batch is not exporting sales data correctly if an Item is having Sale and Void within the same transaction.

Steps to Reproduce:
--------------------------
1. Create a RTLOG file for below scenario:
  a) Sale transaction T1 with one TITEM record with item I1, item status as ‘S’, qty as 1 and IDISC record with discount amount D1 and another TITEM record with same item I1 but with item status as ‘V’ and qty as -1.
  b) Sale transaction T2 with one TITEM record with same item I1, item status as ‘S’, qty as 1 and IDISC record with discount amount D2.
  c) Both the transactions should be at same retail
2. Upload the RTLog and ensure that there are no errors for both the transactions T1 and T2.
3. Run SAEXPRMS and notice that the POSU file generated has total sales qty as 1, but two TDETL records having both discount amounts D1 and D2.

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