Hi
There is one debtor that I am trying to delete where I get there error message 'Transactions exist for this debtor. The debtor record cannot be deleted.'
I have checked front end GP -
Enquiry\Transction by Debtor
Enquiry\Sales Documents (Unposted and History)
I have checked all Sales Transactions tables in SSMS
RM20101, RM10301, RM30101, SOP30200, SOP10100
I have run reconcile over the debtor. It still can't be deleted. What am I missing?
Thanks
*This post is locked for comments
Thanks Vaidhyanathan
This one is still proving to be a bit difficult to resolve but this is a great step in the right direction. This would also be useful for a lot of other things.
That's excellent suggestion by Vaidy I agree with the same.
Vaidy is absolutely right. I have used spSearchOnAllDB many times for finding data in GP tables. Thanks David for sharing this script with the GP community.
After you create the Stored Procedure, you can run this script against your GP company database
exec spSearchOnAllDB 'YourDebtorID%'
Alternatively, you could use SQL profiler to find which tables are called when you try to delete the debtor.
Please download and run this SQL script on the company database: spSearchOnAllDB.
Try searching for this debtor ID across the entire company database and see if there is any transaction stuck somewhere. For instance, even a service call transaction from Field Service would hold the debtor deletion.
This script might help you locate the stranded/persistent transaction(s) for this debtor.
Hope this helps.
Hi Jorge
The status of the Debtor Card is active.
As mentioned in my original email I have check front end GP -
Enquiry\Transaction by Debtor
Enquiry\Sales Documents (Unposted and History)
I have also from SQL queried the Sales transactions tables
SOP10100 Sales Transaction Work
SOP30200 Sales Transaction History
RM20101 RM Open File
RM10301 RM Sales Work File
RM30101 RM History File
No results for anything. I would imagine checklinks would be running over these same tables anyway.
Thanks
What is the status of the vendor you want to delete? Active, inactive or temporary?
Does it have any balance or unposted transactions or posted transactions?
Wouldn't checklinks just check the Sales and receivables transaction tables that I have listed anyway? Nothing exists in any of them with that Customer Number. The company has very high levels on transactions in Sales, running checklinks can take over 12 hours and require numerous other systems that write to the GP database to be taken offline.
Hi Tania,
Have you tried checklink against sales and receivable transactions. Please take a backup before doing this.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (