305
I am having problems deleting transaction that were posted. I read in the documentation for GP that you have to void any transaction that have been posted before you can delete them. I was able to void the open posted transaction and when looking at the payble transaction inquery window i can see that invoice document as voided. Just dont know how to delete the transaction after doing this. Any insight on this will be great.
Thanks
*This post is locked for comments
Hello Ian,
I have checked and tested this issue. What I found is it is deleteing entire transactions. I mean it is deleting Receipt Part as well as Void Part. What I should do so that only Void Part should get deleted and payment or Cash receipt part should remain. Please suggest any help on this.
Thanks
Sanjay Parab.
I am having this exact issue. our purchasing manager has requested that three voided RTN documents be deleted as they are apparently screwing with either the inventory or the GL. When I attempt to remove any one of the three voided returns it fails with this message:
When i try to process the request to remove the transaction. I get this output message in the screen window.
Remove: Transactions
* Unable to remove this transaction: an open apply record exists or an apply record exists outside the selected range.
Type Document Number Doc Date Description Customer Number Salesperson Writeoff Invoice Amount
------------------------------------------------------------------------------------------------------------------------------------
Post Date Discount Available Short Name Sales Territory Discount Taken Payments
------------------------------------------------------------------------------------------------------------------------------------
We just want these returns that were never supposed to be entered to be deleted, I have spent ALL day on this and I'm not even in the inventory department, I'm the IT manager. UGH.
Good stuff.
Ian.
Ian,
You did it again. Thanks :)
Good stuff Michael.
Hi Michael,
Not sure whats causing this. Are you sure the transaction is voided? When you look at in Enquiry >> Sales >> transactions by debtor...is there an asterisk beside the transaction?
Are you filtering the remove history to just this document?
Did you run the paid transaction removal process (Microsoft Dynamics GP >> Tools >> Routines >> Sales >> Paid Transaction Removal)...Run it for just Voided transactions for the relevant debtor. This will transfer voided transactions to history where they can then be deleted using 'Remove Transaction History' (if you are keeping history, otherwise this will delete them completely).
Tell us how you get on.
Best regards,
Hey guys,
I am trying to do the samething for receivable transactions. When i void these transactions i try to delete them using
Microsoft Dynamics >> Tools >> Utilities >> Sales >> Remove Transaction history.
When i try to process the request to remove the transaction. I get this output message in the screen window.
Remove: Transactions
* Unable to remove this transaction: an open apply record exists or an apply record exists outside the selected range.
Type Document Number Doc Date Description Customer Number Salesperson Writeoff Invoice Amount
------------------------------------------------------------------------------------------------------------------------------------
Post Date Discount Available Short Name Sales Territory Discount Taken Payments
------------------------------------------------------------------------------------------------------------------------------------
Ian,
That did the trick.
Frank to your point i completely agree with you but i forgot to mention i am working in a dev environmment not production.
Michael,
There's a reason you can't delete posted transactions in GP. It's called 'maintaining an audit trail'. :)
Hi, when you void a payables transaction it is moved to history. To remove transaction history, go to Microsoft Dynamics >> Tools >> Utilities >> Purchasing >> Remove transaction history.
Back up your data first in case you make a mistake.
In the Remove Transaction History window select Voucher Number in the Ranges field, and enter the relevant voucher number in the From and To fields. Click on 'insert' to insert this voucher number range in the restrictions section.
Accept the other default values, and click on process.
Best regards,
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,321
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
