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 basis, or even if they do, the company representative may not be able to guarantee the turnaround 855 can be sent in 1 or 2 hours. The expectation is that our ERP system can be automated to perform the import of sales orders and automatically send back the 855 acknowledgment without any human intervention. Traditionally, we expect the user to review the imported orders and that some of the line items may need to be canceled due to them being out of stock.  Some of the line item ship dates may need to be changed or maybe the entire order need to be canceled. Only after that review takes place do we send the 855. But now, the trading partners are requesting that the 855 be sent from our ERP system before any company representatives even review the order. In the current version of Elliott, Sales Order Import can be automated now through deferred processing but the Sales Order Export application can not. 

This feature supports a “simple” version of the 855. That is, when the order is imported through Sales Order Import, the 855 is exported out immediately to acknowledge that the order was received.   

To enable this feature, you must specify that the trading partner requires the 855 (turnaround document) to be exported at the time of Sales Order Import. This is enabled through fields 83 and 84 in the Customer's EDI Profile Data, which can be accessed from the Special Functions option when accessing the customer through the Change mode of Customer File Maintenance .

83. Export Turn Around During Sales Ord Import?    The default value is N. If set to Y, and the export turnaround order file path and name is set up, orders will be exported immediately when imported.

84. Export Turn Around Order File Path & Name - Specify the path and file name for the export file. This field supports 4 different masks:

YYYYMMDD - full date including the century (20190306)

YYMMDD - date without the century (190306)

HHMMSS - time stamp (070700)

OOOOOO - Elliott order number that was created during the import (900999) 

Once this feature is enabled, the Sales Order Import Journal will specify that the export file was generated and the name of the file that was generated.

If any errors are encountered when generating the file, this will be indicated on the report. Possible errors include:

Error 2: Item Not On File

Error 4: Either the UPC Code, Alternate Item Number, Customer Item Number, or Style Code does not exist.

Error 9: Order Not On File

Error 10: Error Opening Export File - This can occur if the file is in use or an invalid directory is specified in the customer's EDI Profile Date.

Programs Modified: ARCUSEXT.FD, ARCUSEDI, CPORDIMP, CPORDEDP

New Program Added: CPORDEXP

CLS

• Related Articles

• Feature - Added Archive Function to Sales Order Import File Search Window

  Release Date: 9/21/23 Version: 8.5 and Above Some customers have asked how to delete or archive files from the Import Folder for Sales Order Import. This can happen because the import file has invalid information which will require the trading ...

• Feature - Avalara Tax Code Support in Sales Order Import

  Release Date: 9/6/23 Version: 8.6 and Above Sales Order Import now determines the correct tax codes for an order based on the ship-to state and country for the order. First, the application will determine if the address is a foreign address (non-US ...

• Feature - Check for Duplicate PO During Sales Order Import

  Release Date: 7/19/2016 A new feature has been added to COP Sales Order Import that will check imported orders for potential duplicates. Setup by entering "Y" in Global Setup - > Add-ons -> Sales order import, field 23. When running Sales Order ...

• Feature - Alleviate Error 25 When Two Users Import Sales Orders Simultaneously

  Release Date: 9/26/19 Version: 8.5 and up If two users attempt to run Sales Order Import at the same time, the second user will receive an error 25 on the Import Header File (CPIMPHDR). If the second import is launched from deferred processing, this ...

• 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 ...