Feature - Sales Order Import Error Directory Support

Date Released: 8/21/18

This feature gives users the ability to move import files that contain errors to an error directory during the Interface process. This is helpful for users who want to use defer processing to import sales orders every few minutes. Currently, if there’s an error in the import file, it won’t be imported but it will be imported again a few minutes later with the same error. Once this feature is enabled, files containing errors can be moved to a separate directory where the user can review the files, correct the errors, and move the files back to the standard directory for processing.

This field is enabled through Global Setup-> Add-ons-> Sales Order Import-> Fields 26 and 27.

26. Move File with Errors to Different Folder? - Default value is N. If set to Y, import files containing errors will be moved to the directory specified in field 27 when interfacing.

27. Move Import File with Errors To This Folder - Specify a folder. The folder must exist.

If an error is encountered during the interface process, the import file will be moved to the error directory specified. An error message will print on the report specifying the directory and the file name that was moved. For example:

*** Errors Found. Import File Moved to s:\edi\import\errors\AlliedUsOrdersEOD201806142564999.txt ***

Once this function is enabled, it is recommended that users subscribe to the Sales Order Import event ORDERIMP. This event can be configured to notify users when errors are encountered during the sales order import. Users can subscribe to this event "Sales Order Import" from Company File Maintenance. The program is CPORDIMP. The type is ORDERIMP.

Once selected, choose the filter tab.

Add a filter based on the number of errors field. If the number of errors is greater than zero, users should be notified that a file has been moved to the error directory for their review.

 Programs Modified: NSCTLFIL.FD, NSCTLFIL.W33, NSCTLINI, NSCTLMNV, CPORDIMP

CLS

• Related Articles

• Feature - Plus Work Order CSV Import Sales Order Support

  Release Date: 4/28/23 Version: 8.5 and Above This feature allows the user to support the creation of a Plus Work Order from a COP sales order using the customized components or routing specified on the COP sales order using Bill of Material ...

• Feature - Support Payment Record in Sales Order Import

  Release: 06/07/2023 Version: 8.5 and Higher Introduction Elliott Sales Order Import is used extensively to import orders from EDI transactions and eCommerce websites. In this enhancement, we expanded Sales Order import to support "Payment" records. ...

• Feature - Sales Order Import to Support Turnaround Exporting of Order Immediately

  Release Date - 3/6/19 Version: 8.2 and Up There are certain trading partners that require the order acknowledgement (855) be sent immediately (within 1 hour or 2) upon receiving the 850 (Sales Order Import). If your business does not work on a 24x7 ...

• Feature - Support Callable Module to Customize Sales Order Import

  Release Date: 6/6/23 Version: 8.5 and Above This feature allows for a custom module to be called during the interface mode of Sales Order Import. To use this feature, you must have a custom modification provided by NETcellent. Go to System ...

• Feature - Mass Billing by CSV Error Directory Support

  Release Date: 5/17/24 Version: 8.5 and Above This feature adds the ability to move Mass Billing import files that have errors to a separate directory when interfacing. This feature is useful to allow the user to correct the error with the CSV and to ...