pstre
asked on
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!
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!!
ASKER
See above
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!!
ASKER
I found everything except the column name for credit memos. Thanks..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, Steve!
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