(continued from Cheques Only)

Journal Report

The Journal message type enables GL (General Ledger) Lists to be created. There is no hard and fast rule as to what a Journal Report/List should look like, except that it should show a list of debits and credits in the journal.

The Journal format type has Setup, Header, Lines and Tail sections.

Screen Shot 218: Journal Message Setup Screen

Depending on user preference, the Journal list can be fixed or floating format.

Header Section

The Journal message header is designed to output the Journal Header data which is entered when a journal is created.

Example 102: Journal Header Section

The following substitutions will be made in the header:

<trnref>Journal Reference

<trndate>Transaction (Journal) date

<trnentdate>Date Journal entered.

<trnaddesc1>/<trnaddesc3>Journal Header additional description lines 1–3.

Example 103: Journal Header Output

Lines Section

Since the Journal message is non booking related, it is not necessary to have all line types in the Lines Section. The Blank–Unassigned line type can be used.

Example 104: Journal Lines Section

<trnac:F><trndesc1><trndramt><trncramt>

<rms:bl><trndesc2>

<rme:bl>

The following substitutions will be made in the header:

<trnac>Transaction posting GL Account. :F = The full account number (Branch/Department/Account).

<trndesc1>/<trndesc2>Transaction line descriptions 1 & 2. <rms:bl>/<rme:bl> = Remove line if the substituted value is blank.

For <rms:bl>/<rme:bl> to effectively remove the blank line, in the lines section, do not place a carriage return/enter after <rme:bl>.

 

<trndramt>Transaction debit amount.

<trncramt>Transaction credit amount.

Example 105: Journal Lines Output

Tail Section

In Example 106: Journal Tail Section Example 106: Journal Tail Section, the Tail section is being used solely to output the total of debits and credits.

Example 106: Journal Tail Section

The following substitutions will be made in the header:

<trndramt>Transaction debit amount.

<trncramt>Transaction credit amount.

These are the same codes used in the Lines section. Because they are being used in the Tail, Totals will be output.

 

Example 107: Journal Tail Outpu

Example 108: Complete Journal Output

(continued in Agent (Debtor) Statement)