Dear Experts, Pls help me how to reset the amount field. Code is as under: [#Line: EI ColumnTwo] Add : Fields : Before: VCH ActualQtyTitle : Mani, CMP MRateH [Field : Mani] Use : Simple Field Info : "Exchange Rate" Align : Centre Width : 18 mms Style : Small bold COLOR : RED Line : 1 [Field :CMP MRateH] Use : Simple Field Set as : "Rate" Width : 9 mms Border : Thin Bottom [#Line: EI InvInfo] Add : Fields: After : VCH StockItem : ManiM, CMPMrate [Field : ManiM] Use : Amount Field Set As : $Khandi Format : "NoPercentage, Decimal:2" Align : Centre Border : Thin Left Right ;; Skip : YES COLOR : RED ;; background : YELLOW border : thin box Storage : Khandi [Field : CMPMrate ] Use : Amount Field Set As : $Khandi1 Format : "NoPercentage, Decimal:2" Align : Centre Border : Thin Left Right ;; Skip : YES COLOR : RED ;; background : YELLOW border : thin box Storage : Khandi1 [#Field: VCH Value] ;;[Field: VCH Value] Use : Amount Forex Field ;;a Set as : $BilledQty * $$Rate * $$Khandi ResetVal : If @@STKINarration = "Mani" then ($Khandi * $Khandi1) Else + $$Value ;; If (@@Khandi OR $$IsEmpty:$Khandi1) then $$Value else (($Rate * $BilledQty * (100 - $Discount)) / 100) ; ResetVal : If @@STKINarration = "$" then ($Khandi * $Khandi1) Else + ; If (@@Khandi OR $$IsEmpty:$Khandi1) then $$Value else (($Rate * $BilledQty * (100 - $Discount)) / 100) Set Always : Yes [System : UDF] khandi : Amount : 18001 khandi1 : Amount : 18002 [System : Formula] MAmt : $khandi1 * $Khandi ;;$PQty * $MQty * $MRate
In field -- VCH Value, there are many SWITCHES.......... The correct one in your case would be........ VCH NrmlValue ...... In this field add your condition.
Admin Sir, I Use this but its not working. pls guide [#Field : VCH NrmlValue] ;;[#Field: VCH Value] ;;[Field: VCH Value] Use : Amount Forex Field ;;a Set as : $BilledQty * $$Rate * $$Khandi Set as : If @@STKINarration = "Mani" then ($Khandi * $Khandi1) Else + If (@@Khandi OR $$IsEmpty:$Khandi1) then $$Value else (($Rate * $BilledQty * (100 - $Discount)) / 100) ; ResetVal : If @@STKINarration = "$" then ($Khandi * $Khandi1) Else + ; If (@@Khandi OR $$IsEmpty:$Khandi1) then $$Value else (($Rate * $BilledQty * (100 - $Discount)) / 100) Set Always : Yes
Try this..... [#Field : VCH NrmlValue] Set as : $Khandi * $Khandi1 if above works, then there is problem with your IF conditions.......... Also, before posting any coed, please remove all the "commented" lines .... as it is confusing. Always post a CLEAN code.
use set by condition exp : [#Field: VCH Value] Use : Amount Forex Field Set By Condition : @@STKINarration = "Mani" $Khandi * $Khandi1) formula STKINarration : $Narration:Stockitem:$StockitemName
Res. Sir, Thanks Admin Sir & Mahbu for your replay. Its work Sir [#Field : VCH NrmlValue] Set as : If @@STKINarration = "$" Then ($Khandi * $Khandi1) else (($Rate * $BilledQty * (100 - $Discount)) / 100) [System : Formula] STKINarration : $Narration:Stockitem:$StockitemName
Res. Admin Sir, Sir pls help me the below condition is not work on rate field. [#Field: EXPINV Rate] Use : Rate Price Field Align : Right Set By Condition: IF @@STKINarration = "$" Then $Khandi Else $Rate ;Set Always : Yes