COGS Analysis by Vendor

Prev Next

The COGS Analysis by Vendor report runs the amounts of specified COGS types for designated vendors over a selected period of time. This report compliments the COGS Allotment report because it provides further analysis into the COGS Types and the cost of each item by specific Vendor. The vendor listings also allow the User to dig into the COGS by including hot links to the invoices associated with each type amount.


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

Start Date

The beginning date for the report.

End Date

The end date for the report.

Location

A listing of all locations.

Show Unapproved

This option allows unapproved invoices to either be included or excluded in the report.

Detail Level

Clicking 'Summary' will run the report without expanding the vendor details.

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

Vendor and Invoice Number

An alphabetical listing of all vendors and their hyperlinked invoices from the selected date range.

Invoice Date

The date of the invoice.

COGS Types

The COGS types are listed here within their own columns to provide purchase details. In each column, the plus sign enables a user to expand the details within the COGS type to see the costs associated with each GL account.

Total

The total amount of each row. The vendor row will total all of its invoices.


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.