Office - Interactive Reports - Vendor - Purchase Order-Vendor Activity

Table of Contents


Overview

  • In this guide we will cover the Purchase Order, Reconciled Checks, and Vendor Activity Reports. You will learn how to run each report and will see an example of the data that each report will produce.

Required Permissions

  • Interactive Reports

  • Accounts Payable


Accessing the Tool

Interactive Reports gives you the ability to filter, sort, and group the data using criteria. The available criteria are specific to the information the report contains. The report functions give you the ability to customize date settings, save criteria settings, delete saved reports, and schedule an email delivery. In this section you will learn how to use the criteria and report functionality.

  1. Click on the Interactive Reports Icon from the left menu bar. 

  2. On the Report Overview page, there is a list of reporting categories to choose from, or the User can search for a topic in the top search bar. It is best to keep the topic as broad as possible. If the club wants to see POS sales search for sale.

Purchase Order

Provides the ability to select and view a Purchase Order. 

To run Purchase Order, select the report from the Vendor Dropdown,

  1. Choose the Purchase Order you wish to view.

  2. Select View Report.

In this example we ran the report for one of our Golf Shop Items. We see the PO information like the Item, Qty ordered, Unit Cost, and Amount.

Reconciled Checks

Provides a list of all checks that have been reconciled within a date range. Includes Check date, Vendor Reconcile date and Amount. Select a G/L Asset Account. Select a Date Filter of Check Print Date or Reconciled date. 

To run Reconciled Checks, select the report from the Vendor Dropdown,

  1. Set the Date Range.

  2. Choose the Ledger Account.

  3. Set the Date Filter.

  4. Select View Report.

In this example we ran the report for all Ledger Accounts. The checks listed have been reconciled in the Bank Rec.

Vendor Activity

Provides a list of all Vendor Invoices and Payments within a specific date range with the ability to filter by Vendor Category. Can search for a specific Member.

To run Vendor Activity, select the report from the Vendor Dropdown,

  1. Set the Date Range.

  2. Choose the Categories.

  3. Set the Detail Level.

  4. Choose the Vendors.

  5. Select View Report.

In this example we ran the report for one week and set the detail level to Activity to ensure the report ran fully extended. We see the Vendor Number and Vendor Name. We also see the Reference Number, Batch Date, A/P Batch, Invoice Date, Due Date, Original Amount, Payments, and Balance.


Best Practices

FAQs

 

Â