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

• APINVIMS Accounts Payable Invoice Import Utility

  A/P Invoice Import Utility Introduction This utility is similar to the COP Sales Order Import Utility. It will allow vendor invoices created through an external source to be imported and become New A/P Transactions in Elliott. Traditionally, if a ...

• CPIMPMNU Customer Order Processing Sales Order Import

  Sales Order Import Application Overview The Sales Order Import module is designed to import a pre-defined ASCII file to create COP sales orders. It is intended to provide an easy way for developers to create add-on solutions for creating sales ...

• Avalara Attribute Support

  Release Date: 4/28/23 Updated: 1/26/28 Version: 8.6 and Above For Elliott to work with the Avalara Sales Tax Interface, there are additional data to be stored on the Elliott side. Our implementation chooses to store these data in the following ...

• A Summary to Outline of Elliott EDI Integration Flow

  Release Date: 06/15/2023 Version: 8.x & Up Q - We currently use SPS Fulfillment Portal for our EDI processing. We are getting too great of a volume of EDI orders and we are evaluating whether to automate it with Elliott. Can you give me an outline of ...

• CPSLSDSK Customer Order Processing Sales Desk

  Sales Desk Application Overview Sales Desk is designed for companies who need versatile order entry functions and improved customer service. It is designed to be used by salespersons, order entry personnel and telemarketers. Sales Desk is extremely ...