Edit Closed MO Description

(0) Share

Report

Posted on by sherrera

I'm trying to determine if it's possible to edit the description field on MOs after they've been closed. We use that field to record the batch number for the year and I've mis-numbered one of our products; it's not a huge deal but it would be nice if I could correct it. As far as I can tell it's not possible, but I'm hoping that maybe there's a back door or something I don't know about.

Thanks for any help!

Categories:

Microsoft Dynamics GP

All responses (1)

Answers (0)

Suggested answer

Angela Eckman Ebens... 1,216 on at

Like (1)

Report

RE: Edit Closed MO Description

Hi,

Unfortunately, there is no way to update the MO description via the front end once the MO is closed. If you are good with SQL, you could update the field in the table to be what you need. The table is the WO010032 and the field is DSCRIPTN. Below is the example update script. Always make a backup before running anything in SQL or do this in a test company. Where you see XXX you would put in the description you would like to have and where you see MONUMBERXXX you would put in the MO number you would like to update.

Example:

UPDATE WO010032 SET DSCRIPTN = 'XXX' WHERE MANUFACTUREORDER_I = 'MONUMBERXXX'

Hope this helps!

Thanks for using community forums!

Angela Ebensteiner

Sr Technical Advisor

Microsoft