Explanation of ATP LP Type - Negative Sign (-) vs (*) Symbols

Explanation of ATP LP Type - Negative Sign (-) vs (*) Symbols

Release Date: 5/17/17

Q - For the ATP (Available to Promise) processing screen, can you advise what the “ * “ (asterisk) symbol means next to the 792*?  Also, why do some LPs have the ” - “ (negative sign) and some are blank. See sample screen below:



A - As you probably already know, the ATP record type LP stands for "plan orders."  Plan orders are created by the system automatically when you perform ATP regen.  Like other ATP types, plan orders can be categorized as  replenishment ( + ) or requirement ( - ). Replenishment ATP records increase the quantity-on-hand balance, so their quantity is positive.  Requirement ATP records decrease the quantity-on-hand balance, so their quantity is negative.  In Elliott's standard numeric value presentation convention, the negative values are presented with a trailing negative sign ( - ).  Positive values do not show a trailing sign.  
  


Plan orders can be either a purchase order or a production order (BOMP Work Order). For plan production orders, the ATP records involve both parent and component items. If the system detects a plan order, then for that parent item, the plan order quantity is positive (+) since it will increase the quantity-on-hand balance when the parent item is produced. On the other hand, for the components of that plan order, the plan order quantity is negative (-) since it will decrease the quantity-on-hand when the parent item is produced.

Elliott ATP, by default, is a just-in-time (JIT) planning system. That is to say, we will plan for just enough quantity to meet the requirement. On the other hand, your vendors or production staff may place restrictions on your order with requirements like order multiple or order minimum. The ATP process screen is for the planner to convert the plan orders to an actual order.  So the system tries to warn the planner that there may be some issues with the suggested quantity.  The asterisk ( * ) simply means there is some issue with the quantity -- like it may not meet the order multiple or minimum order requirements as set up in the Item Master. In your example, item# 0 358 365 0041 is set up with order minimum = 234 and order multiple = 234. Even though 792 > 234, which meets the order minimum requirement, 792 is not a multiple of 234. As a planner, you can either order higher quantity or consolidate with a later-day plan order so it meets these requirements.

It is possible to configure Elliott so the plan order quantity it generates takes into consideration the order minimum and the order multiple. See the following Knowledge Base article for more details:

EMK



    • Related Articles

    • 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 ...
    • 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 ...
    • 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, ...
    • 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 ...
    • Feature - ATP Regen to Consider Order Multiple and Economic Order Qty

      Release Date: 03/09/2016 Revision Date: 01/20/2021 Version: 8.5 & Up When running the ATP Regen to create plan orders, the program only creates enough plan order quantity to make sure there will be no negative inventory in the future. The program ...