Hello,
We have a customer that wants to do Tax Inclusive Pricing. Meaning that they want to charge TAX of (8.25% Los Angeles, CA) but they want the system to back calculate the price so it?s an even number.
Example:
They want a pair of sun glasses to be $100.00 even INCLUDING TAX. So if the glasses cost 92.38 + 8.25% tax it will be $100. They want to enter in $100 in the price field instead of back calculating the price themselves; they want RMS to do it. Does RMS have such mathematically capabilities? We sell other POS software for restaurants that have this feature.
Formula is Price Divided by 1.0825 = Price before tax. I tried a SQL query but that only works the first time, after that it will start modifying the already modified ones.
Any ideas?