Need help for showing selected entries amount in words format

Discussion in 'Free Source Codes' started by ONKAR, Mar 16, 2020.

    
  1. ONKAR

    ONKAR Active Member


    Dear Experts, As you can see, in the picture I have opened an account of shop expenses, and see That closing balance below in Words Format, so same as this, I want if I select one of any entry, then its balance should be seen in words in Below,

    SEE THE CODE BELOW


    [#Line: DSP VchClAmt]
    Add : Left Field : ClBalinWord
    [#Line: LV FCThree]
    Add : Left Field : ClBalinWord
    [Field: ClBalinWord]
    Set as: $$InWords:mad:@VchClg + @@IfAmtthenOnlystring
    Add :Background : Blue
    Add :Color : Lily White
    Add :Border :Thin Box
    Local:Style:DEFAULT:Height:17
    [System: Formulae]
    IfAmtthenOnlystring : If @@VchClg = 0 Then "" Else $$String:" Only"

    SEE THE SCREENSHOT BELOW
     


  2. ONKAR

    ONKAR Active Member


    Capture - 1.JPG


    IMAGE NO. 2 When I select any of Entry So Showing Below That Perticuler Entry Balance in Amount In word Format


    Capture - 2.JPG
     


  3. Amritpal singh gill

    Amritpal singh gill New Member


    [#Line: DSP VchClAmt]
    Add : Left Field : ClBalinWord
    [#Line: LV FCThree]
    Add : Left Field : ClBalinWord
    [Field: ClBalinWord]
    Set as: If $$IsEmpty:mad:@VchClg Then "" Else $$InWords:mad:@VchClg;@@IfAmtthenOnlystring
    Add :Background : Blue
    Add :Color : Lily White
    Add :Border :Thin Box
    Local:Style:DEFAULT:Height:17
    [System: Formulae]
    IfAmtthenOnlystring : If @@VchClg = 0 Then "" Else $$String:" Only"
     


  4. ONKAR

    ONKAR Active Member


    Not working bro.

    Capture.JPG
     


  5. Sanjeev S

    Sanjeev S Active Member


    Try this as a first step......

    [#Line: DSP VchClAmt]
    Add : Left Field : ClBalinWord

    [#Line: LV FCThree]
    Add : Left Field : ClBalinWord

    [Field: ClBalinWord]
    Set as: $$InWords:mad:@DispAmt + @@IfAmtthenOnlystring
    Add :Background : Blue
    Add :Color : Lily White
    Add :Border :Thin Box
    Local:Style:DEFAULT:Height:17


    [System: Formulae]
    DispAmt : if $$IsEmpty:#DSPVchDrAmt then #DSPVchCrAmt else #DSPVchDrAmt
    IfAmtthenOnlystring : If @@DispAmt = 0 Then "" Else $$String:" Only"

    This will provide you balance of the first entry.

    All you have to do is now add logic form showing it for selected entry.

    :) enjoy learning.


    upload_2020-3-20_7-3-18.png
     


  6. ONKAR

    ONKAR Active Member


    Dear Sanjeev Sir No idea sir.
     


  7. Umashankar

    Umashankar Member


    What does this smiley :mad: means? Please guide me
     


  8. Sanjeev S

    Sanjeev S Active Member


    It's Colon plus @
     


  9. ONKAR

    ONKAR Active Member


    Dear Sanjeev Sir please I have no idea.
     


  10. Umashankar

    Umashankar Member


    Dear Sanjeev, the smiley shows in text as :mad:
    Is it :mad: or : @
    Please guide me.
    Thanks in advance
     


Share This Page