strange that you're using Tally in Dev mode, yet you're asking for the collection name try hashing the existing definition of the filed, (in your case, the filed name is EI Consignee), if you hash it like below [#Field:EI Consignee] you can go to the existing definition with ctrl + left click on this Code: [Field: EI Consignee] Use : Vch LedgerFetch Use : Ledger Name Field Use : Create Ledger Storage : Party Ledger Name Table : Party Cash Ledgers Extract, Create Master : NOT @@UseClassFmt Table : Invoice Ledgers Extract, Create Master : @@UseClassFmt Set as : If (@@IsPOSInvoice AND $$IsSysName:$$Value) Then "" Else $$CollectionField:$LedgerName:1:LedgerEntries Show Table : On Blank Sub Form : EI Excise Supplementary : @@IsExciseSupplementaryInv Sub Form : VchSuppl DespatchOrderDetails : NOT @@IsExciseSupplementaryInv AND ##ICFGOrderDispDetails AND $$Line = 1 Sub Form : VchSuppl PartyDetails : ##ICFGSupplementary AND $$Line = 1 Sub Form : VchSuppl TaxationDetails : NOT @@IsExciseSupplementaryInv AND @@IsExciseVATSupplAppl AND $$Line = 1 On : Focus : Yes : SET : EISTPartyLedger : $$Value ;;$PartyLedgerName the collection you're looking for are these Code: [Collection: Invoice Ledgers] Use : VLedTable Type : Ledger Fetch : Parent Include : Group:$$GroupSundryDebtors, Group:$$GroupSundryCreditors, Group:$$GroupBranches Include : Group:$$GroupCash Include : Group:$$GroupBank Include : Group:$$GroupBankOD Parm Var : pvVTypeName : String : $VoucherTypeName Parm Var : pVchClassName : String : $ClassName Parm Var : GroupCash : String : $$GroupCash Parm Var : GroupBank : String : $$GroupBank Parm Var : GroupBankOD : String : $$GroupBankOD Parm Var : GroupSundryDebtors : String : $$GroupSundryDebtors Parm Var : GroupSundryCreditors : String : $$GroupSundryCreditors Parm Var : GroupBranches : String : $$GroupBranches Filter : NewClassFilter [Collection: Party Ledgers] Use : VLedTable Type : Ledger Fetch : Name Include : Group:$$GroupSundryDebtors, Group:$$GroupSundryCreditors, Group:$$GroupBranches [Collection: Cash Ledgers] Use : VLedTable Type : Ledger Fetch : Name, ReserveName Include : Group:$$GroupCash Include : Group:$$GroupBank Include : Group:$$GroupBankOD
thanks you for reply sir .... meine bahut find kiya par VLedTable ko modify kiya par fir bhi nahi ho raha tha mere se fir mein yeh kiya [#Field:EI COnsignee] Delete:Table Add:Table:gstinmyledgercoll [Collection:gstinmyledgercoll] Use : Alias Collection Title : $$LocaleString:"List of Ledger Gstin" Type : Ledger Report : Ledger Variable : LLedger Trigger : LLedger IsODBCTable : Yes Fetch : Name,PartyGSTIN Add : SubTitle : $$LocaleString:"Ledger Name","Gstin" Add :Format :$PartyGSTIN
