Please help me in the below code .Which changes amount in Words in Reports. ;; Shree Ganeshay Namah ;; 10-05-2014 ;; This TDL Show Ledger Closing Balance IN WORDS both in Display & Print. ;; Created By @mrit. [#Line: DSP VchClAmt] Add : Left Field : ClBalinWord [#Line: LV FCThree] Add : Left Field : ClBalinWord [Field: ClBalinWord] Set as: $$InWords@VchClg+@@IfAmtthenOnlystring [System: Formulae] IfAmtthenOnlystring : If @@VchClg = 0 Then "" Else $$String:" Only" ;; End of File In the Report Amount in words words correctly but on the printing it shows the opening Balance in words . Please rectify this TDL for me ..... Thanks in Advance
;;;Bro here it is....... [#Line: DSP VchClAmt] Add : Left Field : ClBalinWord [#Line: LV FCTwo] Add : Left Field:ClBalinWord1 [Field: ClBalinWord] Set as: $$InWords@VchClg+@@IfAmtthenOnlystring Style:Large Bold Color:RED [Field:ClBalinWord1] Set as:$$InWords@BalanceVchDrCrAmt + " Only " Style:Large Bold Print FG:RED [System: Formulae] IfAmtthenOnlystring : If @@VchClg = 0 Then "" Else $$String:" Only"
[#Line: DSP VchClAmt] Add : Left Field : ClBalinWord Local : Field : Default: Style: normal bold Local : Field : Default: Background: Lily White Local : Field : Default: Color: Blue [#Line: LV FCThree] Add : Left Field : ClBalinWord Local : Field : Default: Style: normal bold Local : Field : Default: Background: Lily White Local : Field : Default: Color: Blue [Field: ClBalinWord] Set as:$$InWords@VchClg + @@IfAmtthenOnlystring Color: Blue Style: Large Bold Fullwidth :yes [System: Formulae] IfAmtthenOnlystring : If @@VchClg = 0 Then "" Else $$String:" Only" ;; End of File
Thanks Raju Bhai ! Your code is working. And Laxman Bhai Your Given code is not working But thanks to you also
how can we print the ledger same way as it appears on screen i.e. closing balance to be in the end.. Kindly tell?