query for tax calculation.
I want to know if it's possible to do calculation using the unit price field in Purchase Order.
This is what I want to test
I insert unit price then select the Taxable UDF option (Yes) then the Total(LC) Field ( Standard B1 field must display the amount plus 14% vat and when I select Not taxable it must not apply the 14 % vat.
The reason why i'm doing this is the client is not a vat vendor ( they dont have to report for tax) so this is just a workaround that i have to expense the whole amount.
And how to use variables when you want to write a query... like (unit price x 0.14)
Please any suggestions are welcome.....