Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

GL Account Assignments

21 views
Skip to first unread message

Nabonibus

unread,
Oct 19, 2006, 3:55:02 AM10/19/06
to
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: Nabo...@yahoo.com

David Walker

unread,
Dec 13, 2006, 10:41:00 PM12/13/06
to
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,

Jason Kelton

unread,
Jul 17, 2007, 9:30:01 AM7/17/07
to
David,
What is the reason that you recommend not using the QB Accounts Payable type
of account?

Craig

unread,
Jul 17, 2007, 10:25:34 AM7/17/07
to
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

"Jason Kelton" <Jason...@discussions.microsoft.com> wrote in message
news:C4FAA74B-D522-441B...@microsoft.com...

Jason Kelton

unread,
Jul 17, 2007, 1:30:00 PM7/17/07
to
Thanks! Any suggestions or tips you guys may have to someone who hasn't set
up RMS/QuickBooks yet would be greatly appreciated.

Cyfluthrin

unread,
Sep 23, 2007, 3:48:00 AM9/23/07
to
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.

Doug Hubka

unread,
Mar 25, 2008, 12:32:02 PM3/25/08
to
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
--
Doug Hubka
Acccounting Support for RMS
Advanced Retail Management

JJ

unread,
Apr 9, 2008, 10:43:01 AM4/9/08
to
I would appreciate a copy Doug, does this document work for 1.3 or only 2.0?

Doug Hubka

unread,
Apr 9, 2008, 11:29:01 AM4/9/08
to
Send you request to: doug....@armsys.com so I will know where to send doc.

--
Doug Hubka
Acccounting Support for RMS
Advanced Retail Management

ISSAM

unread,
Aug 26, 2008, 11:30:04 AM8/26/08
to
could you plz send me a copy
iss...@hotmail.com
thank you a lot

ozman

unread,
Oct 5, 2008, 5:21:00 PM10/5/08
to
Doug, pls send me a copy as well. Send it to da...@mysisterskitchen.net

Thanks,

Dave

Craig

unread,
Oct 6, 2008, 10:20:03 AM10/6/08
to
Doug,
I would like a copy as well. cr...@cctropicalparadisepets.com thank you.

"ozman" <oz...@discussions.microsoft.com> wrote in message
news:BDEA9632-8CB1-4064...@microsoft.com...

Carlos

unread,
Oct 23, 2008, 12:49:03 PM10/23/08
to
I would really aprecciate if you can send me a copy Doug

carlos...@msn.com

leslie

unread,
Jan 31, 2009, 1:00:01 PM1/31/09
to
leslie Please send me a copy at lmcc...@flyingnumbers.com I am working
with the Canadian version of QB. Does that matter?

Crystal Clear

unread,
Apr 21, 2009, 10:54:09 AM4/21/09
to
Hey Doug, I would like a copy also croac...@yahoo.com.
Thanks so very much.
--
Crystal Roach

Ed

unread,
Apr 23, 2009, 9:01:01 PM4/23/09
to
Doug, please send me this info as well.

Ed

Todd Berger [MSFT]

unread,
Apr 27, 2009, 10:44:28 AM4/27/09
to
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=?= <E...@discussions.microsoft.com>
Subject: RE: GL Account Assignments
Date: Thu, 23 Apr 2009 18:01:01 -0700

nick

unread,
Nov 27, 2009, 4:20:01 PM11/27/09
to
Can you email me too. Thank you.

nyp...@gmail.com

yokas

unread,
Dec 31, 2009, 10:06:01 AM12/31/09
to
Thanks. I have been having problems with the integration. Please send me a
copy of the pdf GL accounts assignment table

yokas

unread,
Dec 31, 2009, 10:27:01 AM12/31/09
to
Thanks Doug. Im going to need a copy of Account Assignment Table for
Quickbooks. My email is eje...@hotmail.com

yokas

unread,
Dec 31, 2009, 10:26:01 AM12/31/09
to
Thanks Doug. Im going to need a copy of the Account Assignment Table for
Quickbooks.

AL

unread,
Feb 15, 2010, 9:15:01 PM2/15/10
to
Please send me PDF Assignment Table al...@msn.com

lweekspors

unread,
Mar 12, 2010, 10:43:01 AM3/12/10
to
Thanks Doug. I would like a copy of Account Assignment Table for
Quickbooks as well. My email is la...@livingsafari.com

Robert Phipps

unread,
May 7, 2016, 11:34:01 AM5/7/16
to
replying to =?Utf-8?B?RG91ZyBIdWJrYQ==?=, Robert Phipps wrote:
> Hubka
Mr. Hubka - I am also attempting to integrate QuickBooks Pro 2016 with RMS,
could I also get a copy of your account assignment table. Thank you

--
posted from
http://www.beansmart.com/point-of-sale/gl-account-assignments-16568-.htm
using BeanSmart's Web, RSS and Social Media Interface to
microsoft.public.pos and other accounting and tax groups

Robert Phipps

unread,
May 7, 2016, 1:34:03 PM5/7/16
to
replying to Robert Phipps, Robert Phipps wrote:
My email address is bobsc...@cox.net
0 new messages