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.
- Open the Reports app.
- Navigate to My Reports.
- Enter all or part of the report name in the search bar.
- The Results tab will open with the list of search results.
- 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.