It’s interesting to see the ability to have a tiered sales tax system being offered but here, we have what might be considered to be a unique situation. Our sales tax rate is 6% but has a cap of $30 irregardless if the purchase amount exceeds $500. Is there a built in method to enable a sales tax cap within Dolibarr? If not, is it a difficult thing to implement? I did check the store for an addon but did not find one there either.
As with most things, there are multiple ways to accomplish the result you desire.
With some programming skills, you could create a conditional calculated sales tax field in the “Sales Order Module”
An alternative but not as elegant would be to:
- Create a Sales Tax Rate of 0% in Dictionary Setup
- Create a Sales Tax “Product” with $30 as the selling price along with the appropriate accounting accounts
In practice, if your sales order is going to be more than $500, you would choose the 0% sales tax for the line items. You would lastly insert a “Sales Tax” product for the $30.00 and then process accordingly.
Hope this helps.
Frank
I’m somewhat familiar with database access & manipulation but do not have much for programming knowledge with php. There are also a myriad of tables in the database & without knowing the full schema of the database, could be disasterous, The other option was something I thought of but as stated, it would be ugly. The unfortunate part of it is the invoice will have the actual sales tax line at the bottom but there will not be an entry… kind of appears that the company isn’t in control… hmm, what to do?
Dolibarr does allow calculated fields to be user developed and implemented without php programing knowledge.
However, the alternative method I described is similar to what I use for my sales on Ebay. Each state and locality seems to have different tax rate percentages. It was far simpler to insert the appropriate sales tax as a line item on the invoice than to define a multitude of tax rates in the sales tax dictionary.
