VAT issue « Gravity Support Forums

Gravity Support Forums » Plugin Support » Gravity Forms

dietika
Member

Hi, at http://dietika.lv/ I have order forms with products, quantities and a formula calculating grand total including VAT - let's call it x. I need to insert a field which shows VAT only: x/1.21 in my case and a total without VAT: x/1.21 * 0.21
Here are calculations I could use for Price without VAT:
( ({Product 1 (Price):1.2} * {Product 1 (Quantity):1.3}) + ({Product 2 (Price):3.2} * {Product 2 (Quantity):3.3}) ) / 1.21
and VAT{Price without VAT (Price):4.2} * 0.21
The problem is that I have 12 forms with more than 50 products in each of them. Entering formulas manually will take me ages.

Any solutions??

URL to one of the forms: http://dietika.lv/?page_id=302

Posted 11 years ago on Friday December 14, 2012 | Permalink
David Peralty

There isn't any quick solution that will automatically grab all the product prices and quantities, add them together and then allow you to set a tax. It has to be done manually as Gravity Forms couldn't know which products are considered taxable or not, nor the tax amount in your area. Sorry.

Posted 11 years ago on Friday December 14, 2012 | Permalink
dietika
Member

David, if I have a total, why couldn't there be an option just to add a simple calculation: Total/1.21= Price without a tax. Total minus Price without a tax= Tax. What's so difficult about it? PayPay does it automatically - they have a Tax field.

And, of course, a simple checkbox in the product field could show whether to imply a tax to an item.

I am really disappointed. To my humble opinion such a general option as adding/substracting Tax MUST be included in forms by default.

Posted 11 years ago on Friday December 14, 2012 | Permalink
dietika
Member

Hello again,
Maybe I am not clear enough due to my English.
I have around 80 items per form and 12 forms. I have a price (including VAT 21% for my country) for each of them. I have a grand total (a sum of all chosen items x quantities). What I need is Grand Total/1.21 (to see the amount of VAT) and Grand Total/1.21x0.21 (to see amount of Grand Total without VAT). Not for every item, just for total!!!

Please advice where is the "Total"'s code we can work with.

Thanks

Posted 11 years ago on Friday December 14, 2012 | Permalink
David Peralty

You can definitely post a field to show tax. What I was saying was that there wasn't a quick field like you are looking for currently. Tax isn't a simple as you laid out. We would have to add the option to remove products and options from the tax calculation as things like produce are not taxable in my country. Also, is the tax rate set by the user location selection or by the creator of the form? There are a number of user interface and feature issues that go into making something like Tax work well for everyone. I hope you'll understand, as Gravity Forms was not originally intended to be an e-commerce solution.

You can use a Calculation Product Field and calculate tax on a form.

Posted 11 years ago on Friday December 14, 2012 | Permalink
dietika
Member

David, thanks for a quick response. What do you mean by Calculation Product Field? I can't find it in my forms.

Do you revert to the same long formula Product 1 price * Product 1 quantity + Product 2 price etc. I started the topic with?

Posted 11 years ago on Friday December 14, 2012 | Permalink
David Peralty

The field you want is a Product Field. Then you want to change its type to Calculation (There will be a few options, checkbox, drop down...etc..)

Then you can use the long formula you started with to calculate the tax. All my best!

Posted 11 years ago on Friday December 14, 2012 | Permalink
dietika
Member

OK, I solved it (export/Excel/Word). The solution is too long to describe it here. If somebody has a similar problem - e-mail me olga@dietika.lv

Posted 11 years ago on Saturday December 15, 2012 | Permalink
dietika
Member

David, there is a problem! I spent hours entering long formulas and they do work. And now when I fill in the form I have a timeout error (exceeded maximum execution time), because it takes the form too long to make calculations!

Posted 11 years ago on Saturday December 15, 2012 | Permalink
dietika
Member

Hello Again, David,

As calculations didn't make it, t edited the code so that it matches my needs. http://pastie.org/5542307

Now the only problem is that in e-mail notifications to users GF doesn't include my new fields in {all fields} merge tag. Please advise what files should be changed in order to make it work.
tnx

Posted 11 years ago on Monday December 17, 2012 | Permalink
David Peralty

Sorry, I'm going to get a developer to look over your code and see what's happening and give you some advice. All my best!

Posted 11 years ago on Tuesday December 18, 2012 | Permalink
David Peralty

Instead of changing core code, which we can't support, are you able and willing to work with us after reverting back to our code? Our development team was saying you could use a custom field to potentially show VAT. All my best!

Posted 11 years ago on Thursday December 20, 2012 | Permalink
dietika
Member

How?

Posted 11 years ago on Thursday December 20, 2012 | Permalink