Share via

Table "Item Ledger Entry"

ID 32
Namespace: Microsoft.Inventory.Ledger

Properties

Name Value
Caption Item Ledger Entry
DrillDownPageID Page Microsoft.Inventory.Ledger."Item Ledger Entries"
LookupPageID Page Microsoft.Inventory.Ledger."Item Ledger Entries"
Permissions TableData "Item Ledger Entry" = rimd
DataClassification CustomerContent

Fields

Name Type Description
"Entry No." Integer
"Item No." Code[20]
"Posting Date" Date
"Entry Type" Enum Microsoft.Inventory.Ledger."Item Ledger Entry Type"
"Source No." Code[20]
"Document No." Code[20]
Description Text[100]
"Location Code" Code[10]
Quantity Decimal
"Remaining Quantity" Decimal
"Invoiced Quantity" Decimal
"Item Register No." Integer
"SIFT Bucket No." Integer

Specifies an automatically generated number that is used by the system to enable better concurrency.
"Applies-to Entry" Integer
Open Boolean
"Global Dimension 1 Code" Code[20]
"Global Dimension 2 Code" Code[20]
Positive Boolean
"Shpt. Method Code" Code[10]
"Source Type" Enum Microsoft.Foundation.Enums."Analysis Source Type"
"Drop Shipment" Boolean
"Transaction Type" Code[10]
"Transport Method" Code[10]
"Country/Region Code" Code[10]
"Entry/Exit Point" Code[10]
"Document Date" Date
"External Document No." Code[35]
"Area" Code[10]
"Transaction Specification" Code[10]
"No. Series" Code[20]
"Reserved Quantity" Decimal
"Document Type" Enum Microsoft.Inventory.Ledger."Item Ledger Document Type"
"Document Line No." Integer
"Order Type" Enum Microsoft.Foundation.Enums."Inventory Order Type"
"Order No." Code[20]
"Order Line No." Integer
"Dimension Set ID" Integer
"Shortcut Dimension 3 Code" Code[20]
"Shortcut Dimension 4 Code" Code[20]
"Shortcut Dimension 5 Code" Code[20]
"Shortcut Dimension 6 Code" Code[20]
"Shortcut Dimension 7 Code" Code[20]
"Shortcut Dimension 8 Code" Code[20]
"Assemble to Order" Boolean
"Job No." Code[20]
"Job Task No." Code[20]
"Job Purchase" Boolean
"Variant Code" Code[10]
"Qty. per Unit of Measure" Decimal
"Unit of Measure Code" Code[10]
"Derived from Blanket Order" Boolean
"Originally Ordered No." Code[20]
"Originally Ordered Var. Code" Code[10]
"Out-of-Stock Substitution" Boolean
"Item Category Code" Code[20]
Nonstock Boolean
"Purchasing Code" Code[10]
"Item Reference No." Code[50]
"Completely Invoiced" Boolean
"Last Invoice Date" Date
"Applied Entry to Adjust" Boolean
"Cost Amount (Expected)" Decimal
"Cost Amount (Actual)" Decimal
"Cost Amount (Non-Invtbl.)" Decimal
"Cost Amount (Expected) (ACY)" Decimal
"Cost Amount (Actual) (ACY)" Decimal
"Cost Amount (Non-Invtbl.)(ACY)" Decimal
"Purchase Amount (Expected)" Decimal
"Purchase Amount (Actual)" Decimal
"Sales Amount (Expected)" Decimal
"Sales Amount (Actual)" Decimal
Correction Boolean
"Shipped Qty. Not Returned" Decimal
"Item Ledger Entry Quantity" Decimal
"Prod. Order Comp. Line No." Integer
"Serial No." Code[50]
"Lot No." Code[50]
"Warranty Date" Date
"Expiration Date" Date
"Item Tracking" Enum Microsoft.Inventory.Tracking."Item Tracking Entry Type"
"Package No." Code[50]
"Return Reason Code" Code[10]
"Item Description" Text[100]
SystemId Guid
SystemCreatedAt DateTime
SystemCreatedBy Guid
SystemModifiedAt DateTime
SystemModifiedBy Guid
SystemRowVersion BigInteger

Methods

GetNextEntryNo

[InherentPermissions(TableData,32,r)]
procedure GetNextEntryNo(): Integer

Returns

Type Description
Integer

GetLastEntryNo

[InherentPermissions(TableData,32,r)]
procedure GetLastEntryNo(): Integer

Returns

Type Description
Integer

GetCurrencyCode

Obsolete

This element will become obsolete from version 27.0. Please use GetAdditionalReportingCurrencyCode instead.

[Obsolete(Please use GetAdditionalReportingCurrencyCode instead.,27.0)]
procedure GetCurrencyCode(): Code[10]

Returns

Type Description
Code[10]

GetAdditionalReportingCurrencyCode

procedure GetAdditionalReportingCurrencyCode(): Code[10]

Returns

Type Description
Code[10]

ShowReservationEntries

procedure ShowReservationEntries(Modal: Boolean)

Parameters

Name Type Description
Modal Boolean

SetAppliedEntryToAdjust

procedure SetAppliedEntryToAdjust(AppliedEntryToAdjust: Boolean)

Parameters

Name Type Description
AppliedEntryToAdjust Boolean

SetAvgTransCompletelyInvoiced

procedure SetAvgTransCompletelyInvoiced(): Boolean

Returns

Type Description
Boolean

SetCompletelyInvoiced

procedure SetCompletelyInvoiced()

IsOutbndConsump

procedure IsOutbndConsump(): Boolean

Returns

Type Description
Boolean

IsExactCostReversingPurchase

procedure IsExactCostReversingPurchase(): Boolean

Returns

Type Description
Boolean

IsExactCostReversingOutput

procedure IsExactCostReversingOutput(): Boolean

Returns

Type Description
Boolean

UpdateItemTracking

procedure UpdateItemTracking()

GetSourceCaption

procedure GetSourceCaption(): Text

Returns

Type Description
Text

GetUnitCostLCY

procedure GetUnitCostLCY(): Decimal

Returns

Type Description
Decimal

FilterLinesWithItemToPlan

procedure FilterLinesWithItemToPlan(var Item: Record Item, NetChange: Boolean)

Parameters

Name Type Description
Item Table Microsoft.Inventory.Item.Item
NetChange Boolean

FindLinesWithItemToPlan

procedure FindLinesWithItemToPlan(var Item: Record Item, NetChange: Boolean): Boolean

Parameters

Name Type Description
Item Table Microsoft.Inventory.Item.Item
NetChange Boolean

Returns

Type Description
Boolean

LinesWithItemToPlanExist

procedure LinesWithItemToPlanExist(var Item: Record Item, NetChange: Boolean): Boolean

Parameters

Name Type Description
Item Table Microsoft.Inventory.Item.Item
NetChange Boolean

Returns

Type Description
Boolean

FilterLinesForReservation

procedure FilterLinesForReservation(ReservationEntry: Record "Reservation Entry", NewPositive: Boolean)

Parameters

Name Type Description
ReservationEntry Table Microsoft.Inventory.Tracking."Reservation Entry"
NewPositive Boolean

FilterLinesForTracking

procedure FilterLinesForTracking(CalcReservEntry: Record "Reservation Entry", Positive: Boolean)

Parameters

Name Type Description
CalcReservEntry Table Microsoft.Inventory.Tracking."Reservation Entry"
Positive Boolean

IsOutbndSale

procedure IsOutbndSale(): Boolean

Returns

Type Description
Boolean

ShowDimensions

procedure ShowDimensions()

CalculateRemQuantity

procedure CalculateRemQuantity(ItemLedgEntryNo: Integer, PostingDate: Date): Decimal

Parameters

Name Type Description
ItemLedgEntryNo Integer
PostingDate Date

Returns

Type Description
Decimal

VerifyOnInventory

procedure VerifyOnInventory()

VerifyOnInventory

procedure VerifyOnInventory(ErrorMessageText: Text)

Parameters

Name Type Description
ErrorMessageText Text

CalculateRemInventoryValue

procedure CalculateRemInventoryValue(ItemLedgEntryNo: Integer, ItemLedgEntryQty: Decimal, RemQty: Decimal, IncludeExpectedCost: Boolean, PostingDate: Date): Decimal

Parameters

Name Type Description
ItemLedgEntryNo Integer
ItemLedgEntryQty Decimal
RemQty Decimal
IncludeExpectedCost Boolean
PostingDate Date

Returns

Type Description
Decimal

CalculateRemInventoryValue

procedure CalculateRemInventoryValue(ItemLedgEntryNo: Integer, ItemLedgEntryQty: Decimal, RemQty: Decimal, IncludeExpectedCost: Boolean, ValuationDate: Date, PostingDate: Date): Decimal

Parameters

Name Type Description
ItemLedgEntryNo Integer
ItemLedgEntryQty Decimal
RemQty Decimal
IncludeExpectedCost Boolean
ValuationDate Date
PostingDate Date

Returns

Type Description
Decimal

TrackingExists

procedure TrackingExists(): Boolean

Returns

Type Description
Boolean

CheckTrackingDoesNotExist

procedure CheckTrackingDoesNotExist(RecId: RecordId, FldCaption: Text)

Parameters

Name Type Description
RecId RecordId
FldCaption Text

CopyTrackingFromItemJnlLine

procedure CopyTrackingFromItemJnlLine(ItemJnlLine: Record "Item Journal Line")

Parameters

Name Type Description
ItemJnlLine Table Microsoft.Inventory.Journal."Item Journal Line"

CopyTrackingFromNewItemJnlLine

procedure CopyTrackingFromNewItemJnlLine(ItemJnlLine: Record "Item Journal Line")

Parameters

Name Type Description
ItemJnlLine Table Microsoft.Inventory.Journal."Item Journal Line"

GetReservationQty

procedure GetReservationQty(var QtyReserved: Decimal, var QtyToReserve: Decimal)

Parameters

Name Type Description
QtyReserved Decimal
QtyToReserve Decimal

SetItemVariantLocationFilters

procedure SetItemVariantLocationFilters(ItemNo: Code[20], VariantCode: Code[10], LocationCode: Code[10], PostingDate: Date)

Parameters

Name Type Description
ItemNo Code[20]
VariantCode Code[10]
LocationCode Code[10]
PostingDate Date

SetReservationEntry

procedure SetReservationEntry(var ReservEntry: Record "Reservation Entry")

Parameters

Name Type Description
ReservEntry Table Microsoft.Inventory.Tracking."Reservation Entry"

SetReservationFilters

procedure SetReservationFilters(var ReservEntry: Record "Reservation Entry")

Parameters

Name Type Description
ReservEntry Table Microsoft.Inventory.Tracking."Reservation Entry"

SetTrackingFilterFromItemLedgEntry

procedure SetTrackingFilterFromItemLedgEntry(ItemLedgEntry: Record "Item Ledger Entry")

Parameters

Name Type Description
ItemLedgEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"

SetTrackingFilterFromItemJournalLine

procedure SetTrackingFilterFromItemJournalLine(ItemJournalLine: Record "Item Journal Line")

Parameters

Name Type Description
ItemJournalLine Table Microsoft.Inventory.Journal."Item Journal Line"

SetTrackingFilterFromItemTrackingSetup

procedure SetTrackingFilterFromItemTrackingSetup(ItemTrackingSetup: Record "Item Tracking Setup" temporary)

Parameters

Name Type Description
ItemTrackingSetup Table Microsoft.Inventory.Tracking."Item Tracking Setup"

SetTrackingFilterFromItemTrackingSetupIfNotBlank

procedure SetTrackingFilterFromItemTrackingSetupIfNotBlank(ItemTrackingSetup: Record "Item Tracking Setup" temporary)

Parameters

Name Type Description
ItemTrackingSetup Table Microsoft.Inventory.Tracking."Item Tracking Setup"

SetTrackingFilterFromItemTrackingSetupIfRequired

procedure SetTrackingFilterFromItemTrackingSetupIfRequired(ItemTrackingSetup: Record "Item Tracking Setup" temporary)

Parameters

Name Type Description
ItemTrackingSetup Table Microsoft.Inventory.Tracking."Item Tracking Setup"

SetTrackingFilterFromSpec

procedure SetTrackingFilterFromSpec(TrackingSpecification: Record "Tracking Specification")

Parameters

Name Type Description
TrackingSpecification Table Microsoft.Inventory.Tracking."Tracking Specification"

SetTrackingFilterBlank

procedure SetTrackingFilterBlank()

ClearTrackingFilter

procedure ClearTrackingFilter()

TestTrackingEqualToTrackingSpec

procedure TestTrackingEqualToTrackingSpec(TrackingSpecification: Record "Tracking Specification")

Parameters

Name Type Description
TrackingSpecification Table Microsoft.Inventory.Tracking."Tracking Specification"

CollectItemLedgerEntryTypesUsed

procedure CollectItemLedgerEntryTypesUsed(var ItemLedgerEntryTypesUsed: Dictionary of [Enum "Item Ledger Entry Type", Boolean], ItemNoFilter: Text)

Parameters

Name Type Description
ItemLedgerEntryTypesUsed Dictionary of [Enum Microsoft.Inventory.Ledger."Item Ledger Entry Type", Boolean]
ItemNoFilter Text

Events

OnAfterClearTrackingFilter

[IntegrationEvent(False,False)]
local procedure OnAfterClearTrackingFilter(var ItemLedgerEntry: Record "Item Ledger Entry")

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"

OnAfterSetReservationEntry

[IntegrationEvent(False,False)]
local procedure OnAfterSetReservationEntry(var ReservationEntry: Record "Reservation Entry", ItemLedgerEntry: Record "Item Ledger Entry")

Parameters

Name Type Description
ReservationEntry Table Microsoft.Inventory.Tracking."Reservation Entry"
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"

OnAfterSetTrackingFilterBlank

[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterBlank(var ItemLedgerEntry: Record "Item Ledger Entry")

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"

OnAfterCopyTrackingFromItemJnlLine

[IntegrationEvent(False,False)]
local procedure OnAfterCopyTrackingFromItemJnlLine(var ItemLedgerEntry: Record "Item Ledger Entry", ItemJnlLine: Record "Item Journal Line")

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
ItemJnlLine Table Microsoft.Inventory.Journal."Item Journal Line"

OnAfterCopyTrackingFromNewItemJnlLine

[IntegrationEvent(False,False)]
local procedure OnAfterCopyTrackingFromNewItemJnlLine(var ItemLedgerEntry: Record "Item Ledger Entry", ItemJnlLine: Record "Item Journal Line")

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
ItemJnlLine Table Microsoft.Inventory.Journal."Item Journal Line"

OnAfterFilterLinesWithItemToPlan

[IntegrationEvent(False,False)]
local procedure OnAfterFilterLinesWithItemToPlan(var ItemLedgerEntry: Record "Item Ledger Entry", var Item: Record Item, NetChange: Boolean)

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
Item Table Microsoft.Inventory.Item.Item
NetChange Boolean

OnAfterFilterLinesForReservation

[IntegrationEvent(False,False)]
local procedure OnAfterFilterLinesForReservation(var ItemLedgerEntry: Record "Item Ledger Entry", ReservationEntry: Record "Reservation Entry", NewPositive: Boolean)

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
ReservationEntry Table Microsoft.Inventory.Tracking."Reservation Entry"
NewPositive Boolean

OnAfterFilterLinesForTracking

[IntegrationEvent(False,False)]
local procedure OnAfterFilterLinesForTracking(var ItemLedgerEntry: Record "Item Ledger Entry", CalcReservEntry: Record "Reservation Entry", Positive: Boolean)

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
CalcReservEntry Table Microsoft.Inventory.Tracking."Reservation Entry"
Positive Boolean

OnAfterSetReservationFilters

[IntegrationEvent(False,False)]
local procedure OnAfterSetReservationFilters(var ReservEntry: Record "Reservation Entry", ItemLedgerEntry: Record "Item Ledger Entry")

Parameters

Name Type Description
ReservEntry Table Microsoft.Inventory.Tracking."Reservation Entry"
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"

OnAfterSetTrackingFilterFromItemLedgEntry

[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterFromItemLedgEntry(var ItemLedgerEntry: Record "Item Ledger Entry", FromItemLedgerEntry: Record "Item Ledger Entry")

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
FromItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"

OnAfterSetTrackingFilterFromItemJournalLine

[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterFromItemJournalLine(var ItemLedgerEntry: Record "Item Ledger Entry", ItemJournalLine: Record "Item Journal Line")

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
ItemJournalLine Table Microsoft.Inventory.Journal."Item Journal Line"

OnAfterSetTrackingFilterFromItemTrackingSetup

[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterFromItemTrackingSetup(var ItemLedgerEntry: Record "Item Ledger Entry", ItemTrackingSetup: Record "Item Tracking Setup" temporary)

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
ItemTrackingSetup Table Microsoft.Inventory.Tracking."Item Tracking Setup"

OnAfterSetTrackingFilterFromItemTrackingSetupIfNotBlank

[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterFromItemTrackingSetupIfNotBlank(var ItemLedgerEntry: Record "Item Ledger Entry", ItemTrackingSetup: Record "Item Tracking Setup" temporary)

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
ItemTrackingSetup Table Microsoft.Inventory.Tracking."Item Tracking Setup"

OnAfterSetTrackingFilterFromItemTrackingSetupIfRequired

[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterFromItemTrackingSetupIfRequired(var ItemLedgerEntry: Record "Item Ledger Entry", ItemTrackingSetup: Record "Item Tracking Setup" temporary)

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
ItemTrackingSetup Table Microsoft.Inventory.Tracking."Item Tracking Setup"

OnAfterSetTrackingFilterFromSpec

[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterFromSpec(var ItemLedgerEntry: Record "Item Ledger Entry", TrackingSpecification: Record "Tracking Specification")

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
TrackingSpecification Table Microsoft.Inventory.Tracking."Tracking Specification"

OnAfterTrackingExists

[IntegrationEvent(False,False)]
local procedure OnAfterTrackingExists(ItemLedgerEntry: Record "Item Ledger Entry", var IsTrackingExist: Boolean)

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
IsTrackingExist Boolean

OnAfterTestTrackingEqualToTrackingSpec

[IntegrationEvent(False,False)]
local procedure OnAfterTestTrackingEqualToTrackingSpec(var ItemLedgerEntry: Record "Item Ledger Entry", TrackingSpecification: Record "Tracking Specification")

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
TrackingSpecification Table Microsoft.Inventory.Tracking."Tracking Specification"

OnBeforeCalculateRemQuantity

[IntegrationEvent(False,False)]
local procedure OnBeforeCalculateRemQuantity(ItemLedgerEntry: Record "Item Ledger Entry", ItemLedgEntryNo: Integer, PostingDate: Date, var RemQty: Decimal, var IsHandled: Boolean)

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
ItemLedgEntryNo Integer
PostingDate Date
RemQty Decimal
IsHandled Boolean

OnBeforeCheckTrackingDoesNotExist

[IntegrationEvent(False,False)]
local procedure OnBeforeCheckTrackingDoesNotExist(RecId: RecordId, ItemLedgEntry: Record "Item Ledger Entry", FldCaption: Text, var IsHandled: Boolean)

Parameters

Name Type Description
RecId RecordId
ItemLedgEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
FldCaption Text
IsHandled Boolean

OnBeforeGetReservationQty

[IntegrationEvent(False,False)]
local procedure OnBeforeGetReservationQty(var ItemLedgerEntry: Record "Item Ledger Entry", var QtyReserved: Decimal, var QtyToReserve: Decimal, var IsHandled: Boolean)

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
QtyReserved Decimal
QtyToReserve Decimal
IsHandled Boolean

OnBeforeVerifyOnInventory

[IntegrationEvent(False,False)]
local procedure OnBeforeVerifyOnInventory(var ItemLedgerEntry: Record "Item Ledger Entry", var IsHandled: Boolean, ErrorMessageText: Text)

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
IsHandled Boolean
ErrorMessageText Text

OnFilterLinesForReservationOnBeforeSetFilterVariantCode

[IntegrationEvent(False,False)]
local procedure OnFilterLinesForReservationOnBeforeSetFilterVariantCode(var ItemLedgerEntry: Record "Item Ledger Entry", var ReservationEntry: Record "Reservation Entry", var Positive: Boolean, var IsHandled: Boolean)

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
ReservationEntry Table Microsoft.Inventory.Tracking."Reservation Entry"
Positive Boolean
IsHandled Boolean

OnAfterVerifyOnInventory

[IntegrationEvent(False,False)]
local procedure OnAfterVerifyOnInventory(var ItemLedgerEntry: Record "Item Ledger Entry", ErrorMessageText: Text)

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
ErrorMessageText Text

OnBeforeCalcReservedQuantity

[IntegrationEvent(False,False)]
local procedure OnBeforeCalcReservedQuantity(var ItemLedgerEntry: Record "Item Ledger Entry", var IsHandled: Boolean)

Parameters

Name Type Description
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"
IsHandled Boolean

See also