Consultant Ledger General Tab

Use the General tab to select report options for the Consultant Ledger report and to save sets of options for reuse.

Contents

Field Description
Report Name You can change the default report name.
Create Activity To create activities in the Calendar/Activities application when you generate the report, select this check box. When you generate the report, Vision displays the Activity dialog box so you can enter the activity information. Vision then creates an activity for each project included on the report.
Format

Select one of the following formats from the drop-down list:

  • Voucher Detail — Select this option to display voucher line detail for each vendor.

  • Voucher Summary — Select this option to display a summary of voucher detail for each vendor.

  • Vendor Summary — Select this option to display totals for the vendor, without any voucher detail.

Vision displays the format as part of the report name.

Include

Select one of the following to include vouchers on the report based on payment status:

  • All

  • Paid in Full

  • Unpaid

If you select Paid in Full, specify a date in the Since field.

Since

If you select Paid in Full in Include, enter a cut-off date in Since. You can enter the date, or you can click and select the date.

Vision only includes vouchers that were paid in full on or after the date you enter.

Exclude if paid prior to Select a fiscal year and period as a cut-off date for displaying zero-balance invoices on this report. The report does not include vouchers that were paid in full prior to the specified accounting period.
Liability Code

To include only vouchers that were posted to a specific liability code, enter the liability code. The report displays only those vendors with vouchers posted to that liability code.

If you use the Multicompany feature, the list of available liability codes only contains those that are valid for the active company. This is based on the organization code specified in Organization on the Liability Codes tab of the Company AP Configuration form.

Bank Code

To include only vouchers that were posted to a specific bank code, enter the bank code. The report displays only those vendors with vouchers posted to that bank code.

If you use the Multicompany feature, the list of available bank codes only contains those that are valid for the active company. This is based on the organization code specified in Organization on the Bank Codes tab of the Bank Codes form).

Vendor Selection

Click to display the Vendor Lookup dialog box and select one or more vendors for your report:

  • To select one vendor, click that row.

  • To select multiple vendors in consecutive rows, hold down the SHIFT key and click the first and last row.

  • To select multiple vendors that are not in consecutive rows, hold down the CTRL key and click each row.

Accounting information for each vendor is set up separately for each company on the Accounting tab of the Vendor Info Center. The active company at the time you generate the report determines the accounting information that is referenced for that report.

Consolidate Select this option to consolidate the phases or the tasks for each project in your report.
Payment Currency

To limit the data displayed on the report to amounts with selected payment currencies, click to display the Lookup dialog box and select one or more currencies.

  • To select one currency, click that row.

  • To select multiple currencies in consecutive rows, hold down the SHIFT key and click the first and last row.

  • To select multiple currencies that are not in consecutive rows, hold down the CTRL key and click each row.

The bank code determines the payment currency for both voucher amounts and payment amounts. When you set up a bank code, you select an account for which you have specified a currency code in the Currency field on the General tab of the Chart of Accounts Info Center. The currency for the bank code is the currency selected for that account.

Budget Source

Select one of the following as the source of the budget data for the report:

  • Budget Worksheet

  • Project Planning

Page Break by Project Select this check box to begin a new page each time the project changes.
Time Frame

Specify the period for the report. The report only includes vouchers dated in the period you select.

The options are the following:

Period

Select a setting from the drop-down list:

  • Current — The report shows data for the accounting period that is currently open.

  • Year-to-date — The report shows data for the current fiscal year through the current accounting period.

  • Job-to-date — The report shows data from the beginning of the project through the current accounting period.

Period Range

Specify a range of accounting periods. You can select accounting periods from the drop-down lists, or you can enter them in mm/yyyy format.

Dates

Enter the start and end dates of the range, or click for each field and select the dates.

Include Reimbursable Expenses Select this check box to include reimbursable expenses.
Include Reimbursable Consultant Expenses Select this check box to include reimbursable consultant expenses.
Include Direct Expenses Select this check box to include direct expenses.
Include Direct Consultant Expenses Select this check box to include direct consultant expenses.
Include Indirect Expenses Select this check box to include indirect expenses.
Include Other Expenses Select this check box to include other expenses (expenses that are not classified as reimbursable, reimbursable consultant, direct, direct consultant, or indirect expenses).