Skip to main content

Available To Promise (ATP) Report

A guide to the Available to Promise/Available to Sale report.

S
Written by Stephanie Kelley
Updated over 2 months ago

The Available To Promise (ATP) report stands as a cornerstone for dynamic and efficient inventory management. It empowers businesses by offering a precise forecast of inventory genuinely available for sale, meticulously excluding items already committed to existing sales orders or sold but pending shipment. Effective use of the ATP report allows organizations to sharpen control over customer distribution, enhance the accuracy of inventory predictions, improve promise accuracy for customer orders, and ultimately boost overall operational agility and customer satisfaction.

This guide will walk you through its functionalities and how to interpret its valuable data.

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

The ATP report offers significant benefits for managing your production and delivery workflows:

  • Clear Visibility: It provides precise insights into the quantity of products available to fulfill customer orders on any given day.

  • Demand Forecasting: The report inherently considers demand factors, allowing you to anticipate customer needs and adjust your ordering strategy for popular items accordingly.

  • Informed Stock Management: Unlike physical stock quantities, ATP figures can be negative. A positive ATP indicates available inventory for sale. A negative ATP signifies that current orders exceed your available (non-allocated, undamaged) inventory, signaling a need to reorder or produce more.

  • Improved Delivery Estimates: By offering a clear view of available stock and upcoming receipts (Open PO Qty), the report helps you provide more accurate estimated delivery times to your customers.

  • Efficient Navigation with Hyperlinks: To enhance usability and allow for quicker in-depth analysis, several columns in the ATP report interface act as hyperlinks. This functionality allows for seamless navigation to related screens for more detailed investigation:

    • Clicking a SKU value will take you to the Product List screen, filtered for that specific client and SKU.

    • Clicking values in Total Undamaged Quantity, Damaged Qty, or Allocated SO Item Qty will navigate you to the Inventory by Location screen. This screen will be pre-filtered by warehouse, client, SKU, and the relevant inventory status (e.g., excluding damaged for Total Undamaged Quantity, showing only damaged items for Damaged Qty, or displaying non-Stock statuses for Allocated SO Item Qty).

    • Clicking the Open SO Qty will redirect you to the Shipment Order Backlog screen, filtered for the specific warehouse, client, and SKU.

    • Clicking the Kit Type will navigate to the Kit Inventory Report, filtered for the warehouse, client, and SKU.

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 ATP report is product-centric, with each line detailing inventory information for a specific product, by warehouse. All quantity fields are based on the Unit of Measure (UOM). It operates in real-time, refreshing automatically when key inventory-affecting actions occur, such as:

  • Creation of new purchase orders (manual or imported).

  • Receiving, canceling, or deleting purchase orders.

  • Adding, removing, or adjusting inventory.

  • Placement of new shipment orders (manual, imported, API, or store download).

  • Shipping, canceling, or deleting shipment orders.


Column Explanations

The table below details the columns found in the ATP report, their descriptions, calculation logic, and corresponding Open API fields. All quantity fields represent UOM-based values.

The Open API method to obtain this report as followed:

GET /v{version}/Report/AvailableToPromise/i/{index}/s/{size}

Note: Please use version as 3.2 to retrieve the most updated version of the endpoint.

Field

Description

Formula

Open API Field

Total Quantity

The absolute total physical quantity of the product in the warehouse, including both undamaged and damaged items.

(Undamaged Qty) + (Damaged Qty)

totalQuantity

Undamaged Quantity

The total physical quantity of undamaged items for the product in the warehouse

(Total Qty) - (Damaged Qty)

undamagedQuantity

Undamaged Quantity

The total quantity of the product that is currently identified as damaged within the warehouse

Sum of inventory quantities with a damage reason

damagedQuantity

Open SO Qty

The total quantity of the product on shipment orders that are not yet fully shipped or canceled. This represents current demand from customers

Sum of UOM for non-shipped/non-canceled Shipment Order lines.

openShipmentOrderQuantity

Open PO Qty

The total quantity of the product expected to be received from purchase orders that are not yet fully received or canceled. This represents incoming supply.

Sum of UOM for non-received/non-canceled Purchase Order lines.

openPurchaseOrderQuantity

Current ATP

The current inventory quantity available to promise for new shipment orders, based on current undamaged stock and existing open sales orders.

(Undamaged Quantity) - (Open SO Qty)

currentATPQuantity

Planned ATP

The projected inventory quantity available to promise, considering current ATP plus expected incoming stock from open purchase orders.

(Current ATP) + (Open PO Qty)

plannedATPQuantity

Pickable Qty

The quantity of undamaged, non-allocated inventory that is physically available in pickable locations (i.e., not in locked or allocation-prevented locations).

(Undamaged Quantity - Allocated SO Item Qty) - (Inventory in Locked Locations) - (Inventory in Allocation Prevented Locations)

pickableQuantity

OnHand Qty

The quantity of undamaged inventory physically present in the warehouse in locations that are configured to be synced with external sales channels.

Undamaged Quantity - (Inventory in Sync Prevented Locations)

onHandQuantity

Sellable Qty

The OnHand Qty that is available to be sold, after accounting for current commitments to Open SO Qty.

(OnHand Qty) - (Open SO Qty)

sellableQuantity

Unallocated SO Item Qty

The portion of Open SO Qty for which inventory has not yet been specifically allocated.

(Open SO Qty) - (Sum of UOM for inventory allocated, picked, packed, loaded, or sorted for sales orders)

unallocatedShipmentOrderQuantity

Allocated SO Item Qty

The portion of Open SO Qty for which inventory has been specifically allocated.

(Open SO Qty) - (Unallocated SO Item Qty)

allocatedShipmentOrderQuantity

Kit Type

Identifies the product's kitting nature: 'Kit to Stock', 'Kit to Order' or not a kit. Affects ATP calculation, especially for 'Kit to Order'.

-

kitTypeName (kitTypeId)


Couldn’t Find What You Were Looking For?

Visit to our Help Center to search for more documents!

Did this answer your question?