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

AR Sales Transaction Journals

You use the AR Sales Transaction Journals 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.

Transaction journals are created automatically whenever you successfully process a transaction in these programs. The corresponding ledger journal is created and posted according to your selections for Accounts Payable on the General Ledger tab of the General Ledger Integration program. Refer to Effect of automation level selected.

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

AR Sales Transaction Journals

Field Description
Select Select this to use the entry currently highlighted in the listview in the corresponding field of another program.
Year You use this field to indicate the financial year for which you want to display journals.
Period You use this field to 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 You use this field to 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 You use this field to 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

When you select the AR Sales Transaction Journals program, the transaction journals are displayed in a listview. 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.

The following information is included in this listview:

  • 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.

  • Customer invoice
  • Summary line

  • Invoice date

    This indicates the date on which the invoice was generated.

  • Branch

    This indicates the Accounts Receivable for which the invoice was generated.

  • Salesperson

  • 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.

  • 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 (for example, 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. 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.