Vendor Analysis

Prev Next

The Vendor Analysis report primarily focuses on a GL Account or range of GL Accounts to only show the distribution on AP Invoices and the Payments applied to them. Since payments in R365 are applied at the invoice level, the payment will need to be distributed on a weighted average basis if the invoice has a remaining balance.

There are four primary sections to the report:

  1.  Summary Heading

  2.  Transactions List

  3.  Grouping by GL Account

  4.  Grouping by Legal Entity


Navigation

The My Reports search bar can be used to search R365's entire catalog of reports.

  1. Open the Reports app. 
  2. Navigate to My Reports
  3. Enter all or part of the report name in the search bar.
  4. The Results tab will open with the list of search results.
  5. From beneath the report name, click Run to run the report with the selected report view.
    -OR-
    Click Customize to adjust the report parameters and run the report. 



Report Parameters

Field/Column

Description

Filter By

A listing of all location categories.

Filter

A listing of all locations associated with the selected location category.

GL Date

This option will either show or hide the GL date on the report.

Start

The beginning date that the report is ran for.

End

The end date that the report is ran for.

Vendor

A listing of all vendors.

Run Button

Runs the report. Users can also send, export, or print the report directly from this button by clicking the down arrow portion and selecting the desired action.


Report Columns


Field/Column

Description

Gross Purchases

The sum of invoices, not including credit memos or discounts.

Number of Invoices

The count number of invoices from the vendor.

Average Invoice Amount

Gross purchases divided by the number of invoices.

Discounts Taken

The sum of discounts taken when a payment is processed (does not include credit memos).

1099 Amount

The total amount recorded as tracked for 1099 processing.

Last Invoice Date

The date of the most recent approved invoice.

Last Payment Date

The date of the most recent payment.

Document Date

The date listed on the invoice.

GL Date

The date the invoice posts to the general ledger. This is only available for an AP invoice, so other transactions will show the document date here.

Number

The document number entered at the header level. This is hyperlinked back to the transaction in R365. Unapproved transactions will have an asterisk next to their document number.

Type

The R365-assigned transaction type.

Legal Entity

The name of the legal entity assigned to the location on the header of the transaction.

Location

The name and number of the location on the header of the transaction. When multiple locations are used on the document, "Multiple" will be displayed.

Location Amt

The total of the detail lines that match the filter restrictions provided by the user when running the report. For example, if the document amount is $1500 for locations 1, 2, and 3, but you only choose to view locations 2 and 3, the amount for only those selected locations will be displayed.

Document Amt

The total amount of the invoice.

Date Last Paid

The date of the most recent payment or credit memo applied to the invoice.

Payment Ref

The R365 number (document number) assigned to the payment or credit memo that was most recently applied to the invoice. This should match the record used in "Date Last Paid."

Total Amt Paid

The portion of the payment or credit memo that is applied to the distribution line of the invoice. When one invoice is applied to different GL accounts, that invoice will appear for each account, and as the invoice amount is paid, the payment will be distributed among all GL accounts based on the amount owed for each account, reflecting a remaining amount for each.

Example

An invoice with a total of $1000 is partially paid in the amount of $750. This payment is applied to the entire invoice and distributed across three separate accounts:

  • GL account #1 = $350 / $1000 = 35% → 35% × $750 = $262.50 (remaining: $87.50)

  • GL account #2 = $500 / $1000 = 50% → 50% × $750 = $375 (remaining: $125)

  • GL account #3 = $150 / $1000 = 15% → 15% × $750 = $112.50 (remaining: $37.50)

Amt Remaining

The open amount of the distribution line as of the date the report is run. For outstanding balances on an invoice with multiple expense accounts, refer to the example under Total Amt Paid.

Account

The GL account used on the first line of the GL distribution.

Expense Amt

The amount from the header of the transaction.


Email, Export, or Print the Report

This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Click here to learn how to send, export, or print this report.