Sir i dont know how to reduce the body parts. Any other solution is there ha Sir? *Screen shot of export invoice has been attached *export invoice tdl has been attached
Sir this formula is not working in normal sales voucher type [#line:ei columnone] add:right field:at beginning:exchratetit,exchcurtit,exchamttit [field:exchcurtit] use:name title field width:30 mms type:string set as: if @@salesornot then "cur" else "";+ ;if @@ispurchase then "cur" else "" style: normal bold align:center [field:exchratetit] use:name title field width:30 mms type:string set as: if @@salesornot then "usd" else "";+ ;if @@ispurchase then "usd" else "" style: normal bold align:center [field:exchamttit] use:name title field type:string info:if @@salesornot then "value" else "";+ ;if @@ispurchase then "value" else "" width:30 mms align:center style:normal bold [#line:ei invinfo] add:right field:at beginning:exchrate,exchcur,exchamt,vch value local:field:exchrate:skip on@salesornotvch local:field:exchcur:skip on@salesornotvch local:field:exchamt:skip on@salesornotvch local:field:vch value:skip on@salesornotvch [field:exchcur] use:name field set as:$formalname:currency$$currency:$udfexchrate) width:30 mms inactive:$$isend:$stockitemname align:center format:"currency,showbasesymbol" skip:yes [field:exchrate] use:amount forex field storage:udfexchrate width:30 mms inactive:$$isend:$stockitemname align:center format:"currency" [field:exchamt] use:amount forex field set as:$billedqty * $rate width:30 mms inactive:$$isend:$stockitemname align:center skip:no [#field: vch value] use:amount field resetval:if (@@nobaseunits or $$isempty:$billedqty) then $$value else (@@bqudfbqr) ;or (($rate * $billedqty * (100 - $discount)) / 100) skip:yes [system:udf] udfexchrate:amount:5894 [system:formulae] bqudfbqr$udfexchrate * #exchamt) udfbr$billedqty * $rate) salesornot:$vouchertypename = "sales" salesornotvch:$vouchertypename = "balaji" [#field: vch nrmlrate] delete:set by condition add:set by condition:yes:$$value
In creation with voucher class, you have used [#line:ei columnone] [#line:ei invinfo] these below lines also to be considered [#line:Ci columnone] [#line:Ci invinfo]
Balaji Sir *I added ur corrections in my tdl *I added a screenshot of Sales voucher type till now i didnot get [#field:Vch value] amount.
From the screen, you are getting the value of 600/- and 50/-.... so what is the issue? give detailed explanation.
Sir I need a formula for both calculation If I mentioned USD calculation is taken correctly If I mentioned 0 in USD means straight away I want to put quantity, rate & amount want to calculate. That's all my quire's Sir @amit @Balaji
put a conditional formula......... If $$IsEmpty:#exchamt then $Qty * $Rate Else @@bqudfbqr am assuming exchamt means USD unit. Also replace $Qty and $Rate with the appropriate UDF name (refer Developer)