Report "Inventory Valuation"

ID 1001
Namespace: Microsoft.Inventory.Reports

Reconcile your inventory subledger to the inventory account(s) in the general ledger at the end of each period. Include Expected Costs and Apply Location Filters to ensure that the Ending Date Value, Cost Posted to G/L and the Balance in the related Inventory or Inventory (Interim) Account are all in balance.

Properties

Name Value
DefaultLayout RDLC
RDLCLayout ./Inventory/Reports/InventoryValuation.rdlc
ApplicationArea #Basic,#Suite
Caption Inventory Valuation
EnableHyperlinks True
UsageCategory ReportsAndAnalysis
DataAccessIntent ReadOnly

Methods

AssignAmounts

procedure AssignAmounts(ValueEntry: Record "Value Entry", var InvoicedValue: Decimal, var InvoicedQty: Decimal, var ExpectedValue: Decimal, var ExpectedQty: Decimal, Sign: Decimal)

Parameters

Name Type Description
ValueEntry Table Microsoft.Inventory.Ledger."Value Entry"
InvoicedValue Decimal
InvoicedQty Decimal
ExpectedValue Decimal
ExpectedQty Decimal
Sign Decimal

CalculateItem

procedure CalculateItem(var Item: Record Item)

Parameters

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

SetStartDate

procedure SetStartDate(DateValue: Date)

Parameters

Name Type Description
DateValue Date

SetEndDate

procedure SetEndDate(DateValue: Date)

Parameters

Name Type Description
DateValue Date

InitializeRequest

procedure InitializeRequest(NewStartDate: Date, NewEndDate: Date, NewShowExpected: Boolean)

Parameters

Name Type Description
NewStartDate Date
NewEndDate Date
NewShowExpected Boolean

Events

OnBeforeOnAfterItemGetRecord

[IntegrationEvent(False,False)]
local procedure OnBeforeOnAfterItemGetRecord(var Item: Record Item, var SkipItem: Boolean)

Parameters

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

OnAfterGetRecordItemOnBeforeSkipEmptyLine

[IntegrationEvent(False,False)]
local procedure OnAfterGetRecordItemOnBeforeSkipEmptyLine(var Item: Record Item, var StartingInvoicedQty: Decimal, var IncreaseInvoicedQty: Decimal, var DecreaseInvoicedQty: Decimal, var IsHandled: Boolean, var IsEmptyLine: Boolean, var StartingExpectedQty: Decimal, var IncreaseExpectedQty: Decimal, var DecreaseExpectedQty: Decimal)

Parameters

Name Type Description
Item Table Microsoft.Inventory.Item.Item
StartingInvoicedQty Decimal
IncreaseInvoicedQty Decimal
DecreaseInvoicedQty Decimal
IsHandled Boolean
IsEmptyLine Boolean
StartingExpectedQty Decimal
IncreaseExpectedQty Decimal
DecreaseExpectedQty Decimal

OnItemOnAfterGetRecordOnAfterValueEntrySetInitialFilters

[IntegrationEvent(True,False)]
local procedure OnItemOnAfterGetRecordOnAfterValueEntrySetInitialFilters(var ValueEntry: Record "Value Entry", Item: Record Item)

Parameters

Name Type Description
ValueEntry Table Microsoft.Inventory.Ledger."Value Entry"
Item Table Microsoft.Inventory.Item.Item

OnCalculateItemOnBeforeAssignDecreaseAmounts

[IntegrationEvent(True,False)]
local procedure OnCalculateItemOnBeforeAssignDecreaseAmounts(var ValueEntry: Record "Value Entry", Item: Record Item)

Parameters

Name Type Description
ValueEntry Table Microsoft.Inventory.Ledger."Value Entry"
Item Table Microsoft.Inventory.Item.Item

OnCalculateItemOnAfterAssignDecreaseAmounts

[IntegrationEvent(True,False)]
local procedure OnCalculateItemOnAfterAssignDecreaseAmounts(var ValueEntry: Record "Value Entry", Item: Record Item, var DecreaseInvoicedValue: Decimal, var DecreaseInvoicedQty: Decimal, var DecreaseExpectedValue: Decimal, var DecreaseExpectedQty: Decimal, var IncreaseInvoicedValue: Decimal, var IncreaseInvoicedQty: Decimal, var IncreaseExpectedValue: Decimal, var IncreaseExpectedQty: Decimal)

Parameters

Name Type Description
ValueEntry Table Microsoft.Inventory.Ledger."Value Entry"
Item Table Microsoft.Inventory.Item.Item
DecreaseInvoicedValue Decimal
DecreaseInvoicedQty Decimal
DecreaseExpectedValue Decimal
DecreaseExpectedQty Decimal
IncreaseInvoicedValue Decimal
IncreaseInvoicedQty Decimal
IncreaseExpectedValue Decimal
IncreaseExpectedQty Decimal

OnGetOutboundItemEntryOnAfterSetItemLedgEntryFilters

[IntegrationEvent(True,False)]
local procedure OnGetOutboundItemEntryOnAfterSetItemLedgEntryFilters(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

See also