GL Account Assignments


N

Nabonibus

Can anyone send me a sample copy of a GL Assignment. I just can't get it to
balance out. Please send me a copy of one that currently works with
Quickbooks so I can figure out how to get this done.

My Email Address is: (e-mail address removed)
 
Ad

Advertisements

D

David Walker

That is a bit of a challenge as the Accounts you have set up would likely
vary a great deal from another setup. Here are a couple of general rules I
have found helpful:

1. Creat three new accounts in Quickbooks for RMS Sales Tax, RMS Accounts
Payable (use other liability type in QUickbooks), and RMS Account Receivable
(Other asset type). Do not use a QB Accounts payable Type of account in the
Mappings.

2. Realize that many mappings have only a dr or a cr and not both. You will
need the spreadsheet from a MS Partner to know which ones.

3. Recognize that there are varying levels of detail to which you can post
and you cannot use two different methods at once, again refer to the
spreadsheet from your MS partner.

Don't feel bad, it took me days to figure out the first one, hours to figure
out the second, and still take a few minutes of scratching my head to
remember how it all works. This is 1 part CPA stuff, One Part MBA stuff, and
one part Geek stuff so it can be a real challenge.

Good luck,
 
J

Jason Kelton

David,
What is the reason that you recommend not using the QB Accounts Payable type
of account?
 
C

Craig

If you use the default Acounts Payable account in QB it requires a name be
entered so RMS won't post correctly. You need to setup a new Accounts
Payable so that RMS can post without errors.
Craig
 
J

Jason Kelton

Thanks! Any suggestions or tips you guys may have to someone who hasn't set
up RMS/QuickBooks yet would be greatly appreciated.
 
C

Cyfluthrin

We were explained by our RMS seller that QB can be integrated into RMS. At
least for the QB 2003 onwards. On the SOM, I recall there is a Tab for
"Accounting", then you choose QB. It will search for a running QB instance,
and when found it will show the version. QB will prompt whether to allow RMS
to update/edit its database. Then on Utilities, you can import GL data to QB,
as RMS-QB ledger tables are preset according to the type of operation (i.e.
retail. wholesale, accounting) you have configured your QB to run first-hand.
I'm not very clear on this one but I sure wish we had QB alongside RMS.

Unfortunately, we were recommended the GP Small Business Financials instead
for accounting purposes. GP = Great Pains. You have to manually assign the
account numbers. Importing Customers, Vendors, and Inventories was bloody, we
had to forego having it take care of Customers accounts (statements, billing,
etc) and have RMS be assigned for the function albeit the lack in
functionality.
 
Ad

Advertisements

D

Doug Hubka

We have found that the Account Assignment Table in Help ( RMS 2.0) is
inaccurate.
And have produced our own document that we tested for posting accuracy in
QuickBooks. Post a reply to this thread and request a copy of our pdf doc.

Also, we advise against posting receiving to A/P as it is not very workable
in 2.0 and we are hoping that this gets greatly improved in the next version
 
J

JJ

I would appreciate a copy Doug, does this document work for 1.3 or only 2.0?
 
D

Doug Hubka

Send you request to: (e-mail address removed) so I will know where to send doc.
 
O

ozman

Doug, pls send me a copy as well. Send it to (e-mail address removed)

Thanks,

Dave
 
Ad

Advertisements

C

Craig

Doug,
I would like a copy as well. (e-mail address removed) thank you.
 
C

Carlos

I would really aprecciate if you can send me a copy Doug

(e-mail address removed)
 
L

leslie

leslie Please send me a copy at (e-mail address removed) I am working
with the Canadian version of QB. Does that matter?
 
C

Crystal Clear

Hey Doug, I would like a copy also (e-mail address removed).
Thanks so very much.
 
Ad

Advertisements

T

Todd Berger [MSFT]

Good morning Ed,

Thank you for posting about QuickBooks GL account assignments.

I would recommend that you take a look at Knowledge Base article 836444:
How to integrate QuickBooks with Microsoft Dynamics Retail Management
System Store Operations
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;836444

Stage 4 covers Assign general ledger accounts in Store Operations Manager.


Todd Berger
Microsoft Online Support Engineer

Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
From: =?Utf-8?B?RWQ=?= <[email protected]>
Subject: RE: GL Account Assignments
Date: Thu, 23 Apr 2009 18:01:01 -0700

Doug, please send me this info as well.

Ed
 
Y

yokas

Thanks. I have been having problems with the integration. Please send me a
copy of the pdf GL accounts assignment table
 
Ad

Advertisements

Y

yokas

Thanks Doug. Im going to need a copy of the Account Assignment Table for
Quickbooks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top