Report "Calculate Inventory"

ID 790
Namespace: Microsoft.Inventory.Counting.Journal

Properties

Name Value
Caption Calculate Inventory
ProcessingOnly True

Methods

SetItemJnlLine

procedure SetItemJnlLine(var NewItemJnlLine: Record "Item Journal Line")

Parameters

Name Type Description
NewItemJnlLine Table Microsoft.Inventory.Journal."Item Journal Line"

ValidatePostingDate

procedure ValidatePostingDate()

InsertItemJnlLine

procedure InsertItemJnlLine(ItemNo: Code[20], VariantCode2: Code[10], DimEntryNo2: Integer, BinCode2: Code[20], Quantity2: Decimal, PhysInvQuantity: Decimal)

Parameters

Name Type Description
ItemNo Code[20]
VariantCode2 Code[10]
DimEntryNo2 Integer
BinCode2 Code[20]
Quantity2 Decimal
PhysInvQuantity Decimal

InitializeRequest

procedure InitializeRequest(NewPostingDate: Date, DocNo: Code[20], ItemsNotOnInvt: Boolean, InclItemWithNoTrans: Boolean)

Parameters

Name Type Description
NewPostingDate Date
DocNo Code[20]
ItemsNotOnInvt Boolean
InclItemWithNoTrans Boolean

SetHideValidationDialog

procedure SetHideValidationDialog(NewHideValidationDialog: Boolean)

Parameters

Name Type Description
NewHideValidationDialog Boolean

InitializePhysInvtCount

procedure InitializePhysInvtCount(PhysInvtCountCode2: Code[10], CountSourceType2: Option)

Parameters

Name Type Description
PhysInvtCountCode2 Code[10]
CountSourceType2 Option

GetLocation

procedure GetLocation(LocationCode: Code[10]): Boolean

Parameters

Name Type Description
LocationCode Code[10]

Returns

Type Description
Boolean

SetSkipDim

procedure SetSkipDim(NewSkipDim: Boolean)

Parameters

Name Type Description
NewSkipDim Boolean

AddZeroQtySKU

procedure AddZeroQtySKU()

Events

OnAfterGetRecordItemLedgEntryOnBeforeUpdateBuffer

[IntegrationEvent(False,False)]
local procedure OnAfterGetRecordItemLedgEntryOnBeforeUpdateBuffer(var Item: Record Item, ItemLedgEntry: Record "Item Ledger Entry", var ByBin: Boolean, var IsHandled: Boolean)

Parameters

Name Type Description
Item Table Microsoft.Inventory.Item.Item
ItemLedgEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
ByBin Boolean
IsHandled Boolean

OnAfterInsertItemJnlLine

[IntegrationEvent(False,False)]
local procedure OnAfterInsertItemJnlLine(var ItemJournalLine: Record "Item Journal Line")

Parameters

Name Type Description
ItemJournalLine Table Microsoft.Inventory.Journal."Item Journal Line"

OnAfterItemOnPreDataItem

[IntegrationEvent(False,False)]
local procedure OnAfterItemOnPreDataItem(var Item: Record Item, ZeroQty: Boolean, IncludeItemWithNoTransaction: Boolean)

Parameters

Name Type Description
Item Table Microsoft.Inventory.Item.Item
ZeroQty Boolean
IncludeItemWithNoTransaction Boolean

OnAfterWhseEntrySetFilters

[IntegrationEvent(False,False)]
local procedure OnAfterWhseEntrySetFilters(var WarehouseEntry: Record "Warehouse Entry", var ItemJournalLine: Record "Item Journal Line")

Parameters

Name Type Description
WarehouseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"
ItemJournalLine Table Microsoft.Inventory.Journal."Item Journal Line"

OnItemLedgerEntryOnAfterPreDataItem

[IntegrationEvent(False,False)]
local procedure OnItemLedgerEntryOnAfterPreDataItem(var ItemLedgerEntry: Record "Item Ledger Entry", var Item: Record Item)

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
Item Table Microsoft.Inventory.Item.Item

OnItemLedgerEntryOnAfterGetRecordOnBeforeUpdateBuffer

[IntegrationEvent(False,False)]
local procedure OnItemLedgerEntryOnAfterGetRecordOnBeforeUpdateBuffer(var WarehouseEntry: Record "Warehouse Entry")

Parameters

Name Type Description
WarehouseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"

OnInsertItemJnlLineOnBeforeInit

[IntegrationEvent(False,False)]
local procedure OnInsertItemJnlLineOnBeforeInit(var ItemJournalLine: Record "Item Journal Line")

Parameters

Name Type Description
ItemJournalLine Table Microsoft.Inventory.Journal."Item Journal Line"

OnInsertItemJnlLineOnAfterCalcShouldInsertItemJnlLine

[IntegrationEvent(True,False)]
local procedure OnInsertItemJnlLineOnAfterCalcShouldInsertItemJnlLine(ItemNo: Code[20], VariantCode2: Code[10], DimEntryNo2: Integer, BinCode2: Code[20], Quantity2: Decimal, PhysInvQuantity: Decimal, ZeroQty: Boolean, var ShouldInsertItemJnlLine: Boolean, Location: Record Location, var NextLineNo: Integer)

Parameters

Name Type Description
ItemNo Code[20]
VariantCode2 Code[10]
DimEntryNo2 Integer
BinCode2 Code[20]
Quantity2 Decimal
PhysInvQuantity Decimal
ZeroQty Boolean
ShouldInsertItemJnlLine Boolean
Location Table Microsoft.Inventory.Location.Location
NextLineNo Integer

OnInsertItemJnlLineOnAfterValidateLocationCode

[IntegrationEvent(False,False)]
local procedure OnInsertItemJnlLineOnAfterValidateLocationCode(ItemNo: Code[20], VariantCode2: Code[10], DimEntryNo2: Integer, BinCode2: Code[20], Quantity2: Decimal, PhysInvQuantity: Decimal, var ItemJournalLine: Record "Item Journal Line")

Parameters

Name Type Description
ItemNo Code[20]
VariantCode2 Code[10]
DimEntryNo2 Integer
BinCode2 Code[20]
Quantity2 Decimal
PhysInvQuantity Decimal
ItemJournalLine Table Microsoft.Inventory.Journal."Item Journal Line"

OnAddZeroQtySKUOnBeforeInsertQuantityOnHandBuffer

[IntegrationEvent(True,False)]
local procedure OnAddZeroQtySKUOnBeforeInsertQuantityOnHandBuffer(var TempInventoryBuffer: Record "Inventory Buffer" temporary, StockkeepingUnit: Record "Stockkeeping Unit", Item: Record Item)

Parameters

Name Type Description
TempInventoryBuffer Table Microsoft.Inventory.Counting.Journal."Inventory Buffer"
StockkeepingUnit Table Microsoft.Inventory.Location."Stockkeeping Unit"
Item Table Microsoft.Inventory.Item.Item

OnBeforeItemOnAfterGetRecord

[IntegrationEvent(True,False)]
local procedure OnBeforeItemOnAfterGetRecord(var Item: Record Item, var IsHandled: Boolean)

Parameters

Name Type Description
Item Table Microsoft.Inventory.Item.Item
IsHandled Boolean

OnBeforeFunctionInsertItemJnlLine

[IntegrationEvent(False,False)]
local procedure OnBeforeFunctionInsertItemJnlLine(ItemNo: Code[20], VariantCode2: Code[10], DimEntryNo2: Integer, BinCode2: Code[20], Quantity2: Decimal, PhysInvQuantity: Decimal, var ItemJournalLine: Record "Item Journal Line", var IsHandled: Boolean, Location: Record Location)

Parameters

Name Type Description
ItemNo Code[20]
VariantCode2 Code[10]
DimEntryNo2 Integer
BinCode2 Code[20]
Quantity2 Decimal
PhysInvQuantity Decimal
ItemJournalLine Table Microsoft.Inventory.Journal."Item Journal Line"
IsHandled Boolean
Location Table Microsoft.Inventory.Location.Location

OnBeforeInsertItemJnlLine

[IntegrationEvent(False,False)]
local procedure OnBeforeInsertItemJnlLine(var ItemJournalLine: Record "Item Journal Line", var InventoryBuffer: Record "Inventory Buffer")

Parameters

Name Type Description
ItemJournalLine Table Microsoft.Inventory.Journal."Item Journal Line"
InventoryBuffer Table Microsoft.Inventory.Counting.Journal."Inventory Buffer"

OnBeforeRetrieveBuffer

[IntegrationEvent(True,False)]
local procedure OnBeforeRetrieveBuffer(var TempInventoryBuffer: Record "Inventory Buffer" temporary, ItemLedgerEntry: Record "Item Ledger Entry", BinCode: Code[20], DimEntryNo: Integer, var Result: Boolean, var IsHandled: Boolean)

Parameters

Name Type Description
TempInventoryBuffer Table Microsoft.Inventory.Counting.Journal."Inventory Buffer"
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
BinCode Code[20]
DimEntryNo Integer
Result Boolean
IsHandled Boolean

OnBeforeQuantityOnHandBufferFindAndInsert

[IntegrationEvent(True,False)]
local procedure OnBeforeQuantityOnHandBufferFindAndInsert(var InventoryBuffer: Record "Inventory Buffer", WarehouseEntry: Record "Warehouse Entry")

Parameters

Name Type Description
InventoryBuffer Table Microsoft.Inventory.Counting.Journal."Inventory Buffer"
WarehouseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"

OnAfterFunctionInsertItemJnlLine

[IntegrationEvent(False,False)]
local procedure OnAfterFunctionInsertItemJnlLine(ItemNo: Code[20], VariantCode2: Code[10], DimEntryNo2: Integer, BinCode2: Code[20], Quantity2: Decimal, PhysInvQuantity: Decimal, var ItemJournalLine: Record "Item Journal Line")

Parameters

Name Type Description
ItemNo Code[20]
VariantCode2 Code[10]
DimEntryNo2 Integer
BinCode2 Code[20]
Quantity2 Decimal
PhysInvQuantity Decimal
ItemJournalLine Table Microsoft.Inventory.Journal."Item Journal Line"

OnItemLedgerEntryOnPreDataItemOnBeforeInsertQuantityOnHandBuffer

[IntegrationEvent(True,False)]
local procedure OnItemLedgerEntryOnPreDataItemOnBeforeInsertQuantityOnHandBuffer(var TempInventoryBuffer: Record "Inventory Buffer" temporary, Item: Record Item)

Parameters

Name Type Description
TempInventoryBuffer Table Microsoft.Inventory.Counting.Journal."Inventory Buffer"
Item Table Microsoft.Inventory.Item.Item

OnItemLedgerEntryOnPreDataItemOnBeforeClearQuantityOnHandBuffer

[IntegrationEvent(False,False)]
local procedure OnItemLedgerEntryOnPreDataItemOnBeforeClearQuantityOnHandBuffer(var ItemLedgerEntry: Record "Item Ledger Entry", Item: Record Item)

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
Item Table Microsoft.Inventory.Item.Item

OnCalcPhysInvQtyAndInsertItemJnlLineOnBeforeCheckIfInsertNeeded

[IntegrationEvent(False,False)]
local procedure OnCalcPhysInvQtyAndInsertItemJnlLineOnBeforeCheckIfInsertNeeded(InventoryBuffer: Record "Inventory Buffer")

Parameters

Name Type Description
InventoryBuffer Table Microsoft.Inventory.Counting.Journal."Inventory Buffer"

OnCalcPhysInvQtyAndInsertItemJnlLineOnBeforeFindset

[IntegrationEvent(False,False)]
local procedure OnCalcPhysInvQtyAndInsertItemJnlLineOnBeforeFindset(var InventoryBuffer: Record "Inventory Buffer")

Parameters

Name Type Description
InventoryBuffer Table Microsoft.Inventory.Counting.Journal."Inventory Buffer"

OnCalcWhseQtyOnAfterLotRequiredWhseEntryClearFilters

[IntegrationEvent(False,False)]
local procedure OnCalcWhseQtyOnAfterLotRequiredWhseEntryClearFilters(var WarehouseEntry: Record "Warehouse Entry")

Parameters

Name Type Description
WarehouseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"

OnCalcWhseQtyOnAfterLotRequiredWhseEntrySetFilters

[IntegrationEvent(False,False)]
local procedure OnCalcWhseQtyOnAfterLotRequiredWhseEntrySetFilters(var WarehouseEntry: Record "Warehouse Entry")

Parameters

Name Type Description
WarehouseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"

OnCalcWhseQtyOnAfterWhseEntrySetFilters

[IntegrationEvent(False,False)]
local procedure OnCalcWhseQtyOnAfterWhseEntrySetFilters(var WarehouseEntry: Record "Warehouse Entry")

Parameters

Name Type Description
WarehouseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"

OnInsertItemJnlLineOnAfterUpdateDimensionSetID

[IntegrationEvent(False,False)]
local procedure OnInsertItemJnlLineOnAfterUpdateDimensionSetID(var ItemJnlLine: Record "Item Journal Line")

Parameters

Name Type Description
ItemJnlLine Table Microsoft.Inventory.Journal."Item Journal Line"

OnPreDataItemOnAfterGetItemJnlTemplateAndBatch

[IntegrationEvent(False,False)]
local procedure OnPreDataItemOnAfterGetItemJnlTemplateAndBatch(var ItemJnlTemplate: Record "Item Journal Template", var ItemJnlBatch: Record "Item Journal Batch")

Parameters

Name Type Description
ItemJnlTemplate Table Microsoft.Inventory.Journal."Item Journal Template"
ItemJnlBatch Table Microsoft.Inventory.Journal."Item Journal Batch"

OnRetrieveBufferOnBeforeFind

[IntegrationEvent(True,False)]
local procedure OnRetrieveBufferOnBeforeFind(var InventoryBuffer: Record "Inventory Buffer", ItemLedgerEntry: Record "Item Ledger Entry")

Parameters

Name Type Description
InventoryBuffer Table Microsoft.Inventory.Counting.Journal."Inventory Buffer"
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"

OnReserveWarehouseOnAfterWhseEntry2SetFilters

[IntegrationEvent(False,False)]
local procedure OnReserveWarehouseOnAfterWhseEntry2SetFilters(var ItemJnlLine: Record "Item Journal Line", var WhseEntry: Record "Warehouse Entry", var WhseEntry2: Record "Warehouse Entry", EntryType: Option)

Parameters

Name Type Description
ItemJnlLine Table Microsoft.Inventory.Journal."Item Journal Line"
WhseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"
WhseEntry2 Table Microsoft.Warehouse.Ledger."Warehouse Entry"
EntryType Option

OnUpdateBufferOnBeforeInsert

[IntegrationEvent(True,False)]
local procedure OnUpdateBufferOnBeforeInsert(var InventoryBuffer: Record "Inventory Buffer", CalledFromItemLedgerEntry: Boolean)

Parameters

Name Type Description
InventoryBuffer Table Microsoft.Inventory.Counting.Journal."Inventory Buffer"
CalledFromItemLedgerEntry Boolean

OnUpdateBufferOnBeforeModify

[IntegrationEvent(True,False)]
local procedure OnUpdateBufferOnBeforeModify(var InventoryBuffer: Record "Inventory Buffer", CalledFromItemLedgerEntry: Boolean)

Parameters

Name Type Description
InventoryBuffer Table Microsoft.Inventory.Counting.Journal."Inventory Buffer"
CalledFromItemLedgerEntry Boolean

OnBeforeOnPreReport

[IntegrationEvent(False,False)]
local procedure OnBeforeOnPreReport(var ItemJournalLine: Record "Item Journal Line", var PostingDate: Date)

Parameters

Name Type Description
ItemJournalLine Table Microsoft.Inventory.Journal."Item Journal Line"
PostingDate Date

OnAddZeroQtyOnAfterFilterSKU

[IntegrationEvent(True,False)]
local procedure OnAddZeroQtyOnAfterFilterSKU(var Item: Record Item, var SKU: Record "Stockkeeping Unit")

Parameters

Name Type Description
Item Table Microsoft.Inventory.Item.Item
SKU Table Microsoft.Inventory.Location."Stockkeeping Unit"

OnAddZeroQtyOnAfterCalcShouldAddZeroQty

[IntegrationEvent(True,False)]
local procedure OnAddZeroQtyOnAfterCalcShouldAddZeroQty(var Item: Record Item, ZeroQty: Boolean, var ShouldAddZeroQty: Boolean)

Parameters

Name Type Description
Item Table Microsoft.Inventory.Item.Item
ZeroQty Boolean
ShouldAddZeroQty Boolean

OnAddZeroQtySKUOnBeforeInsertZeroQtySKU

[IntegrationEvent(True,False)]
local procedure OnAddZeroQtySKUOnBeforeInsertZeroQtySKU(var Item: Record Item, var SKU: Record "Stockkeeping Unit", var TempInventoryBuffer: Record "Inventory Buffer" temporary, var IsHandled: Boolean)

Parameters

Name Type Description
Item Table Microsoft.Inventory.Item.Item
SKU Table Microsoft.Inventory.Location."Stockkeeping Unit"
TempInventoryBuffer Table Microsoft.Inventory.Counting.Journal."Inventory Buffer"
IsHandled Boolean

OnInsertItemJnlLineOnBeforeValidateItemNo

[IntegrationEvent(False,False)]
local procedure OnInsertItemJnlLineOnBeforeValidateItemNo(var ItemJournalLine: Record "Item Journal Line")

Parameters

Name Type Description
ItemJournalLine Table Microsoft.Inventory.Journal."Item Journal Line"

OnCalcWhseQtyOnAfterGetWhseItemTrkgSetup

[IntegrationEvent(False,False)]
local procedure OnCalcWhseQtyOnAfterGetWhseItemTrkgSetup(LocationCode: Code[10], var ItemTrackingSetup: Record "Item Tracking Setup" temporary)

Parameters

Name Type Description
LocationCode Code[10]
ItemTrackingSetup Table Microsoft.Inventory.Tracking."Item Tracking Setup"

OnBeforeItemBinLocationIsCalculated

[IntegrationEvent(False,False)]
local procedure OnBeforeItemBinLocationIsCalculated(ItemLedgerEntry: Record "Item Ledger Entry", var IsHandled: Boolean, var IsCalculated: Boolean, var WarehouseEntry: Record "Warehouse Entry")

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
IsHandled Boolean
IsCalculated Boolean
WarehouseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"

OnInsertQuantityOnHandBufferOnBeforeInsert

[IntegrationEvent(True,False)]
local procedure OnInsertQuantityOnHandBufferOnBeforeInsert(var InventoryBuffer: Record "Inventory Buffer")

Parameters

Name Type Description
InventoryBuffer Table Microsoft.Inventory.Counting.Journal."Inventory Buffer"

OnWhseEntryLoopOnBeforeFindlast

[IntegrationEvent(False,False)]
local procedure OnWhseEntryLoopOnBeforeFindlast(var WarehouseEntry: Record "Warehouse Entry", var IsHandled: Boolean)

Parameters

Name Type Description
WarehouseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"
IsHandled Boolean

OnAfterGetRecordItemLedgEntryOnBeforeWhseEntryFind

[IntegrationEvent(False,False)]
local procedure OnAfterGetRecordItemLedgEntryOnBeforeWhseEntryFind(var WarehouseEntry: Record "Warehouse Entry", ItemLedgerEntry: Record "Item Ledger Entry")

Parameters

Name Type Description
WarehouseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"

OnItemBinLocationIsCalculatedOnBeforeFind

[IntegrationEvent(False,False)]
local procedure OnItemBinLocationIsCalculatedOnBeforeFind(var InventoryBuffer: Record "Inventory Buffer", ItemLedgerEntry: Record "Item Ledger Entry")

Parameters

Name Type Description
InventoryBuffer Table Microsoft.Inventory.Counting.Journal."Inventory Buffer"
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"

See also