Reset the amount Field

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

 

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

 

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