If you open the Tax Type form, open a tax and go to the Rates tab, then the Effective Rate tab, the the Detail tab. The box labeled percentage holds the tax percentage, expressed as a decimal. If you open the form in designer mode, you will see that the text box’s epi binding is a TaxRate.DspTaxPercent, which is not an actual field in the table. There is a field in TaxRate called TaxPercent. however for all of our taxes, the TaxRate.TaxPercent is 0.00.
I am trying to create a query to review all the tax rates, but it won’t work…
Epicor won’t tell me where to find this information. They tell me I need go pay someone at Epicor to tell me where the number is stored.
Does anyone else know? We aren’t using any 3rd party tax services.
Thanks for any help.
Epicor version 10.0.700.2
I’m not sure where it is, but I would put a 99% tax in the field you are trying to find and then check all of the tax tables to locate it. The 99% should stick out.
if you are on 10.0… Then it appears you will find the Tax Rates in the PatchFld Table:
SELECT [Company]
,[TableName]
,[FieldName]
,[ForeignKey]
,[FieldDataType]
,[DataCharacter]
,[DataDate]
,[DataLogical]
,[DataInteger]
,[DataDecimal]
,[SystemFlag]
,[SysRevID]
,[SysRowID]
FROM [Epicor10SandBox].[Ice].[PatchFld]
WHERE TableName = ‘Taxrate’ and FieldName = ‘TaxPercent’
The Challenge is to join it to the TaxRate table because the ForeignKey looks like this:
~~
which looks like this in the PatchFld.ForeignKey:
CA34375~CA34375~10/06/17
It appears that after 10.1 this has been upgraded to be in the actual TaxRate table where the 10.1… TaxRate.TaxPercent has a format of 5 decimal places: 5.50000 and does present the data when you run a query against that table…