Reversing the Entire Production Order Consumption in Microsoft Dynamics NAV 2013
(Without Keying in the items One by One)
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:
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:
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”:
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:
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:
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.