Unable to delete debtor card

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (8)

Answers (1)

Community Member on at

Like (0)

Report

RE: Unable to delete debtor card

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.

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

RE: Unable to delete debtor card

That's excellent suggestion by Vaidy I agree with the same.

Was this reply helpful? Yes No
Suggested answer

coquisalsa 2,725 on at

Like (0)

Report

RE: Unable to delete debtor card

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.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

RE: Unable to delete debtor card

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Unable to delete debtor card

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

Was this reply helpful? Yes No
Suggested answer

coquisalsa 2,725 on at

Like (0)

Report

RE: Unable to delete debtor card

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?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Unable to delete debtor card

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.

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

RE: Unable to delete debtor card

Hi Tania,

Have you tried checklink against sales and receivable transactions. Please take a backup before doing this.

Was this reply helpful? Yes No