Diary Report
Diaries make it possible to keep a sequential log of general ledger entries in their database. If the active company is set up to assign transactions to diaries, use the Diary report to review general ledger transactions by diary.
If you use diaries, the diary numbers are assigned to transactions along with the standard transaction reference numbers (voucher numbers, check numbers, invoice numbers, and so on). The diary numbers are linked to the debit and credit entries made to the general ledger for the transaction.
- By default, Transaction Detail is selected, and the report includes transaction detail rows.
- If you do not select Transaction Detail, the report only displays group totals, and any transaction detail columns on the report are blank.
The PSA module does not include the diary feature, so this report is not available if that module is activated.
Settings
To activate diaries, you set up automatic numbering for the active company in the Diary Auto Numbering Options section on the Transaction Settings form ( ). If automatic numbering for diaries has not been set up, the Diary report does not display in the list of General Ledger reports.
Transaction Selection
Use the fields on the Options tab to filter the transactions included on the report by any of the following:
- Diary code
- Diary type
- Diary number
- Fiscal period or transaction date
For this report, you do not select records on the lookup that displays from the Record Selection column in the Reports grid.
Drill Down Option
If the report includes transaction detail, you can click the link in the Posting Sequence report column for a transaction to drill down to the Posting Log report.
- Related Topics:
- Diary Columns & Groups Tab
Use the Columns & Groups tab to organize and group data on the report and to select the columns to display on your report. - Diary Layout Tab
Use the Layout tab of an individual report to choose document formatting properties, fonts, default field formats and other overall properties for reports. You can select defaults for many of the fields via My Preferences to apply specific options that you reuse when running reports. - Columns for Diary Report
The following columns are available for this report.