Skip to content

Reversing the Entire Production Order Consumption in Microsoft Dynamics NAV 2013

(Without Keying in the items One by One)

ArcherPoint How-To Blog: Step-by-step instructions on how to perform specific tasks in Microsoft Dynamics NAV

Occasionally there is a mistake made where Production Order Consumption is posted. It is quite easy to fix the problem if there are only one or two lines that need to be reversed, but what if the entire consumption needs to be reversed for tens or hundreds of items on a single Dynamics NAV Production Order?

Here is an example of a Released Production Order for a Bicycle in NAV 2013:

Released Production Order for a Bicycle

Figure 1 - Released Production Order for a Bicycle

You can use the Dynamics NAV Consumption Journal to Calculate and Post the consumption for the Production Order:

Calculate and post the consumption for the Production Order

Figure 2 – Dynamics NAV Consumption Journal to calculate and post the consumption for the Production Order

After the consumption is posted, you realize the consumption was posted for the wrong order, and you need to reverse all of the consumption for this order.

You could open up the Consumption Journal and type in all of the items and the quantities. This might be OK if there were only a few lines, but what if there were a hundred?

Here is the trick:

Open up the Consumption and then select “Calculate consumption”. Simply select “OK” and let it calculate. The trick is to select the calculation based on “Actual Output”:

Set the calculation based on “Actual Output”

Figure 3 – Edit the Consumption Journal->Calculate Consumption and set the calculation based on “Actual Output”

Now, when using Actual Output, you can see that the quantities are all negative:

Consumption Journal showing negative quantities

Figure 4 – Consumption Journal showing negative quantities

And you can see that the component lines of the Production Order are returned to the original state:

Component lines of the Production Order are returned to the original state

Figure 5 – Component lines of the Production Order are returned to the original state

If you would like more information on this subject or another Dynamics NAV Manufacturing subject, please contact ArcherPoint.

Read ArcherPoint's Blog Follow us on Twitter Follow us on Facebook Follow us on LinkedIn Link to our RSS feed Join us on Google+ Watch us on YouTube
Get Help Now