Inventory > GL Integration > Inventory GL Integration > Inventory Journals

Inventory Journals

You use this program to view details of transaction journals created for postings made which affect Inventory.

Toolbar and menu

Field Description
Select Use the entry currently highlighted in the listview in the corresponding field of another program.
Year Indicate the financial year for which you want to display journals.
Period Indicate the period(s) within the financial year indicated for which you want to display journals.

You can select to display all journals for the selected year, a range of periods or a single period.

From period Indicate the first period in a range of periods for which you want to display journals.

If you selected Single at the Period field, then you use this field to indicate the single period which you want to display journals.

This field is not enabled when you select All at the Period field.

To period Indicate the last period in a range of periods for which you want to display journals.

This field is only enabled when you select Range at the Period field.

Include posted Select this to display transaction journals for which ledger journals currently exist (i.e. for which ledger journals were created in the General Ledger module).
Go (arrow icon) Select this arrow to display the journals according to your selections.

Listview columns

By default, only the transaction journals for which no corresponding GL journals have been created are displayed. You use the Include posted option to display all transaction journals.

Column Description
Year Indicates the Inventory year into which the transaction was processed.
Month Indicates the Inventory month into which the transaction was processed.
Journal Indicates the Inventory transaction journal number.
Journal date Indicates the date on which the Inventory transaction journal was created.
Warehouse Indicates the code of the warehouse for which the transaction was processed.
Warehouse description Indicates the description of the warehouse for which the transaction was processed.
Goods in transit journal Indicates whether the transaction relates to a goods in transit transaction.
Posted

Indicates whether a ledger journal exists (i.e. was created) for the transaction journal.

It is possible that the word "Yes" is indicated in this column, but that the GL year, GL period and GL journal columns contain only zeroes. This means that the system attempted to create a GL journal for the transaction, but that no GL journal was required (for example, the transaction journal was zero and the system does not create zero GL journals).

GL year

Indicates the General Ledger year for the ledger journal.

Zeroes indicate that the General Ledger journal has not yet been created.

GL period

Indicates the General Ledger period for the ledger journal.

Zeroes indicate that the General Ledger journal has not yet been created.

GL journal

Indicates the General Ledger journal number created for the transaction journal.

Zeroes indicate that the General Ledger journal has not yet been created. You need to use the Inventory GL Integration program to create the General Ledger journal.

A GL journal number does not indicate that the journal was posted into the General Ledger. It only indicates the ledger journal number that was created from the transaction journal and passed to the General Ledger module for processing. Ledger journals are posted according to your selections on the General Ledger tab of the General Ledger Integration program. Refer to Effect of automation level selected.

Notes and warnings

Program access

  • This program can be accessed by selecting the Browse icon from the Journal field of the Inventory GL Integration program.

Coding considerations

  • Transaction journals are created automatically whenever you successfully process a transaction which affects Inventory. The corresponding ledger journal is created and posted according to your selections for Inventory on the General Ledger tab of the General Ledger Integration program.

    Refer to Effect of automation level selected.