Quickbooks Import QBI

[barrys]

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.

[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.

[adam5532]

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

[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?

[adam5532]

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

[rmccown]

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

[adam5532]

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

[rmccown]

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

[rmccown]

Just FYI, too, this is exporting previous orders.

[adam5532]

Just FYI, too, this is exporting previous orders.

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

Thanks,
Adam