Exception handling

Uploaded CSV Validation and Exceptions:
  • Uploads must be in CSV format.
  • Invalid file formats are rejected.
  • If the required columns are missing or do not match the expected format, the processing fails. The validation captures the issue, but no UI error message is displayed.

Quantity handling for negative and zero quantity

Quantity values in uploaded records, including negative, zero, and blank entries, determine how recall issue lines are created during processing:

  • If a record contains a negative quantity, the system converts the quantity to its absolute value. The recall issue line is created with the converted value.
  • If a record contains a zero quantity or a blank quantity, no rows are rejected based on quantity values. The recall issue line is created with the value that the record provides, whether zero or blank.
  • Recall processing continues for all rows. No rows are rejected based on quantity values.

Duplicate records management

Duplicate records are not validated or prevented during processing, and may affect the creation of recall issue lines.
  • The solution does not verify duplicate records or stop them from being uploaded.
  • Duplicate rows in the uploaded CSV can create duplicate recall issue lines.
  • You must review and clean the GLT export before you upload the file.