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 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.
Location
To easily reach the ATP report, please enter either "ATP" or "available to promise" into the search bar and click the available option.
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.
Each quantity field represents UOM based values.
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, can be retrived throughout API or can be downloaded from your store.
You ship, cancel, or delete a shipment order.
Column Explanations
Below are explanations for the ATP-related columns on this report.
Each quantity field is calculated as UOM amounts.
Field | Description | Formula |
Total Quantity | The total amount of inventory for the product in the warehouse, including reserved inventory. | (Free inventory) + (Allocated inventory) |
Open SO Qty | The total number of products included in shipment orders with statuses in Open, Shortage, On Hold, Ready to Pick, Ready to Pack, Ready to Load, and Ready to Ship. This quantity does not include shipped and canceled shipment orders. | The total number of products included in shipment orders |
Open PO Qty | The total number of products included in purchase orders with statuses in Pending. This quantity does not include received and canceled purchase orders. | The total number of non-received products included in purchase orders |
Current ATP | The current ATP quantity refers to the convenient sale quantity. It is based on current inventory and current demand. Essentially, the calculation is the difference between total available inventory and existing shipment order quantity. | (Free inventory) - (Open SO Qty) |
Planned ATP | The available inventory quantity that you can sell, which includes planned inventory to be received as well. Essentially, it is calculated by adding the planned purchase quantity to the Current ATP. | (Free inventory) + (Open PO Qty) - (Open SO Qty) |
Pickable Qty* (currently only available in Open API) | The inventory available for fulfilling orders. Referred as non-damaged free inventory present in locations which are not locked and inventory sync is not prevented | (Free inventory) - [(Damaged Qty)+ (Inventory in Locked or Inventory Sync Prevented Locations ) ] |
OnHand Qty* (currently only available in Open API) | The non-damaged total inventory in locations where sync inventory is not prevented. | (Total Inventory) - [(Damaged Qty)+(Inventory in Sync Prevented Locations ) ] |
Sellable Qty* (currently only available in Open API) | Calculated as removing Open SO Qty from the OnHand qty | (OnHand Qty) - (TotalSOQty) |
Total Unallocated SO Item Qty* (currently only available in Open API) | Refers to the inventory qty demanded by shipment orders but not allocated yet | (Quantity in UOM needed to fulfill open SOs)-(Sum of inventory in allocated or above status) |
Couldn’t Find What You Were Looking For?
Visit to our Help Center to search for more documents!