Skip to main content
Skip table of contents

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.