Feature - Sales Order Import ATP Quantity Warning

Feature - Sales Order Import ATP Quantity Warning

Release Date: 6/17/19

Version: 8.2 and Up

Sales Order Import gives the user warning messages in some situations when the quantity ordered is greater than the quantity available. This feature gives the user the ability to also give a warning if the quantity ordered is greater than the available to promise (ATP) for a future date. For example, when you receive an order and you typically have a 7-day turnaround, then showing the ATPQty(07) is a better way to see if you have enough quantity for the order instead of the current quantity available.

This new warning can be configured through two new options in Global Setup-> Add-Ons-> Sales Order Import-> field 23. Import Qty Exceed Qty Available Handling. 



When the user chooses field 23, a new window will appear with three entry fields. 

Allow Qty-To-Ship > Qty Available? or Warn Qty Order > Qty Available? - If field 22. Default Qty-To-Ship To Zero is set to "Y," the prompt will read "Warn Qty Order > Qty Available" and this option will be treated as a warning only. No quantities will be updated based upon availability. Otherwise, the prompt will read "Allow Qty-To-Ship > Qty Available?" If set to N, the quantity to ship will be updated based upon the quantity available.

Warning If Qty Order > ATPQty(99)? - The default value is N. If set to Y, a warning message will print for each line item with an ATP quantity that is less than the quantity ordered. This is based up the current system date plus the number of days specified in the ATP Qty Days field.

ATP Qty Days? - Enter the number of days in the future to be used for the ATP quantity available calculation.

If  Warning If Qty Order > ATPQty(99) is set to Y and ATP Qty Days is not set to zero, the ATP available quantity will be calculated during sales order import. If the ATP available quantity is less than the quantity ordered, the following warning message will print on the report and will be included in the total number of warnings indicated at the bottom of the report.

Warning: Qty Ordered Greater Than ATPQty(99) 

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




    • Related Articles

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

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

    • Feature - Sales Order Import Request Date Warning

      Release Date: 6/13/19 Version: 8.2 and Up Previously users would control whether the message "Request Date Has Already Passed" was a warning or just a standard attention message through Global Setup-> Add-Ons-> Sales Order Import field 20, Ship Date ...

    • ARECIMNT Accounts Receivable Customers and Contacts Import Utility

      Last Update: 03/20/2024 Version: 8.0 & Higher Introduction This utility was the first utility we developed to handle the import and update of customers and contacts at the same time. Since then, we have developed a separate utility to import or ...

    • ARSTLSCN Accounts Receivable Sales Tax Liability Report

      Sales Tax Liability Report Application Overview Sales Tax Liability Reports are a function of the A/R Sales Tax Audit Trail feature. The purpose of this feature is to give a detailed tracking for sales tax so that complete auditing information can be ...