Item Ledger Entry Table

Specifies the item ledger entries that are created every time that you post a change to your inventory quantity. This change could be a result of a receipt or shipment of goods, because you post a negative or positive adjustment of quantity or consumption or output due to production.

These inventory records also carry the item's item tracking numbers, which are the serial or lot number,if assigned.

Note

The Item Ledger Entry table only holds information about quantity. All amounts are listed in the Value Entry table.

Item ledger entries are created by the following: the posting of an item journal line; the posting of a sales order, return order, invoice, or credit memo; and the posting of a purchase order, return order, invoice, or credit memo.

Item ledger entries also result from the production of a BOM (bill of materials) in a BOM journal. Before you can create an item entry for the BOM you have produced, the program automatically creates an item entry for each of the component items that comprise the BOM.

For example, if a BOM is a table that consists of four legs and a table top, three item entries will be created: one for the BOM itself, the table (the entry is a positive adjustment because the inventory is increased by one table), and one for each of the items that comprise the table, that is, the table top and the legs (the entries are negative adjustments because the inventory is decreased by one table top and four legs). All three item entries have the same document number.

Finally, the Applied Entry to Adjust field is updated by the Adjust Cost - Item Entries batch job.

Item Tracking

If one of the above types of document lines carries multiple unique item tracking numbers when posted, this will result in one item ledger entry for each item tracking number.

For example, the posting of a line with four pieces each carrying a unique serial number will create four separate item ledger entries. The Item Entry Relation table is used to manage such one-to-many relations during posting and lookup from posted document lines.

List of Fields in the Table

The following table lists the fields in this table.

Field	Location
Originally Ordered No. Field, Item Ledger Entry Table	Inventory
Document No. Field, Item Ledger Entry Table	Inventory
Cost Amount (Expected) (ACY) Field, Item Ledger Entry Table	Inventory
Remaining Quantity Field, Item Ledger Entry Table	Inventory
Order Type Field, Item Ledger Entry Table	Inventory
Correction Field, Item Ledger Entry Table	Inventory
Cost Amount (Actual) Field, Item Ledger Entry Table	Inventory
Subcontr. Purch. Order No. Field, Item Ledger Entry Table	Italy Local Functionality
Drop Shipment Field, Item Ledger Entry Table	Inventory
Other Duties Amount Field, Item Ledger Entry Table	India Excise
Document Type Field, Item Ledger Entry Table	Inventory
Transport Method Field, Item Ledger Entry Table	Inventory
Other Duties % Field, Item Ledger Entry Table	India Excise
Cost Amount (Non-Invtbl.) Field, Item Ledger Entry Table	Inventory
Document Line No. Field, Item Ledger Entry Table	Inventory
Subcontr. Purch. Order Line Field, Item Ledger Entry Table	Italy Local Functionality
Item No. Field, Item Ledger Entry Table	Inventory
Description Field, Item Ledger Entry Table	Inventory
Global Dimension 2 Code Field, Item Ledger Entry Table	Inventory
Area Field, Item Ledger Entry Table	Inventory
Document Date Field, Item Ledger Entry Table	Inventory
Lot No. Field, Item Ledger Entry Table	Inventory
Shipped Qty. Not Returned Field, Item Ledger Entry Table	Inventory
Open Field, Item Ledger Entry Table	Inventory
Last Invoice Date Field, Item Ledger Entry Table	Inventory
DSA Entry No. Field, Item Ledger Entry Table	India Excise
Purchasing Code Field, Item Ledger Entry Table	Inventory
Entry No. Field, Item Ledger Entry Table	Inventory
BED % Field, Item Ledger Entry Table	India Excise
Variant Code Field, Item Ledger Entry Table	Inventory
Serial No. Field, Item Ledger Entry Table	Inventory
BED Amount Field, Item Ledger Entry Table	India Excise
Subcon Order No. Field, Item Ledger Entry Table	India Local Functionality
Cost Amount (Expected) Field, Item Ledger Entry Table	Inventory
No. Series Field, Item Ledger Entry Table	Inventory
Source No. Field, Item Ledger Entry Table	Inventory
Order No. Field, Item Ledger Entry Table	Inventory
Shipment Method Code Field, Item Ledger Entry Table	United Kingdom Local Functionality
Positive Field, Item Ledger Entry Table	Inventory
Job No. Field, Item Ledger Entry Table	Inventory
Shipment Method Code Field, Item Ledger Entry Table	France Local Functionality
Completely Invoiced Field, Item Ledger Entry Table	Inventory
Country/Region Code Field, Item Ledger Entry Table	Inventory
Global Dimension 1 Code Field, Item Ledger Entry Table	Inventory
Sales Amount (Actual) Field, Item Ledger Entry Table	Inventory
Cost Amount (Actual) (ACY) Field, Item Ledger Entry Table	Inventory
Originally Ordered Var. Code Field, Item Ledger Entry Table	Inventory
Re-Dispatch Field, Item Ledger Entry Table	India Excise
External Document No. Field, Item Ledger Entry Table	Inventory
Purchase Amount (Actual) Field, Item Ledger Entry Table	Inventory
Applied Entry to Adjust Field, Item Ledger Entry Table	Inventory
Out-of-Stock Substitution Field, Item Ledger Entry Table	Inventory
Return Reason Code Field, Item Ledger Entry Table	Inventory
Item Category Code Field, Item Ledger Entry Table	Inventory
Shipment Method Code Field, Item Ledger Entry Table	Spain Local Functionality
Reserved Quantity Field, Item Ledger Entry Table	Inventory
Order Line No. Field, Item Ledger Entry Table	Inventory
Qty. per Unit of Measure Field, Item Ledger Entry Table	Inventory
Assemble to Order Field, Item Ledger Entry Table	Inventory
Posting Date Field, Item Ledger Entry Table	Inventory
Captive Consumption Field, Item Ledger Entry Table	India Excise
Sales Amount (Expected) Field, Item Ledger Entry Table	Inventory
Transaction Specification Field, Item Ledger Entry Table	Inventory
Warranty Date Field, Item Ledger Entry Table	Inventory
Nature of Disposal Field, Item Ledger Entry Table	India Local Functionality
Location Code Field, Item Ledger Entry Table	Inventory
Purchase Amount (Expected) Field, Item Ledger Entry Table	Inventory
Unit of Measure Code Field, Item Ledger Entry Table	Inventory
Laboratory Test Field, Item Ledger Entry Table	India Local Functionality
Prod. Order Comp. Line No. Field, Item Ledger Entry Table	Inventory
Job Task No. Field, Item Ledger Entry Table	Inventory
Applies-to Entry Field, Item Ledger Entry Table	Inventory
Cross-Reference No. Field, Item Ledger Entry Table	Inventory
Expiration Date Field, Item Ledger Entry Table	Inventory
Entry/Exit Point Field, Item Ledger Entry Table	Inventory
Entry Type Field, Item Ledger Entry Table	Inventory
Quantity Field, Item Ledger Entry Table	Inventory
Nonstock Field, Item Ledger Entry Table	Inventory
Cost Amount (Non-Invtbl.)(ACY) Field, Item Ledger Entry Table	Inventory
Job Purchase Field, Item Ledger Entry Table	Inventory
Product Group Code Field, Item Ledger Entry Table	Inventory
Derived from Blanket Order Field, Item Ledger Entry Table	Inventory
Type of Disposal Field, Item Ledger Entry Table	India Local Functionality
Assessable Value Field, Item Ledger Entry Table	India Local Functionality
Other Usage Field, Item Ledger Entry Table	India Local Functionality
Reason Code Field, Item Ledger Entry Table	India Local Functionality
Country/Region of Origin Code Field, Item Ledger Entry Table	Deleted Topics
Depreciation Book Code Field, Item Ledger Entry Table	Russia Local Functionality
CD No. Field, Item Ledger Entry Table	Russia Local Functionality
FA No. Field, Item Ledger Entry Table	Russia Local Functionality
CD Line No. Field, Item Ledger Entry Table	Deleted Topics
FA Entry No. Field, Item Ledger Entry Table	Russia Local Functionality
Customer No. Field, Item Ledger Entry Table	Switzerland Local Functionality
Ship-to Address Code Field, Item Ledger Entry Table	Switzerland Local Functionality
Customer Salesperson Code Field, Item Ledger Entry Table	Switzerland Local Functionality
Depreciation Book Code Field, Item Ledger Entry Table	Russia Local Functionality
CD No. Field, Item Ledger Entry Table	Russia Local Functionality
FA No. Field, Item Ledger Entry Table	Russia Local Functionality
FA Entry No. Field, Item Ledger Entry Table	Russia Local Functionality
Transaction Type Field, Item Ledger Entry Table	Inventory
Invoiced Quantity Field, Item Ledger Entry Table	Inventory
Item Tracking Field, Item Ledger Entry Table	Inventory
Dimension Set ID Field, Item Ledger Entry Table	Inventory
Source Type Field, Item Ledger Entry Table	Inventory
Originally Ordered No. Field, Item Ledger Entry Table	Inventory
Document No. Field, Item Ledger Entry Table	Inventory
Cost Amount (Expected) (ACY) Field, Item Ledger Entry Table	Inventory
Transaction Type Field, Item Ledger Entry Table	Inventory
Remaining Quantity Field, Item Ledger Entry Table	Inventory
Order Type Field, Item Ledger Entry Table	Inventory
Correction Field, Item Ledger Entry Table	Inventory
Cost Amount (Actual) Field, Item Ledger Entry Table	Inventory
Drop Shipment Field, Item Ledger Entry Table	Inventory
Document Type Field, Item Ledger Entry Table	Inventory
Transport Method Field, Item Ledger Entry Table	Inventory
Cost Amount (Non-Invtbl.) Field, Item Ledger Entry Table	Inventory
Document Line No. Field, Item Ledger Entry Table	Inventory
Item No. Field, Item Ledger Entry Table	Inventory
Description Field, Item Ledger Entry Table	Inventory
Global Dimension 2 Code Field, Item Ledger Entry Table	Inventory
Area Field, Item Ledger Entry Table	Inventory
Document Date Field, Item Ledger Entry Table	Inventory
Lot No. Field, Item Ledger Entry Table	Inventory
Shipped Qty. Not Returned Field, Item Ledger Entry Table	Inventory
Open Field, Item Ledger Entry Table	Inventory
Last Invoice Date Field, Item Ledger Entry Table	Inventory
Purchasing Code Field, Item Ledger Entry Table	Inventory
Entry No. Field, Item Ledger Entry Table	Inventory
Variant Code Field, Item Ledger Entry Table	Inventory
Serial No. Field, Item Ledger Entry Table	Inventory
Cost Amount (Expected) Field, Item Ledger Entry Table	Inventory
No. Series Field, Item Ledger Entry Table	Inventory
Source No. Field, Item Ledger Entry Table	Inventory
Order No. Field, Item Ledger Entry Table	Inventory
Invoiced Quantity Field, Item Ledger Entry Table	Inventory
Positive Field, Item Ledger Entry Table	Inventory
Job No. Field, Item Ledger Entry Table	Inventory
Completely Invoiced Field, Item Ledger Entry Table	Inventory
Country/Region Code Field, Item Ledger Entry Table	Inventory
Global Dimension 1 Code Field, Item Ledger Entry Table	Inventory
Sales Amount (Actual) Field, Item Ledger Entry Table	Inventory
Cost Amount (Actual) (ACY) Field, Item Ledger Entry Table	Inventory
Originally Ordered Var. Code Field, Item Ledger Entry Table	Inventory
External Document No. Field, Item Ledger Entry Table	Inventory
Purchase Amount (Actual) Field, Item Ledger Entry Table	Inventory
Applied Entry to Adjust Field, Item Ledger Entry Table	Inventory
Out-of-Stock Substitution Field, Item Ledger Entry Table	Inventory
Item Tracking Field, Item Ledger Entry Table	Inventory
Return Reason Code Field, Item Ledger Entry Table	Inventory
Item Category Code Field, Item Ledger Entry Table	Inventory
Reserved Quantity Field, Item Ledger Entry Table	Inventory
Order Line No. Field, Item Ledger Entry Table	Inventory
Qty. per Unit of Measure Field, Item Ledger Entry Table	Inventory
Dimension Set ID Field, Item Ledger Entry Table	Inventory
Source Type Field, Item Ledger Entry Table	Inventory
Assemble to Order Field, Item Ledger Entry Table	Inventory
Posting Date Field, Item Ledger Entry Table	Inventory
Sales Amount (Expected) Field, Item Ledger Entry Table	Inventory
Transaction Specification Field, Item Ledger Entry Table	Inventory
Warranty Date Field, Item Ledger Entry Table	Inventory
Location Code Field, Item Ledger Entry Table	Inventory
Purchase Amount (Expected) Field, Item Ledger Entry Table	Inventory
Unit of Measure Code Field, Item Ledger Entry Table	Inventory
Prod. Order Comp. Line No. Field, Item Ledger Entry Table	Inventory
Job Task No. Field, Item Ledger Entry Table	Inventory
Applies-to Entry Field, Item Ledger Entry Table	Inventory
Cross-Reference No. Field, Item Ledger Entry Table	Inventory
Expiration Date Field, Item Ledger Entry Table	Inventory
Entry/Exit Point Field, Item Ledger Entry Table	Inventory
Entry Type Field, Item Ledger Entry Table	Inventory
Quantity Field, Item Ledger Entry Table	Inventory
Nonstock Field, Item Ledger Entry Table	Inventory
Cost Amount (Non-Invtbl.)(ACY) Field, Item Ledger Entry Table	Inventory
Job Purchase Field, Item Ledger Entry Table	Inventory
Product Group Code Field, Item Ledger Entry Table	Inventory
Derived from Blanket Order Field, Item Ledger Entry Table	Inventory
Shipment Method Code Field, Item Ledger Entry Table	France Local Functionality
Shipment Method Code Field, Item Ledger Entry Table	United Kingdom Local Functionality
Subcontr. Purch. Order No. Field, Item Ledger Entry Table	Italy Local Functionality
Subcontr. Purch. Order Line Field, Item Ledger Entry Table	Italy Local Functionality
Shipment Method Code Field, Item Ledger Entry Table	Spain Local Functionality
Depreciation Book Code Field, Item Ledger Entry Table	Russia Local Functionality
CD No. Field, Item Ledger Entry Table	Russia Local Functionality
FA No. Field, Item Ledger Entry Table	Russia Local Functionality
FA Entry No. Field, Item Ledger Entry Table	Russia Local Functionality
Customer No. Field, Item Ledger Entry Table	Switzerland Local Functionality
Ship-to Address Code Field, Item Ledger Entry Table	Switzerland Local Functionality
Customer Salesperson Code Field, Item Ledger Entry Table	Switzerland Local Functionality

See Also

Reference

Item Ledger Entries