Correcting the Errors and Re-uploading

Transactions that have been rejected by the Import process will have a status of ‘Error’.

Errors encountered during processing can be corrected by either updating the interface table or by deleting and reprocessing the records. The interface IDs on the sheet are crucial for identifying which records to update and should not be modified.

To Update the Interface Table:

  1. Identify and Correct the Issue: Pinpoint the problem and rectify it directly on the sheet.

  2. Set Header Upload Action to 'Update': This is mandatory, even if no changes are made to the header record, as it enables the selection of line updates.

  3. Set Transaction Upload Action to 'Update': This action is necessary for updating the transaction lines. This is mandatory, even if no changes are made to the line records, if you have Update in the Lot Number or Serial Number sections.

  4. Optionally, Set Lot Upload Action or Serial Upload Action to “Update”: If the issue is in these areas no need to manually update the status columns. The Update process will automatically reset them to "Pending" to ensure the import reprocesses them.

If a transaction line from the original load was successfully created (i.e., has a processing status of 'Success'), it is automatically purged from the interface table and cannot be updated.

To delete transactions in the interface table, you can either use the Upload Action of Delete in the integrator or use the Purge Receiving Interface described above