1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

TallyPrime TDL Enthusiast

Discussion in 'Free Source Codes' started by Nithin Patel, May 6, 2022.

    
Page 2 of 2
  1. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Column Align : Left, Left, Right, Left
     
    Amit Kamdar, Sep 2, 2023
    #26
    Nithin Patel likes this.


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Format : $BaseClosing : "AllSymbols, DrCr" -- for Dr/Cr
     
    Amit Kamdar, Sep 2, 2023
    #27
    Nithin Patel likes this.


  3. Nithin Patel

    Nithin Patel Member


    Thanks Amit Bhai

    bottomline.jpg

    [#Line : EI InvInfo]
    Border : Thin Bottom
    Space Bottom: 0.50

    Sir Help,
    Correct me to set a thin line after VCH AltBilledQty
     
    Nithin Patel, Sep 5, 2023
    #28


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Study the [Line: EI InvInfo] in Developer -- there will be an EXPLODE, for AltUnits .....

    Find the LINE Name of that Explode and ADD your Borders and Space therein.

    Capture.PNG
     
    Amit Kamdar, Sep 5, 2023
    #29


  5. Nithin Patel

    Nithin Patel Member


    Here The [Line: EI InvInfo] in Developer mode shows
    Explode : STKVCH AltUnitsExplosion : NOT $$IsEmpty:$StockItemName AND NOT @@NoAltUnits

    Sir, What will be the line name from the explode, here i tried with AltUnitsExplosion but of no use.
     
    Nithin Patel, Sep 8, 2023
    #30


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In developer --- hover CURSOR on the STKVCH AltUnitsExplosion and press CTRL+LeftClick -- will take you to that Code part --- Find the Line therein and add your field / conditions.

    You also need to learn to navigate through Developer -- how to forward/reverse search etc. -- Refer to Tally Developer shortcuts on TallySolutions.com website.
     
    Amit Kamdar, Sep 8, 2023
    #31


  7. Nithin Patel

    Nithin Patel Member


    Thanks Amitji

    [#Line : STKVCH AltUnits]
    Border : Thin Bottom
    Space Bottom: 0.50

    This shows only when data is entered, how can border made permanent?
    [#Line : EI DescExplosion]
    Border : Thin Bottom
     
    Nithin Patel, Sep 9, 2023
    #32


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Give condition in the BORDER attribute.
     
    Amit Kamdar, Sep 9, 2023
    #33


  9. Nithin Patel

    Nithin Patel Member


    nozero.jpg

    How to remove Zeros?
     
    Nithin Patel, Sep 25, 2023
    #34


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    format : "No zero" -- in your feild
     
    Amit Kamdar, Sep 25, 2023
    #35


  11. Nithin Patel

    Nithin Patel Member


    Code:
    [Collection    : SKCLedgerCollection]
    Fetch    : Name
    Use        : Alias Collection, Table EndofList
    Title    : $$LocaleString:"List of Ledgers"
    Align    : Center
    Type    : Ledger
    Report    : Ledger
    Variable: LLedger
    Trigger    : LLedger
IsODBCTable : Yes
   
    Add        : SubTitle : $$LocaleString:" Ledger Name ", " GSTIN ", " Contact ", " Mobile No ", " TDS ", " Closing Balance "
Column Align: Left, Left, Left, Left, Right, Right, Right
    Add        : Format :$LedGSTRegDetails[Last].GSTIN
    Fetch    : LedGSTRegDetails[Last].GSTIN
    Add        : Format :$LedgerContact
    Fetch    : LedgerContact
    Add        : Format :$LedgerMobile
    Fetch    : LedgerMobile
    Add        : Format :$IsTDSApplicable,6
    Add        : Format: $BaseClosing : "AllSymbols, DrCr, NoZero"
    Fetch    : ClosingBalance
    Here i need a change
    Show GSTIN if available else Show PAN
     
    Nithin Patel, Jan 12, 2024
    #36


  12. vishnu joshi

    vishnu joshi Member


    ;Try This
    Code:
    [Collection : SKCLedgerCollection]
Fetch : Name
Use : Alias Collection, Table EndofList
Title : $$LocaleString:"List of Ledgers"
Align : Center
Type : Ledger
Report : Ledger
Variable: LLedger
Trigger : LLedger
IsODBCTable : Yes

Add : SubTitle : $$LocaleString:" Ledger Name ", " GSTIN ", " Contact ", " Mobile No ", " TDS ", " Closing Balance "
Column Align: Left, Left, Left, Left, Right, Right, Right
Fetch : LedGSTPANNo
Add : Format :$LedGSTPANNo
Add : Format :$LedgerContact
Fetch : LedgerContact
Add : Format :$LedgerMobile
Fetch : LedgerMobile
Add : Format :$IsTDSApplicable,6
Add : Format: $BaseClosing : "AllSymbols, DrCr, NoZero"
Fetch : ClosingBalance


[#Object:Ledger]
    LedGSTPANNo : If ($$Isempty:$LedGSTPANNo) Then $IncomeTaxNumber Else $PartyGSTNum
    PartyGSTNum  : $LedGSTRegDetails[Last].GSTIN
     
    vishnu joshi, Jan 12, 2024
    #37


  13. Nithin Patel

    Nithin Patel Member


    Thanks for the reply but not working
     
    Nithin Patel, Jan 13, 2024
    #38


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    LedGSTPANNo : If NOT $$Isempty:$LedGSTPANNo Then $IncomeTaxNumber Else $PartyGSTNum
     
    Amit Kamdar, Jan 13, 2024
    #39


  15. vishnu joshi

    vishnu joshi Member


    ;Last Mai Typing mistake ho gaya tha...
    ;please check this


    Code:
    [Collection : SKCLedgerCollection]
Fetch : Name
Use : Alias Collection, Table EndofList
Title : $$LocaleString:"List of Ledgers"
Align : Center
Type : Ledger
Report : Ledger
Variable: LLedger
Trigger : LLedger
IsODBCTable : Yes

Add : SubTitle : $$LocaleString:" Ledger Name ", " GSTIN ", " Contact ", " Mobile No ", " TDS ", " Closing Balance "
Column Align: Left, Left, Left, Left, Right, Right, Right
Fetch : LedGSTPANNo
Add : Format :$LedGSTPANNo
Add : Format :$LedgerContact
Fetch : LedgerContact
Add : Format :$LedgerMobile
Fetch : LedgerMobile
Add : Format :$IsTDSApplicable,6
Add : Format: $BaseClosing : "AllSymbols, DrCr, NoZero"
Fetch : ClosingBalance


[#Object:Ledger]
    LedGSTPANNo : If ($$Isempty:$PartyGSTNum) Then $IncomeTaxNumber Else $PartyGSTNum
    PartyGSTNum  : $LedGSTRegDetails[Last].GSTIN
     
    vishnu joshi, Jan 14, 2024
    #40


  16. vishnu joshi

    vishnu joshi Member


    ; Same Yaha bhi huaa

    LedGSTPANNo : If NOT $$Isempty:$PartyGSTNum Then $IncomeTaxNumber Else $PartyGSTNum
     
    vishnu joshi, Jan 14, 2024
    #41


  17. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    If $$IsEmpty:$PartyGSTNumber Then $IncomeTaxNumber Else $PartyGSTNumber
     
    Amit Kamdar, Jan 14, 2024
    #42


  18. Nithin Patel

    Nithin Patel Member


    Thanks for the reply Amitji & Vishnu Joshi
    but, the desired result is not obtained.

    Code:
    [#Collection: List of Ledgers]
    Fetch    : Name
    Use        : Alias Collection
    Title    : $$LocaleString:"List of Ledgers"
    Type    : Ledger
    Report    : Ledger
    Variable: SLedger
    Trigger    : SLedger
IsODBCTable : Yes
    Delete    : Format
    Add        : Format : $Name,36

    Add        : SubTitle : $$LocaleString:" Ledger Name ", " PAN ", " GSTIN ", " Contact ", " Mobile No ", " Parent Group ", " Closing Balance "
Column Align: Left, Left, Left, Left, Left, Right, Right, Right

    Add        : Format :$LedGSTPANNo
    Fetch    : LedGSTPANNo

    Add        : Format :$LedGSTRegDetails[Last].GSTIN
    Fetch    : LedGSTRegDetails[Last].GSTIN

    Add        : Format :$LedgerContact
    Fetch    : LedgerContact

    Add        : Format :$LedgerMobile
    Fetch    : LedgerMobile

    Add     : Format :$Parent
    Fetch    : Parent

    Add     : Format :$BaseClosing : "AllSymbols, DrCr, NoZero"
    Fetch    : ClosingBalance

[#Object:Ledger]
LedGSTPANNo    : If $$IsEmpty:$PartyGSTNumber Then $IncomeTaxNumber Else $PartyGSTNumber
PartyGSTNum    : $LedGSTRegDetails[Last].GSTIN
     
    Nithin Patel, Jan 17, 2024
    #43


  19. Nithin Patel

    Nithin Patel Member


    Show GSTIN if available, else Show PAN/IT No.
     
    Nithin Patel, Jan 17, 2024
    #44


Page 2 of 2

Share This Page