You can generate the Inventory Status report to investigate planned inventory transactions, when Committed or Ordered quantities exist for an item, using the Normal (this is the default) or Available-to-Promise layout.
Choose
from the SAP Business One Main Menu.In the Inventory Status - Selection Criteria window, choose OK.
From the Double-click row number to open following report dropdown list, select Normal or Available-to-Promise.
Double-click on the row number of an item.
A list of all planned inventory transactions for the item is displayed in the Inventory Status report window.
Note
You can also generate the Inventory Status report for the ATP layout directly by doing the following:
Right-click in the Item Master Data window for Inventory Items and choose Available-to-Promise
Choose the Display Available-to-Promise Report radio button in the Item Availability Check window
Right-click a row in a Sales A/R or Purchasing A/P document and choose Available-to-Promise
The document type and number. The type is displayed as an abbreviation, such as OR for order, or PO for purchase order. |
The name of the business partner in the document. |
The order date and delivery date from the document. If the document is a Production Order, the due date is displayed as the delivery date. |
The quantity of an item reserved from the inventory for the following document types:
Note A/R correction invoices are relevant only for the following localizations: Czech Republic, Hungary, Poland, and Slovakia. End of the note. |
The quantity of an item already purchased or produced, but not yet received. The following document types contribute to the quantity displayed in this field:
Note A/P correction invoices are relevant only for the following localizations: Czech Republic, Hungary, Poland, and Slovakia. End of the note. |
The type of unit by which you manage the inventory, for example, box, carton, or case, as specified in the Item Master Data. |
This report is sorted according to the Delivery Date, in ascending order.
The following additional fields appear in the ATP layout:
When the layout is opened from Item Availability Check window, the warehouse code appears. This field is empty when opened from the Inventory Status window. |
The current stock level of the item for the selected warehouse range. This is the quantity physically in the warehouse. |
The quantity of an item already purchased or produced, but not yet received. The following document types contribute to the quantity displayed in this field:
Note A/P correction invoices are relevant only for the following localizations: Czech Republic, Hungary, Poland, and Slovakia. End of the note. |
The quantity of an item reserved from the inventory for the following document types:
Note A/R correction invoices are relevant only for the following localizations: Czech Republic, Hungary, Poland, and Slovakia. End of the note. |
The quantity of an item that will be available when the Committed stock is issued from the warehouse and the Ordered stock is received by the warehouse (for the selected warehouse range). The quantity available is calculated as follows: Available = In Stock quantity (only in the first row item) + Ordered quantity – Committed quantity. If the available stock for an item is negative, the value appears in red. |
The item's Sales A/R or Purchasing A/P inventory unit of measure (if specified in the Item Master Data window or sales and purchasing documents) stored in the document, at the row level. |
The items per unit value stored in the document at the row level. |
When this option is selected (this is the default) orders with a Delivery Date beyond the item's lead time are included in the report. Note The item's lead time is defined in the Item Master Data window, Planning Data tab. End of the note. |
The Inventory Status (Available-to-Promise) report considers work orders, sales orders, purchase orders, sales A/R and purchasing A/P reserve invoices, and sales A/R and purchasing A/P reserve invoices.