This issue actually came to light from the Canadian version of the Online system. For the American version, it worked. The American version seemed to accept anything for taxes, or nothing at all, but the Canadian version has no option for automatic taxes, and is very rigid, so as a developer, you have to pull the tax code table and the rate table to get the tax code and rate IDs. QuickBooks has it structured as two different tables. In the program I'm working with, it's a single table with one column for tax code, and one column for tax rate ID. When I push an invoice, I have to grab the data in this table and send those codes or else I get a business validation error. My question is - what if I sell to someone who has a tax code record with multiple rates? QuickBooks allows for it, but no one would need to enter multiple rates for a Code unless they were in a municipality somewhere that had multiple rates per code for some reason. Does anyone know of any place that does that? In Vermont, there's only one rate per Vermont code. In Winnipeg with the GST, there's only one rate for the GST code record, but what about the rest of the world? In the QuickBooks interface, I thought I just selected Vermont. I don't recall having to make separate rates, myself, but that's the American version. I can probably test NYC which if any place would have a complicated tax system, I think they're likely, but I can't test for Canada because I don't have access to an online Canada QuickBooks system. If there's a way I can set one up through the Sandbox, please let me know. I was really surprised they were that different in that the Canadian version gave me a business validation error and the American version was fine with it.
