Dear Sir, I am using this TDL Code which i got from internet " [System : Formula] isEnhancedFieldsOn: Yes [#Field: EI Desc] Add: Option: Enhanced Ei Desc: @@isEnhancedFieldsOn [!Field : Enhanced Ei Desc] Add: Max: 51 Add: Width: 50 Option: Ei Desc Print: Not $$inPrintMode Add: Lines: 0 Add: Align: Justified [!Field : Ei Desc Print] Add: FullWidth: Yes Add: Lines: 1 [#Field: DSP VchNumberTitle] Add: Option: Enhanced VNum: @@isEnhancedFieldsOn [#Field: DSP VchNumber] Add: Option: Enhanced VNum: @@isEnhancedFieldsOn [#Field: BILLRef] Add: Option: Enhanced VNum: @@isEnhancedFieldsOn [#Field : VCH Short Title] Add: Option: Enhanced VNum: @@isEnhancedFieldsOn [#Field: VCHBILL Name] Add: Option: Enhanced VNum: @@isEnhancedFieldsOn [#Field: VCH Ref] Add: Option: Enhanced VNum: @@isEnhancedFieldsOn [!Field : Enhanced VNum] Add: Width: 25 [#Field: Voucher Name Field] Add : Option: Enhanced Voucher Name: @@isEnhancedFieldsOn [#Field: Master Name Field] Add : Option: Enhanced Voucher Name: @@isEnhancedFieldsOn [#Field: Item Name Field] Add : Option: Enhanced Voucher Name: @@isEnhancedFieldsOn [!Field : Enhanced Voucher Name] Add: Width: 70 Add: Max: 70 [#Field : VCH Narration] Add: Option: Enhanced Narration: @@isEnhancedFieldsOn [!Field : Enhanced Narration] Add: FullWidth: Yes Add: Max: 150 Add: Lines: 3 [#Collection: List of Stock Items] Use : Alias Collection Title : $$LocaleString:"List of Stock Items" Type : Stock Item Fetch : Name Report : Stock Item Variable : SStockItem Trigger : SStockItem IsODBCTable : Yes Delete : Format Add : Format : $Name,50 Add : SubTitle : $$LocaleString:"PRODUCT","Part No.", "DESCRIPTION", "Group", "%", "COST", "LSP", "QTY" Add :Format :$partno Fetch artno Add :Format : $Description Fetch escription Add : Format : $parent Fetch : parent Add :Format : $GSTIGSTRate Fetch :GSTIGSTRate Add :Format : $Standardcost Fetch :standardcost Add :Format : $LastSalePrice Fetch :LastSalePrice Add :Format : $closingbalance Fetch :closingbalance [#Collection: List of Ledgers] Use : Ledger Collection Title : $$LocaleString:"List of Ledgers" Type : ledger Fetch : Name Report : ledger Variable : Sledger Trigger : Sledger IsODBCTable : Yes Delete : Format Add : Format : $Name,50 Add : SubTitle : $$LocaleString:"LEDGER NAME", "Mobile No", "GROUP", "PAN", "GSTIN", "OP BALANCE", "CL BALANCE" Add :Format :$LedgerMobile Fetch :LedgerMobil Add : Format : $parent Fetch : parent Add : Format : $IncomeTaxNumber Fetch : IncomeTaxNumber Add : Format : $PartyGSTIN Fetch : PartyGSTIN Add : Format : $OpeningBalance Fetch : OpeningBalance Add : Format : $ClosingBalance Fetch : ClosingBalance [#Collection : VLedTable] Use : Ledger Collection Title : $$LocaleString:"List of Ledger Accounts" Delete : Format Add : Format : $Name,50 Add : SubTitle : $$LocaleString:"LEDGER NAME", "Mobile No", "GROUP", "GSTIN", "CL BALANCE" Add :Format :$LedgerMobile Fetch :LedgerMobil Add : Format : $parent Fetch : parent Add : Format : $PartyGSTIN Fetch : PartyGSTIN Add : Format : $ClosingBalance Fetch : ClosingBalance [#Collection: List of Groups] Use : Ledger Collection Title : $$LocaleString:"List of Groups" Type : Group Fetch : Name Delete : Format Add : Format : $Name,50 Add : SubTitle : $$LocaleString:"GROUP NAME","MAIN GROUP", Add : Format : $parent Fetch : parent " When In Tally ERP i apply this code it shows opening and closing cloumn right aligned but when i use this in Tally Prime the opening and closing cloumn shows left aligned. Please needed help. please provide correction to this code.
Try This Code Code: [#Collection: List of Ledgers] Use : Ledger Collection Title : $$LocaleString:"List of Ledgers" Type : ledger Fetch : Name Report : ledger Variable : Sledger Trigger : Sledger IsODBCTable : Yes Delete : Format Add : Format : $Name,50 Add: SubTitle : $$LocaleString:" Ledger Name ","Mobile No", "GROUP", "PAN", "GSTIN", "OP BALANCE", "CL BALANCE" Column Align: Left, Left, Right, Left, Left, Right, Right, Right Add :Format :$LedgerMobile Fetch :LedgerMobil Add : Format : $parent Fetch : parent Add : Format : $IncomeTaxNumber Fetch : IncomeTaxNumber Add : Format : $PartyGSTIN Fetch : PartyGSTIN Add : Format : $OpeningBalance Fetch : OpeningBalance ;Add : Format : $ClosingBalance ;Fetch : ClosingBalance Add : Format: $BaseClosing : "AllSymbols, DrCr, NoZero" Fetch : ClosingBalance
Thanks Sir, it solved my problem by adding this line Add : Format: $BaseClosing : "AllSymbols, DrCr, NoZero" Fetch : ClosingBalance
