You use the Cash Book GL Distribution program to generate a report of General Ledger entries for transactions processed to your Cash Book.
This report is generated from the General Ledger journals created by the Cash Book GL Integration program.
If you have posted all your Cash Book ledger journals to the General Ledger, then you can use this report as an audit trail of entries posted to the General Ledger and possibly to assist in balancing the Cash Book to the General Ledger when discrepancies exist.
This report can be run at any time and as often as required.
| Field | Description | ||||
|---|---|---|---|---|---|
| Bank selection | Indicate the SYSPRO bank(s) for which you want to generate the report. | ||||
| Current GL period | This is displayed for information purposes only and cannot be changed. | ||||
| Period | This indicates the current period of your General Ledger module. | ||||
| Year | This indicates the current year of your General Ledger module. | ||||
| Report options | |||||
| Report type | Indicate the type of report you want to generate. | ||||
| Detail |
Select this if you want to generate a list (in ledger code sequence) of all transactions posted against each ledger code. Totals are printed for each ledger code with a distribution total printed at the end of the report. If Cash Book is integrated to the General Ledger in Summary, (General Ledger Integration - General Ledger tab), then you should print this report in detail for reconciliation purposes. |
||||
| Summary | Select this If you want to print only totals for each ledger code and the distribution totals at the end of the report. | ||||
| Reprint | Select this to reprint Cash Book GL Distribution
reports previously printed. When you select this option, you can define a range of selection criteria according to which you want to reprint the report.
|
||||
| Entry selection | This option only applies when you select the Reprint option. | ||||
| Entry selection by: | Indicate whether you want to reprint the report for a specific set of journals or a set of distribution entries. | ||||
| Journal | Select this to reprint the report for a specific range of General Ledger journal numbers. | ||||
| Entries group | Select this to reprint the report for a specific range
of distribution entry groups.
|
||||
In addition to the report options that can be selected, the following selection criteria can be defined when you select the Reprint option:
![[Note]](images/note.png)
|
|
|
The number of periods and years for which you can reprint distribution entries depends on the number of months for which you are retaining Cash book journals (Cash Book Setup - History tab). |
|
| Selection | Description |
|---|---|
| Ledger period | Indicate the ledger period(s), within the ledger year(s) indicated, for which you want to reprint the report. |
| Ledger year | Indicate the ledger year(s) for which you want to reprint the report. |
| GL journal | Indicate the General Ledger journals for which you
want to reprint the report. This selection is only enabled when your Entry selection is by Journal. |
| Ledger entries group | Indicate the entry group(s), within the selected
periods and years, for which you want to reprint the
distribution report. This selection is only enabled when your Entry selection is by Entries group. |
| Ledger code | Indicate the General Ledger code(s) for which the you
want to reprint the report. Only the distribution entries for the General Ledger code(s) you select are included in the report. |
These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).
The distribution report reflects details of the sub-module transactions posted to the GL Journal and are grouped by the GL journal number.
For tax entries, the tax account description is printed instead of the ledger code if you enabled the option: Disburse tax amount over multiple G/L tax accounts (Accounts Payable Setup).