Vendors Reports are ran to provide information on the invoices made from and for Vendors. These reports can then be exported from the system for tax purposes or to process payments through an outside company.
Navigation
To access My Reports, click on the 'My Reports' Tab in any module. When the main Reports screen opens, it will default to your 'Favorites', or any report that you previously starred. Hover over and click 'Vendors' on the header; this will then display all of the Vendors Reports.
Make one of these reports a favorite by clicking the Star icon to the left of the report name and it will be saved as a favorite in the 'Favorites' tab.
Security and Report Access
Vendors Reports can be accessed by Users who have been given Report Roles by their system administrator.
If you aren't able to view these reports, it's most likely because you don't have security access. Speak with your system administrator to give you access to running or viewing these reports.
Reports
The following reports are available on the 'Vendors' tab:
1096 Prep - Lists the totals of returns from 1099 Vendors throughout the year. This can be helpful to view before printing the 1096 Printable Form.
1096 Printable Form - Downloads the information needed to print onto the 1096 Tax Form.
1099 Export - Exports 1099 data by Form Type, which can then be imported into an online system so your taxes can be done electronically.
1099 Review - Displays all of the 1099 Vendors for a specified period of time. This can be helpful to view before producing the 1099 Tax Form.
1099-INT Printable Form - Downloads the information needed to print onto the 1099-INT Tax Form.
1099-MISC Printable Form - Downloads the information needed to print onto the 1099-MISC Tax Form.
1099-NEC Printable Form - Downloads the information needed to print onto the 1099-NEC Tax Form.
AP Aging - Shows all the open AP Transactions, including credit memos that haven't been applied to an invoice yet, as of a selected date. The day ranges for current and past due invoices will be listed along with their invoice number.
ComData Export - Produces a listing of all open, unpaid invoices for Customer's who are signed up for ComData. This information can then be exported in the correct formatting and given to ComData for payment purposes.
CPX Buyer Export - Exports a listing of all Buyer Names and Buyer IDs used for R365 Payments.
Mineral Tree Export - Produces a listing of all open, unpaid invoices for Customer's who are signed up for MineralTree. This information can then be exported in the correct formatting and given to MineralTree for payment purposes.
Vendor Reconciliation - Detail - Runs all AP Transactions for a single Vendor as of a specific cut-off date and details out the expenses tied to multiple GL Accounts and/or Locations from one transaction.
Vendor Reconciliation - Summary - Runs all AP Transactions for a single Vendor as of a specific cut-off date and provides a quick view into the total amounts paid and due to a Vendor.