Share via

Value Entry Table

  • Article

Contains all value postings, that is 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

To see the list of fields in this table, change to the Classic view. Choose the Choose View button in the upper-right corner, and then choose Classic.

Field Location
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
Other Duties Amount Field, Value Entry Table Service Tax
Type Field, Value Entry Table Inventory
Description Field, Value Entry Table Inventory
Dimension Set ID Field, Value Entry Table Inventory
Excise Amount Field, Value Entry Table Excise
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
Other Duties Percent Field, Value Entry Table Service Tax
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
Excise Percentage Field, Value Entry Table Excise
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
Assessable Value Field, Value Entry Table India Local Functionality

See Also

Other Resources

Value Entries