Dynamics GP Order Receipt Glitch? Here's What To Do

Table of Contents

Dynamics GP Order Receipt Glitch? No Sweat! Here’s the Fix!¶

image just illustration

Ever get that annoying “You can’t create a receipt for this manufacturing order. Another user or process is editing it.” message in Microsoft Dynamics GP? Ugh, talk about a workflow killer. Don’t worry, you’re not alone! This guide will walk you through some common causes and solutions, so you can get back to business.

Understanding the Dreaded Error Message¶

This error typically pops up when you’re trying to create Manufacturing Order Receipts, and it can really throw a wrench in your operations. It might legitimately happen if someone else is running MRP (Material Requirements Planning) at the same time. However, it can also rear its ugly head if an MRP process crashed and left some data hanging around in the system, causing a digital traffic jam.

Clearing the Roadblocks: Step-by-Step Solutions¶

Here’s the good news: there are some pretty straightforward fixes you can try. Let’s break them down:

1. Check for Stuck Security Records¶

First, let’s do a little detective work. A stuck security record might be the culprit. Head over to these windows in Dynamics GP:

• MRP Security: Transactions > Manufacturing > MRP > Security
• MRP Planned Order Security: Transactions > Manufacturing > MRP > MRP Planned Order Security

Look carefully – is there a record stuck there even though nobody’s actively running MRP? If so, removing that stuck row of information might just do the trick. Think of it as clearing a rogue shopping cart from a checkout line.

2. SQL Script Cleanup¶

If the security windows are clean, we can try a more direct approach using SQL. This assumes you’re comfortable running SQL scripts. Fire up SQL Query Analyzer and run this little snippet:

delete tempdb..DEX_SESSION where session_id not in
(select SQLSESID from DYNAMICS..ACTIVITY)

delete tempdb..DEX_LOCK where session_id not in
(select SQLSESID from DYNAMICS..ACTIVITY)

This script helps clean up any lingering session or lock information that might be causing the issue.

3. Checking MFG Table Flags¶

If you’re still hitting a wall, let’s dive a little deeper into the database. Run the following select statement against your company database in SQL Query:

select * from mops0100

Key Columns to Check:

Focus on the REVAL_IN_PROCESS_I and RECONCILE_IN_PROCESS_I columns. If either of these is set to 1 instead of 0, that could be the source of your frustration. Important: Before you make any changes, double-check that no one is currently running a revalue or reconcile process!

Updating the Table (if necessary):

If those columns are indeed set to 1 and you’ve confirmed nobody’s working on a revalue or reconcile, run these update statements:

update mops0100 set REVAL_IN_PROCESS_I = 0
update mops0100 set RECONCILE_IN_PROCESS_I = 0

This essentially resets those flags, and hopefully clears the error.

Prevention is Better Than Cure: Tips to Avoid Future Glitches¶

While these solutions can help fix the immediate problem, here are a few tips to minimize the chances of this error popping up again:

• Regular Maintenance: Just like a well-oiled machine, your Dynamics GP system needs regular maintenance. Ensure you have a good backup and recovery plan, and consider scheduling regular checks for database integrity.
• User Training: Proper training for your team on using Dynamics GP can significantly reduce the likelihood of accidental interruptions or improper processes that might lead to these kinds of errors.
• Monitor MRP Processes: Keep an eye on your MRP runs. If they fail frequently, investigate the root cause to prevent data corruption.

Still Stuck?¶

Sometimes, even the best troubleshooting steps don’t solve the problem. If you’ve tried all of these solutions and you’re still seeing the error, it’s time to call in the cavalry. Reach out to Microsoft Support or a qualified Dynamics GP consultant. They have the expertise to dig deeper and resolve more complex issues.

We hope this guide has been helpful! If you have any questions, tips, or other solutions that have worked for you, please share them in the comments below! We’d love to hear from you. And remember, a smooth-running Dynamics GP system is a happy Dynamics GP system! Come back anytime for more helpful tips and tricks.