Quickbooks Import QBI

Thanks for the reply Adam. I am using the Payflow Pro module as well as Paypal Express.

Everything is set up as services because I do not sell actual products. I am using Zen cart for convention registrations.

Hi Adam,

This looks like a great contribution and one that would save hours of time but unfortunately i am located in the UK running a UK version of quickbooks. Do you have any plans to release a UK version? This is something I would gladly pay for if it was available.

Quote:

---

Originally Posted by asphole

Hi Adam,

This looks like a great contribution and one that would save hours of time but unfortunately i am located in the UK running a UK version of quickbooks. Do you have any plans to release a UK version? This is something I would gladly pay for if it was available.

---

Yes, UK and Canadian versions are coming. No release date yet. Watch the qbisoftware site for updates.

Thanks,
Adam

I'm using Quickbooks Premiere 2006. I have imported customers and products to QB fine, but when I try and import orders, I get the following error:

Error on Line 6: Imported record has an invalid date. It should be MM/DD/YY.

the line number changes for each order.

I don't see a config option either in QBI or Quickbooks to allow/set the date format. Help?

Quote:

---

Originally Posted by rmccown

I'm using Quickbooks Premiere 2006. I have imported customers and products to QB fine, but when I try and import orders, I get the following error:

Error on Line 6: Imported record has an invalid date. It should be MM/DD/YY.

the line number changes for each order.

I don't see a config option either in QBI or Quickbooks to allow/set the date format. Help?

---

In Quickbooks, under Edit: Preferences: General: Company Preferences, try checking "Always show years as 4 digits".

Thanks,
Adam

Quote:

---

Originally Posted by adam5532

In Quickbooks, under Edit: Preferences: General: Company Preferences, try checking "Always show years as 4 digits".

Thanks,
Adam

---

I looked at that option, and it was already checked.

I hand-edited the iif file, to make the date on the TRSN line of each transaction mm/dd/yy (ex 02/03/08), but keep the rest of the lines 02/03/2008, and it imports fine.

Odd

Quote:

---

Originally Posted by rmccown

I looked at that option, and it was already checked.

I hand-edited the iif file, to make the date on the TRSN line of each transaction mm/dd/yy (ex 02/03/08), but keep the rest of the lines 02/03/2008, and it imports fine.

Odd

---

There must be a setting somewhere in your Windows or Quickbooks affecting this, because it hasn't come up before in 3 years and 10's of thousands of users!

- Adam

Strange. Basic QB install, and XP Professional. US English, nothing fancy.

Just FYI, too, this is exporting previous orders.

Quote:

---

Originally Posted by rmccown

Just FYI, too, this is exporting previous orders.

---

If you export current orders, do you not get this problem?

Thanks,
Adam