Account Analysis 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.

If you select a user-defined column for this report, the report does not display subtotals for that column.

Contents

Field Description
Transaction Type This column displays a two-letter abbreviation for the type of transaction (for example, CD for cash disbursements).
Reference Number This column displays the reference number for the transaction.
  • If the transaction is an implicit posting or an automatic posting, this column displays Auto.

  • If the transaction is historical, this column displays History.

  • If the transaction is related to revenue generation, this column displays REVGEN.

If you preview the report, you can drill down on the reference to see a listing of all transactions associated with that reference number. You can drill down on Auto to see all transactions for the posting run.

Fiscal Year and Period This column displays the fiscal year and period in which the transaction was posted (for example, 200906 for the sixth accounting period in the year 2009).
Posting Sequence This column displays the posting sequence number of the transaction. Vision assigns sequence number 1 to the first group of transactions posted during an accounting period, sequence number 2 to the second group, and so on.

To generate a numbered list of all of the postings for the current accounting period, click Transaction Center > Posting Review Report from the Vision Navigation menu.

Transaction Date For all transactions except automatic postings, this column displays the date entered for the transaction. For automatic postings, this column displays the period-ending date for the file of transactions that generated the posting.
Description This column displays the description of the transaction entered during transaction entry.

If you use the Multicompany feature and the report includes journal entries to intercompany accounts receivable or intercompany accounts payable accounts, you can drill down from the Description column in those rows to see supporting detail in the Intercompany Billing Detail report. (This drill-down option is only available if your role security gives you access to the Intercompany Billing Detail report, and it is not available for tax-related journal entries.)

Project This column displays the project number associated with the transaction.

If a transaction is not related to a project, this column is blank. This column is blank for all Balance Sheet account transactions except for those that affect accounts receivable.

Phase This column displays the phase number associated with the transaction.
Task This column displays the task number associated with the transaction.
Opening Balance This column displays the balance of the account at the beginning of the reporting period. For example, if you generate a year-to-date Account Analysis, this column displays the balance as of the first day of the fiscal year.
Amount This column displays the total amount of the transaction.
Closing Balance This column displays the balance of the account at the end of the reporting period.

If you generate a report for the current period or year to date, this column displays the balance on the day that you generate the report. If you generate a report for a range of past periods, this column displays the balance at the end of the last accounting period in the range.

Transaction Currency Code This column displays the code for the transaction currency. This code applies to the amount in the Transaction Amount column.
Transaction Opening Balance This column displays the balance of the account at the beginning of the reporting period, expressed in the transaction currency.

This amount will be different from the amount in the Opening Balance column if the transaction currency and functional currency are not the same.

Transaction Amount This column displays the total amount of the transaction, expressed in the transaction currency. This amount will be different from the amount in the Amount column if the transaction currency and functional currency are not the same.
Transaction Closing Balance This column displays the balance of the account at the end of the reporting period, expressed in the transaction currency. This amount will be different from the amount in the Closing Balance column if the transaction currency and functional currency are not the same.
Total Credits This column displays the total credits posted to the account during the reporting period.
Total Debits This column displays the total debits posted to the account during the reporting period.
Account Number This column displays the number of the general ledger account.
Description 1, Description 2 These columns display the descriptions for each transaction detail line.

Vision stores the following types of descriptions for each transaction:

  • Description 1 is a general description of the transaction (for example, the name of the vendor for an accounts payable voucher).

  • Description 2 is a more specific description of the transaction (for example, the description entered during transaction entry for a single item on a voucher).

Due To/ From Company For an intercompany transaction, this column displays the name of the other company involved.
Sort/Select 1-3 These columns display the sort and select fields that are assigned to this account.
Organization This column displays the organization associated with the transaction. If your firm does not use organizations in Vision, this column is not available.
Organization levels These columns display the full names of the subcodes for the organization in the Organization column.