Please help me how to fetch gstno from party ledger thru odbc Code: [Collection:purColl] Type:Voucher Fetch:Date, VoucherNumber, Reference, VoucherTypeName,LedgerName,PartyLedgerName,Narration,Amount,*.* [Collection : purColl1] Source Collection:purColl Walk : LedgerEntries,billallocations Fetch :Masterid,Date, VoucherNumber, Reference, VoucherTypeName,LedgerName,PartyLedgerName,PartyGSTIN,Narration,Amount,*.* Compute: gstno:$PartyGSTIN Compute: date:$date Compute: vouchertypename :$vouchertypename Compute:BillRef :$name Compute:LWL1:$$CollectionField:$LedgerName:1:AllLedgerEntries Compute:LWA1:$$CollectionField:$Amount:1:AllLedgerEntries Compute:LWL2:$$CollectionField:$LedgerName:2:AllLedgerEntries Compute:LWA2:$$CollectionField:$Amount:2:AllLedgerEntries Compute:LWL3:$$CollectionField:$LedgerName:3:AllLedgerEntries Compute:LWA3:$$CollectionField:$Amount:3:AllLedgerEntries Compute:LWL4:$$CollectionField:$LedgerName:4:AllLedgerEntries Compute:LWA4:$$CollectionField:$Amount:4:AllLedgerEntries Compute:LWL5:$$CollectionField:$LedgerName:5:AllLedgerEntries Compute:LWA5:$$CollectionField:$Amount:5:AllLedgerEntries Compute:LWL6:$$CollectionField:$LedgerName:6:AllLedgerEntries Compute:LWA6:$$CollectionField:$Amount:6:AllLedgerEntries Compute:LWL7:$$CollectionField:$LedgerName:7:AllLedgerEntries Compute:LWA7:$$CollectionField:$Amount:7:AllLedgerEntries Compute:LWL8:$$CollectionField:$LedgerName:8:AllLedgerEntries Compute:LWA8:$$CollectionField:$Amount:8:AllLedgerEntries Compute:LWL9:$$CollectionField:$LedgerName:9:AllLedgerEntries Compute:LWA9:$$CollectionField:$Amount:9:AllLedgerEntries Compute:LWL10:$$CollectionField:$LedgerName:10:AllLedgerEntries Compute:LWA10:$$CollectionField:$Amount:10:AllLedgerEntries Compute:LWL11:$$CollectionField:$LedgerName:11:AllLedgerEntries Compute:LWA11:$$CollectionField:$Amount:11:AllLedgerEntries Compute:LWL12:$$CollectionField:$LedgerName:12:AllLedgerEntries Compute:LWA12:$$CollectionField:$Amount:12:AllLedgerEntries Compute:LWL13:$$CollectionField:$LedgerName:13:AllLedgerEntries Compute:LWA13:$$CollectionField:$Amount:13:AllLedgerEntries Compute:LWL14:$$CollectionField:$LedgerName:14:AllLedgerEntries Compute:LWA14:$$CollectionField:$Amount:14:AllLedgerEntries Compute:LWL15:$$CollectionField:$LedgerName:15:AllLedgerEntries Compute:LWA15:$$CollectionField:$Amount:15:AllLedgerEntries Compute:LWL16:$$CollectionField:$LedgerName:16:AllLedgerEntries Compute:LWA16:$$CollectionField:$Amount:16:AllLedgerEntries Compute:LWL17:$$CollectionField:$LedgerName:17:AllLedgerEntries Compute:LWA17:$$CollectionField:$Amount:17:AllLedgerEntries Compute:LWL18:$$CollectionField:$LedgerName:18:AllLedgerEntries Compute:LWA18:$$CollectionField:$Amount:18:AllLedgerEntries Compute:LWL19:$$CollectionField:$LedgerName:19:AllLedgerEntries Compute:LWA19:$$CollectionField:$Amount:19:AllLedgerEntries Compute:LWL20:$$CollectionField:$LedgerName:20:AllLedgerEntries Compute:LWA20:$$CollectionField:$Amount:20:AllLedgerEntries Is ODBC Table:Yes
;Try This. Code: [Collection:purColl] Type:Voucher Fetch:Date, VoucherNumber, Reference, VoucherTypeName,LedgerName,PartyLedgerName,Narration,Amount,*.* [Collection : purColl1] Source Collection:purColl Walk : LedgerEntries,billallocations Fetch :Masterid,Date, VoucherNumber, Reference, VoucherTypeName,LedgerName,PartyLedgerName,PartyGSTIN,Narration,Amount,*.* Compute: gstno:$PartyGSTIN:Ledger:$PartyLedgerName Compute: date:$date Compute: vouchertypename :$vouchertypename Compute:BillRef :$name Compute:LWL1:$$CollectionField:$LedgerName:1:AllLedgerEntries Compute:LWA1:$$CollectionField:$Amount:1:AllLedgerEntries Compute:LWL2:$$CollectionField:$LedgerName:2:AllLedgerEntries Compute:LWA2:$$CollectionField:$Amount:2:AllLedgerEntries Compute:LWL3:$$CollectionField:$LedgerName:3:AllLedgerEntries Compute:LWA3:$$CollectionField:$Amount:3:AllLedgerEntries Compute:LWL4:$$CollectionField:$LedgerName:4:AllLedgerEntries Compute:LWA4:$$CollectionField:$Amount:4:AllLedgerEntries Compute:LWL5:$$CollectionField:$LedgerName:5:AllLedgerEntries Compute:LWA5:$$CollectionField:$Amount:5:AllLedgerEntries Compute:LWL6:$$CollectionField:$LedgerName:6:AllLedgerEntries Compute:LWA6:$$CollectionField:$Amount:6:AllLedgerEntries Compute:LWL7:$$CollectionField:$LedgerName:7:AllLedgerEntries Compute:LWA7:$$CollectionField:$Amount:7:AllLedgerEntries Compute:LWL8:$$CollectionField:$LedgerName:8:AllLedgerEntries Compute:LWA8:$$CollectionField:$Amount:8:AllLedgerEntries Compute:LWL9:$$CollectionField:$LedgerName:9:AllLedgerEntries Compute:LWA9:$$CollectionField:$Amount:9:AllLedgerEntries Compute:LWL10:$$CollectionField:$LedgerName:10:AllLedgerEntries Compute:LWA10:$$CollectionField:$Amount:10:AllLedgerEntries Compute:LWL11:$$CollectionField:$LedgerName:11:AllLedgerEntries Compute:LWA11:$$CollectionField:$Amount:11:AllLedgerEntries Compute:LWL12:$$CollectionField:$LedgerName:12:AllLedgerEntries Compute:LWA12:$$CollectionField:$Amount:12:AllLedgerEntries Compute:LWL13:$$CollectionField:$LedgerName:13:AllLedgerEntries Compute:LWA13:$$CollectionField:$Amount:13:AllLedgerEntries Compute:LWL14:$$CollectionField:$LedgerName:14:AllLedgerEntries Compute:LWA14:$$CollectionField:$Amount:14:AllLedgerEntries Compute:LWL15:$$CollectionField:$LedgerName:15:AllLedgerEntries Compute:LWA15:$$CollectionField:$Amount:15:AllLedgerEntries Compute:LWL16:$$CollectionField:$LedgerName:16:AllLedgerEntries Compute:LWA16:$$CollectionField:$Amount:16:AllLedgerEntries Compute:LWL17:$$CollectionField:$LedgerName:17:AllLedgerEntries Compute:LWA17:$$CollectionField:$Amount:17:AllLedgerEntries Compute:LWL18:$$CollectionField:$LedgerName:18:AllLedgerEntries Compute:LWA18:$$CollectionField:$Amount:18:AllLedgerEntries Compute:LWL19:$$CollectionField:$LedgerName:19:AllLedgerEntries Compute:LWA19:$$CollectionField:$Amount:19:AllLedgerEntries Compute:LWL20:$$CollectionField:$LedgerName:20:AllLedgerEntries Compute:LWA20:$$CollectionField:$Amount:20:AllLedgerEntries Is ODBC Table:Yes