Table "Average Cost Calc. Overview"

ID 5847
Namespace: Microsoft.Inventory.Costing

Properties

Name Value
Caption Average Cost Calc. Overview
DataClassification CustomerContent

Fields

Name Type Description
"Entry No." Integer
Type Option
"Valuation Date" Date
"Item No." Code[20]
"Location Code" Code[10]
"Variant Code" Code[10]
"Cost is Adjusted" Boolean
"Attached to Entry No." Integer
"Attached to Valuation Date" Date
Level Integer
"Item Ledger Entry No." Integer
"Posting Date" Date
"Entry Type" Enum Microsoft.Inventory.Ledger."Item Ledger Entry Type"
"Document Type" Option
"Document No." Code[20]
"Document Line No." Integer
Description Text[100]
Quantity Decimal
"Applied Quantity" Integer
"Cost Amount (Expected)" Decimal
"Cost Amount (Actual)" Decimal
SystemId Guid
SystemCreatedAt DateTime
SystemCreatedBy Guid
SystemModifiedAt DateTime
SystemModifiedBy Guid
SystemRowVersion BigInteger

Methods

CalculateAverageCost

procedure CalculateAverageCost(): Decimal

Returns

Type Description
Decimal

CalculateRemainingQty

procedure CalculateRemainingQty(): Decimal

Returns

Type Description
Decimal

CalculateCostAmt

procedure CalculateCostAmt(Actual: Boolean): Decimal

Parameters

Name Type Description
Actual Boolean

Returns

Type Description
Decimal

SetItemFilters

procedure SetItemFilters()

Events

OnAfterSetItemFilters

[IntegrationEvent(False,False)]
local procedure OnAfterSetItemFilters(var ValueEntry: Record "Value Entry", AverageCostCalcOverview: Record "Average Cost Calc. Overview")

Parameters

Name Type Description
ValueEntry Table Microsoft.Inventory.Ledger."Value Entry"
AverageCostCalcOverview Table Microsoft.Inventory.Costing."Average Cost Calc. Overview"

See also