User Tools

Site Tools


leon:fuel-prices

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
leon:fuel-prices [2024/01/17 06:59]
rafal [COUNTRY TAX RATES FILE]
leon:fuel-prices [2024/01/19 14:33] (current)
rafal [Mineral Oil Tax]
Line 103: Line 103:
 Once the file is uploaded, the Tax, MOT, and VAT rates will appear in the **Country tax rate** column when hovering the mouse over the **?** icon. Once the file is uploaded, the Tax, MOT, and VAT rates will appear in the **Country tax rate** column when hovering the mouse over the **?** icon.
  
-The correct file format is presented below:+The correct file formats that can be uploaded are presented below:
  
-  * **Old file format that includes the 'Total Tax' column**+  * **File format that contains the 'Total Tax' information only**
  
 {{:leon:fuel-prices:mot_-_old_format.png?nolink|}} {{:leon:fuel-prices:mot_-_old_format.png?nolink|}}
Line 116: Line 116:
 After uploading the file, the fuel prices in the tab 'FUEL' in OPS are being recalculated accordingly: After uploading the file, the fuel prices in the tab 'FUEL' in OPS are being recalculated accordingly:
  
-  * Value from the **Total Tax** column is prioritized. If the 'Total Tax' column contains the rate, values from the 'MOT' and 'VAT' columns are omitted +  * If the Fuel File contains the **Total price** value, then this price is prioritized and the values from the 'MOT' and 'VAT' columns are omitted 
-  * If the 'Total Tax' column is empty:+  * If the 'Total price' column is not included or empty:
        
     * **Total Fuel Price** = (Base + MOT) x (1 + VAT)     * **Total Fuel Price** = (Base + MOT) x (1 + VAT)
leon/fuel-prices.txt · Last modified: 2024/01/19 14:33 by rafal