Share
ReportWe have a situation where in the middle of a manufacturing receipt entry against an open manufacturing order that is consuming serialized sub assemblies the computer system lost power. We are unable to recover the incomplete transaction and the sub assembly serial numbers are no longer available to be selected in the manufacturing receipt window.
Doing a quick look at the database I can see:
- The MOP_RECIEPT_MSTR table has an incomplete record for the interrupted manufacturing receipt
- The MOP_PENDING_SERIAL_LOT table has entries for the serialized sub assemblies that are no longer available to be received.
- The MOP_RECEIPT_DETAIL and MOP_RECEIPT_DETAIL_SERIAL_LOT tables do not have any entries for the incomplete manufacturing receipt.
Looking at the MOP_RECEIPT_MSTR table I can see 77 incomplete records - so apparently there have been problems in the past surrounding incomplete receipts.
The question is how do we recover or clear the incomplete manufacturing receipt? Checklinks did not identify any issue. Is there another way within Dynamics GP to do this or do we have to resort to SQL scripts to fix this?
Thanks in advance.
Regards,
Ron
*This post is locked for comments
All responses (
Answers (
291,269
