I WANT TO ADD [Line: RPTPart_A RightBb] INDENT:50 Field: Medium Prompt, RPTPart_A RightBb Local: Field: Medium Prompt: Info :"Plus:Mdi Amt" Local: Field: Medium Prompt: Style:sMALL BOLD Local: Field: Medium Prompt: Full space: yes [Field: RPTPart_A RightBb] Use : Amount Field Set as : $mdiamtstorage Align : Right ; Type : String Color : Blue printfg:Royal blue Style : Tiny Bold FullWidth: yes Skip: Yes Format : "Show Base Currency" [Line: RPTPart_A RightBbt] INDENT:50 Field: Medium Prompt, RPTPart_A RightBbt Local: Field: Medium Prompt: Info :"Plus:Taxes" Local: Field: Medium Prompt: Style:sMALL BOLD Local: Field: Medium Prompt: Full space: yes [Field: RPTPart_A RightBbt] Use : Amount Field Set as : $totalstorage Align : Right ; Type : String Color : Blue printfg:Royal blue Style : Tiny Bold FullWidth: yes Skip: Yes Format : "Show Base Currency" [Line: RPTPart_A RightC] Space Top: 0 INDENT:50 Field: Medium Prompt, RPTPart_A RightC Local: Field: Medium Prompt: Info :"Till Due dt" Local: Field: Medium Prompt: Style:sMALL BOLD Local: Field: Medium Prompt: Full space: yes [Field: RPTPart_A RightC] Use : Amount Field Set as :$$ToValue:$date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries IN THIS FORMULA I WANT TO ADD TEHSE FIELDS RPTPart_A RightBb + RPTPart_A RightBbBT Set as :$$ToValue:$date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries +#RPTPart_A RightBb + #RPTPart_A RightBbBT but nor working Align : right ; Type : String Color : Blue print fg:Blue Style : Tiny Bold FullWidth: yes Skip: Yes Format : "Show Base Currency"
Try to learn a little bit of coding.... I have given a example........... [System:Formula] form01 : If stockitemname="offpeakconsumption" then $amount Else 0 form02 : If stockitemname="peakconsumption" then $amount Else 0 TotalCalc : @@form01 + @@Form02 In above red marked word .... replace it with the UDF name .... since you have not shown us the code so cannot understand which collection you are using.....
sir actually i am not very well trained this formula is difficult for me becoz i am learning PLZZZZ LET ME TRY TO SOLVE SIR THANKS FOR REPLY
SIR CAN U PLZZ CHEK IS THIS CORRECT PLZZZ [Field: GSTTFld] Use: Number Field Storage: GSTtaxstorage Set as@totalcalc * 20% Set Always: Yes Skip: Yes width:15 ; Invisible: ##SVvouchertype<>"ElectricityBill" Background : @@SV_VCHCOLOR Color : "Blue" ;@@SV_VCHTYPE [System:Formula] form01 : If GSTtaxstorage="offpeakconsumption" then $amount Else 0 form02 : If GSTtaxstorage="peakconsumption" then $amount Else 0 TotalCalc : @@form01 + @@Form02
[System: UDF] DueDateStorage: String: 8500 LateFeeStorage: String: 8600 AftDueDtStorage: String: 8700 CurrentPeakStorage: String: 8501 PreviousPeakStorage: String: 8601 TotalPeakStorage: String: 8701 CurrentOffpeakStorage: String: 8901 PreviousoffPeakStorage: String: 8902 TotaloffPeakUnitsStorage: String: 8903 MDIStorage: Number: 8904 MDIrateStorage: Number: 8910 MDIamtStorage: Number: 8911 Billmonthstorage: String: 8905 readdatestorage:String: 8906 GSTtaxstorage:Number: 8921 INCOMEtaxstorage:Number: 8908 staxstorage:Number: 8909 Fcsurchargestorage:Number: 8920 FPAstorage:Number: 8915 totalstorage:Number: 8916
[System:Formula] form01 : If $GSTtaxstorage="offpeakconsumption" then $amount Else 0 form02 : If $GSTtaxstorage="peakconsumption" then $amount Else 0 TotalCalc : @@form01 + @@Form02
[Field: GSTTFld] Use: Number Field Storage: GSTtaxstorage Set as@totalcalc * 20% SIR THIS NOT WORKING Set Always: Yes Skip: Yes width:15 ; Invisible: ##SVvouchertype<>"ElectricityBill" Background : @@SV_VCHCOLOR Color : "Blue" ;@@SV_VCHTYPE
I have given you example .... if it is not working because GSTtaxstorage must be something else....... and i do not know what it is.... You have been on this site for long time and you need to learn small basic of TDL, so you can understand and implement.
ok let em try I AM TRYING ADING THIS BUT GETING ERROR I HAVE A LITTLE CONFUSION KINDLY CHECK Line: RPTPart_A RightBb] INDENT:50 Field: Medium Prompt, RPTPart_A RightBb Local: Field: Medium Prompt: Info :"Plus:Mdi Amt" Local: Field: Medium Prompt: Style:sMALL BOLD Local: Field: Medium Prompt: Full space: yes [Field: RPTPart_A RightBb] Use : Amount Field Set as : $mdiamtstorage Align : Right ; Type : String Color : Blue printfg:Royal blue Style : Tiny Bold FullWidth: yes Skip: Yes Format : "Show Base Currency" [Line: RPTPart_A RightBbt] INDENT:50 Field: Medium Prompt, RPTPart_A RightBbt Local: Field: Medium Prompt: Info :"Plus:Taxes" Local: Field: Medium Prompt: Style:sMALL BOLD Local: Field: Medium Prompt: Full space: yes [Field: RPTPart_A RightBbt] Use : Amount Field Set as : $totalstorage Align : Right ; Type : String Color : Blue printfg:Royal blue Style : Tiny Bold FullWidth: yes Skip: Yes Format : "Show Base Currency" [Line: RPTPart_A RightC] Space Top: 0 INDENT:50 Field: Medium Prompt, RPTPart_A RightC Local: Field: Medium Prompt: Info :"Till Due dt" Local: Field: Medium Prompt: Style:sMALL BOLD Local: Field: Medium Prompt: Full space: yes [Field: RPTPart_A RightC] Use : Amount Field Set as :$$ToValue:$date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries IN THIS FORMULA I WANT TO ADD TEHSE FIELDS RPTPart_A RightBb + RPTPart_A RightBbBT Set as :$$ToValue:$date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries +#RPTPart_A RightBb + #RPTPart_A RightBbBT but nor working
GOOD ADFTER NOON AF PER SUGGESTIN by mr amit sir i am tryong this formula but value comming "0" KINDLY SUGGEST ME PLZZZ WHERE IS ERROR THANKS [Field: GSTTFld] Use: Number Field Storage: GSTtaxstorage Set as@totalcalc * 20% Set Always: Yes Skip: Yes width:15 ; Invisible: ##SVvouchertype<>"ElectricityBill" Background : @@SV_VCHCOLOR Color : "Blue" ;@@SV_VCHTYPE [Field: staxfld] Use: Number Field Storage: staxstorage Set as: @@totalcalc1 * 10% Set Always: Yes Skip: Yes width:12 GSTtaxstorage:Number: 8921 INCOMEtaxstorage:Number: 8908 staxstorage:Number: 8909 Fcsurchargestorage:Number: 8920 FPAstorage:Number: 8915 totalstorage:Number: 8916 [System:Formula] form01 : If $GSTtaxstorage="offpeakconsumption" then $amount Else 0 form02 : If $GSTtaxstorage="peakconsumption" then $amount Else 0 TotalCalc : @@form01 + @@Form02 [System:Formula] form03 : If $STaxstorage="offpeakconsumption" then $amount Else 0 form04 : If $STaxstorage="peakconsumption" then $amount Else 0 TotalCalc1 : @@form03 + @@Form04
You have already been given a solution and you need to modify that to work as per your data, but instead you are just using copy/paste. This will not give you your solution.
thanks for reply sir i try my best i change udf and fields as per my request but still not got solution