Start Free Trial

asked on 7/17/2015

Great Plains - Sales Module

I need help in finding the table and field where the default account code on the customer card is set. We would like to remove all default account codes on any customer card. Thanks!

Microsoft Dynamics Tax / Financial Software

Last Comment

7/20/2015

7/17/2015

Hi,

The customer GL accounts are stored in the RM00101 table. There are several default accounts, so let me know if you are referring to a particular one.

I believe these are all of them:

SELECT CUSTNMBR, RMCSHACC, RMARACC, RMSLSACC, RMIVACC, RMCOSACC, RMTAKACC, RMAVACC, RMFCGACC, RMWRACC, RMSORACC FROM RM00101

Thanks,

Steve Endow
Microsoft MVP - Dynamics GP
Dynamics GP Certified IT Professional

7/20/2015

ASKER

Thanks, Steve. I am trying to find out the table that holds the default account that is set up on the customer card. I have set the default account on the posting accounts setup but accounts on the customer card override this setting. Which field changes the default receivables account in the RM00101 table. I need to set this so there is no default account on the customer card and then the posting accounts setup will work. THanks!!

7/20/2015

ASKER

See above

7/20/2015

ASKER

Thanks, Steve. I am trying to find out the table that holds the default account that is set up on the customer card. I have set the default account on the posting accounts setup but accounts on the customer card override this setting. Which field changes the default receivables account in the RM00101 table. I need to set this so there is no default account on the customer card and then the posting accounts setup will work. THanks!!

7/20/2015

ASKER

I found everything except the column name for credit memos. Thanks..

ASKER CERTIFIED SOLUTION

7/20/2015

Blurred text

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

7/20/2015

ASKER

Thanks, Steve!

Microsoft Dynamics

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.

5K

Questions

--

Followers

--

Top Experts

Get a personalized solution from industry experts

Ask the experts

"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23
"Your help has saved me hundreds of hours of internet surfing."
@fblack61
"Just a dang good service!"
@golferski
"Worth every penny."
Steve Hougom
"It’s been a life saver."
Maria Halt
"Best support site I’ve seen!"
Bob Schneider
"I would be lost without them."
@fblack61
"Saved my job multiple times."
Walt Forbes
"I love this site."
Maria Duwe
"Friendly respectful help."
Andrew Kowtalo
"Such top-notch experts."
@magento
"The best money I have ever spent."
@rwheeler23
"Beyond any comprehensible value"
George Morris
"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23

Read over 600 more reviews

TRUSTED BY