After running import processes in IFP you may have some records which have been rejected as the item code does not currently exist in the database. This topic shows how to import new item codes based on these exceptions.
The format of the exceptions file must be exactly as in the exceptions template in your database. Column names must not be changed here, as they are referred to in the exceptions import mapping provided with your database. AJB Systems can provide you with an Exceptions import template if required.
Preparing the Exceptions Template
Before importing the new item codes you will need to update your exceptions template with the rejected codes. To update this, please proceed as follows:
- Copy the rejected messages and paste them in column A of the exceptions template. For example Code 'HQ-3070-0000000000-60001000-XXX' was not found
- Copy the formula for the remaining columns to create the required information for the item code
- Check that columns contain no #N/A records. If these are present, update the relevant lookup sheet with the missing information
Importing Item Codes
Once the template has been updated, this can then be imported into IFP. For general information on importing, please see Importing Item Codes.