The&nbsp;Vendor Analysis Report (BC0006) provides a report by vendor name, showing all activity for a vendor or vendors in a specified time frame.&nbsp; The report includes purchase orders numbers, general ledger accounts, original purchase order amount, open purchase order amount, invoice number, invoice amount, paid date and check number.
<img src="https://cdn.livechat-files.com/api/file/kb/file/5399341/8d323ec287-d80ea626b58ed43c14c7.png">
The "Excel-friendly format" box generates the report as a CSV file. To view the report on screen or to export it as a PDF, leave the box unchecked.
When you run the report for ALL vendors, the list of vendors is available.&nbsp; Select ALL
<span style="font-size: 11.0pt; font-family: 'Calibri Light',sans-serif; mso-fareast-font-family: Aptos; mso-fareast-theme-font: minor-latin; mso-ligatures: standardcontextual; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;"><img height="422" width="624" src="https://cdn.livechat-files.com/api/file/kb/file/5399341/752498d107-8b490fe98205feed590b.png" style="height: 490px; width: 727px;">
<span style="font-size: 11.0pt; font-family: 'Calibri Light',sans-serif; mso-fareast-font-family: Aptos; mso-fareast-theme-font: minor-latin; mso-ligatures: standardcontextual; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;"><img height="76" width="288" src="https://cdn.livechat-files.com/api/file/kb/file/5399341/6a3fca0291-21c5c29b5b24bc09b786.png" style="height: 135px; width: 522px;">
Select, yes to continue.
For reports generated to the screen, the report preview is displayed and can be printed or saved as a PDF.
For the "Excel-friendly format," a Windows Explorer box pops up, allowing you to save the file locally.
&nbsp;

The Vendor Analysis Report (BC0006) provides a report by vendor name, showing all activity for a vendor or vendors in a specified time frame.  The report includes purchase orders numbers, general ledger accounts, original purchase order amount, open purchase order amount, invoice number, invoice amount, paid date and check number.



The "Excel-friendly format" box generates the report as a CSV file. To view the report on screen or to export it as a PDF, leave the box unchecked.

When you run the report for ALL vendors, the list of vendors is available.  Select ALL





Select, yes to continue.

For reports generated to the screen, the report preview is displayed and can be printed or saved as a PDF.

For the "Excel-friendly format," a Windows Explorer box pops up, allowing you to save the file locally.

 

How do I create a report of all vendor activity (including purchase orders, invoices, G/L accounts) over a given time period?

How can I be alerted of any General Ledger posting errors?

How do I print a report from the Financials Report Writer in landscape format?

Can requisitions be automatically approved in Keystone? 

What report shows all the requisitions that are sitting in the queue waiting for approval?

Can I stop the Check Register and Update (AP4070) to change an incorrect check date?

How do I print all AR invoices that have been entered?

What is the difference between automatically reversing and deleting a journal entry?

How do I reprint AP checks that I have already posted?

How does the "Print Blanket PO's Only" option on Open Purchase Order Listing (LG0501) work?

What do different account statuses mean in Chart of Accounts Maintenance (GL0018)?

When entering a purchase order requisition in KeyNet, where do I change Ship to and Invoice to?

What is the difference between making an account invalid versus inactive?

How do I make a copy of my Budget Preparation Phase 1 to make a Budget Preparation Phase 2?

How do I enter a requisition for a different department?

What report do I run to check my Revenue and Expense Control accounts to see if they equal the GL?

How can I print a COA (Chart of Accounts) from the system?

When I print PO's where do I go to add instructions?

How do I print the "Chart of Account Element Table" screen GL1013?

How do I run a report that shows all the requisitions sitting in the queue waiting for approval?

Set CY*P1 for the Budget Prep Entry but it says, "Phase 1 is not open" how to make sure it's open?

Process Overview: Cash Receipts

Can I update the posting date on a voided check?

Payroll Distribution Posting

What do the fields mean on the Funds Period Status Change (GL0048) and Funds File Maintenance (GL0019) screens?

How do I set up Positive Pay Parameters in Financials?

How can I prevent receiving when a purchase order is complete?

How do I set up system parameters for entering next year requisitions and purchase orders?

Where can I print an Accounts Payable Check Register?

General Ledger Transaction Types

How do I create a PO for the prior year?

What does the “Alt Req” (Alternate Requisition) button do?

How do I know if an account is marked as Student Activity Fund?

On the Chart of Accounts Maintenance screen (GL0018), what is the significance of the checkboxes?

How do I add a new OASIS code?

What is the difference between A/P Release for Payment AP3061 & Release Invoices for Payment AP0092

How do I print a separate check for each line on a Purchase Order?

What do the status codes stand for on the Funds File Maintenance (GL0019) screen?

How do I re-create an AP direct deposit file?

On the Funds File Maintenance (GL0019) screen what do the options for the Transfer Flag mean?

I have a requisition "In Review" on the web, how do I make it become a LIVE requisition?

What is the difference between a standard/recurring journal entry and a journal entry?

If I void a check can I use the same check number?

Where do I find the inventory issue inquiry?

How do I add an attachment when inputting a purchase order requisition?

Once a check is posted where do I manually clear it in order to continue my bank reconciliation?

How do I reprint Accounts Payable checks if not using KeyDocs?

How can I make adjustments to the columns in Report Writer?

Is there a report I can print that shows all debits and credits done in a month?

In requisitions, what happens when the General Ledger account has insufficient funds?

I created a budget supplement with an incorrect date, how do I fix this?

How do I add a fund to a check code?

How does Keystone handle requisitions with a zero dollar amount at year end? Will they roll over?

How do you enter a budget supplement against a revenue account?

The status codes for accounting period are as follows:

How do I make a vendor inactive?

What happens to the invoice when a check is voided?

How do I add a Fund?

What is a standard journal entry?

How do I begin a new budget cycle?

How do I add a new General Ledger account?

How do I maintain next sequence numbers for Next Year's Purchase Orders and Requisitions?

Accounts Payable Check Code Set Up for Direct Deposits

How do I set the funds from Next Year's Period to Open?

How do I override the freight on a purchase order?

How does Budget Control / Budget Rollup Work?

In AP Invoice Inquiry (AP9324), what are the different statuses for a line item on an invoice?

What do the status values in each detail / line item mean on a Purchase Order?

How do I delete an OASIS code?

How do I void a check from last Fiscal Year?

How do I manage alternate addresses for vendors?

How do I change invoice check codes after they have been posted and released for payment?

How do I enter new lines on a closed PO?

Can I change the status (open, close, soft close, etc.) of a period for all my funds at one time?

How do I create payment codes?

How do I search class codes?

What do you do when checks were released for payment that should not have been released?

When entering a Budget Supplement and adding a revenue account, does this make the deposit as well?

How does the “Print Blanket PO’s Only” option on Open Purchase Order Listing screen (LG0501) work?

Where do I change the setting so the system gives me a next year requisition/purchase order number?

How can I see and print the detail of an already written check or check register?

Accounts Payable Vendor Maintenance Set Up for Direct Deposits

How do I auto reverse Journal Entries?

How do I import Journal Entries?

How do I re-print an Accounts Payable check register?

How do I set the format of a vendor's EIN/SSN?

Does the creation of an invoice hit the expense/liability line in the GL?

What is the difference between the notation of H, HC, and HR?

Can I roll PO's, Requisitions, and GL before year end?

How do I add two columns together in Financials Report Writer?

Do you think if a Purchase Order gets manually put in, will that throw off the sequence for requisitions and Purchase Order's?

How do I set up a GL account for use in KeyNet Budget Entry?

How are requisitions processed in Keystone, if they exceed the available budget?

How do I reset a check number in Accounts Payable?

How do I set up State Sales Tax Tables (primarily North Carolina)?

What does the "Receipts allowed after PO Complete" check box affect?

What does “Default Credit Crd Check Code” on Define Site Control A/P/DISB (LG0541) screen mean?