louf Posted January 27, 2008 Share Posted January 27, 2008 I am using the Business Tracker. I have two levels of sales tax to calculate. The first is the General Sales Tax .0875. The other is a sales tax on clothing. The sales tax is .04 for the first $110 and total clothes purchases over $110 go to the general sales tax of .0875. I have a combination of sales, some clothing and some general merchandise. How can I caluculate the clothing to say that if purchase is $110 are .0875 and all other sales are taxed at.0875? Thanks Link to comment Share on other sites More sharing options...
Jack Rodgers Posted January 27, 2008 Share Posted January 27, 2008 I am using the Business Tracker. I have two levels of sales tax to calculate. The first is the General Sales Tax .0875. The other is a sales tax on clothing. The sales tax is .04 for the first $110 and total clothes purchases over $110 go to the general sales tax of .0875. I have a combination of sales, some clothing and some general merchandise. How can I caluculate the clothing to say that if purchase is $110 are .0875 and all other sales are taxed at.0875? Thanks If ( clothing and Link to comment Share on other sites More sharing options...
louf Posted January 28, 2008 Author Share Posted January 28, 2008 If ( clothing and Jack, I tried that. It sums all of the tax in the portal. Here is a sample transaction. Item Qty Price Tax Rate Ext Price Clothing 1 $60.00 4% $60.00 Gen Merch 1 $40.00 8.75% $40.00 Sales Tax Clothing $2.40 Sales Tax Gen Merch $3.50 Note: If the total clothing amount was more that $110, the total purchase would be taxed at 8.75%. But since the clothing amount is less than $110, there is actually 2 sales tax calculations needed. I cannot get them to calculate separate in the portal. Does this help illustrate the set up? Thanks for your answer. Link to comment Share on other sites More sharing options...
Jack Rodgers Posted January 28, 2008 Share Posted January 28, 2008 OK, for each item record add two fields, IsClothing and NotClothing (whatever...) Portal Record: Item Price Qty Extended price Calc Field XPrice (Is Clothing) Calc Field XPrice(Is Not Clothing) INVOICE Fields Sum clothing Sum Not Clothing Now do your calc for tax Link to comment Share on other sites More sharing options...
louf Posted January 28, 2008 Author Share Posted January 28, 2008 OK, for each item record add two fields, IsClothing and NotClothing (whatever...) Portal Record: Item Price Qty Extended price Calc Field XPrice (Is Clothing) Calc Field XPrice(Is Not Clothing) INVOICE Fields Sum clothing Sum Not Clothing Now do your calc for tax Jack - I have attached a word document to illustrate. I tried what you gave me, but each portal was not totalling all of the "Clothing" items together. Perhaps the attachement will give more insight! Link to comment Share on other sites More sharing options...
Jack Rodgers Posted January 28, 2008 Share Posted January 28, 2008 OK, here's a quick demo that works. However, if you change the amount for an item the calcs are slow to update and need a commit. If you add items they work ok. I didn't pretty it up, round numbers, etc. You can add quantity, etc. Link to comment Share on other sites More sharing options...
louf Posted January 28, 2008 Author Share Posted January 28, 2008 OK, here's a quick demo that works. However, if you change the amount for an item the calcs are slow to update and need a commit. If you add items they work ok. I didn't pretty it up, round numbers, etc. You can add quantity, etc. Jack That works Great! Thanks for all your help! Lou Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts