Item Journal Line Table

Specifies the various journals in the Inventory application area.

In an item journal, you can adjust inventory in connection with purchases, sales, and positive and negative adjustments. To insert lines in the item journal, click the first empty line and fill in the fields.

When the journal is filled in, you can choose to post, post and print a report, or print a test report only.

When you choose a journal, the program displays the most recently used item journal batch. If you want to use another item journal batch, choose the Name field. The Item Journal Batch List appears. Here you can choose from among the existing journal batches or create new ones.

It is possible to create three levels under an item journal menu item: Item Journal Templates, Item Journal Batch and Item Journal Lines. This lets you use different journals that are suited to different tasks. You can have several journals of the same type; for example, every employee can have their own journal.

This is a special window in which you can enter items that will be posted regularly. You need to type entries in only once, and you can post the same information as often as you want.

Note

Inventory accounts in the general ledger are not updated when you post from an item journal. To update them, you must use the Post Inventory Cost to G/L batch job. Before you do that, it is a good idea to run the Adjust Cost - Item Entries batch job.

List of Fields in the Table

Field	Location
Applies-to Entry (RG 23 D) Field, Item Journal Line Table	Excise
WIP Quantity Field, Item Journal Line Table	Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Other Duties % Field, Item Journal Line Table	Service Tax
RG23PartII Entry No. Field, Item Journal Line Table	Excise
Reverse Excise Field, Item Journal Line Table	Excise
Other Duties Amount Field, Item Journal Line Table	Service Tax
Re-Dispatch Field, Item Journal Line Table	Excise
RG Line No. Field, Item Journal Line Table	Excise
RG Correction Type Field, Item Journal Line Table	Excise
Shipment Method Code Field, Item Journal Line Table	Spain Local Functionality
Excise Record Field, Item Journal Line Table	Excise
Subcontr. Purch. Order No. Field, Item Journal Line Table	Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Shipment Method Code Field, Item Journal Line Table	United Kingdom Local Functionality
Shipment Method Code Field, Item Journal Line Table	France Local Functionality
Subcontr. Purch. Order Line Field, Item Journal Line Table	Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Rcpt. Posting Field, Item Journal Line Table	India Local Functionality
BED Amount Field, Item Journal Line Table	Excise
Entry Type Field, Item Journal Line Table	Spain Local Functionality
Return Field, Item Journal Line Table	Excise
WIP Item Field, Item Journal Line Table	Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Pmt. Discount Amount Field, Item Journal Line Table	Spain Local Functionality
Excise Entry Field, Item Journal Line Table	Excise
RG23PartI Entry No. Field, Item Journal Line Table	Excise
Nature of Disposal Field, Item Journal Line Table	India Local Functionality
BED % Field, Item Journal Line Table	Excise
From Transfer Order Field, Item Journal Line Table	India Local Functionality
Laboratory Test Field, Item Journal Line Table	India Local Functionality
Captive Consumption Field, Item Journal Line Table	India Local Functionality
Phys Invt Counting Period Type Field, Item Journal Line Table	Warehouse Management Systems
Subcon Order No. Field, Item Journal Line Table	India Local Functionality
Phys Invt Counting Period Code Field, Item Journal Line Table	Warehouse Management Systems
Transfer Cost Field, Item Journal Line Table	India Local Functionality
PO/SO Line No. Field, Item Journal Line Table	India Local Functionality
Assessable Value Field, Item Journal Line Table	India Local Functionality
Other Usage Field, Item Journal Line Table	India Local Functionality
Type of Disposal Field, Item Journal Line Table	India Local Functionality
Discount Amount Field, Item Journal Line Table	Inventory
Rolled-up Subcontracted Cost Field, Item Journal Line Table	Inventory
Amount Field, Item Journal Line Table	Inventory
Posting Date Field, Item Journal Line Table	Inventory
Item Shpt. Entry No. Field, Item Journal Line Table	Inventory
Item Category Code Field, Item Journal Line Table	Inventory
Partial Revaluation Field, Item Journal Line Table	Inventory
Job Contract Entry No. Field, Item Journal Line Table	Inventory
Stop Code Field, Item Journal Line Table	Inventory
Correction Field, Item Journal Line Table	Inventory
Transport Method Field, Item Journal Line Table	Inventory
Drop Shipment Field, Item Journal Line Table	Inventory
Run Time Field, Item Journal Line Table	Inventory
Unit Cost (Revalued) Field, Item Journal Line Table	Inventory
Qty. (Calculated) Field, Item Journal Line Table	Inventory
Update Standard Cost Field, Item Journal Line Table	Inventory
Scrap Quantity (Base) Field, Item Journal Line Table	Inventory
Rolled-up Capacity Cost Field, Item Journal Line Table	Manufacturing
Unit Cost Field, Item Journal Line Table	Inventory
Cross-Reference No. Field, Item Journal Line Table	Inventory
Finished Field, Item Journal Line Table	Inventory
New Serial No. Field, Item Journal Line Table	Inventory
Transaction Specification Field, Item Journal Line Table	Inventory
Country/Region Code Field, Item Journal Line Table	Inventory
Order Date Field, Item Journal Line Table	Inventory
Single-Level Subcontrd. Cost Field, Item Journal Line Table	Inventory
Originally Ordered No. Field, Item Journal Line Table	Inventory
Rolled-up Material Cost Field, Item Journal Line Table	Manufacturing
Gen. Prod. Posting Group Field, Item Journal Line Table	Inventory
Output Quantity (Base) Field, Item Journal Line Table	Inventory
Description Field, Item Journal Line Table	Inventory
Purchasing Code Field, Item Journal Line Table	Inventory
Derived from Blanket Order Field, Item Journal Line Table	Inventory
Location Code Field, Item Journal Line Table	Inventory
Item Charge No. Field, Item Journal Line Table	Inventory
Serial No. Field, Item Journal Line Table	Inventory
Order No. Field, Item Journal Line Table	Inventory
New Lot No. Field, Item Journal Line Table	Inventory
Invoiced Quantity Field, Item Journal Line Table	Inventory
Return Reason Code Field, Item Journal Line Table	Inventory
Line No. Field, Item Journal Line Table	Inventory
Posting No. Series Field, Item Journal Line Table	Inventory
Unit Cost (ACY) Field, Item Journal Line Table	Inventory
Changed by User Field, Item Journal Line Table	Manufacturing
Scrap Quantity Field, Item Journal Line Table	Inventory
Flushing Method Field, Item Journal Line Table	Manufacturing
Order Type Field, Item Journal Line Table	Inventory
Unit Cost Calculation Field, Item Journal Line Table	Inventory
Inventory Value (Calculated) Field, Item Journal Line Table	Inventory
Assemble to Order Field, Item Journal Line Table	Inventory
Source No. Field, Item Journal Line Table	Inventory
Variant Code Field, Item Journal Line Table	Inventory
Journal Batch Name Field, Item Journal Line Table	Inventory
Type Field, Item Journal Line Table	Inventory
Stop Time (Base) Field, Item Journal Line Table	Inventory
Transaction Type Field, Item Journal Line Table	Inventory
Value Entry Type Field, Item Journal Line Table	Inventory
Setup Time Field, Item Journal Line Table	Inventory
Indirect Cost % Field, Item Journal Line Table	Inventory
Stop Time Field, Item Journal Line Table	Inventory
Journal Template Name Field, Item Journal Line Table	Inventory
Amount (ACY) Field, Item Journal Line Table	Inventory
New Location Code Field, Item Journal Line Table	Inventory
Applies-from Entry Field, Item Journal Line Table	Inventory
Concurrent Capacity Field, Item Journal Line Table	Inventory
Source Currency Code Field, Item Journal Line Table	Inventory
Document Date Field, Item Journal Line Table	Inventory
Routing Reference No. Field, Item Journal Line Table	Inventory
Lot No. Field, Item Journal Line Table	Inventory
Applies-to Entry Field, Item Journal Line Table	Inventory
Job Purchase Field, Item Journal Line Table	Inventory
Job Task No. Field, Item Journal Line Table	Inventory
New Bin Code Field, Item Journal Line Table	Inventory
Setup Time (Base) Field, Item Journal Line Table	Inventory
Applies-to Value Entry Field, Item Journal Line Table	Inventory
Unit of Measure Code Field, Item Journal Line Table	Inventory
Single-Level Mfg. Ovhd Cost Field, Item Journal Line Table	Inventory
Single-Level Cap. Ovhd Cost Field, Item Journal Line Table	Inventory
Area Field, Item Journal Line Table	Inventory
Level Field, Item Journal Line Table	Manufacturing
Inventory Value (Revalued) Field, Item Journal Line Table	Inventory
Last Item Ledger Entry No. Field, Item Journal Line Table	Inventory
Prod. Order Comp. Line No. Field, Item Journal Line Table	Inventory
Recurring Method Field, Item Journal Line Table	Inventory
Adjustment Field, Item Journal Line Table	Inventory
Rolled-up Mfg. Ovhd Cost Field, Item Journal Line Table	Inventory
Quantity (Base) Field, Item Journal Line Table	Inventory
Scrap Code Field, Item Journal Line Table	Inventory
New Shortcut Dimension 1 Code Field, Item Journal Line Table	Inventory
New Item Expiration Date Field, Item Journal Line Table	Inventory
Applied Amount Field, Item Journal Line Table	Inventory
Unit Cost (Calculated) Field, Item Journal Line Table	Inventory
Inventory Posting Group Field, Item Journal Line Table	Inventory
Subcontracting Field, Item Journal Line Table	Inventory
Reason Code Field, Item Journal Line Table	Inventory
Cap. Unit of Measure Code Field, Item Journal Line Table	Inventory
Reserved Quantity Field, Item Journal Line Table	Inventory
Variance Type Field, Item Journal Line Table	Inventory
Dimension Set ID Field, Item Journal Line Table	Inventory
Single-Level Capacity Cost Field, Item Journal Line Table	Inventory
Document Type Field, Item Journal Line Table	Inventory
Invoice No. Field, Item Journal Line Table	Inventory
Operation No. Field, Item Journal Line Table	Inventory
Product Group Code Field, Item Journal Line Table	Inventory
Out-of-Stock Substitution Field, Item Journal Line Table	Inventory
Warranty Date Field, Item Journal Line Table	Inventory
Warehouse Adjustment Field, Item Journal Line Table	Inventory
Unit Amount Field, Item Journal Line Table	Inventory
External Document No. Field, Item Journal Line Table	Inventory
Document Line No. Field, Item Journal Line Table	Inventory
Starting Time Field, Item Journal Line Table	Inventory
Source Code Field, Item Journal Line Table	Inventory
Output Quantity Field, Item Journal Line Table	Inventory
Work Center No. Field, Item Journal Line Table	Inventory
Item Expiration Date Field, Item Journal Line Table	Inventory
Qty. per Cap. Unit of Measure Field, Item Journal Line Table	Inventory
Item No. Field, Item Journal Line Table	Inventory
Entry/Exit Point Field, Item Journal Line Table	Inventory
Invoice-to Source No. Field, Item Journal Line Table	Inventory
Source Type Field, Item Journal Line Table	Inventory
Single-Level Material Cost Field, Item Journal Line Table	Inventory
Routing No. Field, Item Journal Line Table	Inventory
New Shortcut Dimension 2 Code Field, Item Journal Line Table	Inventory
Originally Ordered Var. Code Field, Item Journal Line Table	Inventory
Source Posting Group Field, Item Journal Line Table	Inventory
Shortcut Dimension 1 Code Field, Item Journal Line Table	Inventory
Inventory Value Per Field, Item Journal Line Table	Inventory
Reserved Qty. (Base) Field, Item Journal Line Table	Inventory
Invoiced Qty. (Base) Field, Item Journal Line Table	Inventory
Ending Time Field, Item Journal Line Table	Inventory
Order Line No. Field, Item Journal Line Table	Inventory
Nonstock Field, Item Journal Line Table	Inventory
Entry Type Field, Item Journal Line Table	Inventory
Planned Delivery Date Field, Item Journal Line Table	Inventory
Document No. Field, Item Journal Line Table	Inventory
No. Field, Item Journal Line Table	Inventory
Qty. (Phys. Inventory) Field, Item Journal Line Table	Inventory
Work Shift Code Field, Item Journal Line Table	Inventory
Recurring Frequency Field, Item Journal Line Table	Inventory
Shortcut Dimension 2 Code Field, Item Journal Line Table	Inventory
Rolled-up Cap. Overhead Cost Field, Item Journal Line Table	Inventory
Work Center Group Code Field, Item Journal Line Table	Inventory
Gen. Bus. Posting Group Field, Item Journal Line Table	Inventory
Phys. Inventory Field, Item Journal Line Table	Inventory
Job No. Field, Item Journal Line Table	Inventory
Salespers./Purch. Code Field, Item Journal Line Table	Inventory
Run Time (Base) Field, Item Journal Line Table	Inventory
Bin Code Field, Item Journal Line Table	Inventory
Quantity Field, Item Journal Line Table	Inventory
Expiration Date Field, Item Journal Line Table	Inventory
Qty. per Unit of Measure Field, Item Journal Line Table	Inventory
Applies-to Entry (RG 23 D) Field, Item Journal Line Table	India Excise
RG23PartII Entry No. Field, Item Journal Line Table	India Excise
Reverse Excise Field, Item Journal Line Table	India Excise
Re-Dispatch Field, Item Journal Line Table	India Excise
RG Line No. Field, Item Journal Line Table	India Excise
RG Correction Type Field, Item Journal Line Table	India Excise
Excise Record Field, Item Journal Line Table	India Excise
BED Amount Field, Item Journal Line Table	India Excise
Return Field, Item Journal Line Table	India Excise
Excise Entry Field, Item Journal Line Table	India Excise
RG23PartI Entry No. Field, Item Journal Line Table	India Excise
BED % Field, Item Journal Line Table	India Excise
From Transfer Order Field, Item Journal Line Table	India Local Functionality
Captive Consumption Field, Item Journal Line Table	India Local Functionality
New Dimension Set ID Field, Item Journal Line Table	General Ledger
Vendor Exchange Rate (ACY) Field, Item Journal Line Table	New Zealand Local Functionality
New Dimension Set ID Field, Item Journal Line Table	General Ledger
Ship-to Address Code Field, Item Journal Line Table	Switzerland Local Functionality
Customer No. Field, Item Journal Line Table	Switzerland Local Functionality
Classification Field, Item Journal Line Table	Switzerland Local Functionality
Title No. Field, Item Journal Line Table	Switzerland Local Functionality
Quote-Level Field, Item Journal Line Table	Switzerland Local Functionality
Customer Salesperson Code Field, Item Journal Line Table	Switzerland Local Functionality
Position Field, Item Journal Line Table	Switzerland Local Functionality
Applies-to Entry (RG 23 D) Field, Item Journal Line Table	Excise
RG23 PartII Entry No. Field, Item Journal Line Table	Excise
Reverse Excise Field, Item Journal Line Table	Excise
Re-Dispatch Field, Item Journal Line Table	Excise
RG Line No. Field, Item Journal Line Table	Excise
RG Correction Type Field, Item Journal Line Table	Excise
Excise Record Field, Item Journal Line Table	Excise
Excise Amount Field, Item Journal Line Table	Excise
Return Field, Item Journal Line Table	Excise
Excise Entry Field, Item Journal Line Table	Excise
RG23PartI Entry No. Field, Item Journal Line Table	Excise
BED Percentage Field, Item Journal Line Table	Excise
From Transfer Order Field, Item Journal Line Table	India Local Functionality
Captive Consumption Field, Item Journal Line Table	India Local Functionality
Overhead Rate Field, Item Journal Line Table	Inventory
New Dimension Set ID Field, Item Journal Line Table	General Ledger
New Dimension Set ID Field, Item Journal Line Table	Inventory

See Also

Reference

Item Journal