Sunday, 18 May 2014 10:30

Troubleshooting Manufacturing Order (MO) Receipt Posting Errors in Dynamics GP

Written by

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

When a Manufacturing Order (MO) receipt posting is interrupted, it will not allow a user to receive the MO again. If this occurs, one should first check the MO variance (Inquiry > Manufacturing > Order Variance) window within Dynamics GP. The MO variance is always a good indication as to what happened to the goods. If the MO variance has zero quantities or dollars in the consumed column, one would assume they may receive the MO.

Manufacturing Order Variance

 

If Dynamics GP provides an error informing the user that units are not available to be received when attempting to receive the MO, one should check the database. To do this, run the following SQL statement:

select * from MOP1000 where MANUFACTUREORDER_I = 'MO number'

Check if there are quantities in the QTYRECVD and QTYSOLD columns. Since posting is interrupted, it may have created values in the QTYRECD column and hence the MO cannot be received.

mo
Update the MOP1000 table and set the QTYRECVD back to zero. This will allow you to receive the MO.

Katrina She, CMA, Application Specialist, This email address is being protected from spambots. You need JavaScript enabled to view it.

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.