CD - Debtors Trial Balance
Debtors Trial Balance Overview
This program allows you to generate a report providing customer account balances for this shop. All transactions up to and including the period for which you are running the report must be posted before this report can be run.
The report is available in summary or detailed format.
This report/export has extensive options that can be selected at run-time. These selections can be saved as your own report 'Configuration' profiles. A report 'Configuration' that you create can't be accessed by another user and vice versa. This is because each 'Configuration' is dependent on the individual user's security permissions that determine the fields that can be included.
To use a previously saved report configuration, select it from the 'Use a Previously Saved Configuration' picklist and click 'Next'.
The 'Use a previously saved configuration' picklist will only be available if a saved configuration exists.
To create a new configuration, click the 'Next' button without selecting an option from the 'Use a Previously Saved Configuration' picklist.
Enter your runtime options for the program.
To save the runtime options that you have entered as a re-usable report configuration, enter a meaningful description into the 'Save this Configuration as' field on the 'Process' or 'Print' tab.
You can delete a report configuration by selecting it from the picklist, clicking the 'Next' button, and then clicking the 'Delete' option.
You can modify an existing configuration by selecting it, making the necessary changes to the run-time options, then clicking 'GO' on the 'Process' or 'Print' tab. You need to ensure the 'Save this Configuration as' field is populated with the report configuration name. This field is populated automatically when an existing configuration is selected.
General Tab
Enter the year and period that you want to run the report for.
Leave 'Customer Code', 'Customer Type' and 'Term Code' blank to run a trial balance for the entire customer ledger or use these fields as filters to produce an abbreviated report.
Print Tab
Sort By
The default is for the report to sort by 'Customer Code'.
Alternatively, you can elect to sort by 'Customer Name' or 'Customer Type'.
Formatting Options
Choose the 'destination' of the report. This can be to Adobe® PDF viewer, Microsoft Excel®, Microsoft Word® or a screen with hyperlinks.
The 'Screen with Hyperlinks' format is best if you need to 'drill-down' to further information.
The report can be run in either a summarised or detailed format.
Use the checkboxes to indicate your preference for displaying 'Alternate Row Colours' and 'Table Borders'. These options can enhance the readability of the report but are not available if the listing destination is Excel®.
Use the 'Include Contact Details' checkbox to include a contact person and phone numbers on the report. This is useful if you are using the report to chase overdue accounts.
By selecting the appropriate checkboxes, you can also nominate whether to include accounts with:
- Zero balances.
- Credit balances only.
- Debit balances only.