Table "Item Ledger Entry"

ID 32

Namespace: Microsoft.Inventory.Ledger

Properties

Name	Value
Caption	Item Ledger Entry
DrillDownPageID	Microsoft.Inventory.Ledger."Item Ledger Entries"
LookupPageID	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"	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
"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"	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"	Microsoft.Inventory.Ledger."Item Ledger Document Type"
"Document Line No."	Integer
"Order Type"	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
"Cross-Reference No."	Code[20]
"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]
"Product Group 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
"Prod. Order Comp. Line No."	Integer
"Serial No."	Code[50]
"Lot No."	Code[50]
"Warranty Date"	Date
"Expiration Date"	Date
"Item Tracking"	Microsoft.Inventory.Tracking."Item Tracking Entry Type"
"Package No."	Code[50]
"Return Reason Code"	Code[10]
SystemId	Guid
SystemCreatedAt	DateTime
SystemCreatedBy	Guid
SystemModifiedAt	DateTime
SystemModifiedBy	Guid
SystemRowVersion	BigInteger

Methods

GetCurrencyCode

procedure GetCurrencyCode(): Code[10]

Returns

Type	Description
Code[10]

GetLastEntryNo

procedure GetLastEntryNo(): Integer

Returns

Type	Description
Integer

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()

AppliedEntryToAdjustExists

Obsolete

This element will become obsolete from version 24.0. Unused

[Obsolete(Unused,24.0)]
procedure AppliedEntryToAdjustExists(ItemNo: Code[20]): Boolean

Parameters

Name	Type	Description
ItemNo	Code[20]

Returns

Type	Description
Boolean

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	Record Item
NetChange	Boolean

FindLinesWithItemToPlan

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

Parameters

Name	Type	Description
Item	Record Item
NetChange	Boolean

Returns

Type	Description
Boolean

LinesWithItemToPlanExist

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

Parameters

Name	Type	Description
Item	Record Item
NetChange	Boolean

Returns

Type	Description
Boolean

FilterLinesForReservation

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

Parameters

Name	Type	Description
ReservationEntry	Record "Reservation Entry"
NewPositive	Boolean

FilterLinesForTracking

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

Parameters

Name	Type	Description
CalcReservEntry	Record "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	Record "Item Journal Line"

CopyTrackingFromNewItemJnlLine

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

Parameters

Name	Type	Description
ItemJnlLine	Record "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	Record "Reservation Entry"

SetReservationFilters

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

Parameters

Name	Type	Description
ReservEntry	Record "Reservation Entry"

SetTrackingFilterFromItemLedgEntry

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

Parameters

Name	Type	Description
ItemLedgEntry	Record "Item Ledger Entry"

SetTrackingFilterFromItemJournalLine

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

Parameters

Name	Type	Description
ItemJournalLine	Record "Item Journal Line"

SetTrackingFilterFromItemTrackingSetup

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

Parameters

Name	Type	Description
ItemTrackingSetup	Record "Item Tracking Setup" temporary

SetTrackingFilterFromItemTrackingSetupIfNotBlank

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

Parameters

Name	Type	Description
ItemTrackingSetup	Record "Item Tracking Setup" temporary

SetTrackingFilterFromItemTrackingSetupIfRequired

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

Parameters

Name	Type	Description
ItemTrackingSetup	Record "Item Tracking Setup" temporary

SetTrackingFilterFromSpec

procedure SetTrackingFilterFromSpec(TrackingSpecification: Record "Tracking Specification")

Parameters

Name	Type	Description
TrackingSpecification	Record "Tracking Specification"

SetTrackingFilterBlank

procedure SetTrackingFilterBlank()

ClearTrackingFilter

procedure ClearTrackingFilter()

TestTrackingEqualToTrackingSpec

procedure TestTrackingEqualToTrackingSpec(TrackingSpecification: Record "Tracking Specification")

Parameters

Name	Type	Description
TrackingSpecification	Record "Tracking Specification"

See also

• Table