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 will halt the deferred processing operation and the following message will be displayed.

The Sales Order Import application has been changed to attempt to detect the error 25 without prompting the user with the standard error message window. The import process will stop and an error will print on the Pre-Interface Edit List or the Interface Journal. The error states:

*** Error Due To Other User Is Currently Using File: M:\Elliott8\DATA\CPIMPHDR.BTR ***

A new event variable has been added to the COMPFILE event ORDERIMP (Sales Order Import).

A Message field has been added as field 9.

If the Sales Order Import cannot open the Import Header File (CPIMPHDR), this event will be triggered and the following information will be returned in the event fields:

Number Of Warnings: 0
Number Of Errors: 1
Number Of Orders: 0
Starting Order No.: 000000
Total Sales Amount: 0.00
Total Backorder Amt: 0.00
Import File Name: 20190607_1945390.NI.US.Dev.txt
Message: Error: CPIMPHDR File In Use By Another User

Programs Modified: CPORDIMP

Programs Added: CPORDTST

CLS

• Related Articles

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

• Feature - Skip Orders With Duplicate PO Numbers in Sales Order Import

  Release Date: 5/21/2024 Revised Date: 08/27/2024 Version: 8.5 and Up Background Sales Order Import would flag orders with duplicate purchase order numbers in Elliott as a warning, but allow the orders to import and place them on hold. This behavior ...

• Feature – Import Shopify Orders to Elliott through ESS and SPS

  Release Date: 07/08/2023 Version: 8.5 & Up New Features to Support Shopify Interface Shopify is a popular turnkey solution for creating eCommerce websites. Our EDI partner has created an interface with Shopify so the eCommerce order can be imported ...

• 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 - Ability to Change EDI Import Path

  Release Date: 1/9/17 This feature gives the user the ability to change the path used when importing EDI orders. This option is enabled through Util-Setup-> Global Setup-> Add-Ons-> Sales Order Import. Field 4. Can User Override Path During Import? ...