Running the INV04 – Inventory Valuation Report
Note: This report should ideally be run & saved at the end of the month after the last day of trading for the month has been completed. Do this & then roll Inventory in the ledger.
- To run this report go into Cognos (Reporting Portal)

- Click on Team Content

- Click on Franchisee Reports

- Click on Inventory

- Select the INV04 – Valuation Report

- The report selection will appear

- Leave all as is except change the “Detailed or Summary” to Summary

As well as choosing your store/warehouse by clicking on it to highlight it

- Then select Finish which is down the bottom left of the screen

- Your report will now show

- In the bottom left corner, click on Bottom

- Then Click on Page Up

- This will now show you the total value of your Inventory as at that point in time

- Make sure to now Save this report as it can’t be reproduced at this date again
To save this, go to the little Right Arrow (looks like a Play Button) near the top Right

- You have several options to choose how you want this document, whether as an Excel spreadsheet or a pdf document for example

- If you select Run Excel, it will download an Excel file for example, it will download to your downloads, go in and save this to a Inventory Folder somewhere on your computer/drive

If you select Run PDF, then it will take you to a screen where you can Print or Download the file

- Once you have done this & saved this report somewhere, you can now go and roll the Inventory Ledger