Dear All, After i installed the TDL given below the inter company ledger comparison is not working (which is done through new column ) the last tdl i added was Expand Info & Width Increase [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: partno Add: Format : $Description Fetch : Description 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", "GROUP", "PAN", "GSTIN", "OP BALANCE", "CL BALANCE" ;;"Mobile No", - add this above if required ;;'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", "GROUP", "GSTIN", "CL BALANCE" ;;"Mobile No" - add this above if required ;;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 ;;end of file PLEASE HELP ME OUT THANK YOU
In your Inter-company comparision TDL...... put all Column-field width's in terms of percentage........whose total come to 100%. e.g. if you have 5 columns....make it 40%+15+15+15+15% OR....... Un-load the above TDL.
SIR FIRST I TRIED THIS (i put width : and % screen) as shown below "but i got the message that this is a invalid input for this field" [#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", "GROUP", "PAN", "GSTIN", "OP BALANCE", "CL BALANCE" Add: Format : $parent Fetch : parent Width : 50% Screen Add: Format : $IncomeTaxNumber Fetch : IncomeTaxNumber Width : 8% Screen Add: Format : $PartyGSTIN Fetch : PartyGSTIN Width : 12% Screen Add: Format : $OpeningBalance Fetch : OpeningBalance Width : 15% Screen Add: Format : $ClosingBalance Fetch : ClosingBalance Width : 15% Screen -----------------xx----------------------- then i tried a different way i put the values as under Add: Format : $parent,50 Fetch : parent Add: Format : $IncomeTaxNumber,8 Fetch : IncomeTaxNumber Add: Format : $PartyGSTIN,12 Fetch : PartyGSTIN Add: Format : $OpeningBalance,15 Fetch : OpeningBalance Add: Format : $ClosingBalance,15 Fetch : ClosingBalance ---------------xx----------------------- but still no luck. Please help this tdl is very helpful and i don't want to unload it. please suggest an alternate solution thank you.
Width has to be defined in the FIELD, not the COLLECTION. You have made a comparision report.... so in your report...whatever the fields are there........in that you need to define percentage.