Inventory of Consumables - Trouble Shooting
Roger Wiese
Last Update 4 năm trước
When your Stock On Hand is not what you expect...
The best way to troubleshoot an inventory issue is to use the Inventory Transaction Report.
By using Grouping and Filtering and Summary options for the report, you can see all the stock movements (Transaction Types) for a consumable and in the Summary, see the calculated stock on hand.
In the report filters, choose a date range that you know will capture all records to do with your troublesome consumable.
Set the consumable type filter as well, to reduce the number of records being fetched. After generating the report, use the column filters to focus in one the consumable (and batch number and/or location ... as required). All the facilities exist for you to find your problems.
The Transaction Type column will guide you in your search for the problem(s)
All consumption records that were successfully recorded will be listed with the Transaction Type of "Consumption". You will also see that the Date column has a hyperlink to view the actual record where the consumption took place.
Where you see "Opening Stock" as the Transaction Type, that is indicating that your report start date was after the initial purchase record, so you might want to reset the Start Date to include all records in the system for a given consumable. HINT: To see the initial record or purchase record for all consumables, run the Original Purchase Records report (See below)
If you want to see the Calculated Stock On Hand for one or more consumables in this report, simply Group By Consumable, then Show Summaries
Original Purchase Records report
