Vendor Analysis
  • 08 Jul 2024
  • 4 Minutes to read
  • Dark
    Light
  • PDF

Vendor Analysis

  • Dark
    Light
  • PDF

Article summary

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

To navigate to the Vendor Analysis Report, click 'My Reports' under 'Reports' in the left pane and then select 'Purch. & Inv.' in the top header of the reporting window. Once opened, a listing of reports will be shown. 

Find 'Vendor Analysis' and select 'Customize' next to the report. This will open up a listing of all Report Parameters that can be set to pinpoint the exact report a User needs.


Report Parameters

  1. Filter By - A listing of all Location categories

  2. Filter - A listing of all Locations associated with the selected Location category 

  3. GL Date - This option will either show or hide the GL Date on the report

  4. Start - The beginning date that the report is ran for

  5. End - The end date that the report is ran for

  6. Vendor - A listing of all Vendors

  7. 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. Click here to learn more about this functionality

Click here to learn more about Report Views and their added functionality.


Report Columns

  1. Gross Purchases - The sum of invoices, not including Credit Memos or Discounts

  2. Number of Invoices - The count number of invoices from the Vendor

  3. Average Invoice Amount - Gross Purchases divided by the Number of Invoices

  4. Discounts Taken - The sum of discounts taken when a Payment is processed (does not include Credit Memos)

  5. 1099 Amount - The total amount recorded as tracked for 1099 processing

  6. Last Invoice Date - The date of the most recent Approved invoice

  7. Last Payment Date - The date of the most recent payment

  8. Document Date - The date listed on the invoice

  9. 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

  10. 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 its document number

  11. Type - The R365 assigned transaction type

  12. Legal Entity - The name of the Legal Entity assigned to the Location on the header of the transaction

  13. 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

  14. 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

  15. Document Amt - The total amount of the invoice

  16. Date Last Paid - The date of the most recent Payment or Credit Memo applied to the invoice

  17. Payment Ref - The R365 number (document number) assigned to the Payment or Credit Memo that was most recently applied to the invoice and should be the same record used in Date Last Paid

  18. 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. For example, an invoice with a total of $1000 is partially paid in the amount of $750. This payment will be applied to the entire invoice, but is distributed among 3 separate accounts:

    • GL Account #1 = $350 / $1000 = 35% x payment of $750 = $262.50, leaving a remaining balance of $87.50

    • GL Account #2 = $500 / $1000 = 50% x payment of $750 = $375, leaving a remaining balance of $125

    • GL Account #3 = $150 / $1000 = 15% x payment of $750 = $112.50, leaving a remaining balance of $37.50

  19. Amt Remaining - The open amount of the distribution line as of the date the report is ran. For outstanding balances on an invoice with multiple expense accounts, review the Note above for the 'Total Amt Paid' Column

  20. Account - The GL Account used on the first line of the GL distribution

  21. 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.


Was this article helpful?

What's Next