cancel
Showing results for 
Search instead for 
Did you mean: 
Level 2

Re: OL-222 and RBC Account

What did you end up reducing the names too then Depot?  I may attempt this also. 

Cheers

Level 1

Re: OL-222 and RBC Account

I just shortened them...  took the 4 digit code off end..  removed “online’ and stuff like that.  Basically ged rid of as much as I can and still know what it’s for

Level 3

Re: OL-222 and RBC Account

I believe that I kept mine below 24 characters in length including spaces.

Level 2

Re: OL-222 and RBC Account

Thanks to you folks, I'll give this a try on the weekend, really appreciate your advice.

Cheers

Level 2

Re: OL-222 and RBC Account

Worked like a charm.  One would think this would be a rather simple fix for the Intuit team. I'll continue sending in bug reports till they get sick of me I guess.  Maybe we should all invoice them for our extra effort and time with editing the ofx files?

Cheers & thanks again for the help!

Level 2

Re: OL-222 and RBC Account

6 months and I'm still doing all my entries by hand. Really thinking about moving to another program in the next few weeks. If users can find solutions it should be an easy fix for trained technical support. 

Anonymous
Not applicable

Re: OL-222 and RBC Account

Hello, VCINC.


This error occurs when QuickBooks does not receive a proper response from user’s Financial Institution. Unsupported characters found in the .QBO file could be the main cause of this error. 
To fix this, let’s reclassify the Formatting of .QBO file. Here’s how:

  1. Right-click the .QBO file and select Edit.
  2. Choose any text editor app to open the file.
  3. Find and remove &amp from the text as it is an invalid character.
  4. From the File tab click Save.
  5. If the problem persist, follow the next troubleshooting step.


Though if the issue continues, it’d be best to reach out to your bank to investigate this further. 


Thanks for your patience. Visit us again if you have other questions. 
 

Level 3

Re: OL-222 and RBC Account

MikiD

As stated previously there are other files from this institution that work perfectly fine. Is this character known to only appear in the chequing/savings file data from RBC and not the credit card data from RBC?

 

This is ridiculous that this hasn't been fixed yet. You guys have left your customers hanging in the balance with a half working product since October of last year. How is it that 2 national institutions haven't got this figured out and implemented yet?

 

My guide on editing the file still works for input... but who wants to have to go through all that editing when we've paid for software and paid our banking dues??

QuickBooks Team

Re: OL-222 and RBC Account

Hello Trevvy. I want to assure you that we have heard and continue to hear your concerns about the OL-222 error with RBC and QuickBooks Desktop. I'm glad that my colleague was able to share a temporary solution while our engineers continue toward a more permanent fix. I know this may not be an ideal solution, especially if you have many bank transactions to upload. Your time is important and we love being able to offer the ease of the bank feed option, which is why resolving this error is one of our priorities.

Level 2

Re: OL-222 and RBC Account

I doesn't seam like a priority at all. 6 months. Ridiculous. I'm moving on from Quickbooks. 85$/month and I have to manually input my transactions

Anonymous
Not applicable

Re: OL-222 and RBC Account

Hello, @VCINC.

 

I understand that this issue should be fixed as soon as possible. I know it's time-consuming to enter things manually and we do value your time.

 

What you can do for now is follow my colleague's suggestion while our Engineering Team is working on getting this resolved. If you haven't called in yet, I'd suggest reaching out to our QuickBooks support so they can add your account to the list of affected users. This way, they can email you with the latest update about this investigation.

 

Additionally, I'll keep an eye out for the progress and provide them as soon as they're made available to me. Please bear with us.

 

Let me know if you have other questions. I can help you further if needed. 

Level 2

Re: OL-222 and RBC Account

How much do you value your customers time? Perhaps enough to reimburse us for it? When I spend time on anything to do with work I usually bill it to my clients. Are you expecting us to have our clients pay for this extra time we have to spend on editing downloaded files that your software is supposed to handle??? I don't think so.  Give us a contact and a billing address so we can invoice you for our time.

QuickBooks Team

Re: OL-222 and RBC Account

Hi ML Painting,

 

I know how it feels when you've used up too much time waiting.

 

Right now, our engineers are still working with RBC for the fix.

If you haven't already, I recommend contacting our Customer Care Team so you'll be listed in our list of affected users.

 

If there's anything else you need assistance with, please don't hesitate to comment below.

Highlighted
Level 3

Re: OL-222 and RBC Account

It should be a simple as someone writing macro to shorten the line. Then put it up on your site for an upload fix / then download import. If someone who knows nothing about your file structure can manually go in and edit THE ONE LINE that is causing the issue to get it to work.... Two teams of professionals from two MASSIVE institutions should have been able to figure this out by now. There's something else happening here that isn't being disclosed. 

 

What are the chances of getting a refund for my Quickbooks 2019 Pro?

QuickBooks Team

Re: OL-222 and RBC Account

Hello again, Trevvy. I know we've spent a lot of time on this subject and I'm still relaying customer concerns, including yours, about how long this is taking with my team. Refunds are not typically offered for this kind of situation as it's one part of the product that has an error. You're welcome to give our phone support team a call to discuss this in greater detail. Pro support is available 24 hours a day at 1-877-772-9158.

Level 2

Re: OL-222 and RBC Account

LauraAB, why would you tell us to call support, after stating that you have relayed our "concerns". Why would I have to click through your support site at this point? Why is it on us to contact RBC? We pay Intuit for this software, we should not have to fix your problems!  I too want a refund or something in line of a credit. I sure as hell am not going to invest more time into making phone calls, or clicking through your support section etc etc. A main component of our complaint is its costing us time, and your suggestion is to invest more time?  If anything I'll be contacting services such as the BBB and our Provincial Consumer Complaint department. I can't get over after using your products for pretty much as long as Quickbooks and Intuit's tax software have existed, the absence of a fix for a simple problem!

Anonymous
Not applicable

Re: OL-222 and RBC Account

I’d totally feel the same way if I were in your position, ML Painting.


Our engineers have come up with this workaround as they continue working to fix the issue:

  1. Right click the .qbo file select Open with then select Choose another app
  2. On the new pop up window select Notepad on the list
  3. Once the file is open, search for the <NAME> field then check its value if it exceeds the 25 character limit.
  4. Rename the value to make it less than 25 characters.
  5. Save the file (do not use "SAVE AS") then test it by importing the modified .qbo to a new company or sample file.
  6. If you encounter the error, kindly check back the file and make sure that all names have less than 25 characters.

Note: You’ll need to modify the file if it comes with a huge amount of information. You can use MS Word to open the .qbo file then use the Find and Replace All feature. 


I’ll also make sure to keep an eye on this issue and will keep you posted once there are updates.


Please continue to bear with us until we fully fix the issue. 
 

Level 1

Re: OL-222 and RBC Account

I upgraded from QB2016 to QB2019 as the online service for 2016 was being discontinued.

 

Although same problem download problems as I was having with QB2016 I am having with QB2019.  Disappointed to see that QB and RBC have known about this for a while but have not fixed it.  So each time I need to go and edit my .qbo file every time I download one.

 

Hey QB and RBC... Get this fixed ASAP!  I'm definitely not recommending either RBC or QB to anyone at the moment.

 

Rod

QuickBooks Team

Re: OL-222 and RBC Account

Hi Rod,

 

Congratulations on upgrading! It's important to us that our customers are using the most up to date software program available.

 

We're still working with RBC to make sure we establish a connection ASAP. I know it's taking longer than usual and I appreciate you holding on tight. If you need assistance with anything related to QB, feel free to reach out. I'll be here to help.

 

Level 2

Re: OL-222 and RBC Account

Yes we have been doing that. Perhaps if Intuit would just fix quickbooks to accept "names" over 25 characters, and quit blaming RBC we would all be better off!  Yes?

Anonymous
Not applicable

Re: OL-222 and RBC Account


Accepting more than 25 characters would be a good solution, ML Painting. 


I can assure you that our engineers are working to fix this. We’ll surely mention everyone in this thread once we receive updates. 


Please continue to bear with us until we completely fix the issue. Thanks for your patience
 

Level 3

Re: OL-222 and RBC Account

The function now works. No more OL-222 error. Glad I heard about it from RBC before the manufacturer of the product... Seriously disappointing Intuit.

 

If you are going to try it out... I suggest that you do a time based import and DO NOT select since last transaction. It imported everything from the start of my bank account till now.

 

Oh well. Guess beggars can't be choosers.

 

 

Level 1

Re: OL-222 and RBC Account

I dont have RBC bank, but I was getting the OL-222 error from Capital one. I was able to resolve it by updating Debit to D and Credit to C for the TRNTYPE fields
Level 1

Re: OL-222 and RBC Account

I am having the same problem with Capital One. Did you make the debit and credit changes in Notepad, save and the import? I am not able to get it to work on my end. thanks.
Level 1

Re: OL-222 and RBC Account

My apologies, I made a mistake in my last post. I did use Notepad to edit, but the edit was the other way around. I updated D to Debit and C to Credit for the TRNTYPE fields