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

Annunci

Rispondi

Inserisci i tuoi dati qui sotto o clicca su un'icona per effettuare l'accesso:

Logo WordPress.com

Stai commentando usando il tuo account WordPress.com. Chiudi sessione / Modifica )

Foto Twitter

Stai commentando usando il tuo account Twitter. Chiudi sessione / Modifica )

Foto di Facebook

Stai commentando usando il tuo account Facebook. Chiudi sessione / Modifica )

Google+ photo

Stai commentando usando il tuo account Google+. Chiudi sessione / Modifica )

Connessione a %s...