Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Can I calculate and add on VAT to a final figure calculated in Acrobat DC Forms

New Here ,
Aug 11, 2016 Aug 11, 2016

Can I calculate and add on VAT to a final figure calculated in Acrobat DC Forms

TOPICS
Acrobat SDK and JavaScript , Windows
1.5K
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Aug 11, 2016 Aug 11, 2016

Yes you can. What is the computation on paper?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 11, 2016 Aug 11, 2016

Thanks for your reply. This is an order form and set for user to check their requirements and type in cost of each item required. The form is set to automatically calculating the total in a net value section. There is another area in the form where the net value appears with a section to add on the VAT showing the total including VAT.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 11, 2016 Aug 11, 2016

I think the question was more about the actual VAT rate in your country... Let's say it's 15% and the name of the pre-tax field is "Total", and the post-tax field is called "TotalPlusTax". Go to the Properties of the latter field, and under the Calculate tab select the second option (Simple Field Notation) and enter this into it:

Total * 1.15

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 11, 2016 Aug 11, 2016

Hi, thank you, our VAT is 20%, I have set the calculation to add the net value, plus VAT to the Final Total. I have entered Total*1.20 in the (Simple Field Notation)

The amount of VAT needs to show in a separate box, the amount will be variable as there is potential for differing total values depending on the users selections.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 11, 2016 Aug 11, 2016

We seem to be one step behind each other... See my previous reply.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 11, 2016 Aug 11, 2016

Hi Thank you. This may be operator error, sop apologies in case it is. I have entered all as mentioned and there is no total appearing or the value of the VAT.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 11, 2016 Aug 11, 2016

Hi, I seem to be missing a calculation between the net total and vat

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 11, 2016 Aug 11, 2016
LATEST

What are the actual names of the fields involved in this calculation? Also, press Ctrl+J and check if there any error messages in the window that opens.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 11, 2016 Aug 11, 2016

Do you want to show the tax in a separate field, or just show the total without tax in one field and with in another?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 11, 2016 Aug 11, 2016

Hi, thanks for your reply. Yes, I want to show the net value in one box, then below that the value of the tax, then below that the total including VAT. I can show you a snip of the area in discussion, can I add an image to this discussion?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 11, 2016 Aug 11, 2016

In that case use this code for the VAT field:

Total * 0.15

And then as the last field do a sum of Total and VAT (or the code provided above, either one will work).

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines