Item Ledger Entry #32

Inventory table in Microsoft Dynamics 365 Business Central. 97 fields, 791 records in Cronus demo.

Item Ledger Entry is one of the most important tables in Business Central. It records every physical movement of inventory — purchases, sales, transfers, adjustments, consumption, and output. If an item quantity changed, there is a row here. This is the go-to table for inventory valuation, stock movement analysis, and tracing item history.

COMMON USE CASES

Inventory quantity and valuation reporting
Stock movement tracing and audit
Cost analysis by entry type
Item availability calculations
Warehouse and supply chain analytics

Fields

791

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Entry No..

All fields (97)

Item Ledger Entry — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Entry No. PK	Integer	Normal
2	Item No.	Code	Normal	→ Item #27
3	Posting Date	Date	Normal
4	Entry Type	Option	Normal
5	Source No.	Code	Normal
6	Document No.	Code	Normal
7	Description	Text	Normal
8	Location Code	Code	Normal	→ Location #14
12	Quantity	Decimal	Normal
13	Remaining Quantity	Decimal	Normal
14	Invoiced Quantity	Decimal	Normal
20	Item Register No.	Integer	Normal	→ Item Register #46
21	SIFT Bucket No.	Integer	Normal
28	Applies-to Entry	Integer	Normal
29	Open	Boolean	Normal
33	Global Dimension 1 Code	Code	Normal	→ Dimension Value #349
34	Global Dimension 2 Code	Code	Normal	→ Dimension Value #349
36	Positive	Boolean	Normal
40	Shpt. Method Code	Code	Normal	→ Shipment Method #10
41	Source Type	Option	Normal
47	Drop Shipment	Boolean	Normal
50	Transaction Type	Code	Normal	→ Transaction Type #258
51	Transport Method	Code	Normal	→ Transport Method #259
52	Country/Region Code	Code	Normal	→ Country/Region #9
59	Entry/Exit Point	Code	Normal	→ Entry/Exit Point #282
60	Document Date	Date	Normal
61	External Document No.	Code	Normal
62	Area	Code	Normal	→ Area #284
63	Transaction Specification	Code	Normal	→ Transaction Specification #285
64	No. Series	Code	Normal	→ No. Series #308
70	Reserved Quantity ⚡ FLOW	Decimal	FlowField
79	Document Type	Option	Normal
80	Document Line No.	Integer	Normal
90	Order Type	Option	Normal
91	Order No.	Code	Normal
92	Order Line No.	Integer	Normal
480	Dimension Set ID	Integer	Normal	→ Dimension Set Entry #480
481	Shortcut Dimension 3 Code ⚡ FLOW	Code	FlowField
482	Shortcut Dimension 4 Code ⚡ FLOW	Code	FlowField
483	Shortcut Dimension 5 Code ⚡ FLOW	Code	FlowField
484	Shortcut Dimension 6 Code ⚡ FLOW	Code	FlowField
485	Shortcut Dimension 7 Code ⚡ FLOW	Code	FlowField
486	Shortcut Dimension 8 Code ⚡ FLOW	Code	FlowField
904	Assemble to Order	Boolean	Normal
1000	Project No.	Code	Normal	→ Job #167
1001	Project Task No.	Code	Normal	→ Job Task #1001
1002	Project Purchase	Boolean	Normal
5402	Variant Code	Code	Normal	→ Item Variant #5401
5404	Qty. per Unit of Measure	Decimal	Normal
5407	Unit of Measure Code	Code	Normal	→ Item Unit of Measure #5404
5408	Derived from Blanket Order	Boolean	Normal
5701	Originally Ordered No.	Code	Normal	→ Item #27
5702	Originally Ordered Var. Code	Code	Normal	→ Item Variant #5401
5703	Out-of-Stock Substitution	Boolean	Normal
5704	Item Category Code	Code	Normal	→ Item Category #5722
5705	Catalog	Boolean	Normal
5706	Purchasing Code	Code	Normal	→ Purchasing #5721
5725	Item Reference No.	Code	Normal
5800	Completely Invoiced	Boolean	Normal
5801	Last Invoice Date	Date	Normal
5802	Applied Entry to Adjust	Boolean	Normal
5803	Cost Amount (Expected) ⚡ FLOW	Decimal	FlowField
5804	Cost Amount (Actual) ⚡ FLOW	Decimal	FlowField
5805	Cost Amount (Non-Invtbl.) ⚡ FLOW	Decimal	FlowField
5806	Cost Amount (Expected) (ACY) ⚡ FLOW	Decimal	FlowField
5807	Cost Amount (Actual) (ACY) ⚡ FLOW	Decimal	FlowField
5808	Cost Amount (Non-Invtbl.)(ACY) ⚡ FLOW	Decimal	FlowField
5813	Purchase Amount (Expected) ⚡ FLOW	Decimal	FlowField
5814	Purchase Amount (Actual) ⚡ FLOW	Decimal	FlowField
5815	Sales Amount (Expected) ⚡ FLOW	Decimal	FlowField
5816	Sales Amount (Actual) ⚡ FLOW	Decimal	FlowField
5817	Correction	Boolean	Normal
5818	Shipped Qty. Not Returned	Decimal	Normal
5819	Item Ledger Entry Quantity on Value Entry ⚡ FLOW	Decimal	FlowField
5820	Remaining Quantity by Date ⚡ FLOW	Decimal	FlowField
5821	Date Filter	Date	FlowFilter
5833	Prod. Order Comp. Line No.	Integer	Normal
6210	Sustainability Account No.	Code	Normal	→ Sustainability Account #6210
6211	Sustainability Account Name	Text	Normal
6212	Sustainability Account Category	Code	Normal	→ Sustain. Account Category #6211
6213	Sustainability Account Subcategory	Code	Normal	→ Sustain. Account Subcategory #6212
6219	EPR Fee per Unit	Decimal	Normal
6220	Total EPR Fee	Decimal	Normal
6250	EPR Reported	Boolean	Normal
6500	Serial No.	Code	Normal
6501	Lot No.	Code	Normal
6502	Warranty Date	Date	Normal
6503	Expiration Date	Date	Normal
6510	Item Tracking	Option	Normal
6515	Package No.	Code	Normal
6602	Return Reason Code	Code	Normal	→ Return Reason #6635
6603	Item Description ⚡ FLOW	Text	FlowField
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal