Manufacturing execution and Advanced warehousing in Microsoft Dynamics 365/AX
August 9 2019
Manufacturing execution functionality in Microsoft Dynamics 365 for Finance and Operations (D365FO) and Dynamics AX handles the registration of actual hours for Production order routing operations. Theoretically a production order can go through Start and Report as Finished (RAF) status by just using the registration functionality. With the arrival of Advanced warehousing in AX 2012 R3 the situation has become a little different.
Controlling the “Start” and “RAF” status for production orders via Time registration terminals requires the right parameter settings. In all cases, the Release will have to be done by the production office or supervisor.
Without release, a production order will not show up in the registration terminals (Job card Device or Job card Terminal).
Let’s see how the “Production order defaults (by site)” make it possible to manage the “Start” and “Report as Finished” status via the time registration terminal.
The parameters are found in Production order control/Setup/Manufacturing execution/Production order defaults (by site)
The parameters in this area control the behavior of production orders during the time registration process. They are valid for all users (in a site or in a company). The settings in “General” are not relevant for this blog.
Settings in the “Start” section
The biggest decision is the first parameter “Update start on- line”.
For real time production order status, it makes sense to have the value “Status + quantity”. The process will be straightforward. The production office (the supervisor) releases the production order. The first registration worker that starts working on operation 10 of this order automatically starts the production order with the quantity entered for operation 10.
This means that any Production BOM materials that have a flushing principle “Start” will now be backflushed.
With Advanced Warehousing, what is different with the automated “Start” process of a Production order in manufacturing execution?
The key difference with Advanced Warehousing is that we now are dealing with a “picked” status for each Prod-BOM item.
At release time or via a batch the system creates Warehouse work for “raw material picking”. This warehouse work will change the inventTrans status of each Prod-BOM line to “picked”. Without advanced warehousing the status ‘picked” was never used for Production order BOM materials.
After picking, the items still have to be “deducted”. Only using the flushing principle “Available on location” guarantees that the system only deducts the items/quantities that were picked. If we use the principle “Start” with advanced warehousing, we will run the risk of errors when not all items in the Prod-BOM were picked and we start the Production order with “Flushing principle” in the Bom-consumption field. “Available on location” is called this way because the Warehouse picking work has put the picked items in the put location which is the input location of the Resource group of operation 10, or to which operation the materials were linked. The items are “available in the input location of the Resource group”. The completion of the warehouse picking work moved them from their warehouse storage location to that put location that is the “input location” in the Resource group. They are now sitting there, ready to be backflushed.
General tab of the Resource group showing the Input location.
When using Advanced warehousing with Production orders, use the flushing principle “Available on location” on the BOM lines and make sure that the resource group in the routing operation has an input warehouse and an input location. With advanced warehousing, the flushing principle “available on location” is the only principle that is aware of the status “Picked” in the inventTrans table and will only flush (= deduct from inventory) what was picked. If we would use the principle “Finish”, we would have an issue just like we would have with “Start”. If not every item was picked yet, the system will not see that and will try to backflush all items with principle “Finish”. The principle “Available on location” will politely flush (= deduct) all inventory that had been picked and put the picked quantity into the input location of the Resource group.
NOTE
If we have to pick additional items later for the same production order (because some items arrived later), the system will almost instantly create and post a picking list after the warehouse picking work has been completed. (it takes a few minutes). This avoids having to manually post additional Picking lists for a production order. The parameter setting shown in the screen shot below will make this happen. It is the standard setting for backflushing, nothing special.
- Automatic BOM consumption: Flushing principle (which will be “Available on Location” which works like “Start” with the important difference that it will only flush what is in status “picked”.
- Post picking list now: This is obviously a Yes.
As always, we avoid the “End-mark picking list” and “Physical reduction”, “Pick negative”, and “Complete picking list journal” parameters like the plague (End-mark = yes would say that we will have no more picking for this Production order, “physical reduction” reduces the quantity on the Prod BOM to whatever we happen to have on-hand, Pick negative would only work if we allow negative physical inventory in the Item Model group, which we typically do not and “Complete” is creating a picking Journal for all lines in the Prod-BOM regardless their pick status or their on hand availability which would disrupt our process).
Now we will discuss the next fast tab in the Production order defaults (per site), “Operations”.
Settings in the “Operations” section
Learn more about us here
Mfg Execution with Adv Warehousing
Great write-up Evert, as always!!!
One short question
Really a great post! Thank you very much for these insights!
Just one question. You mentioned that the report as finish and quantity parameter settings work for the mobile menu item RAF and putaway! What about the RAF menu item without the putaway, where we create the putaway work so that a different warehouse worker can execute it at a later point in time? I was in the opinion that always only the flushing principle on the the BOM item line is used with both mobile device RAF menu items?
Later putaway
Jurgen
I realize that you can postpone the putaway, I have never tried that. As far as quantity validation, that will happen after the license plate has been generated and you click OK.
That is when the pick is created. When End job - yes it will then have checked the quantity of RAF against the started quantity and against the reported quantity in the Routing card(s). I am not an adv whs expert I only learned what I needed to learn to handle production. I am going to try it. Flushing principle does not care which menu item you use, but I am going to test that. Thanks for the question, I will have to add a paragraph on this topic to the blog I think.
Later putaway
Jurgen
I realize that you can postpone the putaway, I have never tried that. As far as quantity validation, that will happen after the license plate has been generated and you click OK.
That is when the pick is created. When End job - yes it will then have checked the quantity of RAF against the started quantity and against the reported quantity in the Routing card(s). I am not an adv whs expert I only learned what I needed to learn to handle production. I am going to try it. Flushing principle does not care which menu item you use, but I am going to test that. Thanks for the question, I will have to add a paragraph on this topic to the blog I think.
Great post
Sorry i have a question, when I try end the production order gave me this error Active job registrations or journal registrations exist on production in Manufacturing Execution. Is there are any work arround for not approve and transfer the journal tasks?
cannot end prod order
We wish , no, there is no way around this.
Time and attendance hours NEED to be calculated, approved andtransferred to Payroll . if not, you cannot end the prod order.
We added an IDEA in MS database to make the error you get mention in detail WHICH worker WHICH date it is talking about becuase you have a lot of look up to do before you find ou WHO and WHEN did these hours so you know where to approve and transfer.
RAF whith serial number
Thanks for the post. Can you help me to configure RAF with serial number, the "plus" that I have is the Serial number group is set up in manual.
I need to report with the Whs APP.
Thanks.
Warehouse for Prod Inputs / Outputs?
Great article!
Quick question: You mention: "make sure that the resource group in the routing operation has an input warehouse and an input location" - do you Need a Sperate input warehouse or can you just use an input location, and similarly for the outputs, would you recommend they be dropped into a separate warehouse or just a location?
Input warehouse
Absolutely not. Just a location. You can take your same good olde warehouse .I would say normally the main warehouse is used here. Output warehouse is not used in advanced warehousing functionality. You can leave it blank or not , it does not matter. The output warehouse is for the Kanban functionality.