Available to Promise (ATP) or Available to Sale allows businesses to keep the minimum amount of a given product on-hand so that they can utilize their inventory efficiently. ATP is the projected amount of inventory available to sell, not including allocated (reserved for sales orders) inventory, damaged quantity, and products that have already been sold (but not shipped). It enables businesses to control distribution to their customers and predict inventory. Read below to learn more about ATP reports and their function in Logiwa.
Using the ATP Report
ATP reports offer several key benefits for managing your production and delivery processes. These reports provide valuable insights into the amount that can be produced on a given day to fulfill customer orders.
Another primary advantage of ATP reports is their ability to consider the demand factor. You can use the ATP report to anticipate customer demands and adjust ordering for popular products. Unlike stock quantity, your ATP numbers can be negative. While a positive value indicates that you have inventory available to sell, a negative value indicates that your inventory is below your stock quantity. In other words, negative quantity means that the number of orders exceeds your physical inventory, letting you know that you need to order/produce more.
Also, by providing visibility into delivery expectations, these reports enable you to communicate estimated delivery times to your customers.
How the ATP Report Works
The Available To Promise report is a product-based report. Each line corresponds to a specific product in the inventory, and each quantity field within the report should be considered in relation to the product line.
Your Available To Promise report is a real-time report. The report refreshes itself when the following actions occur in the system:
When a new purchase order is placed in your account.
A purchase order can be created manually or can be imported with an excel file.
You receive, cancel, or delete a purchase order.
You add, remove, or adjust inventory.
A new shipment order is placed in your account.
Shipment orders can be created manually, can be imported with an excel file, or can be downloaded from your store.
You ship, cancel, or delete a shipment order.
Column Explanations
SKU: It is the SKU of the product.
Product Name: It is the name of the product.
Inventory Qty (Inventory OnHand - IoH): Inventory quantity equal to Total quantity without current shipment order quantities. This quantity not include allocated, damaged, and already sold products(open shipment orders). For better understanding please check the table below. Please consider that Open SO quantity already includes allocated quantity.
Total Qty | Allocated Qty | Open SO | Damaged Qty | IoH |
15 | 5 | 10 | 3 | 2 |
10 | 0 | 4 | 0 | 6 |
17 | 3 | 5 | 1 | 11 |
Open SO Qty: It represents the total number of products included in shipment orders with status in Shortage&On Hold, Ready to Pack, and Ready to Ship. This quantity doesn't include shipped and canceled shipment orders.
Open PO Qty: It represents the total number of products included in purchase orders with status in Pending. This quantity doesn't include received and canceled purchase orders.
Planned ATP: Planned ATP quantity refers to the available inventory quantity that you can sell which includes the planned receipt products as well.
Basically, it is calculated by adding the planned purchase quantity to the Current ATP.
[(Inventory Qty + Open PO Qty) - Open SO Qty]
Inventory ATP (Current ATP): The Current ATP quantity refers to the convenient sale quantity as of now. It is based on current inventory and current demand, basically, the calculation is the difference between total available inventory and existing shipment order quantity.
[(Total Qty) - (Damaged Qty) - (Open SO Qty)]
Couldn’t Find What You Were Looking For?
Visit to our Help Center to search for more documents!