Accounts Receivable > GL Integration > AR Invoice GL Integration > AR Sales Transaction Journals

AR Sales Transaction Journals

You use this program to view details of transaction journals created for postings made in the AR Invoice Posting, AR Initial Invoice Capture, AR Finance Charge Calculation, Sales Order Entry, Document Print and AR Post Permanent Entries programs.

Toolbar and menu

Field Description
Select Select this to use the entry currently highlighted in the listview in the corresponding field of another program.
Year Indicate the financial year for which to display journals.
Period Indicate the period(s) within the financial year indicated for which 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 to display journals.

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

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

This 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 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. Use the Include posted option to display all transaction journals.

Column Description
Year This indicates the year in which the invoice register was created.
Month This indicates the month in which the invoice register was created.
Register This indicates the invoice register number for the transaction.
Invoice date This indicates the date on which the invoice was generated.
Branch This indicates the Accounts Receivable for which the invoice was generated.
Customer This indicates the code of the customer against whom the transaction was processed.
Customer name This indicates the name of the customer against whom the transaction was processed.
Customer purchase order This indicates the customer's purchase order number for the transaction.
Merchandise value This indicates the merchandise value of the transaction in the local currency.
Freight value This indicates the freight value of the transaction in the local currency.
Other value This indicates the other (e.g. miscellaneous charges) value of the transaction in the local currency.
Tax value This indicates the tax value of the transaction in the local currency.
Foreign merchandise value This indicates the merchandise value of the transaction in the foreign currency.
Foreign freight value This indicates the freight value of the transaction in the foreign currency.
Foreign other value This indicates the other (e.g. miscellaneous charges) value of the transaction in the foreign currency.
Foreign tax value This indicates the tax value of the transaction in the foreign currency.
Source

This indicates the source code of the transaction and can be one of the following:

  • O - Order entry
  • T - Balance take-on
  • I - Invoice entry
  • P - Permanent entry
  • F - Finance charge
Posted

This 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 (e.g. the transaction journal was zero and the system does not create zero GL journals).

GL year

This indicates the General Ledger year for the ledger journal.

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

GL period

This indicates the General Ledger period for the ledger journal.

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

GL journal

This 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 AR Invoice 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.

See Coding considerations in Notes and warnings

Notes and warnings

Program access

  • This program can be accessed by selecting the Browse icon at the From register or To register field of the AR Invoice GL Integration program.

Coding considerations

  • Transaction journals are created automatically whenever you successfully process a transaction. The corresponding ledger journal is created and posted according to your selections in the General Ledger Integration program.

    Refer to Effect of automation level selected.