Calculating VAT - 1 views

• 
  #1 wilova on 11 Dec 23

   

  I'm writing a simple invoicing utility but want the VAT rate to be variable. I have:
  tbl_invoice and tbl_vatrate igv calculadora. The VAT rate in the invoice table looks like the rate from the VAT table.
  
  The problem is that trying to run a query to calculate VAT returns a rounded number and I can't stop it happening.
  
  All the numbers in the query are set to currency, except VAT rate which is set to general. The numbers in the invoice table are set to currency, except VAT rate which is set to Double, General Number, and 1 decimal place.
  
  It's driving me cuckoo, any ideas?

   

  <div class="cArrow"> </div><div class="cContentInner">I'm writing a simple invoicing utility but want the VAT rate to be variable. I have: <br /> tbl_invoice and tbl_vatrate <a href="https://calculadoraigv.com/" rel="nofollow">igv calculadora</a>. The VAT rate in the invoice table looks like the rate from the VAT table. <br /> <br /> The problem is that trying to run a query to calculate VAT returns a rounded number and I can't stop it happening. <br /> <br /> All the numbers in the query are set to currency, except VAT rate which is set to general. The numbers in the invoice table are set to currency, except VAT rate which is set to Double, General Number, and 1 decimal place. <br /> <br /> It's driving me cuckoo, any ideas?</div>

  ...

  Cancel

To Top