Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
May 2020
May 2020
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
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
Solved! Go to Solution.
May 2020
May 2020
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:
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.
May 2020
May 2020
That is very helpful!!!! - now if only it could add "committed" to that list and it would be perfect. I had no idea you could do what you have shown me.
Thank You again...
May 2020
May 2020
Hi @jayemee
The committed column is not able available column for the Item List window, only the Only Hand one will show the item quantities. You would need to review the individual item for that record or run the Analyse Inventory report for that committed numbers.
Note: You can also do a similar thing to the Card Lists window i.e. add different columns, advanced searching, copying to clipboard...
1
|
154
|
|||
41
|
3129
|
|||
7
|
747
|
|||
1
|
591
|
|||
1
|
362
|