Store Update Errors Report

Important: This report is not currently implemented. When you generate this report, the system prints a generic document with the following information:

The requested document is not currently implemented: STORE_UPDATE_ERROR

Purpose: This report lists any records in a Store File that contain errors. You can use this report to determine which store upload records you need to correct and reprocess.

Note: Each store upload record in an error status is associated with only one error (the first error the system finds for the record). Once you correct the error and resubmit the Store Upload Process, the system validates the record for additional errors.

This report sorts in store number sequence.

How to print: Submit the STRUPLD Upload Store Periodic Function to perform the Store Upload Process.

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

Contents:

Company: A code for the company you entered when you submitted the STRUPLD periodic function.

Store #: The Store # in the Store file.

Description: The Store Name in the Store file.

Active: The Store Active Indicator in the Store file.

Error Description: The reason why the store record did not create or update a record in the Store Cross Reference table. Possible reasons:

- Store # is required: The Store # must contain a value.

- Store name is required: The Store Name must contain a value.

- Active flag is required: The Store Active Indicator must contain a value.

- Invalid active flag: The Store Active Indicator must be Y or N.

- Address 1 is required: The Address 1 must contain a value. This error occurs only when updating an existing record in the Store Cross Reference table whose Ship for Pickup field is Y.

- City is required: The City must contain a value. This error occurs only when updating an existing record in the Store Cross Reference table whose Ship for Pickup field is Y.

- Country is required: The Country must contain a value. This error occurs only when updating an existing record in the Store Cross Reference table whose Ship for Pickup field is Y.

- Country is invalid: The Country must exist in the Country table. This error occurs only when updating an existing record in the Store Cross Reference table whose Ship for Pickup field is Y.

- State is required: The State must contain a value. This error occurs only when updating an existing record in the Store Cross Reference table whose Ship for Pickup field is Y and whose country requires a state.

- Postal Code is required: The Postal Code must contain a value. This error occurs only when updating an existing record in the Store Cross Reference table whose Ship for Pickup field is Y and whose country requires a postal code.

- Postal Code is invalid, must be at least 5 characters: The Postal Code must contain at least 5 digits. This error occurs only when updating an existing record in the Store Cross Reference table whose Ship for Pickup field is Y.

- SCF is invalid: The Postal Code must begin with a valid SCF for the state. This error occurs only when updating an existing record in the Store Cross Reference table whose Ship for Pickup field is Y.

- Invalid state (XX) for postal code: The Postal Code exists in the SCF table, but the specified state does not match the valid states for the SCF record. This error occurs only when updating an existing record in the Store Cross Reference table whose Ship for Pickup field is Y.

WSCRr OMSCS 19.0 December 2019 OHC