Description
The Vendor Inquiry report allows you to search for invoices, amounts billed, and other cost amounts paid to vendors
Note: This report is run for a date range. You may not see the same figures if you are trying to compare this to an Income Statement or a Balance Sheet that uses a GL Period as a Date Filter.
Data: That data is collected from the Disbursements, Receipts, and Purchase Journals
Prompt
Date Ranges
| • | Start & End Date - Filters the data by the transaction date on the Journal entry. |
General
| • | Vendor Code - Allows you to filter to a specific Vendor. When blank, All Vendors are returned. |
| • | G/L Account - Specifies the account to limit the report. When blank, all accounts are returned |
| • | Transaction Type - Allows you to filter report by Invoice or Payment types or to include both. |
| • | Show Invoice - If checked, will display invoiced amount in report. |
| • | Show Project - If checked, will display associated project with invoice. |
| • | Show WBS - If checked, will display the Work Breakdown Structure of the project. |
| • | Show Transaction Detail - If checked, will display invoice/check item detail |
| • | Only Active Vendors - If checked, filters the report only for vendors marked "active" in the Vendors applet. |
| • | Open Invoices Only - If checked, only returns unpaid invoices |
| • | Include Consultants - If checked, the report will display vendors marked "consultants" in the Vendors applet. |
| • | Include Non-Consultants - If checked, the report will display vendors not marked "consultants" in the Vendors applet. |
| • | Currency Type - The Type of Currency to be used when running the report. Options are Base, Company, Project and Transaction. |
| • | Currency Code - The Currency Code to be used when running the report. Options are set in the Multi-Currency applet. More on Multi-Currency
|
Report
Report Columns
| • | Trans Number - Invoice # (Purchase Journal) or Check # (Disbursement,Receipt) |
| • | Transaction Type - Invoice (Purchase Journal) or Check (Disbursement,Receipt). In Space after - Invoice # (Purchase Journal) or Check Date (Disbursement,Receipt) |
| • | Project Amount - The Cost Amount for the Purchase & Disbursement Journals. The Amount of the Receipts Journals. |
| • | Invoice Amount - The detailed Cost Amount for the Purchase & Disbursement Journals. |
| • | Paid Amount - The Amount for the Receipts Journals. |
| • | Other Amount - The Cost Amount for the Disbursement and Receipts Journals. |
Sample(s)
|