Item Ledger Entry
Field Label | Field Level Help | |
Account | The Account associated with the entry. | |
Allocated Qty. Base | Allocated Qty. converted to the Item’s Base Unit of Measure. | |
Available Qty. Base | Remaining Qty. Base – Allocated Qty. Base | |
Initial Bin | This field is used to populate the initial Warehouse Entry’s Bin field. The current Bin of the inventory could be different due to movements. | |
Initial Bin Content | This field is used to populate the initial Warehouse Entry’s Bin Content field. The current Bin Content of the inventory could be different due to movements. | |
Conversion | The conversion factor of the Unit of Measure on the Item Ledger Entry to the Item’s Base Unit of Measure. | |
Correction | Indicates if the entry is a Correction. | |
Description | The Item Ledger Entry Description. | |
Document No. | The Document No. associated with the entry. | |
Document Type | The type of document that created the entry. Possible values: Shipment, Receipt, Transfer, Adjustment, Consumption, Output, or Sales Invoice. | |
Expected Cost | Sum of the Expected Cost field on all associated Cost Entries. | |
From Entry | The Item Ledger Entry from which this entry was created. | |
GL Ledger | GL Ledger for the transaction. The default is blank. | |
Invoiced Cost | Sum of the Invoiced Cost field on all associated Cost Entries. | |
Invoiced Qty. Base | Sum of the Invoiced Qty. Base field on all associated Cost Entries. | |
Item | The Item associated with the entry. | |
Item Allocation | The Item Allocation record associated with the entry. | |
Item Allocation Id | The record ID of the Item Allocation associated with this Item Ledger Entry. It is used when the Whse Shipment is unposted and the Item Allocation is recreated. | |
Item Journal | The Item Journal that created the entry. | |
Item Journal Line | The specific Item Journal Line that created the entry. | |
Item Lot | The Lot No. of the Item associated with the entry. | |
Material Variance | The total cost of the Cost Entries where the variance type is Material. | |
Original Assigned Cost | Used to calculate landed cost assignment to receipts. | |
Original Cost | The original Unit Cost of the entry. | |
Original Expected Cost | The original cost yet to be posted to the GL. | |
Outside Service | Indicates if the Item comes from an Outside Service. Defined on the Item record. | |
Pending Application | Indicates if the entry has been applied. | |
Pending Cost Adj. | Indicates if Adjustment Cost Entries have be posted to the GL. | |
Posting Date | The Date the entry was posted to the GL. | |
Processed by Item Usage | Indicates if the entry was processed to update Item usage. | |
Qty. Base | Quantity converted to the Item’s Base Unit of Measure. | |
Quantity | The original Quantity of the Item Ledger Entry. | |
Reason | The Reason Code for the Item Ledger Entry. Possible values: Count Error, Receipt Error, Breakages, or Scrap. | |
Remaining Qty. Base | Qty. Base left for the item ledger entry to be used. | |
Rental | The Rental Record associated with the Item Ledger Entry. | |
Sales Invoice | The Sales Invoice associated with the Item Ledger Entry. | |
Sales Invoice Line | The specific Sales Invoice Line associated with the Item Ledger Entry. | |
Serial No. | The Serial No. of the Item associated with the entry. | |
Total Assigned Cost | Total cost assigned from various landed costs | |
Total Cost | Expected Cost + Invoiced Cost | |
Tracking Line | The Tracking Line associated with the entry. | |
Unit Cost | Total Cost / Qty. Base | |
Unit of Measure | The Item Unit of Measure of the entry. | |
Vendor Lead Time | Posting Date - Order Date (of the associated Purchase Order), for Document Type = Receipt. | |
Warehouse | The Warehouse adjusted as a result of the entry. | |
Whse Receipt | The Whse. Receipt No. associated with the entry. | |
Whse Receipt Line | The specific Whse. Receipt Line associated with the entry. | |
Whse Shipment | The Whse. Shipment No. associated with the entry. | |
Whse Shipment Line | The specific Whse. Shipment Line associated with the entry. | |
Work Center | Indicates that the Item is a Work Center Item. Defined on the Item record. | |
Work Line | The specific Work Line associated with the entry. | |
Work Order | The Work Order No. associated with the entry. |