Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Gina Lopez]

An error was made on the quantity of output posted against a Production Order. The order is now in Finished status. Is there a way to “reopen” the order so that the correct amount of output can be posted? In this particular case, the actual quantity is more than what was posted on the order.

We are using version 2013 R2.

Thanks!

——————————
Gina Lopez
GU Energy
——————————

[Eduardo Diaz]

Hi Gina,
Up to a few years ago, there was no out-of-the-box solution. We had to ask our partner to create such a tool. It reopened the order so that we can adjust consumption, output, labor, etc. I don’t think Microsoft has added this feature in the last NAV releases.
Regards,

——————————
Eduardo Diaz
IT Director
Minequip Corp.
Miami FL
——————————
——————————————-

[Theresa Davis]

We’ve had this happen a few time in 2013, as well. 

We just did an item journal to increase the quantity by what it should have been.  We also let the accounting team know that this is what the adjustment was for.  They’re kind of finicky about adjustments.

——————————
Theresa Davis
Applications Analyst
Group O
Milan IL
——————————
——————————————-

[Rick Dill]

Agreed, NAV does not have an out of the box solution that will let you reopen a finished production order.

——————————
Rick Dill
Consultant
ArcherPoint Inc.
Waupaca WI
——————————
——————————————-

[Ben Baxter]

There is currently no way to re-open a Finished Production Order.  Adjustments after would need to be processed through an Item Journal adjustment.  I would suggest using the Production Order Number as the Document No. for the adjustment to help identify why the changes were made.

——————————
Ben Baxter
Consultant
Accent Software, Inc.
Carmel IN
——————————
——————————————-

[Kristina Frank]

Hi Gina,

This happens to us more often than it should.  As noted in a previous response there is no way out of the box to reopen a finished production order.  Here is our work around, but keep in mind it will only work if the output is still in stock.

We create a new production order for the correct quantity and consume the output quantity of the item into the new production order.  This will bring in all the cost and remove the incorrect quantity from inventory.  When you close the production order, you output the correct quantity and the unit cost will be recalculated.

Let me know if you have additional questions.

Thank you,

——————————
Kristina Frank
Controller
Cline Tool & Services
Newton IA
——————————
——————————————-

[John Grant]

Gina –

To add to the discussion sometimes the issue is the process. What I mean by that is I often see the consumption of components on the Production Order setup as “Backflush” without using Routing Link Codes. Resulting in the components not being consumed on the Production Order until the Status is changed to Finished. This process creates an artificial rush to Finish Production Orders particularity at month end.

Setting up your Production Oder to Backflush components with Routing Link Codes will remove the “rush” to Finish Production Orders. Components will be consumed as you post Output. A basic process would be assign all Backflushed components to the last operation which is where you post  finished quantities.

Using this process allows time to detail review Statistics on Production Orders to catch errors before Finishing the Production Order. I will qualify this process as sometimes the component quantities may not be moved/updated in NAV to the staging production bin in a timely fashion (Second shift is always a challenge) which will prevent posting the output and lot/serial tracking is always a consideration.

Lastly the question may come up if I am responsible to “Finish” Production Orders how do I know which Production Orders to review and Finish. One option is to use the Routing Status code on the last operation. When posting the final quantities using Production Output mark the last Operation as Finished. Then setup a Queue that reflects all Released Production Orders with the Last Operation marked as Finished. The Queue  is not out of the box NAV and requires a little development.

Sample screen shot of the field to mark when Production reports the last Output on the last Operation
This field will update routing line status to Finished and a side benefit will remove any expected qty excess component material from planning worksheets

Best Regards

——————————
John Grant
Senior Application Consultant
Innovia Consulting
——————————
——————————————-

[Alex Apodaca]

Hello Gina,

Use the Output Journal and post a negative quantity against the Prod Order number to bring it to the correct output amount. Then use the Consumption Journal to do the same for any extra components that may have been over-consumed. To fix the inventory side of things you may have to do on-hand asjustments.

——————————
If my response has helped you please mark the answer.

Alex A
Consultant
San Diego, CA United States
——————————
——————————————-