Search Page Reports

Audience: Accounting Manager, Read-only AM, Approver*

Summary: This article reviews the content of reports available on the Search page. Combined with advanced search, these reports offer the ability to pull various types of data with a range of potential scope modifiers.

*Note: Approvers have access to a smaller selection of these reports.

This article contains:

• How to
  • Using the Search page reports
• Reports
  • Vendors
  • Invoices
  • Documents
  • Payments
  • Credits
  • Alerts
  • POs (not available for all integrated ERPs)

How to: Using the Search page reports

1. Begin by logging in as an Accounting Manager user and clicking the SEARCH tab to access the Search page.
2. On the search page, select the pertinent data category
3. (Optional) Click the "Advanced Search" button to set additional search criteria. 
4. To get a report of all available data, click "Download Report."

NOTE: there is a maximum file size of 10,000 records. If you require an export of more than 10,000 records, either split the report by manipulating the search criteria or contact MineralTree Support for further assistance.

Vendors

The vendor report contains comprehensive vendor details data of the following categories:

• Basic Identification (including name, external ID, and company name)
• Default Coding Preferences (e.g. default expense account, default terms, etc.)
• Invoice Approval Preferences (vendor rules only)
• Payment Preferences
  • ACH (includes account and routing numbers)
  • Check (includes address and name-on-check data)
  • Credit Card
  • Remittance
• Other, including
  • Customer account number (Listed as "Account #")
  • PO match configuration
  • Payment scheduling

NOTE: Since the file is exported as a CSV, this means that opening the file in Excel may result in account and routing numbers displaying improperly. We recommend using the Import function and setting the account and routing number fields as "text" instead of numbers such that leading zeroes are maintained.

Invoices

The Invoices report contains the following columns:

1. Vendor Name
2. Subsidiary Name
3. Invoice Date
4. Due Date
5. Invoice #
6. Original Invoice Amount
7. Remaining Amount
8. Invoice Status
9. GL Posting Date
10. Posting Period
11. Created Date
12. Created By
13. Invoice Approval Status
14. Approved By
15. Rejected By
16. Awaiting approval By
17. Attached Document Names
18. Invoice Notes
19. Invoice Memo
20. PO#
21. Sync Status
22. Sync Time
23. Terms
24. Discount Amount
25. Discount Date
26. Currency

NOTE: Not all data columns are supported for every integrated ERP, so some may always be blank for your ERP.

Documents

The Documents report contains the following columns:

1. Document Name
2. Attached?
3. Attached to Invoice #s
4. Attached to Vendor Names
5. Synced to ERP?
6. Uploaded Date
7. Invoice Capture? 
8. Upload Type
9. User email

NOTE: Regarding the column named "Synced to ERP?", it should be known that not all integrated ERPs support document sync.

Payments

The Payments report contains the following columns:

1. External ID
2. Vendor Name
3. Subsidiary Name
4. Payment Date
5. Payment Amount
6. Payment Type
7. Sequence Number
8. Payment Status
9. Paid From Account
10. Submitted By
11. Approved By
12. Invoice #s
13. Payment Notes
14. Memo
15. Sync Status
16. Sync Time
17. Discount Applied
18. Currency

NOTE: payments made in your ERP will not have associated payment approval information

Credits

The Credits report contains the following columns:

1. Vendor Name
2. Credit Date
3. Original Amount
4. Remaining Amount
5. Status
6. Applied to Invoice #s
7. Currency

Alerts

The Alerts report contains the following columns:

1. Date
2. Detail
3. Entity (e.g. Company, Payment, Invoice)

POs

The POs report contains the following columns:

1. Vendor Name
2. PO Number
3. Associated Invoices
4. Status