https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 10 Apr 2026 17:35:13 +0000 Fri, 06 Aug 2010 23:48:45 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=3903 https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ https://forum.productcart.com/line-item-tax-send-tax-table-info_topic3903_post15195.html#15195 Author: Matt
Subject: 3903
Posted: 06-August-2010 at 11:48pm

Thank you for the screenshot.  You know the saying... a picture is worth a thousand words. :)

The Order Level feature will map things the way you want.  My only concern is that you would have to map so many, and update them each year.  It would take a week to add them all and map them.  Also, the tax by location interface may not handle 1000+ items.  It was not optimized for that many entries. That is what the tax file does. 

Your best bet is doing it all directly through SQL Manager or writing a script.  We do not have an import script pre-made for that sort of task.  If I remember correctly you have some developers on staff that could build one.  You would need to import your spread sheet to create the tax locations and automatically create a mapping record.

I will create a wish list item for adding rate to the line item description, but I am not sure when the next update will be released.  We just put out v1.07 last week. 
]]> Fri, 06 Aug 2010 23:48:45 +0000 https://forum.productcart.com/line-item-tax-send-tax-table-info_topic3903_post15195.html#15195 https://forum.productcart.com/line-item-tax-send-tax-table-info_topic3903_post15194.html#15194 Author: odathp
Subject: 3903
Posted: 06-August-2010 at 10:34pm

There is a line item tax, but not showing tax rate.  Also, the tax rate does not display in the PC invoice.

To be honest, I really like the idea of taxing by location and mapping each tax code to an item in QuickBooks.  That would completely resolve the real issue here.

When using a tax file, QB Add-on requires using a line item tax which can not be mapped to items in QB.

]]> Fri, 06 Aug 2010 22:34:17 +0000 https://forum.productcart.com/line-item-tax-send-tax-table-info_topic3903_post15194.html#15194 https://forum.productcart.com/line-item-tax-send-tax-table-info_topic3903_post15193.html#15193 Author: Matt
Subject: 3903
Posted: 06-August-2010 at 9:30pm

Hi John,

Tax by Location does require mapping.  Everything I said is correct, except that I said "zone" instead of "location".  You would need to create one "location" for each of the tax codes and map them to items in QuickBooks.

Regarding the line item tax.  I am not clear at all.  You are saying that invoice does not show the tax rate, but you are deleting the line item tax from QuickBooks.  It sounds like it is there if you are deleting it.  Are you saying their is a line item, but it has no rate (e.g. 0%).  If that is what you are saying you should open a ticket so we can review your control panel settings.  No one has ever reported that issue before.

In any event, if you are removing the line item tax from QuickBooks and replacing it with Order Level, then why not just use the Order Level setting?

If you need further assistance please open a ticket so we have the information we need to properly investigate. 


]]> Fri, 06 Aug 2010 21:30:58 +0000 https://forum.productcart.com/line-item-tax-send-tax-table-info_topic3903_post15193.html#15193 https://forum.productcart.com/line-item-tax-send-tax-table-info_topic3903_post15192.html#15192 Author: odathp
Subject: 3903
Posted: 06-August-2010 at 8:50pm

Just so we are on the same page, the invoice does not show the tax rate when using a tax file.  That is our problem.

Also, I wasn't talking about using tax zones.  I was thinking about using tax by location using zip codes, which does not require mapping them to items in Quickbooks.

It seems like the tax by location using zip codes is the same as using a tax file with the benefit of a user defined description along with going back to an order level tax vs the line item tax.

Here is what our customer is currently doing.

1.  Going PC and editing the order
2.  Clicks on "Check Tax Rate" and gets the tax info (Orange County 7%)
3.  Going back to QB invoice and deleting the line item tax
4.  Changing the invoice to order level
5.  Selecting a tax account for the appropriate tax rate

If we could show the tax rate on the invoice, they wouldn't have to go back to PC and find the tax rate for each invoice.  They would still be deleting the line item tax because QB Add-on does not support order level tax when using a tax file.

Thanks again,
John
]]> Fri, 06 Aug 2010 20:50:20 +0000 https://forum.productcart.com/line-item-tax-send-tax-table-info_topic3903_post15192.html#15192 https://forum.productcart.com/line-item-tax-send-tax-table-info_topic3903_post15191.html#15191 Author: Matt
Subject: 3903
Posted: 06-August-2010 at 8:19pm

Thanks John, that is correct.  Really the tax file is a great option for you.  Entering 1471 zones into ProductCart and mapping them to items in QuickBooks would work, but that is really not efficient.   What exactly do you need in your report?  The invoice already has the zip code and tax rate.  Do you need the county name?  Maybe you can customize the report.  Just a thought.]]> Fri, 06 Aug 2010 20:19:19 +0000 https://forum.productcart.com/line-item-tax-send-tax-table-info_topic3903_post15191.html#15191 https://forum.productcart.com/line-item-tax-send-tax-table-info_topic3903_post15189.html#15189 Author: odathp
Subject: 3903
Posted: 06-August-2010 at 8:00pm

The "Display taxes separately" option is not available when using a tax file.  We are using a tax file.

We did noticed when "not using a tax file" there is an option for taxing by location.  It appears in theory we could add each Florida zip code and the corresponding tax rate with a description.

The customers tax file has 1471 zip codes.  Wonder if there is a way to import that data into PC database?

Seems to be a better option then a tax file.  Giving us the ability to put a description of each tax rate that we are assuming would show up on the invoice.

Thanks,
John
]]> Fri, 06 Aug 2010 20:00:11 +0000 https://forum.productcart.com/line-item-tax-send-tax-table-info_topic3903_post15189.html#15189 https://forum.productcart.com/line-item-tax-send-tax-table-info_topic3903_post15187.html#15187 Author: Matt
Subject: 3903
Posted: 06-August-2010 at 12:55pm

So you basically just need the description of the tax in QuickBooks to have more detail.  What value do you have for "Display taxes separately?" in ProductCart tax settings?]]> Fri, 06 Aug 2010 12:55:01 +0000 https://forum.productcart.com/line-item-tax-send-tax-table-info_topic3903_post15187.html#15187 https://forum.productcart.com/line-item-tax-send-tax-table-info_topic3903_post15185.html#15185 Author: Greg Dinger
Subject: 3903
Posted: 06-August-2010 at 10:34am

Some time ago we built a custom sales report that tracks sales tax by rate at the line item level.  If that would be useful, we could provide such a mod for you.]]> Fri, 06 Aug 2010 10:34:44 +0000 https://forum.productcart.com/line-item-tax-send-tax-table-info_topic3903_post15185.html#15185 https://forum.productcart.com/line-item-tax-send-tax-table-info_topic3903_post15184.html#15184 Author: odathp
Subject: 3903
Posted: 06-August-2010 at 10:21am

I guess my last post was a little long winded.  To summarize, the customer is currently using line item tax and a tax file.  Everything works.  They would like to include the [tax file] tax rate on the invoice.

The invoice currently says "Florida Sales Tax" on the line item tax description.  They would like to change it to "Florida Sales Tax (Orange County 7%).  "Orlando County 7%" comes from the tax file.

Could you point me to the code?  I could have my staff modified it to meet the customer needs.  Or, if Early Impact feels this is a valuable enhancement, they could include it in the next version of PC.

Now that I think of it, this is possibly not a QB Add-on issue.  I put it here because the customer needs to identify the tax rate for each invoice that is sent to QB (for IRS auditing purposes).

Thanks,
John
]]> Fri, 06 Aug 2010 10:21:33 +0000 https://forum.productcart.com/line-item-tax-send-tax-table-info_topic3903_post15184.html#15184 https://forum.productcart.com/line-item-tax-send-tax-table-info_topic3903_post15181.html#15181 Author: Matt
Subject: 3903
Posted: 06-August-2010 at 2:14am

Hi John, are you asking if the Add-On supports order level tax, or are you saying it is not working?  Have you read the section in the guide about configuring your tax preferences?  From what you have posted I think line item tax and a tax file would be the best solution for you.  However, you can use order level tax and have the same results.  You basically just map the accounts in ProductCart to the ones in QuickBooks.  If you feel you have found a bug please open a support ticket so we can investigate.]]> Fri, 06 Aug 2010 02:14:52 +0000 https://forum.productcart.com/line-item-tax-send-tax-table-info_topic3903_post15181.html#15181