Downgrade Production Order Status

Downgrade Production Order Status

Sometimes it is required to perform a status change of a production order that was advanced by mistake .. maybe the error is related to many orders …. With NAV (standard) it is not possible to do.

ERROR: “FIRM PLANNED IS NOT A VALID SELECTION”

DOWNGRADE TEST RELEASED TO FIRM PLANNED

 

However, in order to do this without disturbing SQL Scripts, you can change the state by working only on some tables.

SCENARIO

The order should not have been advanced.

I do not recommend reopening a finished order (obviously there are good reasons for various cost problems, traceability, output and consumption, work account etc.)

… If an order is made by mistake, you can reopen it. For example, re-open an released order and return it to a confirmed state.

WORKAROUND

Below you will find a report that allows you to change the status of a production order (in this case from a RELEASED to CONFIRMED)

REPORT REQUEST PAGE

VARIABLESTABLES TO CHANGE

SAMPLE CODE

Etc..

Have a nice ORDER STATUS CHANGING !

Downgrade Odp to Firm Plannerd Orders.zip

Leave a Reply

Your email address will not be published. Required fields are marked *

3 × 5 =

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enjoy this blog? Please spread the word :)