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 ...
    • Blanket POs Not Displaying on Stock Status ATP Screen

      Release Date: 3/20/2019 Q - How can I get Blanket POs to display on the Stock Status ATP screen? You show it on the legend as code "PB" but it doesn’t appear on the screen. See sample screen below: We use the blanket PO for estimated dates for ...
    • ARTYPMNT Accounts Receivable Customer Type File Maintenance

      Customer Type File Maintenance Application Overview The purpose of this program is to classify customers by type for pricing, commission, reporting and analysis purposes, and for sorting as needed. If you enabled COP shipping label in Global Setup -> ...
    • Change - Change Definition of Usage Type's in User Def CSV

      Release date: 6/19/20 Version 8.5 & Up In IM --> Report --> Reorder Advice/User Def CSV --> Maintenance --> User Defined CSV Layout, we changed the definition of UA, U1, U2, U3, U6, and UA type column values so they do not include usage from the ...
    • Feature - Toggle Equal Sign Export in User Defined CSV Export Report

      Release Date: 03/14/2025 Version: 8.5 & up Added an F5 option to I/M, Report, Reorder Advice/User Def CSV, Print, User Defined CSV Export and field 7, "Item Has Attribute" to toggle the value of Export Equal Sign between Y, N, and blank. Blank is the ...