Inventory Management IMATPRSN Help - Elliott Business Software

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 deliveries, the purchasing manager can use it to plan purchase orders, and light manufactures can use it for production planning.


To use this reporting tool, the Available To Promise enhancement must be enabled.  See Generate ATP File in the Utilities Setup section of this document.


In Elliott V7.4, the ATP Inquiry screen will display four zones separated by the following three lines:

            (A) Today Line

            (B) Lead Time Line

            (C) Lead Time + Planning Period Line

Any ATP data before Line (A) is internal data maintenance issues.  For example, if there is an outstanding PO Line Item Request/Promise Date showing 10/01/07 and today’s date is already 10/15/07, it is obvious you cannot count on this 10/01/07 date since that date has come and gone and you have not received the goods yet.  In most situations, this is because your organization lacks an internal mechanism to follow up with the vendor to get a revised estimated date of arrival.  In order for ATP to work and provide valuable information, we must make sure the date is accurate.  Therefore, any ATP records displayed before Line (A) – Today Line is an indication that those records should be revised.  This Line (A) provides better visibility for management to spot problems and effectively direct the staff to follow up with their work in a timely manner.


Line (B) is the Lead Time Line.  Every item can have a different lead time based on the Planning Lead Time (not the Lead Time field) set up in the Item Master file.  For example, if you place a purchase order with the default vendor for Item A and that vendor is overseas and it takes 60 days for the goods to arrive at your warehouse, counting their preparation, production time, plus the shipping, then the Planning Lead Time will be 60 days.  If you have a negative quantity balance before this 60 days line, it means there is a serious situation for you to look into.  You won’t be able to solve the problem by simply making an additional purchase because it will arrive too late, based on the Lead Time principle.  There may be other ways to solve the problem, like shipping via Air Cargo (which will increase your freight cost) or calling your customers to get their permission for late shipments.  If the problem still cannot be resolved, they should cancel the order.  If there is any negative quantity between Line (B) and Line (A), then it is considered “Past Due.”  So we call this area the “Past Due Zone.”


Line (C) is the Lead Time + Planning Period.  Planning Period refers to how often the buyers or planners will review an item to make a purchase decision.  If the buyer will review it on a weekly basis, then the Planning Period is 7 days.  If the buyer will review it on a bi-weekly basis, then the Planning Period is 14 days.  This is a flag to be set up in ATP Global Setup.  If you have a planning period of 14 days, with the previous example of 60 days lead time, Line (C) will be 60 days + 14 days.  Any negative quantity between Line (C) and Line (B) are called “current affairs,” because the buyer and planner should take care of it now.  If the buyer and planner do not take care of it now and wait for the next review (14 days later), then it will be late.  For this reason, we call this zone the “Current Zone.”


ATP records after Line (C) are called Future ATP Records.  If there is any negative quantity balance in this future zone, the planner can either take care of it or ignore it for now since we have enough time to respond when we review it again next time (14 days later, in the previous example).  You may not want to adjust future zone items because things can change and the customer might cancel the order.  While your customer may be able to cancel your order, you may not be able to cancel your PO with your vendor once their production is in motion and you eventually end up with the extra inventory.  In many situations, you want to wait until the last moment to issue a purchase order with your vendor.


These three lines will always be displayed on the ATP Inquiry and Process screen.  They are optional to print on the ATP Report based on the Global Setup.  If you do not setup Planning Lead Time and Planning Period, then Line (B) and (C) will not be meaningful.  Therefore, we suggest you set them up as part of the first step of configuring ATP.


Run Instructions


From Inventory Menu à Reports à Available To Promise Reports à Print







Date: Mar 25, 1998 -  1:09pm         Netcellent System Inc. - Demo                                                     Page    1


             A V A I L A B L E   T O   P R O M I S E   B Y   I T E M


Ranges: For All Locations

        For Item 1006-3042-3640  Thru 1006-3042-3640

        For Item Before 12/31/96

Order Type: S = Sales  P = Purchase B = BOMP Work Order  F = Shop Order


Item-Number     Item-Description                 Price     Cost UOM Qty-To-Ship   Qty-BO  Qty-Alloc Excess-Qty  Qty-On-PO     Qty-OH

Trx-Date T Ref-No Ref-Description                Order-No  Ord-Date PO/Job-No             Unit-Prc   Ext-Prc    Qty-Ord       Balance


1006-3042-3640  386DX-40 WORKSTATION, 4MB RAM   995.00  843.08  EA     20.00       6.00      26.00       1.00-     25.00        .00


01/29/96 S SBS138 A & M Data                     031094    01/29/96                         995.00   4975.00       5.00-       5.00-

02/16/96 S 543740 ABANAKI CORP.                  031137    02/16/96                         995.00    995.00       1.00-       6.00-

02/28/96 P 005485 SIC RESOURCE, INC.             001585-00 02/28/96                         800.95   4004.76       5.00        1.00-

03/25/96 S 875060 Abacus Computer Applications   031208    03/25/96                         957.19  14357.85      15.00-      16.00-

03/25/96 B 875060 Abacus Computer Applications   000103    03/25/96 CP031208                957.19  14357.85      15.00        1.00-

05/14/96 S 594208 3G Technology Inc.             031300    05/14/96                         995.00    995.00       1.00-       2.00-

05/14/96 S 594208 3G Technology Inc.             031301    05/14/96                         995.00    995.00       1.00-       3.00-

05/14/96 B                                       000071    05/14/96                         995.00   5970.00       6.00        3.00

05/14/96 B 594208 3G Technology Inc.             000107    05/14/96 CP031300                995.00    995.00       1.00        4.00

05/14/96 B 594208 3G Technology Inc.             000108    05/14/96 CP031301                995.00    995.00       1.00        5.00

06/19/96 S 594208 3G Technology Inc.             031349    06/19/96                         995.00    995.00       1.00-       4.00

06/19/96 B 594208 3G Technology Inc.             000115    06/19/96 CP031349                995.00    995.00       1.00        5.00

09/25/96 S 594208 3G Technology Inc.             031449    09/25/96                         995.00    995.00       1.00-       4.00

09/25/96 B 594208 3G Technology Inc.             000122    09/25/96 CP031449                995.00    995.00       1.00        5.00



Elliott Business Software
| Add-ons | Services
3rd Party Solutions | News & Events
Technical Support | Company Profile