Table 5847 "Average Cost Calc. Overview"

Base Application · Microsoft.Inventory.Costing · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Average Cost Calc. Overview
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Entry No.	Integer	—
2	Type Δ BC28	Option	Specifies either that the entry is a summary entry, Closing Entry, or the type that was used in the calculation of the average cost of the item.	OptionCaption: Closing Entry,Increase,Applied Increase,Applied Decrease,Decrease,Revaluation
3	Valuation Date Δ BC28	Date	Specifies the valuation date associated with the average cost calculation.
4	Item No. Δ BC28	Code[20]	Specifies the number of the item associated with the entry.	TableRelation Table 27 “Item”
5	Location Code Δ BC28	Code[10]	Specifies the location code associated with the entry.	TableRelation Table 14 “Location”
6	Variant Code Δ BC28	Code[10]	Specifies the variant of the item on the line.	TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Item No.”)))
7	Cost is Adjusted Δ BC28	Boolean	Specifies whether the cost is adjusted for the entry.
11	Attached to Entry No.	Integer	—	TableRelation Table 32 “Item Ledger Entry” (Item Ledger Entry)
12	Attached to Valuation Date	Date	—
13	Level	Integer	—
21	Item Ledger Entry No. Δ BC28	Integer	Specifies the number of the item ledger entry that this entry is linked to.	TableRelation Table 32 “Item Ledger Entry” (Item Ledger Entry)
22	Posting Date Δ BC28	Date	Specifies the posting date for the entry.
23	Entry Type Δ BC28	Enum “Item Ledger Entry Type”	Specifies which type of transaction that the entry is created from.	enum Enum 78 “Item Ledger Entry Type”
24	Document Type Δ BC28	Option	Specifies the type of document that the average cost applies to.	OptionCaption: ,Sales Shipment,Sales Invoice,Sales Return Receipt,Sales Credit Memo,Purchase Receipt,Purchase Invoice,Purchase Return Shipment,Purchase Credit Memo,Transfer Shipment,Transfer Receipt,Service Shipment,Service Invoice,Service Credit Memo
25	Document No. Δ BC28	Code[20]	Specifies a document number for the entry.
26	Document Line No. Δ BC28	Integer	Specifies the document line that the comment applies to.
27	Description	Text[100]	—
31	Quantity Δ BC28	Decimal	Specifies the quantity associated with the entry.
32	Applied Quantity	Integer	—
33	Cost Amount (Expected) Δ BC28	Decimal	Specifies the expected cost in LCY of the quantity posting. via Page 5847 “Average Cost Calc. Overview”
34	Cost Amount (Actual) Δ BC28	Decimal	Specifies the adjusted cost in LCY of the quantity posting. via Page 5847 “Average Cost Calc. Overview”

Keys

Key1: Entry No. (clustered)
Key2: Attached to Valuation Date, Attached to Entry No., Type
Key3: Item Ledger Entry No.

Events published

OnAfterSetItemFilters(var ValueEntry: Record "Value Entry"; AverageCostCalcOverview: Record "Average Cost Calc. Overview") (integration)

Procedures

CalculateAverageCost(): Decimal
CalculateRemainingQty(): Decimal
CalculateCostAmt(Actual: Boolean): Decimal
SetItemFilters()

Relations

Location Code: TableRelation Table 14 “Location”
Item No.: TableRelation Table 27 “Item”
Attached to Entry No.: TableRelation Table 32 “Item Ledger Entry”
Item Ledger Entry No.: TableRelation Table 32 “Item Ledger Entry”
Variant Code: TableRelation Table 5401 “Item Variant”

Pages and codeunits on this table

Page 5847 “Average Cost Calc. Overview” (source table)
Codeunit 5847 “Get Average Cost Calc Overview” (codeunit runs on it)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Average Cost Calc. Overview"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.