SQL to Delete a Sales Transaction 1

[Borvik]

Alright, I need to delete some Sales Transactions and Great Plains won't allow me to do it.

My question is, Can I use a SQL statement to delete all records from all tables with the SOPNUMBE equal to the one I need to delete - without Great Plains freaking out?

 

[stef315]

I wouldn't reccommend it. Why do you need to delete? Can you do a return?

There is a tool that Partners have access to to delete sales transactions. Basically the same thing you want to do but verified all the tables are hit correctly.

 

[jazgeek]

why can't you delete them?

-----------
and they wonder why they call it Great Pains!

jaz

 

[stef315]

Oh yeah, I think I may have mis-read that. Are the transactions posted or not posted?

 

[Borvik]

jazgeek: Not sure why they can't be deleted. I just started a new job, and they presented me with the problem. Some transactions needed to be deleted, and they couldn't. This is the first time I've even heard of Great Plains.

stef315: I'm not sure if they are posted or not. My guess is that it is not - I found the record in the SOP10100 table.

 

[stef315]

If they are not posted, the user should be able to pull them up and delete them. If they can't do this, do they get an error message? There is a setting that says whether or not users are allowed to delete unposted printed documents.

This is a security feature for some companies so users can't print sales invoices, collect money, then delete the record. This setting is located under Setup-Sales-Sales Order Processing. Then you have to click on the button for the document type (Invoice, Order, Quote, etc.). Once you are in there, you have to select the name of the invoice type (such as standard). Finally, you will see a checkbox in the bottom section that says Delete Documents. That box should be marked if your company wants to allow deleting documents.

If your company does not allow deleting documents, the user then has to post the invoice and do a return.

If they are getting a different type of error message (other than something like "You are not allowed to delete documents"), please post that here.

 

[Borvik]

Thanks stef, the company does in fact not allow deleting documents. Thanks for the help.