Getting Error #500 From Quickbooks
| Project: | Ubercart Quickbooks Integration |
| Version: | 5.x-1.x-dev |
| Component: | Documentation |
| Category: | task |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
It is very likely that I have not set everything up correctly, but I am unsure where to go from here. I ran through everything in the README.txt and after a bit of work got all of the modules that this depends on set up. I got the web connector up and running, but now when I try to run the web connector, none of the orders are moved over. I am getting watchdog entries for each product that look like this:
QB responded to a request with error #500 (The query request has not been fully completed. There was a required element ("MODEL") that could not be found in QuickBooks.)
The MODEL value is just that. It is the model from the uc_order_products table. Any thought as to what is happening would be great.
Versions:
uc_qb.module,v 1.1.2.1 2008/08/21
Quickbooks: Premier Accountant Edition 2007
#1
I figured it out. The issue wasn't the above, but that I didn't have taxes turned on. I just set up a rough environment for testing, and as soon as I turned it on, all of my orders were moved over.
#2
Glad you figured it out and that everything is working!
#3
If the taxes being enabled is a requirement, then maybe the Readme.txt should be updated (or the module patched to make that optional?) I've set this to active again to track that.
#4
ChrisBryant has a good point. The following should be added to the documentation:
********************************************************************
QUICKBOOKS CONFIGURATION:
Make sure you have the following accounts set up in QuickBooks:
1. Name: "Merchandise Sales", Type: "Income"
2. Name: "Merchant Account Fees", Type: "Cost Of Goods Sold"
3. Name: "Inventory Asset", Type: "Other Current Asset"
The following preferences need to be enabled (and configured) in your company file:
1. Go to Edit > Preferences
2. Click the Items & Inventory button in the sidebar
3. Click the Company Preferences tab
4. Enable the checkbox "Inventory and purchase orders are active."
5. Click the Items & Inventory button in the sidebar
6. Click the Company Preferences tab
7. Make sure "Do you charge sales tax?" is enabled
#5
Personally, I think this sort of data should appear in the status report, and/or on the configuration page for uc_qb. The module should let you know what it needs, not bury it in a README that many people will never look at. This may sound a bit cynical, but every time I install a module that leads me through it's own setup process, it brightens my day.
Of all the dozens of modules I've used, qb/uc_qb have been THE HARDEST to figure out, period.
I wish to change that, because this is a great tool (_if_ you can get it set up).