Description
The Pay When Paid By Project report can be used for consulting pay when paid purposes. The report layout of this report groups by Vendor.
Note1: Purchases not linked on a sales journal will appear on the report as long as the Vendor is flagged as a "Consultant".
Note2: "Okay to Pay" Column - There is an okay to pay columns. The okay to pay only applies to linked purchases and is based on monies received (Receipt Journal). In the case of partial payments, the receipts are prorated accordingly. This report also considers the Revenue Type in cash receipts when computing consultant dollars received. The Revenue Type option is turned on in Global Settings> A/R Tab> Receipt Wizard Breakdowns.
Note3: Vendors must be flagged as a "Consultant" in their Vendor File (AP> Vendors) to be pulled into this report.
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.
For detailed steps on paying your vendors through InFocus, walk through this Help Center Course: Paying Your Vendors
Prompt
Date Ranges
| • | As of Date - Used as the Cut-off date for all transactions, unless "No Cut-Off Date" is selected. |
| • | No Cut-Off Date - When selected, the "As of Date" is ignored and the report is run for all time. |
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 Projects are returned. |
| • | Project Status - Allows you to filter the returned projects by status. Status includes Active, Inactive and Both. |
| • | Include Sales With No Consultant Revenue - When selected, Sales Journals (Client Invoices) will be included, even if none of the Billed Revenue is going against accounts with a PM Type of Out of Contract Consultants (OCC) or In Contract Consultants (ICC). |
| • | Include Distributed Sales - When selected, Sales Journals that have already paid any associated Vendors, will be included in the report. |
| • | Include Paid Vendor Invoices - When selected, Vendor Invoices (Purchase Journals) that have been paid (Disbursement Journal) will be included in the report. |
Display
| • | Sort By - Gives you the ability to Sort/Group the report by Project, Client, Project Manager, Principal and Org. Unit. |
| • | Show Receipts - When selected, Receipt Journal Entries that go against the Sales Journal (Client Invoice) will be displayed on the report. |
| • | Show Payments - When selected, Disbursement Journal Entries that go against the Purchase Journal (Vendor Invoice) will be displayed on the report. |
| • | Show Vendor Budgets - When selected, Budgets entered in Project Planning against the specific Vendor, will display 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
| • | Ref # - Invoice Number (Purchase and Sales Journals), Check Number (Disbursements and Receipt Journals) |
| • | JN - PJ (Purchase Journal), SJ (Sales Journal), CD (Disbursements Journal) and CR (Receipts Journal) |
| • | Date - Invoice Date (Purchase and Sales Journals), Check Date (Disbursements and Receipt Journals) |
| • | CNS (Billed) - Portion of the Client Invoice (Sales Journal) that is classified as Consulting Revenue. That means that it goes against a Billed Revenue G/L Account that has a PM Type of Out of Contract Consultants (OCC) or In Contract Consultants (ICC). |
| • | Total (Billed) - Total Amount of the Client Invoice (Sales Journal). |
| • | CNS (Charged) - Portion of the Vendor Invoice (Purchase Journal) that is classified as Consulting Cost. That means that it goes against a Cost G/L Account that has a PM Type of Out of Contract Consultants (OCC) or In Contract Consultants (ICC). |
| • | Total (Charged) - Total Amount of the Vendor Invoice (Purchase Journal). |
| • | CNS (Received) - Portion of the Receipt that is classified as Out of Contract Consultants or In Contract Consultants. |
| • | Total (Received) - Total amount of the Receipt entry. |
| • | CNS (Paid) - Consultant portion that has been Paid (Disbursement Journal) in regard to the Vendor Invoice (Purchase Journal) . |
| • | Total (Paid) - Total Invoice Amount that has been Paid (Disbursement Journal) in regard to the Vendor Invoice (Purchase Journal) . |
| • | Balance (Paid) - Charged Total minus Paid Total |
| • | Ok To Pay - The "Okay to Pay" Column indicates the amount that you are able to pay your Vendor and only applies to linked purchases and is based on monies received (Receipt Journal). In the case of partial payments, the receipts are prorated accordingly. This report can also use the Revenue Type in cash receipts when computing consultant dollars received. The Revenue Type option is turned on in Global Settings> A/R Tab> Receipt Wizard Breakdowns. |
Sample(s)
|