Store Update Errors Report

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 To Store 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 To Store 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 To Store 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 To Store 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 To Store 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 To Store 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 To Store 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 To Store 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 To Store field is Y.