Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete Unposted SOP Invoices 1

Status
Not open for further replies.

Kiwiman

Technical User
May 6, 2005
88
GB
Hi

Is there a way to delete Unposted SOP invoices that have been printed? We are trying to delete some documents, but GP says it can not be deleted as it has been printed. You have to void it.

Any help would be appreciated.

Take it Easy
Man with one chopstick go hungry
 
Howzit

No - these invoices are part of a larger batch that needs to be deleted. Only some of these invoices have been printed. I can't delete the batch at all due to the isolated invoices that have been printed.

This is in our test system where we are implementing a new billing platform. Would like to remove everything that comes from the initial testing completely.

Take it Easy
Man with one chopstick go hungry
 
As a workaround - move all the unposted invoices that have been printed to a different Batched.
That is, open each SOP invoice, amend the Batch number and save.
Once you have done this for all the printed invoices, you will at least be able to delete the origianl batch ( having only un printed invoices)

If this is purely for testing, you could use Query Analyzer to amend the Times Printed [TIMESPRT] field in SOP10100 table back to zero.

------
Robert
 
Howzit

Thanks Robert. Yes this is only in the development server - wouldn't do this in live - that this is being done on. Seems to work a treat.

Thanks very much.

Take it Easy
Man with one chopstick go hungry
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top