Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Quickbooks Iff Export From 4.3.3 Rate Topic   - - - - -

 
  • Magpie Don
  • Senior Member
  • Members
  • Join Date: 01-Apr 09
  • 813 posts

Posted 01 September 2015 - 03:06 PM #41

We are still unsure if we are going to upgrade to version 4.3.x and right now we still have a couple of sites using 4.2.x.  So we won't install it.

 

The main reason we stopped using your Quickbooks export file was because it deletes the "cost" associated with each product inside of Quickbooks.  I worked with your support some time ago but they never could figure out why.  Needless to say, deleting the cost on all of our products was quite the pain in the neck.

 

 

Probably this is somehow depends on your Quickbooks version or configuration. Have not heard about any other complains regarding this.

 

CS-Cart's default export INCLUDES exporting ALL the products that are in the orders. The product export includes the COST value, which is NOT in the CS-Cart product data. IF you export the products, the export will contain a ZERO value for COST and overwrite any value you have for COST in your Quickbooks data. It is not dependent upon which version of QB you are using.

 

The current QB export is for ORDERS - which includes the CUSTOMER, ORDER, PAYMENT, and PRODUCTS.

 

To solve the problem just comment out, or delete the entire function for exporting products.

IF CS-Cart wants to build a Quickbooks export for products, they should do that separately.


CS-Cart Ultimate ver 4.3.5


 
  • Magpie Don
  • Senior Member
  • Members
  • Join Date: 01-Apr 09
  • 813 posts

Posted 01 September 2015 - 03:08 PM #42

The other nice part was their software didn't require us to edit every downloaded file like Don is suggesting we do with the file from CS-Cart.

 

I do not edit each downloaded file. After fixing the export process, the IIF file is exported, then imported directly into QB without error. I've been doing it this way for years.


CS-Cart Ultimate ver 4.3.5


 
  • laura
  • Junior Member
  • Members
  • Join Date: 03-Nov 08
  • 2 posts

Posted 30 December 2015 - 10:20 AM #43

You can try it. Just replace the file app/addons/quickbooks/controllers/backend/quickbooks_export.php with one from the attachment. Please post your feedback here so I can add some updates or improvements.


The error message that we are getting when we import the IIF into QuickBooks is "The tax field cannot be left blank, even for non-taxable customers and sales which have no taxable items, so non-taxable sales will be correct for this district."

The version of QuickBooks we are using is Premier Manufacturing and Wholesale 2012.

How can we send you screen shots in a private setting?

 
  • imac
  • Head of Product
  • CS-Cart Architects
  • Join Date: 22-Nov 05
  • 2074 posts

Posted 04 January 2016 - 07:23 AM #44

The error message that we are getting when we import the IIF into QuickBooks is "The tax field cannot be left blank, even for non-taxable customers and sales which have no taxable items, so non-taxable sales will be correct for this district."

The version of QuickBooks we are using is Premier Manufacturing and Wholesale 2012.

How can we send you screen shots in a private setting?


Hi laura,

Please post a ticket to the Help desk. We will investigate. In the ticket title please add a note "for imac"
Ilya Makarov,
CS-Cart Architect Team
Suggest and vote for new features | Report a bug