Data Warehouse Staging Errors Report

Purpose: Use this report to review order transactions that contain item or SKU errors. For example you perform a merge/purge which updates an old order that contains an item or SKU that has since been deleted. Transactions that contain item/SKU errors remain in the DW Capture Transaction table until the errors are corrected.

The system deletes any records in the following data warehouse staging tables that are related to the order transaction in error:

• DW Order Header

• DW Order Detail

• DW Order Ship To

• DW Order Payment

• DW Order Payment Activity

• DW Order Detail Activity

• DW Order Additional Charges

This report sorts in company, date, order number, line number, item, SKU sequence. The report page breaks for each company that contains item or SKU errors.

How to print: Process data warehouse changes by:

• submitting the Initial Load; see Process Initial Load Screen.

• selecting OK at the Process Data Warehouse Changes Window.

• submitting the Process DW Changes (DWCHG) periodic function (DWR0068).

For more information: See the sample report in PDF format.

Contents:

• date: the date when the order transaction in error was submitted to the staging data warehouse.

• order number: the order number containing the item or SKU in error.

• line number: the order line number containing the item or SKU in error.

• item: the item number that is in error.

• SKU: the SKU code that is in error.

• error: a description of the error. The only error that prints on this report is Order Contains an Invalid Item.