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

    • Feature - Sales Order Import Not To Warn If Request/Promise Date > ??? Days

      Release Date: 7/12/19 Version: 8.2 and Up This feature is related to the Sales Order Import ATP Quantity Warning feature. See https://support.netcellent.com/portal/en/kb/articles/feature-sales-order-import-atp-quantity-warning for more information. ...

    • Introduction to Available to Promise (ATP)

      Release Date - 6/12/17 What is ATP? ATP (Available to Promise) is an Elliott database that merges all future transactions like sales orders, purchase orders and production orders. It expands the simple quantity allocated and quantity on order ...

    • IM0405 Inventory Management Available To Promise Inquiry

      Available To Promise Inquiry Application Overview This is a powerful tool that is fast and easy to use. Order entry and sales people can use this inquiry to determine future item deliveries, the purchasing manager can use it to plan purchase orders, ...

    • Feature - Reorder Advice/User Defined CSV Export Example 2 - ATP (Available to Promise)

      Release Date: 08/07/2020 Version: 8.0 & Up Example 2 - ATP (Available to Promise) ATP is a major feature in Elliott that is used to project future inventory balance. The idea of ATP is that the Qty Allocated (or what we call requirement) is a lump ...

    • IMATPRSN Inventory Management Available to Promise Report

      Available To Promise Report Application Overview Information for this report comes from the ATP Open Item file, which merges order information from COP, IM, PO, BOMP, and SFC. Order entry and sales people can use this report to determine future item ...