---
id: object/table/32
type: object
title: Table 32 "Item Ledger Entry"
summary: Table 32 "Item Ledger Entry" in Base Application (Microsoft.Inventory.Ledger). 85 fields, 46 public procedures, 24 events. Present since at least BC23, still in BC30, changed in BC24, BC26-28, BC30.
tier: official
language: en
tags:
  - table
  - base application
versions:
  introduced: null
  last_changed: "30"
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 6c0cbe01e227e8b9dcd3da671dd49a0fb32a4e720525259ea4d768441714d8bd
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Inventory/Ledger/ItemLedgerEntry.Table.al
    title: src/Layers/W1/BaseApp/Inventory/Ledger/ItemLedgerEntry.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn:
    - https://learn.microsoft.com/dynamics365/business-central/dev-itpro/api-reference/v2.0/api/dynamics_itemledgerentry_get
    - https://learn.microsoft.com/dynamics365/business-central/dev-itpro/api-reference/v2.0/resources/dynamics_itemledgerentry
    - https://learn.microsoft.com/dynamics365/business-central/inventory-how-availability-overview
    - https://learn.microsoft.com/dynamics365/business-central/finance-how-to-remove-and-reapply-item-entries
    - https://learn.microsoft.com/dynamics365/business-central/payables-how-apply-purchase-transactions-manually
  objects: []
  features: []
  topics:
    - topic/business-central/business-functionality/finance/manage-inventory-costs
    - topic/business-central/business-functionality/finance/manage-payables
    - topic/business-central/business-functionality/inventory
  localizations:
    - localization/au
    - localization/ca
    - localization/ch
    - localization/es
    - localization/fr
    - localization/gb
    - localization/it
    - localization/mx
    - localization/nz
    - localization/ru
    - localization/us
  videos: []
  posts: []
  guidelines: []
  changes:
    - change/bcapps/12066
object_type: table
object_id: 32
name: Item Ledger Entry
namespace: Microsoft.Inventory.Ledger
app: Base Application
extends: null
first_version: "23"
last_version: "30"
present_in:
  - "23"
  - "24"
  - "25"
  - "26"
  - "27"
  - "28"
  - "29"
  - "30"
changed_in:
  - "24"
  - "26"
  - "27"
  - "28"
  - "30"
source_major: "29"
obsolete: null
countries:
  - au
  - ca
  - ch
  - es
  - fr
  - gb
  - it
  - mx
  - nz
  - ru
  - us
ms_search_form_ids: []
counts:
  fields: 85
  procedures: 71
  events: 24
  subscribers: 0
relations:
  out: 47
  referenced_by: 60
  pages: 11
  extended_by: 5
  event_subscribers: 15
  calls: 4
  called_by: 0
  implements: 0
---

# Table 32 "Item Ledger Entry"

> Table 32 "Item Ledger Entry" in Base Application (Microsoft.Inventory.Ledger). 85 fields, 46 public procedures, 24 events. Present since at least BC23, still in BC30, changed in BC24, BC26-28, BC30.

Base Application · Microsoft.Inventory.Ledger · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Inventory/Ledger/ItemLedgerEntry.Table.al) · facts from BC29

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

## Properties

| Property | Value |
|---|---|
| Caption | Item Ledger Entry |
| DataClassification | CustomerContent |
| Permissions | TableData "Item Ledger Entry" = rimd |

## 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 | Specifies the number of the entry, as assigned from the specified number series when the entry was created. |  |
| 2 | Item No. | Code[20] | Specifies the number of the item in the entry. | TableRelation [Table 27 "Item"](../table/27.md) |
| 3 | Posting Date | Date | Specifies the entry's posting date. |  |
| 4 | Entry Type | Enum "Item Ledger Entry Type" | Specifies which type of transaction that the entry is created from. | enum [Enum 78 "Item Ledger Entry Type"](../enum/78.md) |
| 5 | Source No. | Code[20] | Specifies where the entry originated. | TableRelation [Table 18 "Customer"](../table/18.md), [Table 23 "Vendor"](../table/23.md), [Table 27 "Item"](../table/27.md) (if ("Source Type" = const(Customer)) Customer else if ("Source Type" = const(Vendor)) Vendor else if ("Source Type" = const(Item)) Item) |
| 6 | Document No. | Code[20] | Specifies the document number on the entry. The document is the voucher that the entry was based on, for example, a receipt. |  |
| 7 | Description | Text[100] | Specifies a description of the entry. |  |
| 8 | Location Code | Code[10] | Specifies the code for the location that the entry is linked to. | TableRelation [Table 14 "Location"](../table/14.md) |
| 12 | Quantity | Decimal | Specifies the number of units of the item in the item entry. |  |
| 13 | Remaining Quantity | Decimal | Specifies the quantity in the Quantity field that remains to be processed. |  |
| 14 | Invoiced Quantity | Decimal | Specifies how many units of the item on the line have been invoiced. |  |
| 20 | Item Register No. | Integer | — | TableRelation [Table 46 "Item Register"](../table/46.md) (Item Register); not editable |
| 21 | SIFT Bucket No. | Integer | Specifies an automatically generated number that is used by the system to enable better concurrency. | not editable |
| 28 | Applies-to Entry | Integer | Specifies if the quantity on the journal line must be applied to an already-posted entry. In that case, enter the entry number that the quantity will be applied to. |  |
| 29 | Open | Boolean | Specifies whether the entry has been fully applied to. |  |
| 33 | Global Dimension 1 Code | Code[20] | Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company's most important activities, are available on all cards, documents, reports, and lists. | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(1))) |
| 34 | Global Dimension 2 Code | Code[20] | Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company's most important activities, are available on all cards, documents, reports, and lists. | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(2))) |
| 36 | Positive | Boolean | Specifies whether the item in the item ledge entry is positive. |  |
| 40 | Shpt. Method Code | Code[10] | — | TableRelation [Table 10 "Shipment Method"](../table/10.md) (Shipment Method) |
| 41 | Source Type | Enum "Analysis Source Type" | Specifies the source type that applies to the source number, shown in the Source No. field. | enum [Enum 7131 "Analysis Source Type"](../enum/7131.md) |
| 47 | Drop Shipment | Boolean | Specifies if your vendor ships the items directly to your customer. |  |
| 50 | Transaction Type | Code[10] | — | TableRelation [Table 258 "Transaction Type"](../table/258.md) (Transaction Type) |
| 51 | Transport Method | Code[10] | — | TableRelation [Table 259 "Transport Method"](../table/259.md) (Transport Method) |
| 52 | Country/Region Code | Code[10] | — | TableRelation [Table 9 "Country/Region"](../table/9.md) (Country/Region) |
| 59 | Entry/Exit Point | Code[10] | — | TableRelation [Table 282 "Entry/Exit Point"](../table/282.md) (Entry/Exit Point) |
| 60 | Document Date | Date | — |  |
| 61 | External Document No. | Code[35] | — |  |
| 62 | Area | Code[10] | — | TableRelation [Table 284 "Area"](../table/284.md) |
| 63 | Transaction Specification | Code[10] | — | TableRelation [Table 285 "Transaction Specification"](../table/285.md) (Transaction Specification) |
| 64 | No. Series | Code[20] | — | TableRelation [Table 308 "No. Series"](../table/308.md) (No. Series) |
| 70 | Reserved Quantity | Decimal | Specifies how many units of the item on the line have been reserved. | FlowField: sum("Reservation Entry"."Quantity (Base)" where("Source ID" = const(''), "Source Ref. No." = field("Entry No."), "Source Type" = const(32), "Source Subtype" = const("0"), "Source Batch Name" = const(''), "Source Prod. Order Line" = const(0), "Reservation Status" = const(Reservation))); not editable |
| 79 | Document Type | Enum "Item Ledger Document Type" | Specifies what type of document was posted to create the item ledger entry. | enum [Enum 79 "Item Ledger Document Type"](../enum/79.md) |
| 80 | Document Line No. | Integer | Specifies the number of the line on the posted document that corresponds to the item ledger entry. |  |
| 90 | Order Type | Enum "Inventory Order Type" | Specifies which type of order that the entry was created in. | enum [Enum 90 "Inventory Order Type"](../enum/90.md); not editable |
| 91 | Order No. | Code[20] | Specifies the number of the order that created the entry. | not editable |
| 92 | Order Line No. | Integer | Specifies the line number of the order that created the entry. | not editable |
| 480 | Dimension Set ID | Integer | Specifies a reference to a combination of dimension values. The actual values are stored in the Dimension Set Entry table. | TableRelation [Table 480 "Dimension Set Entry"](../table/480.md) (Dimension Set Entry); not editable |
| 481 | Shortcut Dimension 3 Code | Code[20] | Specifies the code for Shortcut Dimension 3, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(3))); not editable |
| 482 | Shortcut Dimension 4 Code | Code[20] | Specifies the code for Shortcut Dimension 4, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(4))); not editable |
| 483 | Shortcut Dimension 5 Code | Code[20] | Specifies the code for Shortcut Dimension 5, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(5))); not editable |
| 484 | Shortcut Dimension 6 Code | Code[20] | Specifies the code for Shortcut Dimension 6, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(6))); not editable |
| 485 | Shortcut Dimension 7 Code | Code[20] | Specifies the code for Shortcut Dimension 7, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(7))); not editable |
| 486 | Shortcut Dimension 8 Code | Code[20] | Specifies the code for Shortcut Dimension 8, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(8))); not editable |
| 904 | Assemble to Order | Boolean | Specifies if the posting represents an assemble-to-order sale. |  |
| 1000 | Job No. | Code[20] | Specifies the number of the related project. | TableRelation Job."No." |
| 1001 | Job Task No. | Code[20] | Specifies the number of the related project task. | TableRelation [Table 1001 "Job Task"](../table/1001.md) ("Job Task"."Job Task No." where("Job No." = field("Job No."))) |
| 1002 | Job Purchase | Boolean | Project Purchase <small>caption</small> |  |
| 5402 | Variant Code | Code[10] | Specifies the variant of the item on the line. | TableRelation [Table 5401 "Item Variant"](../table/5401.md) ("Item Variant".Code where("Item No." = field("Item No."))) |
| 5404 | Qty. per Unit of Measure | Decimal | Specifies the quantity per item unit of measure. |  |
| 5407 | Unit of Measure Code | Code[10] | Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted. | TableRelation [Table 5404 "Item Unit of Measure"](../table/5404.md) ("Item Unit of Measure".Code where("Item No." = field("Item No."))) |
| 5408 | Derived from Blanket Order | Boolean | — |  |
| 5701 | Originally Ordered No. | Code[20] | — | TableRelation [Table 27 "Item"](../table/27.md) |
| 5702 | Originally Ordered Var. Code | Code[10] | — | TableRelation [Table 5401 "Item Variant"](../table/5401.md) ("Item Variant".Code where("Item No." = field("Originally Ordered No."))) |
| 5703 | Out-of-Stock Substitution | Boolean | — |  |
| 5704 | Item Category Code | Code[20] | — | TableRelation [Table 5722 "Item Category"](../table/5722.md) (Item Category) |
| 5705 | Nonstock | Boolean | Catalog <small>caption</small> |  |
| 5706 | Purchasing Code | Code[10] | — | TableRelation [Table 5721 "Purchasing"](../table/5721.md) |
| 5725 | Item Reference No. | Code[50] | — |  |
| 5800 | Completely Invoiced | Boolean | Specifies if the entry has been fully invoiced or if more posted invoices are expected. Only completely invoiced entries can be revalued. |  |
| 5801 | Last Invoice Date | Date | — |  |
| 5802 | Applied Entry to Adjust | Boolean | Specifies whether there is one or more applied entries, which need to be adjusted. |  |
| 5803 | Cost Amount (Expected) | Decimal | Specifies the expected cost, in LCY, of the quantity posting. <small>via [Page 38 "Item Ledger Entries"](../page/38.md)</small> | FlowField: sum("Value Entry"."Cost Amount (Expected)" where("Item Ledger Entry No." = field("Entry No."))); not editable |
| 5804 | Cost Amount (Actual) | Decimal | Specifies the adjusted cost, in LCY, of the quantity posting. <small>via [Page 38 "Item Ledger Entries"](../page/38.md)</small> | FlowField: sum("Value Entry"."Cost Amount (Actual)" where("Item Ledger Entry No." = field("Entry No."))); not editable |
| 5805 | Cost Amount (Non-Invtbl.) | Decimal | Specifies the adjusted non-inventoriable cost, that is an item charge assigned to an outbound entry. <small>via [Page 38 "Item Ledger Entries"](../page/38.md)</small> | FlowField: sum("Value Entry"."Cost Amount (Non-Invtbl.)" where("Item Ledger Entry No." = field("Entry No."))); not editable |
| 5806 | Cost Amount (Expected) (ACY) | Decimal | Specifies the expected cost, in ACY, of the quantity posting. <small>via [Page 38 "Item Ledger Entries"](../page/38.md)</small> | FlowField: sum("Value Entry"."Cost Amount (Expected) (ACY)" where("Item Ledger Entry No." = field("Entry No."))); not editable |
| 5807 | Cost Amount (Actual) (ACY) | Decimal | Specifies the adjusted cost of the entry, in the additional reporting currency. <small>via [Page 38 "Item Ledger Entries"](../page/38.md)</small> | FlowField: sum("Value Entry"."Cost Amount (Actual) (ACY)" where("Item Ledger Entry No." = field("Entry No."))); not editable |
| 5808 | Cost Amount (Non-Invtbl.)(ACY) | Decimal | Specifies the adjusted non-inventoriable cost, that is, an item charge assigned to an outbound entry in the additional reporting currency. <small>via [Page 38 "Item Ledger Entries"](../page/38.md)</small> | FlowField: sum("Value Entry"."Cost Amount (Non-Invtbl.)(ACY)" where("Item Ledger Entry No." = field("Entry No."))); not editable |
| 5813 | Purchase Amount (Expected) | Decimal | — | FlowField: sum("Value Entry"."Purchase Amount (Expected)" where("Item Ledger Entry No." = field("Entry No."))); not editable |
| 5814 | Purchase Amount (Actual) | Decimal | — | FlowField: sum("Value Entry"."Purchase Amount (Actual)" where("Item Ledger Entry No." = field("Entry No."))); not editable |
| 5815 | Sales Amount (Expected) | Decimal | Specifies the expected sales amount, in LCY. <small>via [Page 38 "Item Ledger Entries"](../page/38.md)</small> | FlowField: sum("Value Entry"."Sales Amount (Expected)" where("Item Ledger Entry No." = field("Entry No."))); not editable |
| 5816 | Sales Amount (Actual) | Decimal | Specifies the sales amount, in LCY. <small>via [Page 38 "Item Ledger Entries"](../page/38.md)</small> | FlowField: sum("Value Entry"."Sales Amount (Actual)" where("Item Ledger Entry No." = field("Entry No."))); not editable |
| 5817 | Correction | Boolean | — |  |
| 5818 | Shipped Qty. Not Returned | Decimal | Specifies the quantity for this item ledger entry that was shipped and has not yet been returned. |  |
| 5819 | Item Ledger Entry Quantity | Decimal | Item Ledger Entry Quantity on Value Entry <small>caption</small> | FlowField: sum("Value Entry"."Item Ledger Entry Quantity" where("Item Ledger Entry No." = field("Entry No."))); not editable |
| 5820 | Remaining Qty. by Date | Decimal | Specifies the remaining quantity for the item ledger entry as of the date specified in the Date Filter field. | FlowField: sum("Item Application Entry".Quantity where("Inbound Item Entry No." = field("Entry No."), "Posting Date" = field("Date Filter"))); not editable |
| 5821 | Date Filter | Date | — | FlowFilter |
| 5833 | Prod. Order Comp. Line No. | Integer | Specifies the line number of the production order component. |  |
| 6500 | Serial No. | Code[50] | Specifies a serial number if the posted item carries such a number. |  |
| 6501 | Lot No. | Code[50] | Specifies a lot number if the posted item carries such a number. |  |
| 6502 | Warranty Date | Date | Specifies the last day of warranty for the item on the line. |  |
| 6503 | Expiration Date | Date | Specifies the last date that the item on the line can be used. |  |
| 6510 | Item Tracking | Enum "Item Tracking Entry Type" | — | enum [Enum 6566 "Item Tracking Entry Type"](../enum/6566.md); not editable |
| 6515 | Package No. | Code[50] | Specifies a package number if the posted item carries such a number. |  |
| 6602 | Return Reason Code | Code[10] | Specifies the code explaining why the item was returned. | TableRelation [Table 6635 "Return Reason"](../table/6635.md) (Return Reason) |
| 6603 | Item Description | Text[100] | Specifies the description of the item in the entry. Analysis mode must be used for sorting and filtering on this field. | FlowField: lookup(Item.Description where("No." = field("Item No."))); not editable |

## 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"](../codeunit/6516.md) 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"](../codeunit/6516.md) ItemLedgerEntryOnAfterSetTrackingFilterBlank
- `OnAfterCopyTrackingFromItemJnlLine(var ItemLedgerEntry: Record "Item Ledger Entry"; ItemJnlLine: Record "Item Journal Line")` (integration)
  - subscribers: [Codeunit 6516 "Package Management"](../codeunit/6516.md) ItemLedgerEntryCopyTrackingFromItemJnlLine
- `OnAfterCopyTrackingFromNewItemJnlLine(var ItemLedgerEntry: Record "Item Ledger Entry"; ItemJnlLine: Record "Item Journal Line")` (integration)
  - subscribers: [Codeunit 6516 "Package Management"](../codeunit/6516.md) 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"](../codeunit/6516.md) 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"](../codeunit/6516.md) ItemLedgerEntrySetTrackingFilterFromItemLedgEntry
- `OnAfterSetTrackingFilterFromItemJournalLine(var ItemLedgerEntry: Record "Item Ledger Entry"; ItemJournalLine: Record "Item Journal Line")` (integration)
  - subscribers: [Codeunit 6516 "Package Management"](../codeunit/6516.md) ItemLedgerEntrySetTrackingFilterFromItemJournalLine
- `OnAfterSetTrackingFilterFromItemTrackingSetup(var ItemLedgerEntry: Record "Item Ledger Entry"; ItemTrackingSetup: Record "Item Tracking Setup")` (integration)
  - subscribers: [Codeunit 6516 "Package Management"](../codeunit/6516.md) ItemLedgerEntrySetTrackingFilterFromItemTrackingSetup
- `OnAfterSetTrackingFilterFromItemTrackingSetupIfNotBlank(var ItemLedgerEntry: Record "Item Ledger Entry"; ItemTrackingSetup: Record "Item Tracking Setup")` (integration)
  - subscribers: [Codeunit 6516 "Package Management"](../codeunit/6516.md) ItemLedgerEntrySetTrackingFilterFromItemTrackingSetupIfNotBlank
- `OnAfterSetTrackingFilterFromItemTrackingSetupIfRequired(var ItemLedgerEntry: Record "Item Ledger Entry"; ItemTrackingSetup: Record "Item Tracking Setup")` (integration)
  - subscribers: [Codeunit 6516 "Package Management"](../codeunit/6516.md) ItemLedgerEntrySetTrackingFilterFromItemTrackingSetupIfRequired
- `OnAfterSetTrackingFilterFromSpec(var ItemLedgerEntry: Record "Item Ledger Entry"; TrackingSpecification: Record "Tracking Specification")` (integration)
  - subscribers: [Codeunit 6516 "Package Management"](../codeunit/6516.md) ItemLedgerEntrySetTrackingFilterFromSpec
- `OnAfterTrackingExists(ItemLedgerEntry: Record "Item Ledger Entry"; var IsTrackingExist: Boolean)` (integration)
  - subscribers: [Codeunit 6516 "Package Management"](../codeunit/6516.md) ItemLedgerEntryTrackingExists
- `OnAfterTestTrackingEqualToTrackingSpec(var ItemLedgerEntry: Record "Item Ledger Entry"; TrackingSpecification: Record "Tracking Specification")` (integration)
  - subscribers: [Codeunit 6516 "Package Management"](../codeunit/6516.md) 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"](../codeunit/20.md) OnInsertItemLedgerEntry
- OnAfterModifyEvent: [Codeunit 20 "Posting Preview Event Handler"](../codeunit/20.md) OnModifyItemLedgerEntry

## Procedures

- `GetNextEntryNo(): Integer`
- `GetLastEntryNo(): Integer`
- `GetCurrencyCode(): Code[10]` (obsolete 27.0: Please use GetAdditionalReportingCurrencyCode instead.)
- `GetAdditionalReportingCurrencyCode(): Code[10]`
- `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)`
- `EntryNoHasSameSign(EntryNo: integer): Boolean` (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"](../page/38.md)
- lookup page [Page 38 "Item Ledger Entries"](../page/38.md)
- Shpt. Method Code: TableRelation [Table 10 "Shipment Method"](../table/10.md)
- Job Task No.: TableRelation [Table 1001 "Job Task"](../table/1001.md)
- Location Code: TableRelation [Table 14 "Location"](../table/14.md)
- Source No.: TableRelation [Table 18 "Customer"](../table/18.md) (conditional)
- Source No.: TableRelation [Table 23 "Vendor"](../table/23.md) (conditional)
- Transaction Type: TableRelation [Table 258 "Transaction Type"](../table/258.md)
- Transport Method: TableRelation [Table 259 "Transport Method"](../table/259.md)
- Item Description: CalcFormula [Table 27 "Item"](../table/27.md)
- Item No.: TableRelation [Table 27 "Item"](../table/27.md)
- Originally Ordered No.: TableRelation [Table 27 "Item"](../table/27.md)
- Source No.: TableRelation [Table 27 "Item"](../table/27.md) (conditional)
- Entry/Exit Point: TableRelation [Table 282 "Entry/Exit Point"](../table/282.md)
- Area: TableRelation [Table 284 "Area"](../table/284.md)
- Transaction Specification: TableRelation [Table 285 "Transaction Specification"](../table/285.md)
- No. Series: TableRelation [Table 308 "No. Series"](../table/308.md)
- Reserved Quantity: CalcFormula [Table 337 "Reservation Entry"](../table/337.md)
- Remaining Qty. by Date: CalcFormula [Table 339 "Item Application Entry"](../table/339.md)
- Global Dimension 1 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Global Dimension 2 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Item Register No.: TableRelation [Table 46 "Item Register"](../table/46.md)
- Shortcut Dimension 3 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Shortcut Dimension 4 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Shortcut Dimension 5 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Shortcut Dimension 6 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Shortcut Dimension 7 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Shortcut Dimension 8 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Dimension Set ID: TableRelation [Table 480 "Dimension Set Entry"](../table/480.md)
- Originally Ordered Var. Code: TableRelation [Table 5401 "Item Variant"](../table/5401.md)
- Variant Code: TableRelation [Table 5401 "Item Variant"](../table/5401.md)
- Unit of Measure Code: TableRelation [Table 5404 "Item Unit of Measure"](../table/5404.md)
- Purchasing Code: TableRelation [Table 5721 "Purchasing"](../table/5721.md)
- Item Category Code: TableRelation [Table 5722 "Item Category"](../table/5722.md)
- Cost Amount (Actual): CalcFormula [Table 5802 "Value Entry"](../table/5802.md)
- Cost Amount (Actual) (ACY): CalcFormula [Table 5802 "Value Entry"](../table/5802.md)
- Cost Amount (Expected): CalcFormula [Table 5802 "Value Entry"](../table/5802.md)
- Cost Amount (Expected) (ACY): CalcFormula [Table 5802 "Value Entry"](../table/5802.md)
- Cost Amount (Non-Invtbl.): CalcFormula [Table 5802 "Value Entry"](../table/5802.md)
- Cost Amount (Non-Invtbl.)(ACY): CalcFormula [Table 5802 "Value Entry"](../table/5802.md)
- Item Ledger Entry Quantity: CalcFormula [Table 5802 "Value Entry"](../table/5802.md)
- Purchase Amount (Actual): CalcFormula [Table 5802 "Value Entry"](../table/5802.md)
- Purchase Amount (Expected): CalcFormula [Table 5802 "Value Entry"](../table/5802.md)
- Sales Amount (Actual): CalcFormula [Table 5802 "Value Entry"](../table/5802.md)
- Sales Amount (Expected): CalcFormula [Table 5802 "Value Entry"](../table/5802.md)
- Return Reason Code: TableRelation [Table 6635 "Return Reason"](../table/6635.md)
- Country/Region Code: TableRelation [Table 9 "Country/Region"](../table/9.md)

## Referenced by

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

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

## Pages and codeunits on this table

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

## Extended by

- [Table extension 20500 "Subc. Item Ledger Entry"](../tableextension/20500.md)
- [Table extension 5015 "Serv. Decl. Item Ledg. Entry"](../tableextension/5015.md)
- [Table extension 6261 "Sust. Item Ledger Entry"](../tableextension/6261.md)
- [Table extension 7415 "Excise Item Ledger Entry Ext"](../tableextension/7415.md)
- [Table extension 99000787 "Mfg. Item Ledger Entry"](../tableextension/99000787.md)

## 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"](../codeunit/408.md) (1 call: `ShowDimensions → ShowDimensionSet`)
- [Codeunit 703 "Find Record Management"](../codeunit/703.md) (1 call: `GetLastEntryNo → GetLastEntryIntFieldValue`)
- [Codeunit 9500 "Sequence No. Mgt."](../codeunit/9500.md) (1 call: `GetNextEntryNo → GetNextSeqNo`)
- [Page 497 "Reservation Entries"](../page/497.md) (1 call: `ShowReservationEntries → (object)`)

## Recent changes

- 2026-10-02 [#12066 Bugs/remove asm inv mfg clean27 tags for wave2 2026](../../changes/bcapps/12066.md) (main, BC30, obsoletion)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC24, BC26-28, BC30

## Countries that replace it

[AU](../../localizations/au.md), [CA](../../localizations/ca.md), [CH](../../localizations/ch.md), [ES](../../localizations/es.md), [FR](../../localizations/fr.md), [GB](../../localizations/gb.md), [IT](../../localizations/it.md), [MX](../../localizations/mx.md), [NZ](../../localizations/nz.md), [RU](../../localizations/ru.md), [US](../../localizations/us.md)

## 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.