Vendor and Customer posting account

(0) Share

Report

Posted on by Community Member Microsoft Employee

We have setup a new company using the copy setup from another company. Then copied the customers and vendors over from the old company to the new company. The problem is the default accounts for the vendors and the customers are all different. Is there a way to remove the default accounts for thee vendors and customers?

*This post is locked for comments

All responses (4)

Answers (0)

Suggested answer

L Vail 65,271 on at

Like (0)

Report

RE: Vendor and Customer posting account

If you are comfortable with SQL, you can use a SQL statement to clear the account numbers from the table. For customers it's the RM00101 table, for Vendors it's the PM00200 table.

Kind regards,

Leslie
DinB 3,812 on at

Like (1)

Report

RE: Vendor and Customer posting account

You can look for Articles online on GP Macros and Mail Merge such as following.

blogs.msdn.microsoft.com/.../how-to-use-word-mail-merge-and-macros-to-import-data

www.gpug.com/.../how-to-create-and-run-a-simple-macro-in-dynamics-gp
Community Member Microsoft Employee on at

Like (0)

Report

RE: Vendor and Customer posting account

I have no idea how to do that. Could you give me instructions?
Suggested answer

DinB 3,812 on at

Like (0)

Report

RE: Vendor and Customer posting account

You can Record Macro to delete the Accounts and run it for all Customers. Same can be done for Vendors. Test in Test Company first any way. Deleting from SQL table can also be tried, but I think Macro is safer.