Value Entry Table

Contains all value postings, meaning changes in the inventory value.

Changes in quantity on inventory are stored as quantity postings in the Item Ledger Entry table.

Value entries may also originate in capacity ledger entries, where the work done on the item in the WIP-inventory adds value to the item. These are found in the Capacity Ledger Entry table.

One or more value entries can exist per item ledger entry and per capacity ledger entry.

When the inventory is reconciled with the general ledger, G/L entries are created on the basis of value entries. The amount to be posted to general ledger is calculated from the value entry as:

Cost Amount (Actual)- Cost Posted to G/L. This is done by running the Post Inventory Cost to G/L batch job.

List of Fields in the Table

Field	Location
Other Duties Amount Field, Value Entry Table	Service Tax
BED Amount Field, Value Entry Table	Excise
Other Duties % Field, Value Entry Table	Service Tax
BED % Field, Value Entry Table	Excise
Assessable Value Field, Value Entry Table	India Local Functionality
Source Type Field, Value Entry Table	Inventory
Document No. Field, Value Entry Table	Inventory
Sales Amount (Actual) Field, Value Entry Table	Inventory
Return Reason Code Field, Value Entry Table	Inventory
Global Dimension 1 Code Field, Value Entry Table	Inventory
Valued Quantity Field, Value Entry Table	Inventory
Sales Amount (Expected) Field, Value Entry Table	Inventory
Variant Code Field, Value Entry Table	Inventory
Cost Amount (Actual) (ACY) Field, Value Entry Table	Inventory
Type Field, Value Entry Table	Inventory
Description Field, Value Entry Table	Inventory
Dimension Set ID Field, Value Entry Table	Inventory
Entry No. Field, Value Entry Table	Inventory
Applies-to Entry Field, Value Entry Table	Inventory
Item Ledger Entry No. Field, Value Entry Table	Inventory
Job Ledger Entry No. Field, Value Entry Table	Inventory
Reason Code Field, Value Entry Table	Inventory
Location Code Field, Value Entry Table	Inventory
Drop Shipment Field, Value Entry Table	Inventory
Purchase Amount (Actual) Field, Value Entry Table	Inventory
Order No. Field, Value Entry Table	Inventory
Partial Revaluation Field, Value Entry Table	Inventory
Global Dimension 2 Code Field, Value Entry Table	Inventory
Document Type Field, Value Entry Table	Inventory
Gen. Prod. Posting Group Field, Value Entry Table	Inventory
Cost per Unit Field, Value Entry Table	Inventory
Item Charge No. Field, Value Entry Table	Inventory
Cost Posted to G/L Field, Value Entry Table	Inventory
Inventoriable Field, Value Entry Table	Inventory
External Document No. Field, Value Entry Table	Inventory
Discount Amount Field, Value Entry Table	Inventory
Cost Amount (Expected) Field, Value Entry Table	Inventory
Variance Type Field, Value Entry Table	Inventory
Cost Amount (Non-Invtbl.)(ACY) Field, Value Entry Table	Inventory
User ID Field, Value Entry Table	Inventory
Job No. Field, Value Entry Table	Inventory
Source Posting Group Field, Value Entry Table	Inventory
Job Task No. Field, Value Entry Table	Inventory
Gen. Bus. Posting Group Field, Value Entry Table	Inventory
Cost Posted to G/L (ACY) Field, Value Entry Table	Inventory
Inventory Posting Group Field, Value Entry Table	Inventory
Item Ledger Entry Type Field, Value Entry Table	Inventory
Cost Amount (Expected) (ACY) Field, Value Entry Table	Inventory
Order Line No. Field, Value Entry Table	Inventory
Valued By Average Cost Field, Value Entry Table	Inventory
Cost per Unit (ACY) Field, Value Entry Table	Inventory
Entry Type Field, Value Entry Table	Inventory
Item Ledger Entry Quantity Field, Value Entry Table	Inventory
Order Type Field, Value Entry Table	Inventory
Expected Cost Field, Value Entry Table	Inventory
Exp. Cost Posted to G/L (ACY) Field, Value Entry Table	Inventory
Journal Batch Name Field, Value Entry Table	Inventory
Document Line No. Field, Value Entry Table	Inventory
Posting Date Field, Value Entry Table	Inventory
Invoiced Quantity Field, Value Entry Table	Inventory
Item No. Field, Value Entry Table	Inventory
Salespers./Purch. Code Field, Value Entry Table	Inventory
Document Date Field, Value Entry Table	Inventory
No. Field, Value Entry Table	Inventory
Average Cost Exception Field, Value Entry Table	Inventory
Purchase Amount (Expected) Field, Value Entry Table	Inventory
Expected Cost Posted to G/L Field, Value Entry Table	Inventory
Cost Amount (Non-Invtbl.) Field, Value Entry Table	Inventory
Capacity Ledger Entry No. Field, Value Entry Table	Inventory
Adjustment Field, Value Entry Table	Inventory
Valuation Date Field, Value Entry Table	Inventory
Cost Amount (Actual) Field, Value Entry Table	Inventory
Source Code Field, Value Entry Table	Inventory
Source No. Field, Value Entry Table	Inventory
BED Amount Field, Value Entry Table	India Excise
BED % Field, Value Entry Table	India Excise
Excise Amount Field, Value Entry Table	Excise
Excise Percentage Field, Value Entry Table	Excise

See Also

Reference

Value Entries