Expression for VAT on Invoice

john-bottomley

My customer wants to see 0.00 rather than VAT being left blank if it is zero for example on Foreign Invoices.

The standard expression just leaves a blank :

iif(SQG_lastrec_L('sname.sn_account+ihead.ih_doc'),p_oCallingObject.dispvalu(.f., p_oCallingObject.w_fcrate, p_oCallingObject.p_tvat,"",.t.,.f.,13),"")

My attempt shows the zero but has changed what normally appears - on my Demodata it's fine shows 27.30 as VAT but on customer data shows 27.3000

iif(SQG_lastrec_L('sname.sn_account+ihead.ih_doc'),(p_oCallingObject.p_tvat)/100,"")

Please can someone advise how to format this correctly?

Thanks

John

john-bottomley

Finally got a sort of solution - used this

iif(empty(iif(SQG_lastrec_L('sname.sn_account+ihead.ih_doc'),p_oCallingObject.dispvalu(.f., p_oCallingObject.w_fcrate, p_oCallingObject.p_tvat,"",.t.,.f.,13),"")),'0.00', "")

basically iif(Empty(expression),0.00,(expression) was too long so used just the above and send to back so if std field is blank shows this filed which will be 0.00 if blank!

Seems to work