Microsoft Dynamics RMS (Archived)

delete holds via SQL

(0) Share

Report

Posted on by Sad

650

high;

i have many serialized items put on hold , how to delete Holds and holdentry using SQL statment.

thanks

*This post is locked for comments

All responses (12)

Answers (1)

Sad 650 on at

Like (0)

Report

RE: delete holds via SQL

thank you Antonijo ,

i will try the first solution , it is save ,and keep you informed .

best regards
Verified answer

Antonijo Todorovik 4,025 on at

Like (0)

Report

RE: delete holds via SQL

Hi again.

I'm not sure if this should be qualified as RMS bug, but it's true that it is a real case and possible situation...

Well, I would recommend You do the work in few steps:

- as Jeff recommended previously, try to pick up all transactions on hold that can be recalled correctly through RMS and cancel them (if You dont need them anymore)

- with what's left or with the transactions who are still giving You the error, can You try to find the sale transactions with the items who have been sold and are still in the OnHold transactions? If You can localize those sale transactions, before deleting anything with SQL, I would try to return the sale transaction, then recall the transaction on hold, cancel it and then do the sale transaction again... It's a lot of work, but its the correct way, as You gonna do the reverse steps...

- If this is too much work, then You have to use tSQL DELETE quieries.....ALWAYS with previous database copy and ALWAYS when the stores are closed (not sending / reciving data to / from RMS HQ). Also, this tSQL queries have to be repeted in RMS HQ Database but filtered by StoreID field, as the Transaction OnHold data is uploaded to the RMS HQ Database. As You can see, SQL deleting option is not the best, You may need to contact your support partner to do the correct steps and avoid data loss... If You still need to do it, I can prepare a step by step guide for You, but would recommend You try the first two options...

Regards, A.
Sad 650 on at

Like (0)

Report

RE: delete holds via SQL

thank you,

yes , i think that the cashier put a transaction on hold , after that one of the serialized item in hold sold by a normal transaction without recalling it from hold .

so when recalling the hold ," i think " RMS can not find the serial in database as "available serial".

how can this be fixed , is it a bug in RMS.
Antonijo Todorovik 4,025 on at

Like (0)

Report

RE: delete holds via SQL

Hi there.

I had something similar in the past, it happend when a serilized item was put on hold and then the Item was deleted or the serial number was changed (dont remember exactly, to be honest).

I remember that once I localized the transaction on hold with the item and deleted manually (yes, tSQL, but I completly agree that this should not be the correct way) it all came back to normal and I could cancel the transactions on hold... Try to investigate (if You can, and maybe using SQL) what Items are in the Transaction OnHold that are provoking the error...

Regards, A.
Sad 650 on at

Like (0)

Report

RE: delete holds via SQL

Thank you , The problem occur when recall a hold transaction " which includes many serialized items "

and get a message " run time error 91 ,object variable or with block variable not set ". after press "OK " on the message RMS shutdown by itself.

we have 10 stores , the problem is in tow stores only , other stores did not make a similar holds.
Jeff @ Check Point ... 13,382 on at

Like (0)

Report

RE: delete holds via SQL

Does it happen on all of them? If not, you've deleted something that was on the Hold. Pick up what you can and then see if there is some commonality with what's left.
Sad 650 on at

Like (0)

Report

RE: delete holds via SQL

HI, i got the message:

run time error 91 ,object variable or with block variable not set.

thanks
Nicole Hellerud 1,712 on at

Like (0)

Report

RE: delete holds via SQL

Sad,

Thank you for your response. Is it possible to close out some of the transactions on hold?

Thanks,

Nicole
Sad 650 on at

Like (0)

Report

RE: delete holds via SQL

Thank you , the message is not understandable " rubish letters " , then when press "OK' bottun in popup message , RMS shut down.

this issue happened in more than one store with the same conditions " many serialized items put on hold ".
Nicole Hellerud 1,712 on at

Like (0)

Report

RE: delete holds via SQL

Sad,

I agree with Jeff in regards to deleting the hold is RMS vs. SQL.

What error message are you receiving when recalling a hold?

Thanks,

Nicole