Hi, Please help me on the below code It is working fine in Purchase Order in Item-Mode But it is not working in Purchase Invoice in Item-Mode though I have checked in developer mode and field name in both voucher type is same. [#Field:EI AccAllocName] Delete:Table Add:Table:MyLedgerColl [Collection:MyLedgerColl] Use : Alias Collection,Table EndofList Title : $$LocaleString:"List of Ledger" Type : Ledger Fetch : Name Report : Ledger Variable : LLedger Trigger : LLedger IsODBCTable : Yes Add : SubTitle : $$LocaleString:"Ledger Name","Parent Group" Add :Format :$Parent,15 Fetcharent, PartyGSTIN, IsTDSApplicable, IncomeTaxNumber Add : SubTitle : $$LocaleString:"Ledger Name","PAN" Add :Format :$IncomeTaxNumber,10 Add : SubTitle : $$LocaleString:"Ledger Name","TDS" Add :Format :$IsTDSApplicable,5 Add : SubTitle : $$LocaleString:"Ledger Name","Gstin" Add :Format :$PartyGSTIN
Thanks for the reply That I have done but this at the time of Purchase ledger selection in Item Invoice Mode
Further can you help how to provide filter in attached code If voucher type is Sales / Sales Order then only ledger shown in the dropdown that of under Debtors Group If voucher type is Purchase / Purchase Order then edger shown in the dropdown that of under Creditor Group
Iam new to TDL and don't know how to add filters Please find below code, Kindly help to filter list as per voucher type like fir Purchase Invoice only creditors party should show to select [#Field:EI Consignee] Delete:Table Add:Table:MyLedgerColl [#Field:ACLSLed] Delete:Table Add:Table:MyLedgerColl [#Field:EI PartyLedger] Delete:Table Add:Table:MyLedgerColl [#Field:EI Buyer] Delete:Table Add:Table:MyLedgerColl [#Field:EI AccAllocName] Delete:Table Add:Table:MyLedgerColl [Collection:MyLedgerColl] Use : Alias Collection,Table EndofList Title : $$LocaleString:"List of Ledger" Type : Ledger Fetch : Name Report : Ledger Variable : LLedger Trigger : LLedger IsODBCTable : Yes Add : SubTitle : $$LocaleString:"Ledger Name","Parent Group" Add :Format :$Parent,15 Fetcharent, PartyGSTIN, IsTDSApplicable, IncomeTaxNumber Add : SubTitle : $$LocaleString:"Ledger Name","PAN" Add :Format :$IncomeTaxNumber,10 Add : SubTitle : $$LocaleString:"Ledger Name","TDS" Add :Format :$IsTDSApplicable,5 Add : SubTitle : $$LocaleString:"Ledger Name","Gstin" Add :Format :$PartyGSTIN
[#Collection:List of Ledgers] Optionis_DrsGrp:Not $$IsCmpOwner And Not $$CmpUserName = "gokul"; And Not $$CmpUserName = "Bala" [!Collectionis_DrsGrp] Child Of:$$GroupSundryDebtors Belongs To:Yes