COLUMN ALIGNMENT & CODE CORRECTION

Discussion in 'Tally Developer' started by kosi, Feb 25, 2019.

    
  1. kosi

    kosi Member


    learned programmers
    please check my code for correction
    i need to make the newly created column field appear only in the cash account screen in the trial balance
    follow this steps to get to the cash account in the reports
    trial Balance>current assets>Cash Account
    in the cash account screen i want to see the newly created fields but the column is appearing in all items in the trial balance.its appearing on capital account please help me remove it from the other items apart from cash ledger

    and also help me do the alignment
    Thanks
    Philip
    code is below


    [#Line: DSP AccLine]
    ;;Border:Thick box
    Add: Field:Number Field
    Local:Field:Number Field:Set as:mad:@ClDrValue* 20%
    Local:Field:Number Field:Space Left:80
    Local:Field:Number Field:Use: Amount Forex Field
     


  2. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    inactive:not $$cashaccount
     


  3. kosi

    kosi Member


    Thanks pankaj Bohndle for the reply

    inactive:not $$cashaccount
    Is not working
    The above field value is appearing in all the sub forms in the trial balance
    Please how do I prevent that Field value from appearing in some of the Sub form in the trial balance
    I only need it in one sub form(cash account)
    Thanks
    Programmers please guide me
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [#Field: DSP AccName]
    Add: Field: After : DSP ActualName : MyNumberField
    Local:Field:MyNumberField:Set as:mad:@ClDrValue* 20%

    [#Field: DSP DispName]
    Width : 30

    [Field : MyNumberField]
    Use : Amount Field
    Width : 20
    Invisible : NOT $$IsBelongsTo:$$GroupCash
     


  5. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    [#Field: DSP AccName]
    Add: Field: After : DSP ActualName : MyNumberField

    [#Field: DSP DispName]
    Full Width : Yes

    [Field : MyNumberField]
    Use : Amount Field
    Width : 20
    Invisible: NOT $$IsLedger:$$GroupCash ;1) SHOW IN CASH LEDGER
    ;Invisible : NOT $$IsBelongsTo:$$GroupCash ; 2) SHOW IN CASH GROUP (CASH-IN HAND)
    ;Background:GREEN
    Set as:$$TOTAL:DSPClDrAmtA*20%
     


  6. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member



  7. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    SECOND SIMPLE FORMULA
    Set as:IF $$ISLEDGER:$$GROUPCASH THEN $$TOTAL:DSPClDrAmtA*20% ELSE 0
     


  8. kosi

    kosi Member


    Ohhhh thanks so much
    Its working
     


  9. kosi

    kosi Member


    How will I get
    @@ClDrValue* 60%
    On capital account on same trial balance after helping me have
    @@ClDrValue* 20% on cash account
    I need @@ClDrValue* 60% on capital account and
    @@ClDrValue* 20% on cash account
    All in the trial balance
    Thanks once again
     


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    same way you wrote code for CASH...........make a small one for your Capital account.

    Hint : use conditional formula in Set as .............. If Cash then ABC * 20% Else If Capital then ABC * 60% Else 0
     


  11. kosi

    kosi Member


    Thanks so m4uch Mr Kamdar and

    Pankaj.I'm trying to understand something and need ur help.

    I could not find below fields with tally developer mode on the trial balance form

    [#Field: DSP AccName]
    [#Field:DSP ActualName ]

    Can u please explain the logic hereI can't find them in the trial balance yet u use them in ur codes and its working perfectly.Please guide me to understand
     


  12. kosi

    kosi Member


    Hello Mr Kamdar
    I made changes below and I'm not getting effects on cash and capital account in trial balance
    Plz check for correction
    I need 30% and 60% on cash and capital account

    [#Field:DSP AccName]
    Add:Field:After:DSP ActualName:MyNumberField
    Local:Field:MyNumberField:Set as:If $$GroupCash then @@CLDrValue*20% else If $$GroupCapital Then @@CLDrValue*60% else 0;;@@CLDrValue*30%
    Local:Field:MyNumberField:Background:Red
    Local:Field:MyNumberField:Invisible:NOT $$IsBelongsTo:$$GroupCash
    Local:Field:MyNumberField:Invisible:
    NOT $$IsBelongsTo:$$GroupCapital
    ;;Local:Field:MyNumberField:Invisible:NOT $$IsLedger:$$GroupCurrentLiab

    [#Field:DSP DispName]
    Width:30
    Background:Green

    [Field:MyNumberField]
    Use:Amount Field
    Width:30
     


  13. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member



  14. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    Set as:IF $$IsBelongsTo:$$GROUPCASH THEN #DSPClDrAmtA*20% ELSE if $$IsBelongsTo:$$GroupCapital then #DSPClDrAmtA*60% else 0
     


  15. kosi

    kosi Member


    learned programmers
    please check my code for correction
    i need to make the newly created column field appear only in the cash account and capital account screen
    in the cash and capital account screen i want to see the newly created fields but the column is appearing in all items in the trial balance.its appearing on capital account please help me remove it from the other items apart from cash and capital account

    Thanks
    Philip
    code is below


    [#Line: DSP AccLine]
    ;;Border:Thick box
    Add: Field:Number Field
    Local:Field:Number Field:Set as:mad:@ClDrValue* 20%
    Local:Field:Number Field:Space Left:80
    Local:Field:Number Field:Use: Amount Forex Field
     


Share This Page