1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

To skip ledger AMT if Ledger Description contains Inactive

Discussion in 'Free Source Codes' started by kapil22, Apr 11, 2024.

    
  1. kapil22

    kapil22 Member


    kindly advise on following codes:

    [#Field: VCH CrAmt]
    Skip: @@LedgerActiveStatus
    [#Field: VCH DrAmt]
    Skip: @@LedgerActiveStatus
    [#Field: ACLSAmt]
    Skip: @@LedgerActiveStatus
    [System : Formula]
    LedgerActiveStatus : IF $Description:Ledger:$Name contains "Inactive" THEN Yes ELSE NO
     
    kapil22, Apr 11, 2024
    #1


  2. AMIT JALAN

    AMIT JALAN Member


    ;;Try This

    Code:
    [#Field: VCH CrAmt]
Skip: @@LedgerActiveStatus
[#Field: VCH DrAmt]
Skip: @@LedgerActiveStatus
[#Field: ACLSAmt]
Skip: @@LedgerActiveStatus
[System : Formula]
LedgerActiveStatus : IF $Description:Ledger:$LedgerName contains "Inactive" THEN Yes ELSE NO
     
    AMIT JALAN, Apr 12, 2024
    #2


Share This Page