Table 32 "Item Ledger Entry"

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

Learn documents this table through its pages: Page 30069 “APIV2 - Item Ledger Entries” (2 Learn pages), Page 504 “Available - Item Ledg. Entries” (1), Page 521 “Application Worksheet” (1), Page 522 “View Applied Entries” (1), Page 9125 “Item Application FactBox” (1).

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 No., SIFT Bucket No.
• Key3: Item No., Posting Date
• Key4: Item No., Entry Type, Variant Code, Drop Shipment, Location Code, Posting Date, SIFT Bucket No.
• Key5: Source Type, Source No., Item No., Variant Code, Posting Date
• Key6: Item No., Open, Variant Code, Positive, Location Code, Posting Date
• Key7: Location Code, Item No., Variant Code, Open, Positive
• Key8: Country/Region Code, Entry Type, Posting Date
• Key9: Document No., Document Type, Document Line No.
• Key12: Order Type, Order No., Order Line No., Entry Type, Prod. Order Comp. Line No.
• Key13: Item No., Applied Entry to Adjust
• Key14: Item No., Positive, Location Code, Variant Code
• Key17: Item No., Open, Variant Code, Positive, Lot No., Serial No., Package No.
• Key19: Lot No.
• Key20: Serial No., Item No., Open, Variant Code, Positive, Location Code, Posting Date
• Key21: SystemModifiedAt
• Key25: Entry Type, Item No.

Events published

• OnAfterClearTrackingFilter(var ItemLedgerEntry: Record "Item Ledger Entry") (integration)
  • subscribers: Codeunit 6516 “Package Management” ItemLedgerEntryClearTrackingFilter
• OnAfterSetReservationEntry(var ReservationEntry: Record "Reservation Entry"; ItemLedgerEntry: Record "Item Ledger Entry") (integration)
• OnAfterSetTrackingFilterBlank(var ItemLedgerEntry: Record "Item Ledger Entry") (integration)
  • subscribers: Codeunit 6516 “Package Management” ItemLedgerEntryOnAfterSetTrackingFilterBlank
• OnAfterCopyTrackingFromItemJnlLine(var ItemLedgerEntry: Record "Item Ledger Entry"; ItemJnlLine: Record "Item Journal Line") (integration)
  • subscribers: Codeunit 6516 “Package Management” ItemLedgerEntryCopyTrackingFromItemJnlLine
• OnAfterCopyTrackingFromNewItemJnlLine(var ItemLedgerEntry: Record "Item Ledger Entry"; ItemJnlLine: Record "Item Journal Line") (integration)
  • subscribers: Codeunit 6516 “Package Management” ItemLedgerEntryCopyTrackingFromNewItemJnlLine
• OnAfterFilterLinesWithItemToPlan(var ItemLedgerEntry: Record "Item Ledger Entry"; var Item: Record Item; NetChange: Boolean) (integration)
• OnAfterFilterLinesForReservation(var ItemLedgerEntry: Record "Item Ledger Entry"; ReservationEntry: Record "Reservation Entry"; NewPositive: Boolean) (integration)
• OnAfterFilterLinesForTracking(var ItemLedgerEntry: Record "Item Ledger Entry"; CalcReservEntry: Record "Reservation Entry"; Positive: Boolean) (integration)
  • subscribers: Codeunit 6516 “Package Management” ItemLedgerEntryFilterLinesForTracking
• OnAfterSetReservationFilters(var ReservEntry: Record "Reservation Entry"; ItemLedgerEntry: Record "Item Ledger Entry") (integration)
• OnAfterSetTrackingFilterFromItemLedgEntry(var ItemLedgerEntry: Record "Item Ledger Entry"; FromItemLedgerEntry: Record "Item Ledger Entry") (integration)
  • subscribers: Codeunit 6516 “Package Management” ItemLedgerEntrySetTrackingFilterFromItemLedgEntry
• OnAfterSetTrackingFilterFromItemJournalLine(var ItemLedgerEntry: Record "Item Ledger Entry"; ItemJournalLine: Record "Item Journal Line") (integration)
  • subscribers: Codeunit 6516 “Package Management” ItemLedgerEntrySetTrackingFilterFromItemJournalLine
• OnAfterSetTrackingFilterFromItemTrackingSetup(var ItemLedgerEntry: Record "Item Ledger Entry"; ItemTrackingSetup: Record "Item Tracking Setup") (integration)
  • subscribers: Codeunit 6516 “Package Management” ItemLedgerEntrySetTrackingFilterFromItemTrackingSetup
• OnAfterSetTrackingFilterFromItemTrackingSetupIfNotBlank(var ItemLedgerEntry: Record "Item Ledger Entry"; ItemTrackingSetup: Record "Item Tracking Setup") (integration)
  • subscribers: Codeunit 6516 “Package Management” ItemLedgerEntrySetTrackingFilterFromItemTrackingSetupIfNotBlank
• OnAfterSetTrackingFilterFromItemTrackingSetupIfRequired(var ItemLedgerEntry: Record "Item Ledger Entry"; ItemTrackingSetup: Record "Item Tracking Setup") (integration)
  • subscribers: Codeunit 6516 “Package Management” ItemLedgerEntrySetTrackingFilterFromItemTrackingSetupIfRequired
• OnAfterSetTrackingFilterFromSpec(var ItemLedgerEntry: Record "Item Ledger Entry"; TrackingSpecification: Record "Tracking Specification") (integration)
  • subscribers: Codeunit 6516 “Package Management” ItemLedgerEntrySetTrackingFilterFromSpec
• OnAfterTrackingExists(ItemLedgerEntry: Record "Item Ledger Entry"; var IsTrackingExist: Boolean) (integration)
  • subscribers: Codeunit 6516 “Package Management” ItemLedgerEntryTrackingExists
• OnAfterTestTrackingEqualToTrackingSpec(var ItemLedgerEntry: Record "Item Ledger Entry"; TrackingSpecification: Record "Tracking Specification") (integration)
  • subscribers: Codeunit 6516 “Package Management” ItemLedgerEntryTestTrackingEqualToTrackingSpec
• OnBeforeCalculateRemQuantity(ItemLedgerEntry: Record "Item Ledger Entry"; ItemLedgEntryNo: Integer; PostingDate: Date; var RemQty: Decimal; var IsHandled: Boolean) (integration)
• OnBeforeCheckTrackingDoesNotExist(RecId: RecordId; ItemLedgEntry: Record "Item Ledger Entry"; FldCaption: Text; var IsHandled: Boolean) (integration)
• OnBeforeGetReservationQty(var ItemLedgerEntry: Record "Item Ledger Entry"; var QtyReserved: Decimal; var QtyToReserve: Decimal; var IsHandled: Boolean) (integration)
• OnBeforeVerifyOnInventory(var ItemLedgerEntry: Record "Item Ledger Entry"; var IsHandled: Boolean; ErrorMessageText: Text) (integration)
• OnFilterLinesForReservationOnBeforeSetFilterVariantCode(var ItemLedgerEntry: Record "Item Ledger Entry"; var ReservationEntry: Record "Reservation Entry"; var Positive: Boolean; var IsHandled: Boolean) (integration)
• OnAfterVerifyOnInventory(var ItemLedgerEntry: Record "Item Ledger Entry"; ErrorMessageText: Text) (integration)
• OnBeforeCalcReservedQuantity(var ItemLedgerEntry: Record "Item Ledger Entry"; var IsHandled: Boolean) (integration)

Trigger event subscribers

• OnAfterInsertEvent: Codeunit 20 “Posting Preview Event Handler” OnInsertItemLedgerEntry
• OnAfterModifyEvent: Codeunit 20 “Posting Preview Event Handler” OnModifyItemLedgerEntry

Procedures

• GetNextEntryNo(): Integer + BC26
• GetLastEntryNo(): Integer Δ BC26
• GetCurrencyCode(): Code[10] Δ BC27 − BC30 (obsolete 27.0: Please use GetAdditionalReportingCurrencyCode instead.)
• GetAdditionalReportingCurrencyCode(): Code[10] + BC27
• ShowReservationEntries(Modal: Boolean)
• SetAppliedEntryToAdjust(AppliedEntryToAdjust: Boolean)
• SetAvgTransCompletelyInvoiced(): Boolean
• SetCompletelyInvoiced()
• IsOutbndConsump(): Boolean
• IsExactCostReversingPurchase(): Boolean
• IsExactCostReversingOutput(): Boolean
• UpdateItemTracking()
• GetSourceCaption(): Text
• GetUnitCostLCY(): Decimal
• FilterLinesWithItemToPlan(var Item: Record Item; NetChange: Boolean)
• FindLinesWithItemToPlan(var Item: Record Item; NetChange: Boolean): Boolean
• LinesWithItemToPlanExist(var Item: Record Item; NetChange: Boolean): Boolean
• FilterLinesForReservation(ReservationEntry: Record "Reservation Entry"; NewPositive: Boolean)
• FilterLinesForTracking(CalcReservEntry: Record "Reservation Entry"; Positive: Boolean)
• IsOutbndSale(): Boolean
• ShowDimensions()
• CalculateRemQuantity(ItemLedgEntryNo: Integer; PostingDate: Date): Decimal
• VerifyOnInventory()
• VerifyOnInventory(ErrorMessageText: Text)
• CalculateRemInventoryValue(ItemLedgEntryNo: Integer; ItemLedgEntryQty: Decimal; RemQty: Decimal; IncludeExpectedCost: Boolean; PostingDate: Date): Decimal
• CalculateRemInventoryValue(ItemLedgEntryNo: Integer; ItemLedgEntryQty: Decimal; RemQty: Decimal; IncludeExpectedCost: Boolean; ValuationDate: Date; PostingDate: Date): Decimal
• TrackingExists(): Boolean
• CheckTrackingDoesNotExist(RecId: RecordId; FldCaption: Text)
• CopyTrackingFromItemJnlLine(ItemJnlLine: Record "Item Journal Line")
• CopyTrackingFromNewItemJnlLine(ItemJnlLine: Record "Item Journal Line")
• GetReservationQty(var QtyReserved: Decimal; var QtyToReserve: Decimal)
• CalcReservedQuantity() (internal)
• SetItemVariantLocationFilters(ItemNo: Code[20]; VariantCode: Code[10]; LocationCode: Code[10]; PostingDate: Date)
• SetReservationEntry(var ReservEntry: Record "Reservation Entry")
• SetReservationFilters(var ReservEntry: Record "Reservation Entry")
• SetTrackingFilterFromItemLedgEntry(ItemLedgEntry: Record "Item Ledger Entry")
• SetTrackingFilterFromItemJournalLine(ItemJournalLine: Record "Item Journal Line")
• SetTrackingFilterFromItemTrackingSetup(ItemTrackingSetup: Record "Item Tracking Setup")
• SetTrackingFilterFromItemTrackingSetupIfNotBlank(ItemTrackingSetup: Record "Item Tracking Setup")
• SetTrackingFilterFromItemTrackingSetupIfRequired(ItemTrackingSetup: Record "Item Tracking Setup")
• SetTrackingFilterFromSpec(TrackingSpecification: Record "Tracking Specification")
• SetTrackingFilterBlank()
• ClearTrackingFilter()
• TestTrackingEqualToTrackingSpec(TrackingSpecification: Record "Tracking Specification")
• CollectItemLedgerEntryTypesUsed(var ItemLedgerEntryTypesUsed: Dictionary of [Enum "Item Ledger Entry Type", Boolean]; ItemNoFilter: Text) + BC24
• 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 1 local procedures.

Triggers

OnInsert

Relations

• drill-down page Page 38 “Item Ledger Entries”
• lookup page Page 38 “Item Ledger Entries”
• Shpt. Method Code: TableRelation Table 10 “Shipment Method”
• Job Task No.: TableRelation Table 1001 “Job Task”
• Location Code: TableRelation Table 14 “Location”
• Source No.: TableRelation Table 18 “Customer” (conditional)
• Source No.: TableRelation Table 23 “Vendor” (conditional)
• Transaction Type: TableRelation Table 258 “Transaction Type”
• Transport Method: TableRelation Table 259 “Transport Method”
• Item Description: CalcFormula Table 27 “Item”
• Item No.: TableRelation Table 27 “Item”
• Originally Ordered No.: TableRelation Table 27 “Item”
• Source No.: TableRelation Table 27 “Item” (conditional)
• Entry/Exit Point: TableRelation Table 282 “Entry/Exit Point”
• Area: TableRelation Table 284 “Area”
• Transaction Specification: TableRelation Table 285 “Transaction Specification”
• No. Series: TableRelation Table 308 “No. Series”
• Reserved Quantity: CalcFormula Table 337 “Reservation Entry”
• Remaining Qty. by Date: CalcFormula Table 339 “Item Application 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”
• Originally Ordered Var. Code: TableRelation Table 5401 “Item Variant”
• Variant Code: TableRelation Table 5401 “Item Variant”
• Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”
• Purchasing Code: TableRelation Table 5721 “Purchasing”
• Item Category Code: TableRelation Table 5722 “Item Category”
• Cost Amount (Actual): CalcFormula Table 5802 “Value Entry”
• Cost Amount (Actual) (ACY): CalcFormula Table 5802 “Value Entry”
• Cost Amount (Expected): CalcFormula Table 5802 “Value Entry”
• Cost Amount (Expected) (ACY): CalcFormula Table 5802 “Value Entry”
• Cost Amount (Non-Invtbl.): CalcFormula Table 5802 “Value Entry”
• Cost Amount (Non-Invtbl.)(ACY): CalcFormula Table 5802 “Value Entry”
• Item Ledger Entry Quantity: CalcFormula Table 5802 “Value Entry”
• Purchase Amount (Actual): CalcFormula Table 5802 “Value Entry”
• Purchase Amount (Expected): CalcFormula Table 5802 “Value Entry”
• Sales Amount (Actual): CalcFormula Table 5802 “Value Entry”
• Sales Amount (Expected): CalcFormula Table 5802 “Value Entry”
• Return Reason Code: TableRelation Table 6635 “Return Reason”
• Country/Region Code: TableRelation Table 9 “Country/Region”

Referenced by

60 fields in 39 objects relate to this table (TableRelation or CalcFormula).

• Table 27 “Item”: Inventory, Negative Adjmt. (Qty.), Net Change, Net Invoiced Qty., Positive Adjmt. (Qty.), Purchases (Qty.), Transferred (Qty.)
• Table 339 “Item Application Entry”: Item No., Location Code, Variant Code, Inbound Item Entry No., Item Ledger Entry No., Outbound Item Entry No., Transferred-from Entry No.
• Table 343 “Item Application Entry History”: Inbound Item Entry No., Item Ledger Entry No., Outbound Item Entry No., Transferred-from Entry No.
• Table 336 “Tracking Specification”: Item Ledger Entry No., Transfer Item Entry No.
• Table 46 “Item Register”: From Entry No., To Entry No.
• Table 5847 “Average Cost Calc. Overview”: Attached to Entry No., Item Ledger Entry No.
• Table 6504 “Serial No. Information”: Expired Inventory, Inventory
• Table 6505 “Lot No. Information”: Expired Inventory, Inventory
• Table 6515 “Package No. Information”: Expired Inventory, Inventory
• Table 1003 “Job Planning Line”: Ledger Entry No.
• Table 169 “Job Ledger Entry”: Ledger Entry No.
• Table 210 “Job Journal Line”: Ledger Entry No.
• Table 281 “Phys. Inventory Ledger Entry”: Last Item Ledger Entry No.
• Table 337 “Reservation Entry”: Item Ledger Entry No.
• Table 4812 “Intrastat Report Line”: Source Entry No.
• Table 5137 “Job Planning Line Archive”: Ledger Entry No.
• Table 520 “Availability Info. Buffer”: Inventory
• Table 5407 “Prod. Order Component”: Act. Consumption (Qty)
• Table 5700 “Stockkeeping Unit”: Inventory
• Table 5774 “Warehouse Pick Summary”: Qty. in Inventory
• Table 5802 “Value Entry”: Item Ledger Entry No.
• Table 5821 “Item Statistics Buffer”: Quantity
• Table 5830 “Availability Calc. Overview”: Attached to Entry No.
• Table 5851 “Invt. Document Line”: Last Item Ledger Entry No.
• Table 5853 “Invt. Receipt Line”: Last Item Ledger Entry No.
• Table 5855 “Invt. Shipment Line”: Last Item Ledger Entry No.
• Table 5876 “Phys. Invt. Order Line”: Last Item Ledger Entry No.
• Table 5880 “Pstd. Phys. Invt. Order Line”: Last Item Ledger Entry No.
• Table 5895 “Inventory Adjustment Buffer”: Item Ledger Entry No.
• Table 6227 “Sustainability Value Entry”: Item Ledger Entry No.
• Table 6240 “Sust. Excise Jnl. Line”: Item Ledger Entry No.
• Table 6241 “Sust. Excise Taxes Trans. Log”: Item Ledger Entry No.
• Table 6507 “Item Entry Relation”: Item Entry No.
• Table 6509 “Whse. Item Entry Relation”: Item Entry No.
• Table 6520 “Item Tracing Buffer”: Item Ledger Entry No.
• Table 8057 “Subscription Header”: Item Ledger Entry No.
• Table 83 “Item Journal Line”: Last Item Ledger Entry No.
• Table 9152 “My Item”: Inventory
• Table extension 20502 “Subc. Prod Order Comp Ext.”: Subc. Qty. transf. to Subcontr

Pages and codeunits on this table

• Page 167 “Item Ledger Entries Preview” (source table)
• Page 30069 “APIV2 - Item Ledger Entries” (source table)
• Page 38 “Item Ledger Entries” (source table)
• Page 504 “Available - Item Ledg. Entries” (source table)
• Page 521 “Application Worksheet” (source table)
• Page 522 “View Applied Entries” (source table)
• Page 5804 “Applied Item Entries” (source table)
• Page 6501 “Item Tracking Entries” (source table)
• Page 6511 “Posted Item Tracking Lines” (source table)
• Page 6614 “FS Item Avail. by Location” (source table)
• Page 9125 “Item Application FactBox” (source table)
• Codeunit 5801 “Show Applied Entries” (codeunit runs on it)

Extended by

• Table extension 20500 “Subc. Item Ledger Entry”
• Table extension 5015 “Serv. Decl. Item Ledg. Entry”
• Table extension 6261 “Sust. Item Ledger Entry”
• Table extension 7415 “Excise Item Ledger Entry Ext”
• Table extension 99000787 “Mfg. Item Ledger 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 408 “DimensionManagement” (1 call: ShowDimensions → ShowDimensionSet)
• Codeunit 703 “Find Record Management” (1 call: GetLastEntryNo → GetLastEntryIntFieldValue)
• Codeunit 9500 “Sequence No. Mgt.” (1 call: GetNextEntryNo → GetNextSeqNo)
• Page 497 “Reservation Entries” (1 call: ShowReservationEntries → (object))

Recent changes

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

Countries that replace it

AU, CA, CH, ES, FR, GB, IT, MX, NZ, RU, US

Deprecations

• procedure GetCurrencyCode: Pending 27.0 (#if not CLEAN27), “Please use GetAdditionalReportingCurrencyCode instead.”

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: "Item Ledger Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.