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?