Table 32 Item Ledger Entry

Base Application, Microsoft.Inventory.Ledger
List17181920212223242526272829
Fields2162
Keys5183342
Procedures2221214
Events41512

In 28 1 changed, 1 added

key(Key6; "Item No.", Open, "Variant Code", Positive, "Location Code", "Posting Date") { IncludedFields = "Job No.", "Job Task No.", "Document Type", "Document No.", "Order Type", "Order No.", "Serial No.", "Lot No.", "Package No.", Quantity, "Remaining Quantity"; }17-29changed in 23, 26, 28
changed, was key(Key6; "Item No.", Open, "Variant Code", Positive, "Location Code", "Posting Date", "SIFT Bucket No.") { IncludedFields = "Job No.", "Job Task No.", "Document Type", "Document No.", "Order Type", "Order No.", "Serial No.", "Lot No.", "Package No."; SumIndexFields = Quantity, "Remaining Quantity"; }
key(Key7; "Location Code", "Item No.", "Variant Code", Open, Positive) { IncludedFields = Quantity, "Remaining Quantity"; }17-20, 28-29changed in 18
added

In 27 4 added, 1 gone, 1 marked obsolete

field(5820; "Remaining Qty. by Date"; Decimal)new in 27
added
field(5821; "Date Filter"; Date)new in 27
added
AppliedEntryToAdjustExists(ItemNo: Code[20]): Booleangone after 26
gone
GetCurrencyCode(): Code[10]new in 23
marked Pending, tag 27.0: Please use GetAdditionalReportingCurrencyCode instead.
GetAdditionalReportingCurrencyCode(): Code[10]new in 27
added
internal EntryNoHasSameSign(EntryNo: Integer): Booleannew in 27
added

In 26 5 added, 2 gone, 4 changed

field(20; "Item Register No."; Integer)new in 26
added
field(21; "SIFT Bucket No."; Integer)new in 26
added
field(5700; "Cross-Reference No."; Code[20])gone after 25
gone
field(5707; "Product Group Code"; Code[10])gone after 25
gone
field(5819; "Item Ledger Entry Quantity"; Decimal)new in 26
added
field(6603; "Item Description"; Text[100])new in 26
added
key(Key2; "Item No.", "SIFT Bucket No.") { SumIndexFields = "Invoiced Quantity", Quantity; }17-29changed in 26
changed, was key(Key2; "Item No.") { SumIndexFields = "Invoiced Quantity", Quantity; }
key(Key4; "Item No.", "Entry Type", "Variant Code", "Drop Shipment", "Location Code", "Posting Date", "SIFT Bucket No.") { SumIndexFields = Quantity, "Invoiced Quantity"; }17-29changed in 26
changed, was key(Key4; "Item No.", "Entry Type", "Variant Code", "Drop Shipment", "Location Code", "Posting Date") { SumIndexFields = Quantity, "Invoiced Quantity"; }
key(Key5; "Source Type", "Source No.", "Item No.", "Variant Code", "Posting Date") { IncludedFields = Quantity; }17-29changed in 26
changed, was key(Key5; "Source Type", "Source No.", "Item No.", "Variant Code", "Posting Date") { IncludedFields = Quantity; SumIndexFields = Quantity; }
key(Key6; "Item No.", Open, "Variant Code", Positive, "Location Code", "Posting Date", "SIFT Bucket No.") { IncludedFields = "Job No.", "Job Task No.", "Document Type", "Document No.", "Order Type", "Order No.", "Serial No.", "Lot No.", "Package No."; SumIndexFields = Quantity, "Remaining Quantity"; }17-29changed in 23, 26, 28
changed, was key(Key6; "Item No.", Open, "Variant Code", Positive, "Location Code", "Posting Date") { IncludedFields = "Job No.", "Job Task No.", "Document Type", "Document No.", "Order Type", "Order No.", "Serial No.", "Lot No.", "Package No."; SumIndexFields = Quantity, "Remaining Quantity"; }
GetNextEntryNo(): Integernew in 26
added

In 24 2 changed, 2 added, 1 marked obsolete

key(Key3; "Item No.", "Posting Date") { IncludedFields = Quantity, "Location Code"; }17-29changed in 24
changed, was key(Key3; "Item No.", "Posting Date") { IncludedFields = Quantity, "Location Code"; }
key(Key9; "Document No.", "Document Type", "Document Line No.") { IncludedFields = "Entry Type", "Item No.", Correction; }17-29changed in 23, 24
changed, was key(Key9; "Document No.", "Document Type", "Document Line No.") { IncludedFields = "Entry Type"; }
key(Key25; "Entry Type", "Item No.")new in 24
added
AppliedEntryToAdjustExists(ItemNo: Code[20]): Booleangone after 26
marked Pending, tag 24.0: Unused
CollectItemLedgerEntryTypesUsed(var ItemLedgerEntryTypesUsed: Dictionary of [Enum "Item Ledger Entry Type", Boolean]; ItemNoFilter: Text)new in 24
added

In 23 3 changed, 1 added

key(Key6; "Item No.", Open, "Variant Code", Positive, "Location Code", "Posting Date") { IncludedFields = "Job No.", "Job Task No.", "Document Type", "Document No.", "Order Type", "Order No.", "Serial No.", "Lot No.", "Package No."; SumIndexFields = Quantity, "Remaining Quantity"; }17-29changed in 23, 26, 28
changed, was key(Key6; "Item No.", Open, "Variant Code", Positive, "Location Code", "Posting Date") { IncludedFields = "Job No.", "Job Task No.", "Document Type", "Document No.", "Order Type", "Order No.", "Serial No.", "Lot No.", "Package No.", Quantity, "Remaining Quantity"; SumIndexFields = Quantity, "Remaining Quantity"; }
key(Key9; "Document No.", "Document Type", "Document Line No.") { IncludedFields = "Entry Type"; }17-29changed in 23, 24
changed, was key(Key9; "Document No.", "Document Type", "Document Line No.") { IncludedFields = "Entry Type", "Item No.", Correction; }
key(Key12; "Order Type", "Order No.", "Order Line No.", "Entry Type", "Prod. Order Comp. Line No.") { IncludedFields = Quantity, "Posting Date", Positive, "Applies-to Entry"; }17-29changed in 21, 23
changed, was key(Key12; "Order Type", "Order No.", "Order Line No.", "Entry Type", "Prod. Order Comp. Line No.") { IncludedFields = Quantity; }
GetCurrencyCode(): Code[10]new in 23
added

In 22 1 state changed, 2 added

field(5700; "Cross-Reference No."; Code[20])gone after 25
Pending to Removed, tag 22.0: Cross-Reference replaced by Item Reference feature.
[IntegrationEvent] OnAfterSetReservationEntry(var ReservationEntry: Record "Reservation Entry"; ItemLedgerEntry: Record "Item Ledger Entry")new in 22
added
[IntegrationEvent] OnAfterFilterLinesForReservation(var ItemLedgerEntry: Record "Item Ledger Entry"; ReservationEntry: Record "Reservation Entry"; NewPositive: Boolean)new in 22
added

In 21 6 gone, 2 changed, 1 added

key(Key7; "Item No.", Open, "Variant Code", Positive, "Location Code", "Posting Date", "Expiration Date", "Lot No.", "Serial No.", "Package No.") { Enabled = false; IncludedFields = Quantity, "Remaining Quantity"; SumIndexFields = Quantity, "Remaining Quantity"; }17-20, 28-29changed in 18
gone
key(Key10; "Item No.", "Entry Type", "Variant Code", "Drop Shipment", "Global Dimension 1 Code", "Global Dimension 2 Code", "Location Code", "Posting Date") { Enabled = false; SumIndexFields = Quantity, "Invoiced Quantity"; }gone after 20
gone
key(Key11; "Source Type", "Source No.", "Global Dimension 1 Code", "Global Dimension 2 Code", "Item No.", "Variant Code", "Posting Date") { Enabled = false; SumIndexFields = Quantity; }gone after 20
gone
key(Key12; "Order Type", "Order No.", "Order Line No.", "Entry Type", "Prod. Order Comp. Line No.") { IncludedFields = Quantity; }17-29changed in 21, 23
changed, was key(Key12; "Order Type", "Order No.", "Order Line No.", "Entry Type", "Prod. Order Comp. Line No.") { IncludedFields = Quantity, "Posting Date", Positive, "Applies-to Entry"; SumIndexFields = Quantity; }
key(Key15; "Entry Type", Nonstock, "Item No.", "Posting Date") { Enabled = false; }gone after 20
gone
key(Key16; "Item No.", "Location Code", Open, "Variant Code", "Unit of Measure Code", "Lot No.", "Serial No.", "Package No.") { Enabled = false; SumIndexFields = "Remaining Quantity"; }gone after 20changed in 18
gone
key(Key17; "Item No.", Open, "Variant Code", Positive, "Lot No.", "Serial No.", "Package No.") { IncludedFields = "Remaining Quantity"; }17-29changed in 18, 21
changed, was key(Key17; "Item No.", Open, "Variant Code", Positive, "Lot No.", "Serial No.", "Package No.") { IncludedFields = "Remaining Quantity"; }
key(Key18; "Item No.", Open, "Variant Code", "Location Code", "Item Tracking", "Lot No.", "Serial No.", "Package No.") { Enabled = false; SumIndexFields = "Remaining Quantity"; }gone after 20changed in 18
gone
[IntegrationEvent] OnBeforeCalculateRemQuantity(ItemLedgerEntry: Record "Item Ledger Entry"; ItemLedgEntryNo: Integer; PostingDate: Date; var RemQty: Decimal; var IsHandled: Boolean)new in 21
added

In 20 1 changed, 2 gone, 5 added

key(Key20; "Serial No.", "Item No.", Open, "Variant Code", Positive, "Location Code", "Posting Date")17-29changed in 20
changed, was key(Key20; "Serial No.")
SetTrackingFilter(SerialNo: Code[50]; LotNo: Code[50])gone after 19
gone
internal CalcReservedQuantity()new in 20
added
[IntegrationEvent] OnBeforeVerifyOnInventory(var ItemLedgerEntry: Record "Item Ledger Entry"; var IsHandled: Boolean)gone after 19
gone
[IntegrationEvent] OnBeforeGetReservationQty(var ItemLedgerEntry: Record "Item Ledger Entry"; var QtyReserved: Decimal; var QtyToReserve: Decimal; var IsHandled: Boolean)new in 20
added
[IntegrationEvent] OnBeforeVerifyOnInventory(var ItemLedgerEntry: Record "Item Ledger Entry"; var IsHandled: Boolean; ErrorMessageText: Text)new in 20
added
[IntegrationEvent] OnAfterVerifyOnInventory(var ItemLedgerEntry: Record "Item Ledger Entry"; ErrorMessageText: Text)new in 20
added
[IntegrationEvent] OnBeforeCalcReservedQuantity(var ItemLedgerEntry: Record "Item Ledger Entry"; var IsHandled: Boolean)new in 20
added

In 19 3 added

CalculateRemInventoryValue(ItemLedgEntryNo: Integer; ItemLedgEntryQty: Decimal; RemQty: Decimal; IncludeExpectedCost: Boolean; ValuationDate: Date; PostingDate: Date): Decimalnew in 19
added
CheckTrackingDoesNotExist(RecId: RecordId; FldCaption: Text)new in 19
added
[IntegrationEvent] OnBeforeCheckTrackingDoesNotExist(RecId: RecordId; ItemLedgEntry: Record "Item Ledger Entry"; FldCaption: Text; var IsHandled: Boolean)new in 19
added

In 18 5 changed, 7 added, 1 gone

field(41; "Source Type"; Enum "Analysis Source Type")17-29changed in 18
changed, was field(41; "Source Type"; Option)
field(6515; "Package No."; Code[50])new in 18
added
key(Key7; "Item No.", Open, "Variant Code", Positive, "Location Code", "Posting Date", "Expiration Date", "Lot No.", "Serial No.", "Package No.") { Enabled = false; IncludedFields = Quantity, "Remaining Quantity"; SumIndexFields = Quantity, "Remaining Quantity"; }17-20, 28-29changed in 18
changed, was key(Key7; "Item No.", Open, "Variant Code", Positive, "Location Code", "Posting Date", "Expiration Date", "Lot No.", "Serial No.") { Enabled = false; IncludedFields = Quantity, "Remaining Quantity"; SumIndexFields = Quantity, "Remaining Quantity"; }
key(Key16; "Item No.", "Location Code", Open, "Variant Code", "Unit of Measure Code", "Lot No.", "Serial No.", "Package No.") { Enabled = false; SumIndexFields = "Remaining Quantity"; }gone after 20changed in 18
changed, was key(Key16; "Item No.", "Location Code", Open, "Variant Code", "Unit of Measure Code", "Lot No.", "Serial No.") { Enabled = false; SumIndexFields = "Remaining Quantity"; }
key(Key17; "Item No.", Open, "Variant Code", Positive, "Lot No.", "Serial No.", "Package No.") { IncludedFields = "Remaining Quantity"; }17-29changed in 18, 21
changed, was key(Key17; "Item No.", Open, "Variant Code", Positive, "Lot No.", "Serial No.") { IncludedFields = "Remaining Quantity"; }
key(Key18; "Item No.", Open, "Variant Code", "Location Code", "Item Tracking", "Lot No.", "Serial No.", "Package No.") { Enabled = false; SumIndexFields = "Remaining Quantity"; }gone after 20changed in 18
changed, was key(Key18; "Item No.", Open, "Variant Code", "Location Code", "Item Tracking", "Lot No.", "Serial No.") { Enabled = false; SumIndexFields = "Remaining Quantity"; }
key(Key21; SystemModifiedAt)new in 18
added
SetTrackingFilterFromItemTrackingSetupIfRequired(ItemTrackingSetup: Record "Item Tracking Setup")new in 18
added
SetTrackingFilterBlank()new in 18
added
[IntegrationEvent] OnAfterFilterLinesWithItemToPlan(var ItemLedgerEntry: Record "Item Ledger Entry"; var Item: Record Item)gone after 17
gone
[IntegrationEvent] OnAfterSetTrackingFilterBlank(var ItemLedgerEntry: Record "Item Ledger Entry")new in 18
added
[IntegrationEvent] OnAfterFilterLinesWithItemToPlan(var ItemLedgerEntry: Record "Item Ledger Entry"; var Item: Record Item; NetChange: Boolean)new in 18
added
[IntegrationEvent] OnAfterSetTrackingFilterFromItemTrackingSetupIfRequired(var ItemLedgerEntry: Record "Item Ledger Entry"; ItemTrackingSetup: Record "Item Tracking Setup")new in 18
added