End Of Month - Running the INV04 – Inventory Valuation Report
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
Related Articles
Running the INV04 – Inventory Valuation Report
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 ...Running the INV04 – Inventory Valuation Report
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 ...End of Month - GL – EOM Detail in terms of Rolling the Ledger Periods Updated
GL – EOM Detail in terms of Rolling Ledger Periods This guide is built off the guide “GL - Understanding the Ledger Status & how to roll the Periods (Months) for each Ledger”. This is purely to explain your End of Month Process (EOM) in terms of ...End of Month Process - Includes rolling 4 ledgers
End of Month Process Please see the following guides on rolling the periods for the different ledgers. In it we suggest the timing of the rolls and how to do it. Also see the Guide on how to run the Inventory Valuation Report in Cognos (Reporting ...End of Month - GL - Understanding the Ledger Status & how to roll the Periods (Months) for each Ledger Updated
GL – Understanding the Ledger Status & how to roll the Periods/Months for each Ledger This guide will show you how to understand the Ledger Status & how to roll the periods/months for each of the 4 different Ledgers (AP, AR, Inventory & GL). To do ...