Thanks Amit Bhai [#Line : EI InvInfo] Border : Thin Bottom Space Bottom: 0.50 Sir Help, Correct me to set a thin line after VCH AltBilledQty
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.
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.
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.
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
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
;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
;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
; Same Yaha bhi huaa LedGSTPANNo : If NOT $$Isempty:$PartyGSTNum Then $IncomeTaxNumber Else $PartyGSTNum
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