Hello Gurus! :)
I have a situation for which I came up with a high-level solution, but there are some details that I was hoping you could help with please.
Scenario:
We will sell a certain quantity of an item, such as 50 pens, and the SO will have only one line item. These 50 items can be shipped to different locations and scripting will take care of it. And depending on the ship-to location, some items will be taxable.
Example: Assume we sell 50 pens, and 49 are shipped to New York, and 1 is shipped to California. California pen is taxable. Imagine each pen is $1. CA pen is 50% taxable.
My solution is simple in the sense that we tell NS that if is shipped to CA, then make the quantity that is shipped to CA taxable.
So, GL impact will be something like:
Dr AR $50.5 (50 total sales + 50%x$1 tax)
Cr Sales $50
Cr Tax Payable 0.5
Question:
What is the best way to ensure the correct tax is used in this circumstance? In other words, since we are not utilizing standard NS tax solution, since we have only 1 line item on the SO, how do we tell NS (meaning specific combination of zip code + tax code, etc.) to use the proper tax for this item?
Thanks.