Quickbooks Import QBI

[gorie]

I'm having a problem with exporting orders to Quickbooks. Basically, all order information is exported properly EXCEPT that the detail of the actual items ordered is not included in the iif file. The items ordered do show up in emails generated by ZenCart, as well as in Admin/Customer/Orders -- they just don't come through in the QBI generated iif file.

The error is a Quickbooks Import Error ("transaction not in balance"). All customer data imports properly, just not the item information. I'm using QBI 3.21, ZenCart 1.3.8.

Thanks in advance for any suggestions.

i just had this same erorr, after using this mod forever with no problems. (although i did recently upgrade to 139e)

ok this is going to sound confusing, but for me, the problem was in the way the calculations were for an item i had on "special". (not sure if that is related) but something was happening with the calculations somewhere. the item was marked down 5% from 7.95 to 7.55. she bought 4 of them, and in the .iif file, it had the total as 30.2 - but she was charged 30.21 - and it was trying to import in quickbooks as 30.2 and that was causing the error because of it being .01 off. so i went into the.iff file and manually changed to 30.21 and then it imported fine. took awhile to figure that one out !

[adam5532]

i just had this same erorr, after using this mod forever with no problems. (although i did recently upgrade to 139e)

ok this is going to sound confusing, but for me, the problem was in the way the calculations were for an item i had on "special". (not sure if that is related) but something was happening with the calculations somewhere. the item was marked down 5% from 7.95 to 7.55. she bought 4 of them, and in the .iif file, it had the total as 30.2 - but she was charged 30.21 - and it was trying to import in quickbooks as 30.2 and that was causing the error because of it being .01 off. so i went into the.iff file and manually changed to 30.21 and then it imported fine. took awhile to figure that one out !

I'm not clear if your problem had to do with item descriptions, or just with rounding. The problem you describe with the discount amount is due to a bug in your discount module, not QBI. Your discount module is displaying a rounded price of 7.55, so 4 items should cost 30.20. It is, however, entering the unrounded price of 7.5525, which equals 30.21 for 4 items.

So, it is actually Zen Cart that has the wrong price. QBI calculates the 4 items itself, but uses the online store's calculation for the total price, hence the out-of-balance condition. The ultimate solution is to fix your discount module, so that the customer is charged the correct price when they check out.

Thanks,
Adam

[gorie]

I'm not clear if your problem had to do with item descriptions, or just with rounding. The problem you describe with the discount amount is due to a bug in your discount module, not QBI. Your discount module is displaying a rounded price of 7.55, so 4 items should cost 30.20. It is, however, entering the unrounded price of 7.5525, which equals 30.21 for 4 items.

So, it is actually Zen Cart that has the wrong price. QBI calculates the 4 items itself, but uses the online store's calculation for the total price, hence the out-of-balance condition. The ultimate solution is to fix your discount module, so that the customer is charged the correct price when they check out.

Thanks,
Adam

it definitely seems to be the pricing issue.
how do i do that? i think it is the one that came w/ the latest zencart upgrade, what is the file that does that so i can check?

[gorie]

oops - i meant it is the rounding issue, as a result of a "specials" discount percentage being applied.
not how the pricing is entered in the product description.

[gorie]

oops - i meant it is the rounding issue, as a result of a "specials" discount percentage being applied.
not how the pricing is entered in the product description.

i actually just got this error again. this time due to how the tax was calculated and being .01 off again. i never had this error in the past. just since upgrading from 138 to 139e. i'm not sure of what other changes could have caused this.

[adam5532]

i actually just got this error again. this time due to how the tax was calculated and being .01 off again. i never had this error in the past. just since upgrading from 138 to 139e. i'm not sure of what other changes could have caused this.

Make sure that you are not using a Sales Tax Group in QB. There is a major bug in QB regarding Sales Tax Groups that they have never fixed. In QB, the individual taxes in the group get rounded to 2 placed before being added together, instead of after, as it should be. Therefore, in random cases the calculation in QB can be off by one cent. The solution is to use a Sales Tax Item, not a Group.

Also, there are some payment modules that have rounding errors. Due to the way computers handle floating point numbers, sometimes rounding can be done incorrectly. This is corrected using a PHP statement such as:
$order->info[’total’]+=0.000001;
You can calculate the amounts yourself to see if this is what happened. This issue is described further in section 14a of the QBI 3.21 User Manual.

Thanks,
Adam

[adam5532]

oops - i meant it is the rounding issue, as a result of a "specials" discount percentage being applied.
not how the pricing is entered in the product description.

You'd need to find the forum area that deals with problems in discount modules, unless someone else can help you here. I don't have time to help with issues that aren't with QBI. Sometimes QBI reveals calculation errors in other modules that would not have been noticed otherwise.

Thanks,
Adam

[mikestaps]

Just finished setting up everything, completed a test order and tried to import it. I got the unbalanced error message, looked at the .iif file and noticed the shipping charge was left out. What would cause this to happen?
Thanks

[mikestaps]

Just finished setting up everything, completed a test order and tried to import it. I got the unbalanced error message, looked at the .iif file and noticed the shipping charge was left out. What would cause this to happen?
Thanks

Fixed it.... doh, somehow the shipping got turned off for the checkout process.

[mikestaps]

Wow, thanks for taking the time to write that extra function, although I had already implemented that before my last post.

Thanks for the great support and great contribution. I've been able to find workarounds for some of the limitations by making very minor changes or commenting something out.
This has allowed me to import as estimates, which can then be used to create sales orders.
Also, attributes are now imported only as part of the product description, without creating endless subitems in Quickbooks.
If anyone needs this let me know and I'll post what I did.

Does anybody know how to do this? It would be very helpful for my setup.
TIA