Share via


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