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.
Note: Kit-to-order product's values on this report are always shown as "0", as kit-to-order products cannot phsyically exist in the inventory. In other words, the inventory capacity of kit-to-order products can only be calculated based on the available component inventory.
Therefore, in order to check kit-to-order inventory capacities, please visit Kit Inventory Report
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 non-damaged inventory for the product in the warehouse, including allocated inventory. | (Total Inventory) - (Damaged 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 sum of UOM based non-shipped SO Line quantity per product |
Open PO Qty | The total number of non-received products included in purchase orders. | The sum of UOM based non-received PO Line quantity per product |
Current ATP | The total non-damaged inventory that can be used to fulfill future shipment orders | (Total Quantity) - (Open SO Qty) |
Planned ATP | The total planned inventory to fuilfill future shipment orders, including the Current ATP and inventory to be received through purchase orders. | (Current ATP) + (Open PO Qty) |
Pickable Qty | Refers to the non-allocated & undamaged product inventory that is located in locations where allocation is not prevented & location is not locked. Can be used to see the product inventory quantity that is available for new allocations. | (Non-allocated inventory qty) - [ (Damaged Qty)+ (inv. in Locked locations)+ (inv. in Allocation Prevented Locations ) ] |
OnHand Qty | Refers to the non-damaged total product inventory in locations where sync inventory is not prevented. Can be used to see the non-damaged product inventory quantity that can be sync with sales channels. | (Total Inventory) - [ (Damaged Qty)+(Inventory in Sync Prevented Locations) ] |
Sellable Qty | Refers to the on hand product inventory quantity that is sellable for future orders. | (OnHand Qty) - (Open SO Qty) |
Total Unallocated SO Item Qty | Refers to the inventory qty demanded by existing shipment orders but not allocated yet | (Quantity in UOM needed to fulfill all shipment orders)-(Sum of UOM inventory in allocated, picked,packed,loaded,sorted status) |
Couldn’t Find What You Were Looking For?
Visit to our Help Center to search for more documents!