Hello,
I was asked to provide the usage of materials for the next 8 days. The idea would be to have a vision of current stock, vs usage and be able to have a daily “picklist” view for the stockroom personnel to transfer the daily need of materials for the jobs.
Kind of an Internal Kanban I guess…
So before I spend hours on that I was wandering if it exists somehow? I have looked at the picklist report but it is for the full job… and we need to have a daily need…
Pierre
Maybe the Time Phase Mtl Requirements report - with a custom style?
How about Job Pick List?
It provides the whole job requirement, not a daily requirement if the job span over a few days…
Hmm… run the production planner workbench process for 1 day out and then use the all parts tab in the production planner workbench? Might not work if you don’t issue material complete from the prior day since you can’t do a date range, only a cutoff day.
I was going to suggest the same thing as @JennL… the Production Planner Process can be run for a period of time, and then you look at the production planner workbench and you can see shortages, shortage jobs, shortage materials, etc. it is quite a useful dashboard (and probably one of the more unutilized ones).
A finding of ours is that the Production Planner Process uses the job start date to determine shortages, instead of the date an item is consumed at it’s operation. Not a big deal for some plants, but if you have looooong lead times, the Production Planner Process muddies up the picture by identifying items as shortages that arrive after job start date, but before the operation that consumes the item is scheduled to occur.
I have struggled with the settings on the process to try to alleviate this (as it would be an extremely valuable tool for us), but have not yet been able to find settings that overcome this limitation.
@Hogardy Looks like there isn’t an easy way, but I’ve been contemplating the same request on our end. We’re a totally custom shop, and without a dedicated material handler to dole out all the material for a shift, our team is left wondering what is needed and if it’s been delivered or not.
I’ve been thinking that each job has a run qty, material required qty, and estimated time after you do GetDetails(). Those three will give you a an estimated consumption per time period - so you could figure out the material qty required for an operation of a certain estimated duration.
Then you need a query to find all the operations with a start date of today/tomorrow/next 8 days, and use the math to figure out how much material should be delivered to each work center for those operations. I think it could be rather simply with a one-level BAQ…
Have you looked at the Job Fulfillment section of the Fulfillment Workbench?
This may be useful for this purpose also.