Page 38 "Item Ledger Entries"

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

Properties

Property	Value
Caption	Item Ledger Entries
SourceTable	Item Ledger Entry
PageType	List
UsageCategory	History
ApplicationArea	Basic, Suite

Fields on this page

Layout controls in source order, grouped by the container they sit in. Shows: the table field a control is bound to (or its expression as written); ToolTip: the control’s own, else the bound field’s (marked).

Group	Control	Shows	ToolTip
Control1	Posting Date	Posting Date	Specifies the posting date for the entry.
	Entry Type	Entry Type	Specifies which type of transaction that the entry is created from. from the table field
	Document Type	Document Type	Specifies what type of document was posted to create the item ledger entry. from the table field
	Document No.	Document No.	Specifies the document number on the entry. The document is the voucher that the entry was based on, for example, a receipt. from the table field
	Document Line No.	Document Line No.	Specifies the number of the line on the posted document that corresponds to the item ledger entry. from the table field
	Item No.	Item No.	Specifies the number of the item in the entry. from the table field
	Item Description	Item Description	Specifies the description of the item in the entry. Analysis mode must be used for sorting and filtering on this field. from the table field
	Variant Code	Variant Code	Specifies the variant of the item on the line. from the table field
	Description	Description	Specifies a description of the entry. from the table field
	Return Reason Code	Return Reason Code	Specifies the code explaining why the item was returned. from the table field
	Global Dimension 1 Code	Global Dimension 1 Code	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. from the table field
	Global Dimension 2 Code	Global Dimension 2 Code	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. from the table field
	Expiration Date	Expiration Date	Specifies the last date that the item on the line can be used. from the table field
	Serial No.	Serial No.	Specifies a serial number if the posted item carries such a number. from the table field
	Lot No.	Lot No.	Specifies a lot number if the posted item carries such a number. from the table field
	Package No.	Package No.	Specifies a package number if the posted item carries such a number. from the table field
	Location Code	Location Code	Specifies the code for the location that the entry is linked to. from the table field
	Quantity	Quantity	Specifies the number of units of the item in the item entry. from the table field
	Inventory	`CalcRunningInvBalance.GetItemBalance(Rec)`	Specifies the inventory at date including this entry.
	Inventory by Location	`CalcRunningInvBalance.GetItemBalanceLoc(Rec)`	Specifies the inventory at date including this entry, for this location.
	Invoiced Quantity	Invoiced Quantity	Specifies how many units of the item on the line have been invoiced. from the table field
	Remaining Quantity	Remaining Quantity	Specifies the quantity in the Quantity field that remains to be processed. from the table field
	Remaining Qty. by Date	Remaining Qty. by Date	Specifies the remaining quantity for the item ledger entry as of the date specified in the Date Filter field. from the table field
	Shipped Qty. Not Returned	Shipped Qty. Not Returned	Specifies the quantity for this item ledger entry that was shipped and has not yet been returned. from the table field
	Reserved Quantity	Reserved Quantity	Specifies how many units of the item on the line have been reserved. from the table field
	Qty. per Unit of Measure	Qty. per Unit of Measure	Specifies the quantity per item unit of measure. from the table field
	Unit of Measure Code	Unit of Measure Code	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. from the table field
	Sales Amount (Expected)	Sales Amount (Expected)	Specifies the expected sales amount, in LCY.
	Sales Amount (Actual)	Sales Amount (Actual)	Specifies the sales amount, in LCY.
	Cost Amount (Expected)	Cost Amount (Expected)	Specifies the expected cost, in LCY, of the quantity posting.
	Cost Amount (Actual)	Cost Amount (Actual)	Specifies the adjusted cost, in LCY, of the quantity posting.
	Cost Amount (Non-Invtbl.)	Cost Amount (Non-Invtbl.)	Specifies the adjusted non-inventoriable cost, that is an item charge assigned to an outbound entry.
	Cost Amount (Expected) (ACY)	Cost Amount (Expected) (ACY)	Specifies the expected cost, in ACY, of the quantity posting.
	Cost Amount (Actual) (ACY)	Cost Amount (Actual) (ACY)	Specifies the adjusted cost of the entry, in the additional reporting currency.
	Cost Amount (Non-Invtbl.)(ACY)	Cost Amount (Non-Invtbl.)(ACY)	Specifies the adjusted non-inventoriable cost, that is, an item charge assigned to an outbound entry in the additional reporting currency.
	Completely Invoiced	Completely Invoiced	Specifies if the entry has been fully invoiced or if more posted invoices are expected. Only completely invoiced entries can be revalued. from the table field
	Open	Open	Specifies whether the entry has been fully applied to. from the table field
	Drop Shipment	Drop Shipment	Specifies if your vendor ships the items directly to your customer. from the table field
	Assemble to Order	Assemble to Order	Specifies if the posting represents an assemble-to-order sale. from the table field
	Applied Entry to Adjust	Applied Entry to Adjust	Specifies whether there is one or more applied entries, which need to be adjusted. from the table field
	Order Type	Order Type	Specifies which type of order that the entry was created in. from the table field
	Order No.	Order No.	Specifies the number of the order that created the entry. from the table field
	Order Line No.	Order Line No.	Specifies the line number of the order that created the entry. from the table field
	Prod. Order Comp. Line No.	Prod. Order Comp. Line No.	Specifies the line number of the production order component. from the table field
	Entry No.	Entry No.	Specifies the number of the entry, as assigned from the specified number series when the entry was created. from the table field
	Job No.	Job No.	Specifies the number of the related project. from the table field
	Job Task No.	Job Task No.	Specifies the number of the related project task. from the table field
	Dimension Set ID	Dimension Set ID	Specifies a reference to a combination of dimension values. The actual values are stored in the Dimension Set Entry table. from the table field
	Shortcut Dimension 3 Code	Shortcut Dimension 3 Code	Specifies the code for Shortcut Dimension 3, which is one of dimension codes that you set up in the General Ledger Setup window. from the table field
	Shortcut Dimension 4 Code	Shortcut Dimension 4 Code	Specifies the code for Shortcut Dimension 4, which is one of dimension codes that you set up in the General Ledger Setup window. from the table field
	Shortcut Dimension 5 Code	Shortcut Dimension 5 Code	Specifies the code for Shortcut Dimension 5, which is one of dimension codes that you set up in the General Ledger Setup window. from the table field
	Shortcut Dimension 6 Code	Shortcut Dimension 6 Code	Specifies the code for Shortcut Dimension 6, which is one of dimension codes that you set up in the General Ledger Setup window. from the table field
	Shortcut Dimension 7 Code	Shortcut Dimension 7 Code	Specifies the code for Shortcut Dimension 7, which is one of dimension codes that you set up in the General Ledger Setup window. from the table field
	Shortcut Dimension 8 Code	Shortcut Dimension 8 Code	Specifies the code for Shortcut Dimension 8, which is one of dimension codes that you set up in the General Ledger Setup window. from the table field
	Source Type	Source Type	Shows the source type that applies to the source number that is shown in the Source No. field. If the entry was posted from an item journal line, the field is blank. If posted from a sales line, the source type is Customer. If posted from a purchase line, the source type is Vendor. If the entry resu…
	Source No.	Source No.	Shows where the entry originated. If the entry was posted from an item journal line, the field will be empty. If the entry was posted from an purchase order, purchase invoice or purchase credit memo, the field displays the buy-from vendor number. If it is posted from sales the sell-to customer numbe…
	Source Description	`InventoryLedgerSourceMgt.GetSourceDescription(Rec."Source Type", Rec."Source No.")`	Specifies the name or description of the source. Analysis mode must be used for sorting and filtering on this field.
	Source Order No.	`InventoryLedgerSourceMgt.GetSourceOrderNo(Rec."Document Type", Rec."Document No.")`	Specifies the order number of the source document this entry is associated with. Analysis mode must be used for sorting and filtering on this field.

Actions

Group	Action	ToolTip	Runs
Entry	Dimensions	View or edit dimensions, such as area, project, or department, that you can assign to sales and purchase documents to distribute costs and analyze transaction history.
	Set Dimension Filter	Limit the entries according to the dimension filters that you specify. NOTE: If you use a high number of dimension combinations, this function may not work and can result in a message that the SQL server only supports a maximum of 2100 parameters.
	Value Entries	View the history of posted amounts that affect the value of the item. Value entries are created for every transaction with the item.	Page 5802 “Value Entries”
Application	Applied Entries	View the ledger entries that have been applied to this record.
	Reservation Entries	View the entries for every reservation that is made, either manually or automatically.
	Application Worksheet	View item applications that are automatically created between item ledger entries during item transactions.
	Item Application Entries	View the item application entries that are created when you post item transactions.
	Mark for adjustment	Mark that it is necessary to run the cost adjustment for the selected item ledger entries.
Functions	Order Tracking	Tracks the connection of a supply to its corresponding demand. This can help you find the original demand that created a specific production order or purchase order.
Processing	Find entries…	Find entries and documents that exist for the document number and posting date on the selected document. (Formerly this action was named Navigate.)

Events published

OnBeforeGetCaption(var ItemLedgerEntry: Record "Item Ledger Entry"; var Result: Text; var IsHandled: Boolean) (integration)
OnBeforeOpenPage() (integration)

Procedures

ShowCostAdjustmentActions() + BC24

Plus 3 local procedures.

Triggers

OnOpenPage

Relations

source table Table 32 “Item Ledger Entry”

Pages and codeunits on this table

Table 32 “Item Ledger Entry” (drill-down page)
Table 32 “Item Ledger Entry” (lookup page)

Extended by

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: SetDimVisibility → UseShortcutDims)
Codeunit 5806 “Item Ledger Entry-Edit” (1 call: SetAppliedEntriesToAdjust → SetAppliedEntriesToAdjust)

Called by

Codeunit 1317 “Aged Inventory Chart Mgt.” (1 call: DrillDownItemLedgerEntries → (object))
Codeunit 245 “Item Reg.-Show Ledger” (1 call: OnRun → (object))
Codeunit 5530 “Calc. Item Availability” (1 call: ShowDocument → (object))
Codeunit 6520 “Item Tracing Mgt.” (1 call: ShowDocument → (object))
Codeunit 99000841 “Item Ledger Entry-Reserve” (1 call: ShowSourceLines → (object))
Table 210 “Job Journal Line” (1 call: SelectItemEntry → (object))
Table 37 “Sales Line” (1 call: SelectItemEntry → (object))
Table 39 “Purchase Line” (1 call: SelectItemEntry → (object))
Table 5741 “Transfer Line” (1 call: SelectItemEntry → (object))
Table 5851 “Invt. Document Line” (1 call: SelectItemEntry → (object))
Table 5902 “Service Line” (1 call: SelectItemEntry → (object))
Table 83 “Item Journal Line” (1 call: SelectItemEntry → (object))
Table 901 “Assembly Line” (1 call: SelectItemEntry → (object))

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