Share via

Table "Inventory Adjustment Buffer"

ID 5895
Namespace: Microsoft.Inventory.Costing

Properties

Name Value
Caption Inventory Adjustment Buffer
ReplicateData False
DataClassification CustomerContent

Fields

Name Type Description
"Entry No." Integer
"Item No." Code[20]
"Posting Date" Date
"Document No." Code[20]
"Location Code" Code[10]
"Item Ledger Entry No." Integer
"Item Ledger Entry Quantity" Decimal
"Cost Amount (Actual)" Decimal
"Cost Amount (Actual) (ACY)" Decimal
"Expected Cost" Boolean
"Valued By Average Cost" Boolean
"Valuation Date" Date
"Entry Type" Enum Microsoft.Inventory.Costing."Cost Entry Type"
"Variance Type" Enum Microsoft.Inventory.Costing."Cost Variance Type"
"Cost Amount (Expected)" Decimal
"Cost Amount (Expected) (ACY)" Decimal
"Variant Code" Code[10]
SystemId Guid
SystemCreatedAt DateTime
SystemCreatedBy Guid
SystemModifiedAt DateTime
SystemModifiedBy Guid
SystemRowVersion BigInteger

Methods

CalcItemLedgEntryCost

procedure CalcItemLedgEntryCost(ItemLedgEntryNo: Integer, Expected: Boolean)

Parameters

Name Type Description
ItemLedgEntryNo Integer
Expected Boolean

SumCostsTillValuationDate

procedure SumCostsTillValuationDate(var ValueEntry: Record "Value Entry")

Parameters

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

AddActualCostBuf

procedure AddActualCostBuf(ValueEntry: Record "Value Entry", NewAdjustedCost: Decimal, NewAdjustedCostACY: Decimal, ItemLedgEntryPostingDate: Date)

Parameters

Name Type Description
ValueEntry Table Microsoft.Inventory.Ledger."Value Entry"
NewAdjustedCost Decimal
NewAdjustedCostACY Decimal
ItemLedgEntryPostingDate Date

AddBalanceExpectedCostBuf

procedure AddBalanceExpectedCostBuf(ValueEntry: Record "Value Entry", NewAdjustedCost: Decimal, NewAdjustedCostACY: Decimal)

Parameters

Name Type Description
ValueEntry Table Microsoft.Inventory.Ledger."Value Entry"
NewAdjustedCost Decimal
NewAdjustedCostACY Decimal

AddOrderCost

procedure AddOrderCost(ItemLedgEntryNo: Integer, EntryType: Option, VarianceType: Option, CostAmt: Decimal, CostAmtLCY: Decimal)

Parameters

Name Type Description
ItemLedgEntryNo Integer
EntryType Option
VarianceType Option
CostAmt Decimal
CostAmtLCY Decimal

AddCost

procedure AddCost(ItemLedgEntryNo: Integer, EntryType: Enum "Cost Entry Type", VarianceType: Enum "Cost Variance Type", CostAmt: Decimal, CostAmtLCY: Decimal)

Parameters

Name Type Description
ItemLedgEntryNo Integer
EntryType Enum Microsoft.Inventory.Costing."Cost Entry Type"
VarianceType Enum Microsoft.Inventory.Costing."Cost Variance Type"
CostAmt Decimal
CostAmtLCY Decimal

Events

OnAddActualCostBufOnBeforeInsert

[IntegrationEvent(False,False)]
local procedure OnAddActualCostBufOnBeforeInsert(var InventoryAdjustmentBuffer: Record "Inventory Adjustment Buffer", ValueEntry: Record "Value Entry")

Parameters

Name Type Description
InventoryAdjustmentBuffer Table Microsoft.Inventory.Costing."Inventory Adjustment Buffer"
ValueEntry Table Microsoft.Inventory.Ledger."Value Entry"

OnSumCostsTillValuationDateGetItem

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

Parameters

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

OnSumCostsTillValuationDateOnAfterSetCostAmounts

[IntegrationEvent(False,False)]
local procedure OnSumCostsTillValuationDateOnAfterSetCostAmounts(var InventoryAdjustmentBuffer: Record "Inventory Adjustment Buffer", PrevInventoryAdjustmentBufferSum: Record "Inventory Adjustment Buffer", QtyFactor: Decimal)

Parameters

Name Type Description
InventoryAdjustmentBuffer Table Microsoft.Inventory.Costing."Inventory Adjustment Buffer"
PrevInventoryAdjustmentBufferSum Table Microsoft.Inventory.Costing."Inventory Adjustment Buffer"
QtyFactor Decimal

OnSumCostsTillValuationDateOnBeforeCalcSums

[IntegrationEvent(False,False)]
local procedure OnSumCostsTillValuationDateOnBeforeCalcSums(var Rec: Record "Inventory Adjustment Buffer", var QtyFactor: Decimal, FromDate: Date, ToDate: Date, ValueEntry: Record "Value Entry")

Parameters

Name Type Description
Rec Table Microsoft.Inventory.Costing."Inventory Adjustment Buffer"
QtyFactor Decimal
FromDate Date
ToDate Date
ValueEntry Table Microsoft.Inventory.Ledger."Value Entry"

See also