Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Tables - National Accounts

Posted on by 265

I am doing mass customer deletes for one of my customers. I have a Smart List where I have identified customers with $0 balance and no activity after a specified date. 


The transactions prior to that date have been purged.

I have assigned a value to a field that is available for selection in the Mass Delete to the records that meet the criteria.

Therefore, those records should get picked up and deleted except for one thing - they are children on a national account. 

When I go into the National Account Maintenance, I see the child record, $0 balance and I can remove the child from that parent. Given that is is still tagged for me, it will now delete in the Mass Delete.


However, I cannot manually go through 32,000+ National Accounts in the maintenance screen and remove the children. 

Keep in mind, these children have no balance and no transactions

Could I just use SQL to clear the parent field in the RM00101 table to break that national account link?

Categories:
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Tables - National Accounts

    National accounts broadly present output, expenditure, and income activities of the economic actors households, corporations, government in an economy, including their relations with other countries' economies, and their wealth net worth.  mybkexperience

  • Suggested answer
    Roderick McCall Profile Picture
    Roderick McCall 110 on at
    RE: Tables - National Accounts

    Hi LB_Pgh,

    I understand you want to remove link between child account and national account, but do not want to manually do this in the National Account Maintenance window.

    If you need to have the history associated to the child account you could consider removing the link in the RM00101. The field that creates this link is the CPRCTNM.

    This is not a supported method of removing the National Accounts relationship because there is no guarantee your data will not be damaged and that reports will be correct. However, if you wish to do this, you should do this in a test company first and then test to make sure you are satisfied with the results.

    You would have to test some maintenance items as well, like voiding one of the payments, to see what you encounter. You would have to test your reports such as the Trial Balance. If you run any "National Account" reports, they may be affected.

    Kind Regards,

    Roderick

  • Max854 Profile Picture
    Max854 25 on at
    RE: Tables - National Accounts

    Anyone got a thought?

    My-Estub.com Login

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans