none
Modify calculated field RRS feed

  • Question

  • HI everyone

    I have a field which calculates automatically 18% VAT. The problem is, that not all of the products are having VAT. Is there any option to make the calculation as standard but also that is possible to write other numbers inside? Or any other ideas to solve this?

    Thank you all!

    Wednesday, July 25, 2018 5:51 PM

All replies

  • I have a field which calculates automatically 18% VAT. The problem is, that not all of the products are having VAT. Is there any option to make the calculation as standard but also that is possible to write other numbers inside? Or any other ideas to solve this?

    Hi Cathy,

    In all my applications with VAT's (BTW), I use a separate field to hold the "current" percentage. In NL it can be 0, 6 or 21% on this moment. But it can change in time.

    The VAT amount can be calculated from the value of the article or service and the corresponding VAT percentage.

    Imb.

    Wednesday, July 25, 2018 6:05 PM
  • Indeed, Imb-hb is absolutely right.

    Cathis93, you use a wrong method. For example, it is also necessary to maintain the VAT percentage once set. Because the VAT can change and rather convenient invoices or orders must retain the original percentage. Always make sure that the original VAT percentage is saved.

    Wednesday, July 25, 2018 7:11 PM
  • You might like to take a look at InvoicePDF.zip in my public databases folder at:

    https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

    Note that if you are using an earlier version of Access you might find that the colour of some form objects such as buttons shows incorrectly and you will need to  amend the form design accordingly.  

    If you have difficulty opening the link, copy the link (NB, not the link location) and paste it into your browser's address bar.

    This little demo file is primarily intended to illustrate how  to output a report (invoice) as a PDF file, but it also happens to illustrate VAT computation.  The current rate of VAT per product is stored as a fractional value, e.g. 0.18  for 18% in a column in the Products table.  This is assigned to a column in an InvoiceDetails table, so the rate of VAT per product which was current when the invoice was raised remains static with each invoice regardless of subsequent changes in the rate.

    The VAT per invoice is computed in a subform in the main invoice form, and similarly in the invoice report.  The net amount for each subset of products in the invoice which attract the same rate of VAT is first computed, and the VAT added.  Note that VAT is not computed per product as this can lead to rounding errors.  The total VAT per invoice is thus the sum of the amounts per subset within the invoice.


    Ken Sheridan, Stafford, England


    • Edited by Ken Sheridan Wednesday, July 25, 2018 10:43 PM Typo corrected.
    Wednesday, July 25, 2018 10:42 PM