Stock Usage Report
Savannah Ryan
Last Update 2 tahun yang lalu
The Stock Usage Report is a crucial tool within the inventory system. Unlike the Activity Report, which relies on users remembering to record activities, this report calculates usage based on actual stock counts. It is an effective means of identifying unrecorded activities with the help of accurate stock counts.
How the Report Works:
The report utilizes opening and closing stock count values, considering purchases to calculate actual usage during a specified period. It can also work with On Hand system values on selected dates, provided regular stock counts are conducted to ensure accuracy.
Working with the Report:
There are three key steps to effectively using this report:
1. Ensure Accurate Stock Counts and On Hand System Quantities:
It is vital to confirm the accuracy and completeness of opening and closing stock counts or, if using system-generated On Hand stock values, ensure their correctness. Stock counts can be scheduled using the app or printed count sheets, recording and updating the system with correct stock quantities. Mini stock counts using the app can provide ongoing assurance, but a full stock count every six months is recommended.
2. Creating a Stock Usage Report:
As the Usage report uses opening and closing stock quantities, we need to choose an opening stock count report and a closing stock count report.
If the On Hand system quantities are accurate, we can instead select opening and closing dates:
3. Working with the Usage Report:
Once created, the report displays all stock used between selected dates.
Detailed activity during the period can be viewed by clicking on a stock name or the "+" sign on the left.
This information aids in operational analysis.
The report is also valuable for preparing and validating proforma FP34 reports. Usage numbers in the "Used" column should be accurate if stock counts are correct. This allows for agreement with printed scripts to identify missing scripts.
If App usage recorded throughout a month, date and times will be displayed; otherwise, Global Adjustment figures may appear, originating from stock count adjustments in the Stock Count Report.
Note: If adjustments are made to the Stock Count Report or On Hand system figures after creating a Usage report, consider refreshing the report for accuracy.
For more information on stock counts, refer to your Stock Count Report Guide.