Diary Report

If the active company is set up to assign transactions to diaries, use the Diary report to review general ledger transactions by diary.

Diaries make it possible to keep a sequential log of general ledger entries in their database. 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.

Generate the Diary report in a detail or summary version by selecting or clearing the Transaction Detail option in the grid on the Sorting/Grouping tab:
  • 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.

Settings

To activate diaries, you set up automatic numbering for them on the Transaction Auto Numbering tab of the Accounting System Settings form (Settings > Advanced Accounting > System). 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 options on the General tab of the Options dialog box 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 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.

Options Dialog Box

Use the Options dialog box to specify reporting options for a report. Depending on the report, the dialog box contains one or more of the following tabs: General, Sorting/Grouping, Columns, Budget, Metrics, User Defined Sections, Activity, Drill Down, Layout, and Graph.