Locked Orders 1

[Borvik]

I have a problem with locked orders. I'm not entirely sure how it happened - whether it be a power outage while entering or something else, but it is a problem. Here is a screenshot of one of those orders.

http://borvik.gotdns.com/screens/LockedOrder.bmp

Any ideas on how to go about fixing this?

 

[Luvsql]

We have these kind of orders a lot as we run in a citrix environment and everytime a user is disconnected, the data gets stuck in mid-entry and we end up with a lot of data corruption.

When you enter an order, Great Plains does not enter any information into the SOP10100, other than the SOPNUMBE and SOPTYPE until the order is saved. Ie you can start an order, enter the customer, batch, po number, enter some line items, but only the Sopnumber and Soptype appear in the SOP10100. Once you save the transaction, GP updates that record in the SOP10100 table. If GP crashes etc., it does not roll back and you end up with bad data.

The worst thing about this is those items on this "corrupted" order, are still allocated and will not be removed until 1) Run checklinks to remove documents or delete via sql and 2) run reconcile in inventory.

 

[Borvik]

I have seen some talk on the internet about users having to be logged out to do some stuff. Do they have to be logged out for either checklinks or reconcile?

 

[Luvsql]

For checklinks on the Sales Transaction Work, no users can have the SOP Entry window open. For the inventory reconcile, not users can be accessing inventory, therefore no SOP, POP or Inventory entry windows can be open.

 

[Luvsql]

It also may not run if GP thinks transactions are open such as stuck batches in the SY00800 table.

 

[Borvik]

Thanks Luvsql, I tried the Check Links on our Test DB, and am currently running Reconcile on the inventory - it looks like it's going to work, and I'm pretty sure we have some stuck orders in there too... so.

Thanks for the help.