Consultant Tracking By Vendor then Project

The purpose of the Consultant Tracking By Vendor then Project Invoice report is for consulting pay when paid purposes. The display of this report is grouped by Vendor first, then by Project.

Data: That Transactional data is collected from the Purchase, Disbursements, Receipts, and the Sales Journals. The Budget information (optional) comes from Project Planning> Scheduling. The Schedule data, for consultants, is entered in the OCC and/or ICC modes when in Project Planning. Be sure to roll-up the Schedules to Allocations and Allocations to Budgets once you have established the correct amounts.

Note1: This report has been deprecated and was replaced by the Pay When Paid by Project, Vendor and Receipts Reports.

Note2: Only consultant charges in the Purchase Journal (Vendor Invoice), that have been linked to a Sales Journal entry, are included in this report. Also, only A/R invoices with links to consultant purchases are included.

Note3: Vendors must be flagged as a "Consultant" in their Vendor File (AP> Vendors) to be pulled into this report.

Prompt

Date Ranges

•	Aging Date - Used to calculate the "Days Old" column on the report.

•

Age by Invoice Date - Determine which date is used when calculating the "Days Old" column on the report. If "Age by Invoice Date" is selected, the days between the Age Date and the Invoice Date, of the Purchase Journal (Vendor Invoice), make up the Days Old. Otherwise, the Due Date of the Purchase Journal (Vendor Invoice) is used.

General

•	Vendor - Allows you to filter to a specific Vendor. When blank, All Vendor are returned.

•	Project - Allows you to filter to a specific Project. When blank, All Project are returned.

•	Open Vendor Invoices Only - When selected, only Vendor Invoices that have an outstanding balance to be paid will show up on the report.

•	Only Sales With Receipts - When selected, only Sales Invoices that have received a payment (Receipt Journal) will show up on the report.

•	Invoice Currency - The Invoice Currency to be used when running the report. Options are set in the Multi-Currency applet. More on Multi-Currency

Report

Report Columns

•	Vendor - The Vendor associated with the Vendor Invoice (Purchase Journal) that was billed on the Client invoice(Sales Journal) for work done on the project.

•	Project Budget - The Total OCC and ICC Budget going against the project. This is applied in Project Planning, Project Window.

•	Vendor Budget - Scheduled Amount against the specific Vendor. This is applied in Project Planning, Schedule Window.

•	Invoice (Vendor Invoice) - Invoice number of the Purchase Journal that was received from the Vendor.

•	Days Old - If "Age by Invoice Date" is selected, the days between the Age Date and the Invoice Date, of the Purchase Journal (Vendor Invoice), make up the Days Old. Otherwise, the Due Date of the Purchase Journal (Vendor Invoice) is used.

•	Invoice Amount - Total Invoice (Cost) Amount of the Purchase Journal that was received from the Vendor.

•	Total Payments - Total of all payments (Disbursement Journal) made to the vendor in regard to the Vendor Invoice that was received.

•	Cons. Effort - The Effort (marked-up) amount of the Vendor Invoice.

•	SJ (Sales Journal) Invoice No. - Invoice Number of the Sales Journal that was billed to the Client.

•	Total Billed - Total Bill Amount that was billed to the Client.

•	Cons. Billed - Total Consultant (OCC or ICC) Billed portion of the Sales Invoice. Note: Must be posted to a Billed Revenue Account with a PM Type of either Out-of-Contract Consultants (OCC) or In-Contract-Consultants (ICC).

•	Received - Total Amount Received against the specified Sales Invoice.