Table 5802 "Value Entry"

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

Properties

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.

Keys

• Key1: Entry No. (clustered)
• Key2: Item Ledger Entry No., Entry Type
• Key3: Item Ledger Entry No., Document No., Document Line No.
• Key5: Item No., Posting Date, Item Ledger Entry Type, Entry Type, Variance Type, Item Charge No., Location Code, Variant Code, Global Dimension 1 Code, Global Dimension 2 Code, Source Type, Source No.
• Key6: Document No.
• Key7: Item No., Valuation Date, Location Code, Variant Code, SIFT Bucket No.
• Key8: Source Type, Source No., Item No., Posting Date, Entry Type, Adjustment, Item Ledger Entry Type
• Key9: Item Charge No., Inventory Posting Group, Item No.
• Key10: Capacity Ledger Entry No., Entry Type
• Key11: Order Type, Order No., Order Line No.
• Key13: Job No., Job Task No., Document No.
• Key14: Item Ledger Entry Type, Posting Date, Item No., Inventory Posting Group, Dimension Set ID
• Key15: Item Ledger Entry No., Valuation Date, Posting Date
• Key16: Location Code, Inventory Posting Group
• Key17: Item Ledger Entry Type, Order No., Valuation Date
• Key18: Item No., Item Ledger Entry Type, Order Type, Order No., Order Line No.
• Key19: Document No., Document Line No., Document Type

Events published

• OnBeforeCheckApplyLocationVariantFilters(var RecValueEntry: Record "Value Entry"; AccountingPeriod: Record "Accounting Period"; ValueEntry: Record "Value Entry"; var IsHandled: Boolean; Item: Record Item; CostCalcIsChanged: Boolean; var QtyFactor: Decimal; FromDate: Date; ToDate: Date) (integration)
• OnSumCostsTillValuationDateOnAfterCalcSums(var ValueEntry: Record "Value Entry") (integration)
• OnSumCostsTillValuationDateOnAfterGetItem(var Item: Record Item; var ValueEntry: Record "Value Entry") (integration)
• OnSumCostsTillValuationDateOnAfterSetFilters(var ValueEntryRec: Record "Value Entry"; var ValueEntry: Record "Value Entry"; var Item: Record Item) (integration)
• OnSumCostsTillValuationDateOnAfterSetCostAmounts(var ValueEntry: Record "Value Entry"; PrevValueEntrySum: Record "Value Entry"; QtyFactor: Decimal) (integration)
• OnShowGLOnBeforeCopyToTempGLEntry(var GLEntry: Record "G/L Entry"; var GLItemLedgRelation: Record "G/L - Item Ledger Relation") (integration)
• OnBeforeCalcItemLedgEntryCost(var ValueEntry: Record "Value Entry"; ItemLedgEntryNo: Integer; Expected: Boolean; var IsHandled: Boolean) (integration)
• OnBeforeAddCost(var ValueEntry: Record "Value Entry"; InvtAdjmtBuffer: Record "Inventory Adjustment Buffer") (integration)

Trigger event subscribers

• OnAfterInsertEvent: Codeunit 20 “Posting Preview Event Handler” OnInsertValueEntry
• OnAfterModifyEvent: Codeunit 20 “Posting Preview Event Handler” OnModifyValueEntry

Procedures

• GetNextEntryNo(): Integer + BC26
• GetLastEntryNo(): Integer Δ BC26
• GetValuationDate(): Date
• AddCost(InvtAdjmtBuffer: Record "Inventory Adjustment Buffer")
• SumCostsTillValuationDate(var ValueEntry: Record "Value Entry")
• CalcItemLedgEntryCost(ItemLedgEntryNo: Integer; Expected: Boolean)
• NotInvdRevaluationExists(ItemLedgEntryNo: Integer): Boolean
• CalcQtyFactor(FromDate: Date; ToDate: Date): Decimal
• ShowGL()
• IsAvgCostException(IsAvgCostCalcTypeItem: Boolean): Boolean Δ BC26 − BC30 (obsolete 27.0: Moved to the Inventory Adjustment codeunit)
• ShowDimensions()
• GetAvgToDate(ToDate: Date): Date
• GetAvgFromDate(ToDate: Date; var AccountingPeriod: Record "Accounting Period"; var CostCalcIsChanged: Boolean): Date
• FindFirstValueEntryByItemLedgerEntryNo(ItemLedgerEntryNo: Integer)
• IsInbound(): Boolean
• EntryNoHasSameSign(EntryNo: integer): Boolean + BC26 (internal): Returns true if EntryNo parameter and Rec.“Entry No.” both are positive or negative. Used in scenarios where we posting preview entries are negative

Plus 2 local procedures.

Triggers

OnInsert

Relations

• drill-down page Page 5802 “Value Entries”
• lookup page Page 5802 “Value Entries”
• Job Task No.: TableRelation Table 1001 “Job Task”
• Salespers./Purch. Code: TableRelation Table 13 “Salesperson/Purchaser”
• Location Code: TableRelation Table 14 “Location”
• No.: TableRelation Table 156 “Resource”
• Job Ledger Entry No.: TableRelation Table 169 “Job Ledger Entry”
• Source No.: TableRelation Table 18 “Customer” (conditional)
• Source No.: TableRelation Table 23 “Vendor” (conditional)
• Source Code: TableRelation Table 230 “Source Code”
• Reason Code: TableRelation Table 231 “Reason Code”
• Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
• Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
• Item Description: CalcFormula Table 27 “Item”
• Item No.: TableRelation Table 27 “Item”
• Source No.: TableRelation Table 27 “Item” (conditional)
• Item Ledger Entry No.: TableRelation Table 32 “Item Ledger Entry”
• Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
• Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
• Item Register No.: TableRelation Table 46 “Item Register”
• Shortcut Dimension 3 Code: CalcFormula Table 480 “Dimension Set Entry”
• Shortcut Dimension 4 Code: CalcFormula Table 480 “Dimension Set Entry”
• Shortcut Dimension 5 Code: CalcFormula Table 480 “Dimension Set Entry”
• Shortcut Dimension 6 Code: CalcFormula Table 480 “Dimension Set Entry”
• Shortcut Dimension 7 Code: CalcFormula Table 480 “Dimension Set Entry”
• Shortcut Dimension 8 Code: CalcFormula Table 480 “Dimension Set Entry”
• Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
• Variant Code: TableRelation Table 5401 “Item Variant”
• Item Charge No.: TableRelation Table 5800 “Item Charge”
• Capacity Ledger Entry No.: TableRelation Table 5832 “Capacity Ledger Entry”
• Return Reason Code: TableRelation Table 6635 “Return Reason”
• Source Posting Group: TableRelation Table 92 “Customer Posting Group” (conditional)
• Source Posting Group: TableRelation Table 93 “Vendor Posting Group” (conditional)
• Inventory Posting Group: TableRelation Table 94 “Inventory Posting Group”
• Source Posting Group: TableRelation Table 94 “Inventory Posting Group” (conditional)

Referenced by

35 fields in 10 objects relate to this table (TableRelation or CalcFormula).

• Table 32 “Item Ledger Entry”: Cost Amount (Actual), Cost Amount (Actual) (ACY), Cost Amount (Expected), Cost Amount (Expected) (ACY), Cost Amount (Non-Invtbl.), Cost Amount (Non-Invtbl.)(ACY), Item Ledger Entry Quantity, Purchase Amount (Actual), Purchase Amount (Expected), Sales Amount (Actual), Sales Amount (Expected)
• Table 27 “Item”: COGS (LCY), Negative Adjmt. (LCY), Positive Adjmt. (LCY), Purchases (LCY), Sales (LCY), Sales (Qty.), Transferred (LCY)
• Table 5821 “Item Statistics Buffer”: Cost Amount (Actual), Cost Amount (Expected), Cost Amount (Non-Invtbl.), Invoiced Quantity, Sales Amount (Actual), Sales Amount (Expected)
• Table 5832 “Capacity Ledger Entry”: Direct Cost, Direct Cost (ACY), Overhead Cost, Overhead Cost (ACY)
• Table 46 “Item Register”: From Value Entry No., To Value Entry No.
• Table 339 “Item Application Entry”: Latest Valuation Date
• Table 5811 “Post Value Entry to G/L”: Value Entry No.
• Table 5822 “Invt. Post to G/L Test Buffer”: Value Entry No.
• Table 5823 “G/L - Item Ledger Relation”: Value Entry No.
• Table 6508 “Value Entry Relation”: Value Entry No.

Pages and codeunits on this table

• Page 5802 “Value Entries” (source table)
• Page 5807 “Value Entries Preview” (source table)
• Codeunit 5802 “Inventory Posting To G/L” (codeunit runs on it)

Extended by

• Table extension 5021 “Serv. Decl. Value Entry”
• Table extension 99000788 “Mfg. Value Entry”

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

• Codeunit 360 “Accounting Period Mgt.” (1 call: GetAvgFromDate → InitDefaultAccountingPeriod)
• Codeunit 408 “DimensionManagement” (1 call: ShowDimensions → ShowDimensionSet)
• Codeunit 5402 “Unit of Measure Management” (1 call: SumCostsTillValuationDate → QtyRndPrecision)
• Codeunit 5849 “Avg. Cost Entry Point Handler” (1 call: GetAvgToDate → GetValuationPeriod)
• Codeunit 703 “Find Record Management” (1 call: GetLastEntryNo → GetLastEntryIntFieldValue)
• Codeunit 9500 “Sequence No. Mgt.” (1 call: GetNextEntryNo → GetNextSeqNo)

Recent changes

• 2026-10-02 #12066 Bugs/remove asm inv mfg clean27 tags for wave2 2026 (main, BC30, obsoletion)

Countries that replace it

RU

Deprecations

• procedure IsAvgCostException: Pending 27.0 (#if not CLEAN27), “Moved to the Inventory Adjustment codeunit”

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. 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: "Value Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.