I have a BPM that we are trying to implement that will stop the user from receiving a part to stock if the job is supposed to be Make to Order.
Initially I raised the exception when the part on the job had the Non-Stock Item checked. Turns out we use that flag for both Make to Stock and Make to Order jobs.
The simple answer seems to be to look at the MakeToType on the job, however I cannot find a way to put that in my BPM query.
Does anyone have any thoughts or suggestion on how to overcome this?
Iām using a pre-process on the ReceiveMfgPartToInventor.ReceiveMfgPartToInventory and am trying to write a condition statement that will check for āsomethingā to see if it is a MakeToStock or MakeToOrder job.
The Job type only allows me to check if it is a MFG job which both MakeTo types would be MFG.
I donāt really know what I am talking about here, But I might have some ideasā¦
After poking around in the Field Help while looking at the Job Tracker form, I see the following descriptions.
On tab: Job > Make To Stock > field Warehouse. The description reads:
Inventory warehouse that job is producing for.
Only relevant for build to stock demands (ordernum = 0). In this case a valid Part must be referenced.
And on tab: Job > Make to Order field OrderNum. The description reads:
Related sales order number. For build to stock demands the OrderNum, OrderLine and OrderRel fields are all zero
This leads me to believe that your āmake to stockā jobs should have 0 in OrderNum,Line and Release. As well as a warehouse filled in. While, āmake to orderā jobs will have some order number, line number, and release number filled in. The āMake to orderā jobs may not have the warehouse filled in. All of these fields are available in JobProd. Does this help get you any closer?
Good luck!
Nate
Happy to help! It would be nice if one of the millions of fields included in these tables was for make to stock/make to order/make to job. It would make things a little simpler.
