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

I have the same question (0)

All responses (12)

Answers (1)

Jeff @ Check Point ... 13,382 on at

Like (0)

Report

This is a very invloved operation. You're better off just doing it through RMS.

Was this reply helpful? Yes No
Sad 650 on at

Like (0)

Report

Thank you ,

the problem that when i recall from holds i got an error popup and the program turn off by itself.

Was this reply helpful? Yes No
Nicole Hellerud 1,712 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Sad 650 on at

Like (0)

Report

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 ".

Was this reply helpful? Yes No
Nicole Hellerud 1,712 on at

Like (0)

Report

Sad,

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

Thanks,

Nicole

Was this reply helpful? Yes No
Sad 650 on at

Like (0)

Report

HI, i got the message:

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

thanks

Was this reply helpful? Yes No
Jeff @ Check Point ... 13,382 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Sad 650 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Antonijo Todorovik 4,025 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Sad 650 on at

Like (0)

Report

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.

Was this reply helpful? Yes No