You use this program to view details of transaction journals created for transactions processed in Trade Promotions.
Transaction journals are created automatically whenever you successfully process a transaction. The corresponding ledger journal is created and posted according to your selections for Accounts Receivable 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 TPM GL Integration program.
| Field | Description |
|---|---|
| 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. |
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 | This indicates the year in which the TPM journal was created. |
| Month | This indicates the month in which the TPM journal was created. |
| Journal | This indicates the TPM transaction journal number. |
| Deduction code | This indicates the deduction code for the TPM transaction. |
| Customer | This indicates the customer for whom the transaction was processed. |
| Customer name | This indicates the name of the customer for whom the transaction was processed. |
| Sales order number | This indicates the sales order number against which the TPM transaction was processed. |
| Reference | This indicates the reference defined against the TPM transaction. |
| Amount | This indicates the transaction amount. |
| Journal date | This indicates the date on which the TPM transaction journal was processed. |
| 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 TPM transaction journal. Zeroes indicate that the General Ledger journal has not yet been created. You need to use the TPM 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. |