AnsweredAssumed Answered

Working out inc/ex tax price formula loop issue

Question asked by user2148443 on Oct 31, 2018
Latest reply on Nov 1, 2018 by onefish

I have a pickle, trying to figure it out.

Using the basic Invoice starter solution hpwever it is set up for pricing without tax. This is not a big issue but everything i quote is including tax. I am trying to figure out a way to automatically Calculate the pricing so if i enter an ex-price it automatically adjusts the inc tax pricing. This is not an issue as using

"Round ( If ( IsEmpty ( Unit Price ex ) ; "" ; (Unit Price ex * 1.1)) ; 2 ) " and vis versa for the Ex Tax price.

 

However it now creates a loop and i cant eneter a value in either field to update them.

 

I know the easy solution is not to enter the calculation into one of the fields. to break the loop effect.

 

Is there another solution? Just wondering?

Outcomes