Value Entry #5802

Ledger Entries table in Microsoft Dynamics 365 Business Central. 84 fields, 791 records in Cronus demo.

Value Entry tracks the financial value of every inventory movement in Business Central. While Item Ledger Entry (table 32) records quantities, Value Entry records the cost amounts — direct cost, revaluation, rounding, indirect cost, and variance. It is essential for inventory valuation and COGS analysis.

COMMON USE CASES

Inventory cost tracking and valuation
Cost adjustment and revaluation
COGS and margin analysis
Expected vs. actual cost comparison
Cost variance reporting

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

Value 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	Item Ledger 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
9	Inventory Posting Group	Code	Normal	→ Inventory Posting Group #94
10	Source Posting Group	Code	Normal
11	Item Ledger Entry No.	Integer	Normal	→ Item Ledger Entry #32
12	Valued Quantity	Decimal	Normal
13	Item Ledger Entry Quantity	Decimal	Normal
14	Invoiced Quantity	Decimal	Normal
15	Cost per Unit	Decimal	Normal
17	Sales Amount (Actual)	Decimal	Normal
20	Item Register No.	Integer	Normal	→ Item Register #46
21	SIFT Bucket No.	Integer	Normal
22	Salespers./Purch. Code	Code	Normal	→ Salesperson/Purchaser #13
23	Discount Amount	Decimal	Normal
24	User ID	Code	Normal
25	Source Code	Code	Normal	→ Source Code #230
28	Applies-to Entry	Integer	Normal
33	Global Dimension 1 Code	Code	Normal	→ Dimension Value #349
34	Global Dimension 2 Code	Code	Normal	→ Dimension Value #349
41	Source Type	Option	Normal
43	Cost Amount (Actual)	Decimal	Normal
45	Cost Posted to G/L	Decimal	Normal
46	Reason Code	Code	Normal	→ Reason Code #231
47	Drop Shipment	Boolean	Normal
48	Journal Batch Name	Code	Normal
57	Gen. Bus. Posting Group	Code	Normal	→ Gen. Business Posting Group #250
58	Gen. Prod. Posting Group	Code	Normal	→ Gen. Product Posting Group #251
60	Document Date	Date	Normal
61	External Document No.	Code	Normal
68	Cost Amount (Actual) (ACY)	Decimal	Normal
70	Cost Posted to G/L (ACY)	Decimal	Normal
72	Cost per Unit (ACY)	Decimal	Normal
79	Document Type	Option	Normal
80	Document Line No.	Integer	Normal
86	VAT Date	Date	Normal
90	Order Type	Option	Normal
91	Order No.	Code	Normal
92	Order Line No.	Integer	Normal
98	Expected Cost	Boolean	Normal
99	Item Charge No.	Code	Normal	→ Item Charge #5800
100	Valued By Average Cost	Boolean	Normal
102	Partial Revaluation	Boolean	Normal
103	Inventoriable	Boolean	Normal
104	Valuation Date	Date	Normal
105	Entry Type	Option	Normal
106	Variance Type	Option	Normal
148	Purchase Amount (Actual)	Decimal	Normal
149	Purchase Amount (Expected)	Decimal	Normal
150	Sales Amount (Expected)	Decimal	Normal
151	Cost Amount (Expected)	Decimal	Normal
152	Cost Amount (Non-Invtbl.)	Decimal	Normal
156	Cost Amount (Expected) (ACY)	Decimal	Normal
157	Cost Amount (Non-Invtbl.)(ACY)	Decimal	Normal
158	Expected Cost Posted to G/L	Decimal	Normal
159	Exp. Cost Posted to G/L (ACY)	Decimal	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
1000	Project No.	Code	Normal	→ Job #167
1001	Project Task No.	Code	Normal	→ Job Task #1001
1002	Project Ledger Entry No.	Integer	Normal	→ Job Ledger Entry #169
5402	Variant Code	Code	Normal	→ Item Variant #5401
5818	Adjustment	Boolean	Normal
5819	Average Cost Exception	Boolean	Normal
5831	Capacity Ledger Entry No.	Integer	Normal	→ Capacity Ledger Entry #5832
5832	Type	Option	Normal
5834	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