I need some help here , One of our clients doesnot report on vat or can't not claim , but the vendors they deal with some are vat vendors and do claim so it need to be shown on the marketing docs.
So what we've done is on the client side we used a UDF to display the vat amount per line.
So i need a query that will perform task like this.
Supplier is vat vendor then client selects a UDF with YES or No ( Defaults to No) , then based on the selection the Tax Amount UDF must be updated automatically by the query running in the back ground.
something more like this :- if vat udf = 1 ( Yes) then price x 0.14 --- tax amount
then the total must be be combination off the two fields price plus tax amount.
Hope it makes sense.