Item Ledger Entry

Item Ledger Entry table holds information about quantity of an Item. Amount is not stored in this table. All Amounts are stored in the Value Entries table. The Amount related field in Item Ledger Table will flowfield to Value Entries table to get the Amounts value.

Item Leger Entry are created when you:

1. Post Item Journal Line
2. Post Sales Order
3. Post Sales Return Order
4. Post Sales Invoice
5. Post Sales Credit Memo
6. Post Purchase Orer
7. Post Purchase Return Order
8. Post Purchase Invoice
9. Post Purchase Credit Memo
10. Post BOM Journal

Item Ledger Entry table

Please take notes on the following important fields in Item Ledger Entry table:

Source Document
- Show when the entry is originated.
- Empty: if posted from Item Journal Line
- buy-from vendor number: entry is purchase related
- sell-to customer number: entry is sale related
- BOM number: entry originated from production of BOM

Remaining Quantity
- Shows the quantity remains in the inventory if this is an increase entry (purchase, positive adj)
- Shows the quantity remains to be applied if this in an decrease entry (sales, negative adj)

Open
- Shows whether the entry has been fully applied to.

Correction
- Indicates whether this is a corrective entry.

Primary Key for table Item Ledger Entry

The Primary Key for the Item Ledger Entry table is the Entry No.