RE:[sap-log-mm] Sales Tax Calculation Using Brackets

Posted by Sap Land Tuesday, 13 September 2011 12:34

Posted by bsue2
on Sep 13 at 3:34 PM

There is truly no rounding rule from the State of Florida. It is a hard-coded table provided by the State. So rounding up would be mostly correct, but we could over-pay or over-charge tax. Rounding down would more often under-pay/charge tax.

Dave: is this configuration? " implement something in the condition value formula to use the range tables. "

Satish: if we write a routine, where does it go (user exit? what program?)

Thanks for your feedback.

---------------Original Message---------------
From: Betty Sue Shane
Sent: Thursday, September 08, 2011 8:52 AM
Subject: Sales Tax Calculation Using Brackets

Florida uses fixed range brackets for the cents portion of the sale and a straight percent on the whole dollars. For example, the tax on 17-32 cents is 2 cents. A 6% calculation on 23 cents is only 1 cent. So for a sale of $10.23, the tax is 10.00 * 6% = .60 + .02 for a total of 62 cents. There are multiple ranges associated with the tax rate. This is not straight rounding up in all cases. How to configure this in SAP? Or is this a user exit or modification? WE DO NOT PLAN TO USE A TAX SERVICE SUCH AS VERTEX.

__.____._