Inventory Balance Report Layout

This section describes the layout of the Inventory Balance Report. In the following figure, the supply type is ONHAND.

Figure 1. Inventory Balance Report
Fields
Description
Date

The date when the receipt or shipment was made.

Node

The node where the receipt or shipment was made.

Item ID

The identifier of the item that was received or shipped out.

Item Description

The description of the item.

PC

The product class of the item.

UOM

The unit of measure for the item.

Supply Type

Indicates the availability of the inventory.

Segment Type

The segment types are:

MTC: Made To Customer

MTO: Made To Order

Segment

Inventory set aside to fulfill orders from a specific customer.

Ship By Date

The date by which shipment needs to be shipped from the warehouse.

Tag No.

The tag identifier of the item.

Opening Balance(Qty)

The quantity of the item at the beginning of the day.

Receipts

The quantity of the item received during the day.

Shipments

The quantity of the item shipped during the day.

Adjustments

The quantity of the item adjusted during the day.

Returns

The quantity of the item returned during the day.

Closing Balance(Qty)

The quantity of the item at the end of the day.

The Closing Balance is calculated as follows:

Closing Balance = Opening Balance + Receipts + Adjustments + Returns - Shipments

The Inventory Balance Report only displays items having at least one transaction during the day.

The Inventory Balance Report is displayed in portrait layout.