Program Description
The GL Detail By Date/Vendor/Voucher Report is a new in Rev 14 and can be found on the General Ledger Reports menu (GL-4-17). This is similar to the GL Detail Report. This report however gives you an opportunity to run the report for a date range within the fiscal year. This report also allows you to run for a range of voucher control numbers, vendor numbers, account numbers, and certain source codes. This report will have an option to sort by voucher control number or by account number. This report’s key benefit is the ability to report on how an operator distributed money by voucher after the current fiscal year is over. This is a great tool to help dealerships with audits.
Example:
Fields:
Current Fiscal Year (Y/N/E)
Enter Y if the report should use the current fiscal year. Enter N if the report should use a previous fiscal year. Enter E to return to the menu. If N is entered, the report will prompt “Enter Fiscal Year”. The operator should then enter the two digit year that they would like to report with. For example: 99 for 1999, 00 for 2000, 01 for 2001, etc.
Beginning Voucher Number, A’ll Or E’nd
Ending Voucher Number
Enter the range of voucher numbers to print on the report.
Beginning Vendor Number Or A’ll
Ending Vendor Number
Enter the range of vendor numbers to print on the report.
Beginning Account Number Or A’ll
Ending Account Number
Enter the range of General Ledger account numbers that should be printed on the report.
Beginning Transaction Date Or A’ll
Ending Transaction Date
Enter the range of dates that should be used for the report.
Enter Source Code Type Or ‘ALL’
Enter a valid source code type, or enter “ALL” for all source codes. Valid source code types are “AP”, “AR”, “FA”, “GL”, “JE”, “PA”, “PT” and “SA”.
Sort By C’ontrol # Or A’ccount #
Enter C to have report sorted by the voucher control number. Enter A to have the report sorted by General Ledger account number.
Sample report sorted by Voucher Control Number:
When the report is sorted by the voucher control number, the beginning balance does not print and the net change and ending balance do not print on the totals. These will print when the report is sorted by the account number. When the report is sorted by voucher control number, a report total prints the total debit account and total credit account.
Sample report sorted by Account Number:
When sorted by account number, the report will print totals for each account number and a report total at the end of the report. If run for all months and sorted by account number, the report will also print monthly totals. When sorted by account number, the totals will print the total of the beginning balance, debit amount, credit amount, net change and ending balance. Net change is calculated by taking the total debit amount minus the total credit amount. The ending balance is calculated by taking the total beginning balance plus total net change amount.
Rev 15 Changes
Options were added to the report to print for a range of system dates and a range of fiscal months. When the report is run, these fields in the General Ledger File (GLDISTD) is compared with the range(s) entered by the operator to see if the system date or fiscal month is within the range entered by the operator. See screen sample below.
