Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Unable to delete debtor card

Posted on by Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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.

  • Suggested answer
    RE: Unable to delete debtor card

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

  • Suggested answer
    coquisalsa Profile Picture
    coquisalsa 2,725 on at
    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.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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

  • Suggested answer
    coquisalsa Profile Picture
    coquisalsa 2,725 on at
    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?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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.

  • Suggested answer
    RE: Unable to delete debtor card

    Hi Tania,

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,232 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,064 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans