Show TOC

Object documentationInventory Status Window (Normal and ATP Layout) Locate this document in the navigation structure

 

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.

  1. Choose   Inventory   Inventory Reports   Inventory Status   from the SAP Business One Main Menu.

  2. In the Inventory Status - Selection Criteria window, choose OK.

  3. From the Double-click row number to open following report dropdown list, select Normal or Available-to-Promise.

  4. 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 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

End of the note.
Inventory Status – Planned Inventory Transactions (Normal Layout)
Document

The document type and number. The type is displayed as an abbreviation, such as OR for order, or PO for purchase order.

Customer/Vendor

The name of the business partner in the document.

Order Date, Delivery Date

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.

Committed

The quantity of an item reserved from the inventory for the following document types:

  • Sales orders

  • Production orders (the quantity used for producing a parent item)

  • A/R reserve invoices

  • A/R correction invoices

Note Note

A/R correction invoices are relevant only for the following localizations: Czech Republic, Hungary, Poland, and Slovakia.

End of the note.
Ordered

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:

  • Purchase orders

  • Production orders (the quantity planned to receive from production)

  • A/P reserve invoices

  • A/P correction invoices

Note Note

A/P correction invoices are relevant only for the following localizations: Czech Republic, Hungary, Poland, and Slovakia.

End of the note.
Inventory UoM

The type of unit by which you manage the inventory, for example, box, carton, or case, as specified in the Item Master Data.

Inventory Status – Planned Inventory Transactions (Available - to - Promise Layout)

This report is sorted according to the Delivery Date, in ascending order.

The following additional fields appear in the ATP layout:

Warehouse

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.

In Stock

The current stock level of the item for the selected warehouse range. This is the quantity physically in the warehouse.

Ordered

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:

  • Purchase orders

  • Production orders (the quantity planned to receive from production)

  • A/P reserve invoices

  • A/P correction invoices

Note Note

A/P correction invoices are relevant only for the following localizations: Czech Republic, Hungary, Poland, and Slovakia.

End of the note.
Committed

The quantity of an item reserved from the inventory for the following document types:

  • Sales orders

  • Production orders (the quantity used for producing a parent item)

  • A/R reserve invoices

  • A/R correction invoices

Note Note

A/R correction invoices are relevant only for the following localizations: Czech Republic, Hungary, Poland, and Slovakia.

End of the note.
Available

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.

Unit of Measure

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.

Items per Unit

The items per unit value stored in the document at the row level.

Display Orders Beyond Item's Lead Time

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 Note

The item's lead time is defined in the Item Master Data window, Planning Data tab.

End of the note.
Country-Specific Fields: Czech Republic, Hungary, Poland, Russia, and Slovakia

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.