Voucher Collection for ODBC in excel, Need costcenter allocations , inventory allocations

Hi Expers and Admin,

Successfully connected odbc/ power query from excel to the below tally collection.

All data explodes well but it does not include cost center names from vouchers.

Please help to modify the below collection to include Costcenter name, cost center allocation amount for every entry in the voucher.

I am very new to tdl and walk/fetch i don't know much please help in laymen language.



[Collection:SalesColl]
Type:Voucher
Fetchate, VoucherNumber, Reference, VoucherTypeName,LedgerName,PartyLedgerName,Narration,Amount,*.*
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