Am a beginner in tdl and in want to make a collection that can extract invoices from tally using odbc so that i can view them in vb.net and make an envoicing solution from vb.net. so far i have this tdl code to make the collection but it does not give me item names ,quantity,discount e.t.c neccessary for make an envoice. [Collection: RTSAllVouchers] Type: Voucher IsODBCTable: Yes Fetch : *, AllLedgerEntries.*, LedgerEntries.*,Inventory Entries,*
[Collection : RTSAllVouchers] Type: Voucher IsODBCTable: Yes Fetch: Vouchernumber,date,vouchertypename [Collection : INV Coll] Source Collection: RTSAllVouchers Walk : Inventory entries by : Vouchernumber:$Vouchernumber by:Stockitemname:$stockitemname Aggr compute:Qty:sum:$BilledQTy compute:Amt:$Amount
Hey Nagaraj, Since i have vouchers with multiple entries of the same stock item, i modified the query as below to get all the stock item names. However now the BilledQty has become blank. How to fix that? [Collection : RTSAllVouchers2] Type: Voucher [Collection : INVColl2] Source Collection: RTSAllVouchers2 Walk : Inventory entries Fetch: Vouchernumber Compute : Stockitemname:$stockitemname Aggr compute:Qty:sum:$BilledQTy compute:Amt:$Amount ISODBCTable : Yes
I hope this will work Code: [Collection : RTSAllVouchers2] Type: Voucher [Collection : INVColl2] Source Collection: RTSAllVouchers2 Walk : Inventory entries Fetch: Vouchernumber, Date, AllInventoryEntries.BilledQty, AllInventoryEntries.ActualQty By : StockItemName : $StockItemName Compute : Stockitemname : $Stockitemname compute : Amt : $Amount Aggr compute : Qty : sum : $BilledQty ISODBCTable : Yes