Inventory Custom Report
We use a perpetual inventory system and I am trying to customise a report. I was wondering if anyone can help me get the correct information.
In Reports - Analyse Inventory (Summary) it shows me the details for Inventory including
- On Hand
- Committed
- On Order and
- Available
I would also like it to show me the "Minimum Level for Restocking" number. This is the alert amount I enter into the Auto-Build area of the item.
The Analyse Inventory (summary) only shows me how much stock of a particular item needs to be packed EG: CTS20 on hand = 50 bags, committed = 55 bags, 0 on order and therefore -5 Available, therefore it shows you need to pack 5 bags to complete the orders.... But we need a minimum level packed to 70 at the beginning of each week. So I need to report to show me that 75 bags need to be packed this week to bring the level back up to 70... (does that make sense..?). (this is obviously using simple numbers to make sense).
On a side note, I don't really see where the 'minimum level for restocking alert" comes in.. Even if you go to the To-Do List and stock alerts - it doesn't tell you that minimum number ???
Would love some help in this area!
Thanks
Hi jayemee
The Minimum Level for Restocking Alert information is pulled from the Item's Buying Details tab (Inventory>>Item Lists>>Choose the required item>>Select the Buying Details tab>>Minimum Level for Restocking Alert).
In terms of getting that Minimum Level for Restocking Alert information on a report, it will not appear on the Analyse Inventory [Summary] or [Detial] report. The value is set to be a non-reportable field. You could, however, added it to the Item List window and if necessary copy out that list information to combine with that Analyse Inventory report in Excel.
To add that field to the Item List Window:- Go to Inventory>>Item Lists
- Right-click on the column headers i.e. the word "Name"
- Choose Column Chooser from the list
- Drag the Min. Reorder Quant. from the list into the required position
By doing this it will add that information to the Item List window so you can sort, filter, search... using that information. You could also right-click on the table and select Copy List to Clipboard. This will copy what is seen on screen to the Windows Clipboard so you can paste that information into Excel or a similar application.