|
|
updates:fuel-uploading-fuel-taxes-file-implemented [2021/02/23 11:25] bartek created |
updates:fuel-uploading-fuel-taxes-file-implemented [2021/02/23 12:12] (current) bartek |
====== FUEL TAXES FILE ====== | ====== COUNTRY TAX RATES FILE ====== |
| |
[{{ :leon:fuel-prices:fuel prices after tax uploaded.png?200|Fuel taxes from uploaded file}}] | |
| |
When uploading fuel prices files to Leon, not all of them contain of a 'Total' price (including taxes). To make possible viewing 'Total' fuel prices in both: Fuel Prices & OPS > tab FUEL section, we have made possible uploading a **Fuel Taxes** file, which will update 'Total' price. | |
| |
A file itself needs to be created as per a format below - only 2 columns are needed: **Country** and **Total Taxes**. A column 'Country' can have either country name (Argentina), country code (ARG) or iso code (AR). | When uploading fuel prices files to Leon, not all of them contain of a 'Total' price (including taxes). To make possible viewing 'Total' fuel prices in both: Fuel Prices & OPS > tab FUEL section, we have made possible uploading a file with **Country tax rates**, which will update 'Total' fuel price. |
| |
| A file itself needs to be created as per a format below - only 2 columns are needed: **Country** and **Total Taxes**. A column 'Country' can have either country name (Argentina), country code (ARG) or iso code (AR). 'Total Taxes' values will multiply 'Base' price and will show as 'Total' price. |
| |
| What's important is that the sheet's name must be 'Fuel Taxes', otherwise it will not work. |
| [{{ :leon:fuel-prices:fuel prices after tax uploaded.png?200|Country tax rates from uploaded file}}] |
{{:leon:fuel-prices:fuel taxes file.png|}} | {{:leon:fuel-prices:fuel taxes file.png|}} |
| |
Once the file is ready, go to **OSP > Fuel Prices** panel and use an uploader **Upload countries tax rates**. | Once the file is ready, go to **OPS > Fuel Prices** panel and use an uploader **Upload countries tax rates**. |
| |
{{:leon:fuel-prices:fuel taxes upload.png|}} | {{:leon:fuel-prices:fuel taxes upload.png|}} |
Uploaded fuel taxes will show on the main 'Fuel Prices' page in a column **Country tax rate** (see screenshot on the right). | Uploaded fuel taxes will show on the main 'Fuel Prices' page in a column **Country tax rate** (see screenshot on the right). |
| |
| If the fuel file uploaded to Leon already contained of 'Total' fuel prices, Leon will not update them. |
| |
| In a panel OPS, tab FUEL, if you switch between 'BASE' & 'TOTAL', Leon will show prices accordingly, as per an example below: tax rate for Germany has been defined to '3' and Leon multiplied 'Base' price by '3'. |
| |
| {{:leon:fuel-prices:base total fuel price.png?nolink|}} |
| |
| |