Make the following changes to a database previously developed by you:
1. The surcharges are not calculating properly, i.e. surcharge is calculating the same as the fuel tax for the jurisdictions that have it. My error. I thought it should be the same. The fuel tax is calculated correctly with Taxable Paid Litres deducted from Taxable Litres to equal Net Taxable Litres then calculated by the tax rate. The surcharges (KY, IN, VA) should be the Taxable Litres calculated by the surcharge tax rate. It does NOT take the Tax Paid Litres into account.
2. When you redo this calculation, please remember that the Total Kilometres in each jurisdiction should only be counted once. You have this done correctly now, I just want to ensure when you rework the surcharges that the kilometres are not added twice into the Total kms. along the bottom of the reports or into the KPL calculation.
Let me know if you require any additional information Francois.
Hi there, I read your initial requirements and I have some questions regarding your ACCESS FUEL TAX DATABASE CHANGES FOR FRANCOIS project. please send me a message so that we could discuss it further.