Credit Totals

Dear Experts & All Members,
Please complete my below code ;

[#Line: VCHCURBAL ExplLine]
Add: Field:At End : DSP VchCrTotalAmt2
[Field: DSP VchCrTotalAmt2]
Set as : "Credit total of This Current Ledger" ;; $DSPVchCrTotalAmt not working
Color: If $$Value > 20000 then "Red" else "Black"
Background: "Green"
Skip: Yes
Thanks

 

Dear Experts & All Members,
After finding & searching with TD9 & TDL ref. manuals, I got the solution
As it is useful to me & may be others during manual deduction of TDS if Ledger Cr. Amount more then Rs 30,000/-, Cr.Amt highlight with Red color,
And we will do more with this TDL - filter ledgers if it has belongs to creditor groups.

Code:

[#Line: VCHCURBAL ExplLine]
    Add: Field:At End : DSP VchCrTotalAmt2
    [Field:DSP VchCrTotalAmt2]
        Set as      : $CreditTotals:Ledger:#SVLedger ;"Credit total of This Current Ledger"
        Color: If $CreditTotals:Ledger:#SVLedger > 30000 then "Red" else "Blue"
        Width: @@AmountWidth
        Align: Right
        Background: "White"
        Skip: Yes

Thanks

 

Thanks sharing knowledge

 

Can u give us same which will extract only cash receipt total