Finance | Project Operations, Human Resources, ...

Tables - National Accounts

(0) Share

Report

Posted on by LB_Pgh

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:

Microsoft Dynamics GP

All responses (3)

Answers (0)

Sort by

Max854 25 on at

Like (0)

Report
Copy link

Link copied!

Anyone got a thought?

My-Estub.com Login
Suggested answer

Roderick McCall 110 on at

Like (0)

Report
Copy link

Link copied!

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
Community Member on at

Like (0)

Report
Copy link

Link copied!

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