Inventory history table

Beas dashboards > Using the dashboards > Item dashboard > Inventory history table

Top  Previous  Next

Inventory history

DASHBO~1_img28

DASHBO~1_img29

This table that shows the inventory history data of the selected item.

Only items with procurement mode set to Make are displayed in this dashboard.

 

 

Column

Description

Table Field

Item Code

Item code.

View: "BEASV_INVENTORY_HISTORY"."ItemCode"

Item Name

Item name.

View: "BEASV_INVENTORY_HISTORY"."ItemName"

Unit

Inventory UoM.

View: "BEASV_INVENTORY_HISTORY"."WarehouseUnit"

Whs Stock

Sum of stock amounts in Inventory UoM.

View: "BEASV_INVENTORY_HISTORY"."WarehouseStock"

Reserved Stock

Sum of the amounts reserved from the warehouse stock in Inventory UoM.

View: "BEASV_INVENTORY_HISTORY"."ReservedFromStock"

Blocked Stock

Sum of the blocked stock amounts in Inventory UoM.

View: "BEASV_INVENTORY_HISTORY"."BlockedStock"

Sales Order

Sum of sales order amounts in Inventory UoM.

View: "BEASV_INVENTORY_HISTORY"."SalesOrder"

Goods Issue for Production

Sum of the goods issue amounts for production in Inventory UoM.

View: "BEASV_INVENTORY_HISTORY"."GoodsIssueForProduction"

Goods Receipt From Production

Sum of the goods receipt from production in Inventory UoM.

View: "BEASV_INVENTORY_HISTORY"."GoodsReceiptFromProduction"

Purchase Orders

Sum of the goods receipt from purchase orders in Inventory UoM.

View: "BEASV_INVENTORY_HISTORY"."GoodsReceiptFromPO"

Available Balance

Available balance for the item:

Green: Positive or 0 balance.

Red: Negative balance.

View: "BEASV_INVENTORY_HISTORY"."AvailableBalance"


Help URL: https://help.beascloud.com/beas202106/index.html?inventory_history.htm