Validating and submitting an import file

After you imported a data file, you can validate the records and submit them to Distribution SX.e.

  1. In Storeroom, select Issues & Returns > Import.
    If the imported file has errors, Errors Exist is selected in the grid. If the file does not have errors, click
  2. If the file does not have errors, select the import and then click Submit to create the order.

    The Processing indicator will be selected and this message is displayed: Success. The import is being processed.

    Because the submit function runs in the background, you can perform other Storeroom tasks while the file is processing. After processing is complete, an email notification is sent to the email address that is on your Infor OS Portal or Infor Ming.le user record. It includes the order number.

    After you receive the email, click Refresh to clear the processed import from the Active Imports grid. If the import still contains lines with errors, correct the errors and submit the data again. Optionally, delete the lines.

  3. If the file has errors, click the drill down icon to view the lines from the file.

    If a line has errors, Errors Exist is selected in the grid. Review the error in the Error Messages column, and then fix the error.

    A line with a serial- or lot-controlled product causes an error. To assign a control number, select the line and then click Serials or Lots. Specify the control numbers are required and then click OK.

    You must specify the Customer Product to ensure that the product’s unit of measure is processed correctly.

    To exclude a line from import into Storeroom, select the line and then click Delete to remove the line from the database. If you attempt to delete the last remaining line of an imported file, an error occurs. You must delete the file instead of the line.

  4. After the errors are corrected, click Validate to check the file for remaining errors.

    The file remains in the database and is not submitted to Distribution SX.e. Imported records can remain in the Active Imports grid until you are ready to create the sales order.

  5. To validate and submit lines with no errors to Distribution SX.e, click Submit.

    Lines with no errors are processed to create an order. After you receive the email notification, click Refresh to clear the processed import from the Active Imports grid. If the import still contains lines with errors, correct the errors and submit the data again. Optionally, delete the lines.

    Note: To prevent duplicate processing, you cannot resubmit a row or file in the current session or a new session. You are also prohibited from deleting or re-validating a processing import file.