Item Price Change Analysis

Prev Next

The Item Price Change Analysis report shows the purchase price as of the start date of the report versus the average purchase price over the date range of the report. It also shows the COGS usage over the same date range and the COGS impact the higher/lower price has made per item. This can be ran for one or more locations to compare item price changes across stores.

This report will alert the user to the changes in product pricing from multiple vendors on one report and how those changes impact the COGS. This will also help to point out incorrect invoice entries that can easily be drilled into by clicking on the hyperlinked item name and then the invoice via the Transactions tab.


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 list of all filter categories. Filter categories will vary based by report.

Filter

A list of filter options, determined by the 'Filter By' category selected (#1).

Start Date

The beginning date for the report.

End Date

The end date for the report.

Key Items Only

This option has the report run for the key items flagged in inventory or for all items.

Item Categories

These item categories let the user select and filter specific items.

Percent Diff

The variance percentage difference assessed.

Show Unapproved

This option will either show or hide unapproved purchases.

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

Item

A listing of the items from the item categories selected in the report parameters and organized by location name.

Location

The name of the location that is receiving the vendor items.

Default Purchase U of M

The unit of measure used on the invoice.

Price as of (Date)

The price of the item as of the start date set in the report parameters.

Date Range Average

The average price in the date range selected.

Variance

The difference between the date range average and the price as of the specified date.

Variance %

The variance divided by the price as of the specified date.

Total Actual Price

The total price of the items purchased within the price range.

Total Using (Date) Price

The total price of the item amount as of the beginning date.

COGS Impact

The impact of the using price on the COGS.

Vendor

The name of the vendor that the item came from.


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.