RMS GL Jounal Entries Issues

Hello Everyone,

We have succesfuly done the RMS to QB Integration, but there is a small 
problem after we post the batches to QB, the GL Journal Entries are not in 
Numerical Account Order. The Accountant that we are dealing with is very 
picky and is complaining that it very stupid the way that RMS post the batch 
to QB. i.e.
Memo                      Account 
Debits                Credits
RMS COGS...        5000 - Cost of Good..                        517.43
RMS Tender...        1100 - Bank of Amer..                        669.72
RMS Tender...        6100 - Credit Slips... 
13.00
RMS Tender...        1240 - Charges - Credit C                  461.00
RMS Tender...        6100 - Credit Slips...                            57.22
RMS COGS...        1300 - Inventory Asset 
517.43
RMS Sales...           4100 - Sales Taxables 
1,124.18
RMS Tender...        4095 - Overages 
10.53
RMS Tax Col...       2700 - State Tax 
66.79

The way that the accountant would like to see the Batch posted is like this:

Memo                      Account 
Debits                Credits
RMS Tender...        1100 - Bank of Amer..                        669.72
RMS Tender...        1240 - Charges - Credit C                  461.00
RMS COGS...        5000 - Cost of Good..                        517.43
RMS Tender...        6100 - Credit Slips... 
13.00
RMS Tender...        6100 - Credit Slips...                            57.22
RMS COGS...        1300 - Inventory Asset 
517.43
RMS Tax Col...       2700 - State Tax 
66.79
RMS Tender...        4095 - Overages 
10.53
RMS Sales...           4100 - Sales Taxables 
1,124.18

The problem in the way that RMS posts the batch is that in the QB Check 
Register, for the Bank of  America Account, The deposit amount is Correct 
$669.72 but the account that shows is the COGS account 5000.

Please help

Rommel J. Jimenez 


0
12/29/2006 4:21:44 PM
pos 14173 articles. 0 followers. Follow

1 Replies
482 Views

Similar Articles

[PageSpeed] 6

It shows Cost of Goods because that was the first account in the 
transaction.  Not much you can do about it.  I don't think it's any 
different than if a check had been written or deposit taken.  The 
transaction would show the first line of the G/L allocation anyway.

Not terribly significant really.


Mike McCormick, CPA



Rommel J. Jimenez wrote:
> Hello Everyone,
> 
> We have succesfuly done the RMS to QB Integration, but there is a small 
> problem after we post the batches to QB, the GL Journal Entries are not in 
> Numerical Account Order. The Accountant that we are dealing with is very 
> picky and is complaining that it very stupid the way that RMS post the batch 
> to QB. i.e.
> Memo                      Account 
> Debits                Credits
> RMS COGS...        5000 - Cost of Good..                        517.43
> RMS Tender...        1100 - Bank of Amer..                        669.72
> RMS Tender...        6100 - Credit Slips... 
> 13.00
> RMS Tender...        1240 - Charges - Credit C                  461.00
> RMS Tender...        6100 - Credit Slips...                            57.22
> RMS COGS...        1300 - Inventory Asset 
> 517.43
> RMS Sales...           4100 - Sales Taxables 
> 1,124.18
> RMS Tender...        4095 - Overages 
> 10.53
> RMS Tax Col...       2700 - State Tax 
> 66.79
> 
> The way that the accountant would like to see the Batch posted is like this:
> 
> Memo                      Account 
> Debits                Credits
> RMS Tender...        1100 - Bank of Amer..                        669.72
> RMS Tender...        1240 - Charges - Credit C                  461.00
> RMS COGS...        5000 - Cost of Good..                        517.43
> RMS Tender...        6100 - Credit Slips... 
> 13.00
> RMS Tender...        6100 - Credit Slips...                            57.22
> RMS COGS...        1300 - Inventory Asset 
> 517.43
> RMS Tax Col...       2700 - State Tax 
> 66.79
> RMS Tender...        4095 - Overages 
> 10.53
> RMS Sales...           4100 - Sales Taxables 
> 1,124.18
> 
> The problem in the way that RMS posts the batch is that in the QB Check 
> Register, for the Bank of  America Account, The deposit amount is Correct 
> $669.72 but the account that shows is the COGS account 5000.
> 
> Please help
> 
> Rommel J. Jimenez 
> 
> 
0
mike4043 (23)
1/2/2007 2:56:53 PM
Reply:

Similar Artilces:

Please help, Issues moving a CRM4 database to a new server and dom
Hi, I know there are a few posts here about this but nothing works for me. My Goal is to move a database to another server in another location with a different domain. Here is what I tried. I backed up the database on the current server (domain name: serverusa). I did backup both the MSCRM and the Config. First I tried to install MSCRM fresh on the new server (Domain name: server-ebm) I then checked it and I could access the CRM fine on the server using IE. Then I did go to the SQM management and restored the MSCRM database from a dump. After this I can access but it tells me "Inva...

Add non-inventory item in MO Reciept entry (Unit Cost)
Dear All, I am using the (Add Component) button on the MO Reciept entry screen to add some non-inventory items, I notice that the decimal places for the unit cost is (2) although my Functional currency is (3). Kindly advice for the reason behind this, or if there is any setup required for that. Thanks Dear, Go to Tools --> Setup --> Purchasing --> Purchase Order Processing Find Decimal Places for Non-inventoried Items, click on the Expantion Button near to the Currency Field and set the decimal places for you curreny. Regards, -- Mohammad R. Daoud MCP, MCBMSP, MCTS, MCBMSS S...

Word printing issue
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi all, new to MAC, switched from PC to MAC in December 2009. <br> Trying to simulate MS Publisher using MAC Word 2008. <br> Can only seem to get background colours to be effective at Print Preview stage, if I add a background colour in the Word document view first and then switch into Print Preview the background colour has disappeared and the same if I try to Print. <br><br>Any ideas? Check in Word>Preferences>Print>Options for this document only... What is your setting...

How do I remove duplicate entries from a list?
Look at Data/Advanced Filter Bob Umlas Excel MVP "E. Reta" <E. Reta@discussions.microsoft.com> wrote in message news:34E54578-E3AA-44D8-93CB-5C7D11E46D10@microsoft.com... > ...

exmerge calendar send on behalf issue
Hello - I migrated an exchange box using the exmerge utility and have noticed that when a user tries to change an appointment that was on the old box and has invitees, it will not send an update as there is a permission error with send on behalf. This is not a shared calendar, just the users own calendar that was imported from their previous mailbox on the other exchange server. The only scenario that I can figure that would cause something like this is is the calendar appointment is tied down with the previous user and is not associated as the organizer with the new appointment. Any thoug...

MRP issue
For some reason we have a part in MRP that is not quite working as predicted. It suggests buying more items than we have demand for and ends up with 6 extra units. <img src="http://ef2bhg.bay.livefilestore.com/y1pbuKxWwm3MsELispW6MjBW-aFRUrb9OJwxTmQY0lm00NV6z26yviPK69am3kqiKAZrJSu3QzaZJjsR62NhfBNDw/workbench.jpg"/> Any idea why this would be occuring? I noticed there is a suggestion to get -10 units, not sure if that is a problem. We do run MRP regen every day, so that shouldn't be an issue in this case. Thanks, -Scott If you peg the recommendation for -10 uni...

Does rms 1.3 support pindpad 1000se
Does rms 1.3 support pindpad 1000se. We have a pindpad 1000se, can we use the driver on the rms, do we have to install the driver for the pinpad in the cd? Yes it will work and you can use the drivers provided my Microsoft. "TJW" <TJW@discussions.microsoft.com> wrote in message news:9146817C-4E6E-4584-8AEA-DDC12D99BB44@microsoft.com... > Does rms 1.3 support pindpad 1000se. We have a pindpad 1000se, can we use > the driver on the rms, do we have to install the driver for the pinpad in > the > cd? but the one i have is a usb interface, the opos driver fro...

Frustrating Backcolor issue
Hi All, On my forms in the database I'm working on, all the combo boxes backcolor are transparent on moving focus to another control. No matter what I try I can't get it to stay the set backcolor whether I leave it as default or set a color. The moment focus moves out of the combo box it's backcolor is that of the form detail. Am I missing something? I'm probably misunderstanding your question, but it sounds like you need to set the combo box's Back Style from Transparent to Normal. If set at Transparent, it doesn't matter what Back Color you specify, ...

IE 8 Parsing issues?
Hello, since a few month we're having strange requests in our web server logs. Example: 2010-01-27 18:00:35 W3SVC183691552 194.183.128.104 GET /SysRes/GLOBALSkin/Ski/head><body+onload= - 80 - 194.183.153.12 Mozilla/4.0+(compatible;+MSIE+8.0;+Windows+NT+5.1;+Trident/4.0) http://my.domain.at/ 200 0 3 21699 757 46 Sometimes embedded resources like Scripts or CSS files are not loaded correctly. The path to the external resources is broken by adding any HTML code snippet of the page which embeds the resources. It happens on different pages / applications on our serv...

Hyperlink issue
I have a couple of anomolies with excel hyperlinks. I have a spreadsheet created by copying text from an HTML file (saved web page). It has some cells with hyperlinks. These hyperlinks work fine. When I create a new hyperlink to similar page on the same site thing work the same as the copied hyperlinks. I create this the same was as I create the malfunctioning one as below. This page yeilds a normal working hyperlink - (see last paragraph) http://www.woodcraft.com/family.aspx?familyid=1972 HOWEVER, when I create a new hyperlink, to a different page on the same site (a link to one of the...

Date Entry in Excel 2000
Hi All, We recently upgraded to 2003 and one of our users says she was able to enter a date such as 10/24/04 in Excel 2000 as 102404 when she had the cell formatted as a date. I haven't been able to reproduce it on a 2000 machine nor does it make sense to me that it would work given that a date in Excel has a numeric value which is unrelated to the digits in the date. Is she mistaken or is there a setting I don't know about which allows this? Thanks Erin She's most probably mistaken. That behavior isn't native to XL. It's possible to do this with event macros...

eConnect GL Tax node #2
In importing GL Transactions with tax entries, a partner of ours is suggesting to have a node for GL Tax Entry. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=694f0130-4c9...

Another Issue With A Function
Ron Rothstein suggested and I used this function in my Excel 2003 Workbook: Public Function QBRushYds(W, Q) QBRushYds = Worksheets("Week" & W).Range("C2").Offset(Q).Value / 10 End Function In Worksheet Totals Cell B56 thru B59 I have the following four calculations: =TRUNC(QBRushYds(1,1)) =TRUNC(QBRushYds(1,2)) =TRUNC(QBRushYds(1,3)) =TRUNC(QBRushYds(1,4)) In Worksheet Week1 Cells C3 thru C6 I have the following values: 725 814 283 9 The function correctly calculates the values: 72 81 28 0 If I change any of the values in C3 th...

Formatting issue
I have the following formula in one of my cells: =IF(C5<>0,C6 &" Supplied by Marketing - Calculated value is " &C4,C4&" Calculated value") The values in C4, C5, C6 are all in dollar format but the output doesn't show in dollar format. See below: 7500 Supplied by Marketing - Calculated value is 8800 . Any way to get the format like this: $7,500.00 Supplied by Marketing - Calculated value is $8,800.00 Hi, =IF(C5<>0,"$"&C6&" Supplied by Marketing - Calculated value is "&"$"&C...

Multi User Issue's
Access 2003 Split database No Security Front end (Fe) and Back end (Be) are in the same directory on the server "SHORT CUT" to fe on each (2) workstation Opening the DB on each of the 2 workstations does work HOWEVER if it I already open on one workstation it will NOT OPEN on the other workstation. I have tried: STARTING on BOTH workstations - Same results Tried the same set up with an XP server and a win2000 server - Same results Checked to be sure opening mode is "shared" This is my first attempt at a multi user configuration for Access. I called a buddy of mine who...

Standby -- having issues
My computer is running Windows XP Home SP3. I have configured peripherals to allow the keyboard to wake up the computer (from Standby -- I do not use Hibernate), but not the mouse and not the NIC. However, I can still bump the mouse and get the computer to wake up. And other times, I come home or wake up in the morning and see that the computer has woken up on its own. I checked ACPI settings in BIOS -- set to S3, as desired. No other power management settings in BIOS. (I have an older Dell Dimension with PS/2 keyboard & mouse.) Looked through the forums/newsgroups, b...

virus issues
We are using exchange 2003. Apparently we have been hit by a virus. All the users are being constantly hit with emails that are from either: system administrator undeliverable: bla bla bal (password has been updated or account suspended..which is the virus package I think) or from administrator@mydomain.com : you have successfully updated your password (this is the virus package) I have antivirus software running on all systems, including the server. I have run the FXmydoom.exe package from symantec on all the servers and many (not all) of the workstations.. ...I did a google on &...

issue with serial port on module, updating form
Hello, Ive created a serial port instance on a module. In the same module I have the sub data_received. Now I'd like to update a control in a form, how can I do it? Thanks in advance You need to use Control.BeginInvoke or .Invoke to update the UI via a Delegate. You can download the VB2005 Terminal example from my website, which illustrates this. Dick -- Richard Grier, Consultant, Hard & Software 12962 West Louisiana Avenue Lakewood, CO 80228 303-986-2179 (voice) Homepage: www.hardandsoftware.net Author of Visual Basic Programmer's Guide to Serial Comm...

old server removed, now a new synch issue
Hello folks. Today I finally moved the last mailboxes and public folders off our old exchange 2003 server to a new one. I followed all the KB's I could find about properly decomissioning the server, and then uninstalled Exchange 2003 on that system. Since then, all my Outlook 2003 clients are getting the following synch issue whenever you first open outlook with cached mode. And I've tried recreating my profile, that doesn't help at all. This has to be related to something I missed. Anyone have suggestions? 15:54:03 Synchronizer Version 11.0.5604 15:54:03 Synchronizin...

RMS batch postings to SBA out of balance
While setting up a new deployment of RMS and SMA I have encountered a series of 'batches out of balance' issues which is preventing natural posting. I have checked my account mapping and am confident in it's accuracy. How can I error trap in RMS to see where the issue is? Help !! -- Gil Gil, I haven't looked at SBA in a year, but I think there is a error log file in either the RMS SO folder or the SBA folder. -- = Get Secure! - www.microsoft.com/security You must be using Outlook Express or some other type of newsgroup reader to see and download the file attac...

Crosstab Row Heading Issues
Hi, I have Access 2003 and when I do a cross tab I cannot bring in more than 3 field values for row headings - my coworker (who has Access 97) can bring in >3 row headings. Is this a paremter setting in Access 2003? Thanks, Mike I believe that the Wizard can't handle more than 3; however, you can do more with SQL. Try creating a crosstab with the three headings, them modifying it at SQL level to add more. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "mike" wrote: > Hi, > > I have Access 2003 and...

double entries in tasks and reminders
every time i enter a 1 task it displays 2 identical tasks. also when a reminder from my calaneder dispays it displays it twice. If i click on one to snooze of delete both identical entries disappear. does anyone have any idea why this might be happening and suggestions at getting rid of the problem. any help would be appreciated. thanks. outlook 2007 windows vista home premium -- paul I am new to the forum and found this post by searching google. I am having the same issue. It seems to have just started a couple of weeks ago and I've been using it for the last 8 months or so. ...

Report Issues
Hi All, Got a Simple Problem, With a Report, The Situation is, I Have A Form Which Opens When a PROJECT No Is Typed Into a Project No Search Dialog Ive Created When The Project No is Typed In The Result Form Is Displayed Shows The Details Of The Project Relating to that Project Number!. To Create This I Created a Qurey. What I Want To do is Be Able is To Print That Just One Record in a Report Form, As The Print Current Record Prints The Form Which Looks Very Un Professional, And I Have Tabs on the form, so So its Not Any Use. The Report Ive Created at Monement Points To The Same Qurey, W...

datetime format issues when linking access to excel
Does anyone had problems with datetime issues when trying to link access into excel? using the database query option, it gives me an error of [microsoft][ODBC Microsoft access driver]invalid datetime format on column number 1 (date/time), and will not import the data. ...

Need RMS addin Developer
Need to create a method for cashiers to assign a split commission to salespeople on POS Line Items and make this info import into quick books. Anyone out there able to do this? -- Newbie Developer to RMS There's a cheaper way to do it: Buy two items at .5 Qty and assign each 1/2 to a different sales rep. Good luck, Matt "Jewelsmith" <Jewelsmith@discussions.microsoft.com> wrote in message news:512D858F-93B5-440E-9067-D748D85A160D@microsoft.com... > Need to create a method for cashiers to assign a split commission to > salespeople on POS Line Items and make this ...