Quickbooks Import QBI

Taipa:

Just wondering how many Canadians are interested in using the QBI?

I just sent Adam a PM to see how many hours it would take (aka how much it will cost ^_~ ) to get QBI working with the Canadian version of QuickBooks Pro. Since it's probably going to be a lot, I'm just wondering if any Canadians would find this helpful, and if anyone would be willing to share the cost with me? :wub:

Okay, this may be a stupid question...but why won't the US version of QBI work with the Canadian Quickbooks? I live in Alberta so there is only one tax....is it the double tax that is the issue?

Is there a text file somewhere with QBI 3-02 Configuration and User Manual. I cannot open pdf files on this linux machine. If there is one can you post a link or send it via email?

Be much appreciated.

knuckle-101:

Is there a text file somewhere with QBI 3-02 Configuration and User Manual. I cannot open pdf files on this linux machine. If there is one can you post a link or send it via email?

Be much appreciated.
I do not include the user manual in doc format, since it is copyrighted (documentation is not part of the GPL) and I want to assure that it is not reused or altered. Surely you must be able to find a computer that can open pdf files and at least print it out! I'd think there would even be a pdf reader for linux, since it is an open format.

Thanks,
Adam

rachandcam:

Okay, this may be a stupid question...but why won't the US version of QBI work with the Canadian Quickbooks? I live in Alberta so there is only one tax....is it the double tax that is the issue?
I have not had time to investigate all the different international QB versions yet. You can of course go ahead and try it -- if QB doesn't like it, it will tell you with error messages when you try to import the iif file.

Thanks,
Adam

Hi All,

I will be on vacation July 1 through August 15. I'll try to check the forum every few days, but bug fixes and work on international versions will have to wait until I return. I hope this is not a great inconvenience!

Thanks,
Adam

Can this import orders as Sales Orders?

Thanks.

tj1:

Can this import orders as Sales Orders?

Thanks.
Yes, you can set it up to import orders that are paid online as sales orders.

Thanks,
Adam

Hi, I'm trying to upload my lists file, but I keep receiving this message even though the folders are set to 777:

File upload failed! Check that the permissions settings for your qbi_input directory are set to read/write/execute or chmod 777

I will try to ftp the file now instead and see how that works.

tj1:

Hi, I'm trying to upload my lists file, but I keep receiving this message even though the folders are set to 777:

---

File upload failed! Check that the permissions settings for your qbi_input directory are set to read/write/execute or chmod 777

---

I will try to ftp the file now instead and see how that works.
It doesn't sound like a QBI issue -- yes, check you server settings, and make sure that file uploads are enabled in PHP and that the temp directory that PHP uses for file uploads is set up properly. You can ftp the file to the directory and QBI will recognize it just the same -- but make sure you call it lists.iif

Thanks,
Adam

When Importing into QB it is putting any company name that is more than one word (Wireless Retail group) into one (ie WirelessRetailGroup)

Any way to keep it the original w/ spaces?

It just sux cause its making new customers for people I have already dealt with that are setup in QB.

Thx - Dave

Did anyone else have trouble importing orders? I just get a ton of errors.

Also on the product import there was something goofy on products with quotes " in the title. Workaround for that one?

Got this Mod working and its great. Today however I noticed that QBI is not allowing me to download one of my orders. it totally skips over it. It recognizes 1 New order (# 1231) and a previous batch of 2 orders (1228 to 1229) See below:

New Orders
Quan: 1
No.: 1231
Date: Jul 8, 2006 2:38 pm

Previous Batch of Orders
Quan: 2
No.: 1228 to 1229
Date: Jul 7, 2006 3:58 pm to Jul 7, 2006 5:44 pm

I need to import order # 1230!

Any idea why this would happen and if its common and may happen again?

Also any way of just importing one specific order (maybe by order #) into QB?

Did some playing around and figured out that it has somehting to do with editing an order with Super orders - Adv order Mgt. Any1 else run into this bug? before i edit the order ti shows up as a new order in QBI - as soon as I edited it (Added an item to the order) It disappeared from the Craete IIF screen.

Anything we can do to get these 2 awesome mods to be able to work together?

So Sorry - Played around for a bit longer and it had nothing to do with super orders - that was justa coincidence, Git it all figured out now!

dcfxking:

When Importing into QB it is putting any company name that is more than one word (Wireless Retail group) into one (ie WirelessRetailGroup)

Any way to keep it the original w/ spaces?

It just sux cause its making new customers for people I have already dealt with that are setup in QB.

Thx - Dave

Dave,
The spaces are removed from the customer number (called Name in QB), because it is assumed that a customer number, like most account numbers, is one block and does not contain spaces. However, I can show you how to modify this when I return from vacation in one month.

Thanks,
Adam

Does anybody have any idea how to make an icon or a shortcut in quickbooks that links to files->utilitis>import>iif ?

Just looking to streamline the process of importing the iif file. Youd think this would eb possible but i am having no luck

Another issue i am noticing. When the customer data is imported into QB It is puttin compnay name on 1st line, Persons name on 2nd, address on 3rd etc.

This poses a problem when using QB Shipping Manger, it puts the customers name on the 1st address line and moves the actual address to the adress line 2 fiels where apt #/suite # would go.

Anyone else run into this? Any fix for thsi besides manually messing with the addresses each time?

Thanks!

dcfxking:

Another issue i am noticing. When the customer data is imported into QB It is puttin compnay name on 1st line, Persons name on 2nd, address on 3rd etc.

This poses a problem when using QB Shipping Manger, it puts the customers name on the 1st address line and moves the actual address to the adress line 2 fiels where apt #/suite # would go.

Anyone else run into this? Any fix for thsi besides manually messing with the addresses each time?

Thanks!
I'll look at this when I return.

Thanks,
Adam

adam5532 - 10th July 2006:

I can show you how to modify this when I return from vacation in one month.

adam5532 - 23rd July 2006:

I'll look at this when I return.

Um ... I thought you left 2 weeks ago ... :shocking:

Or maybe you work on vacation like I do .... :smartass:

Hi, there is another plugin that works great at import sales into quickbooks and also support making shipping labels with USPS.

Please download it at:

http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_41&products_id=223

Let me know what you think, Thanks!