2022.1.5 Parts shortages / Parts receipt alerts

Hello all,

Looking into ways to make the scheduling side go a little quicker in regards to parts shortages… so I could use some help.

  1. Something I can create for the receiving team, so they know that a part they just received is short on a job. We rarely order parts to jobs or orders, so many are received to stock without the production side always being aware that the part came in.

  2. Something I can create for me that pulls all parts that were received in today. Again, this would be for me to verify that of the parts we received today, which are needed on jobs. This would still take a bit of manual work, that I’m hopeful I can eliminate with some research and test.
    2a) Have those receipts compare to current inventory, demands, or just shortages

  3. A report that could be run to calculate the quantity of a build that could be completed with current inventory. (Do I have enough material to build all 5, or just 1?)

  4. Shortages by supplier. I’d like to see what we’re missing from certain suppliers, with part numbers, quantities left to receive and due dates. This way I can try and combine parts when I ask where parts are, rather than finding additional parts after the fact and having to send multiple emails.

Sorry, there are multiple questions here. Feel free to comment on each number or all of them.

Thanks again!

For 1 you could use the Cross Dock functionality. That allows you to allocate part of an Inventory PO line to a job. So, if you are receiving 10 pieces, you can flag 3 for a job and that will provide some kind of indication at receipt. I have not used the functionality in a few years, so can’t remember exactly how the notification works.

Thanks John.
I’ll dig into that some. I run through what I’m short a few times a week, notating when the next PO is due in the comments. If I just went to that PO and marked a few parts to a job, that would definitely get me somewhere.