Diary

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

Diaries are used by firms that need to keep a sequential log of general ledger entries in their database. If you use diaries in Vision, 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.

Configuration

You activate diaries in Vision by setting up automatic numbering for them on the Transaction Auto Numbering tab of Accounting System Settings (Configuration > Accounting > System Settings). 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 using the Lookup dialog box that you display 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.

Related Topics:

  • Display the Diary Report
    The Diary report is available for selection in the list of General Ledger reports in Vision Reporting.
  • Diary General Tab
    Use the General tab of the Diary Options dialog box to select report options for the Diary report and to save sets of options for reuse.
  • Diary Columns Tab
    Use the Columns tab to select or clear columns, change column sequence, provide new column labels, set column widths, or select number and date formats.
Parent Topic: General Ledger Reports Overview