1. Operations Guide, Volume 1 - Batch Overviews and Designs
  2. Sales Audit
  3. Export Process

Export Process

Another key function of Sales Audit is to export audited data to other solutions. This includes Merchandising, Invoice Matching, within the Merchandising suite of solutions, but also commonly includes exports to store inventory (SIM/SIOCS), Oracle Retail Insights Cloud Service (ORI), and external financials institutions.

Depending upon the application, exported data consists of either transaction data or totals, or both. The process of exporting transaction data varies according to the unit of work selected in the Sales Audit system options. There are two units of work, transaction or store day. If the unit of work selection is transaction, Sales Audit exports transactions as soon as they are free of errors. If the unit of work selection is store day, transactions are not exported until all errors for that store day are either overridden or corrected.

Full Disclosure and Post-export Changes

If you modify data during the interactive audit that was previously exported to Merchandising, Sales Audit export batch modules re-export the modified data in accordance with a process called full disclosure. Full disclosure means that any previously exported values are fully backed out before the new value is sent.

Export Programs

See the Merchandising Operations Guide Volume 2 for details on the following export programs:

  • Download from Sales Audit to Account Clearing House (ACH) System (saexpach)

  • Download of Escheated Vouchers from Sales Audit for Payment (saescheat)

  • Export DSD and Escheatment from Sales Audit to Invoice Matching (saexpim)

  • Export from Sales Audit to Oracle Retail Analytics (saexpdw)

  • Export Inventory Reservation/Release for In Store Customer Order & Layaway Transactions from Sales Audit (saordinvexp)

  • Export of Revised Sale/Return Transactions from Sales Audit to SIM (saexpsim)

  • Export of POS Transactions from Sales Audit to Merchandising (saexprms)

  • Export to Universal Account Reconciliation System from Sales Audit (saexpuar)

  • Extract of POS Transactions by Store/Date from Sales Audit for Web Search (ang_saplgen.ksh)

  • Post User Defined Totals from Sales Audit to General Ledger (saexpgl)