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

Visit Website View Our Posts

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, katrina.she@websan.com

Leave a Comment

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

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

Show Buttons
Hide Buttons