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