# Monitor Part on Hand **URL:** \ **Category:** Epicor ERP 10\ **Tags:** part\ **Created:** [April 19, 2021, 7:44pm UTC](https://www.epiusers.help/t/monitor-part-on-hand/77782 "2021-04-19T19:44:36Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Aaron\_Moreng](https://www.epiusers.help/user_avatar/www.epiusers.help/aaron_moreng/32/745_2.png) [@Aaron\_Moreng](https://www.epiusers.help/u/Aaron_Moreng)\ **Post date:** [April 19, 2021, 7:44pm UTC](https://www.epiusers.help/t/monitor-part-on-hand/77782/1 "2021-04-19T19:44:36Z")
I’ve been asked to trigger an alert (email) when a certain part is less than 25 units in inventory. I’m sure there is a native functionality for this, but we don’t use MRP or anything fancy, just manually create a PO for the new inventory when we ship out the existing. Is there a super simple way to do this? ---
**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\ **Post date:** [April 19, 2021, 7:50pm UTC](https://www.epiusers.help/t/monitor-part-on-hand/77782/2 "2021-04-19T19:50:13Z")
The details that the devil will be in are how are you determining what the min QOH should be for which parts? Do you need to know the instant the QOH drops below the min value? Or can you wait until the end of the day and get a report of all the parts that are currently below the threshold? If it is the later, just make a BAQ report, and then “print it” using a schedule, and send it via email. ---
**Author:** ![Aaron\_Moreng](https://www.epiusers.help/user_avatar/www.epiusers.help/aaron_moreng/32/745_2.png) [@Aaron\_Moreng](https://www.epiusers.help/u/Aaron_Moreng)\ **Post date:** [April 19, 2021, 7:51pm UTC](https://www.epiusers.help/t/monitor-part-on-hand/77782/3 "2021-04-19T19:51:55Z")
I think ideally what they want is when a shipment goes out for these (always in batch, usually monthly), they want to make sure they replenish soon via PO. I was thinking of monitoring the shipment itself with a BPM, if it matches the part, count up and send email? But I don’t know ---
**Author:** ![jgehling](https://www.epiusers.help/user_avatar/www.epiusers.help/jgehling/32/78990_2.png) [@jgehling](https://www.epiusers.help/u/jgehling)\ **Post date:** [April 19, 2021, 8:05pm UTC](https://www.epiusers.help/t/monitor-part-on-hand/77782/4 "2021-04-19T20:05:16Z")
You could potentially make a standard data directive on PartWhse. Youd have to subtract the values from some columns to get QOH, depending on your needs. ---
**Author:** ![Aaron\_Moreng](https://www.epiusers.help/user_avatar/www.epiusers.help/aaron_moreng/32/745_2.png) [@Aaron\_Moreng](https://www.epiusers.help/u/Aaron_Moreng)\ **Post date:** [April 19, 2021, 8:06pm UTC](https://www.epiusers.help/t/monitor-part-on-hand/77782/5 "2021-04-19T20:06:48Z")
Do you know which columns? It is for 1 particular part and use case, so I’d hate to build too much around it for this… ---
**Author:** ![jgehling](https://www.epiusers.help/user_avatar/www.epiusers.help/jgehling/32/78990_2.png) [@jgehling](https://www.epiusers.help/u/jgehling)\ **Post date:** [April 19, 2021, 8:10pm UTC](https://www.epiusers.help/t/monitor-part-on-hand/77782/6 "2021-04-19T20:10:04Z")
Ohh wait, it looks like this table already has an on hand qty column. Maybe you can just report on this when it drops below 25 ---
**Author:** ![Craig](https://www.epiusers.help/user_avatar/www.epiusers.help/craig/32/52991_2.png) [@Craig](https://www.epiusers.help/u/Craig)\ **Post date:** [April 19, 2021, 8:12pm UTC](https://www.epiusers.help/t/monitor-part-on-hand/77782/7 "2021-04-19T20:12:50Z")
You ever used the Kanban monitor? might work for something like this just as a way to monitor inventory levels for a part ![image](https://www.epiusers.help/uploads/default/original/3X/2/5/25a75967d03582311a8da2acc49fef290a9e4cba.png) ---
**Author:** ![Aaron\_Moreng](https://www.epiusers.help/user_avatar/www.epiusers.help/aaron_moreng/32/745_2.png) [@Aaron\_Moreng](https://www.epiusers.help/u/Aaron_Moreng)\ **Post date:** [April 19, 2021, 8:14pm UTC](https://www.epiusers.help/t/monitor-part-on-hand/77782/8 "2021-04-19T20:14:17Z")
Never even knew it existed, I might check that out too. They are of course looking for a spoon feeding scenario here 😉 ---
**Author:** ![Craig](https://www.epiusers.help/user_avatar/www.epiusers.help/craig/32/52991_2.png) [@Craig](https://www.epiusers.help/u/Craig)\ **Post date:** [April 19, 2021, 8:19pm UTC](https://www.epiusers.help/t/monitor-part-on-hand/77782/9 "2021-04-19T20:19:34Z")
I used to use Kanban monitor when i worked at a company that didnt run MRP. Gives a nice visual when a part is below you Kanban Min. Make sure to run through the application help. there is a little leg work for setting it up to run.