Hello Everyone , I am a Data Science intern and we are working on project where we are using tally as a source for our data. I am new to tally and TDL and therefore need a little help here. I need to create a collection in TDL which can then be used as an ODBC table. The collection should include all the voucher information. I am attaching an image here, which is how I think the table should look like. I was able to get some information like voucher number , date and grand total in my table with the help of other discussions on this platform itself and I am grateful for that, but there is still some information I am not able to extract such as stock item name, inwards value, closing value etc . Please help me with this.Thank You.
Am not expert in Function...but you need to use a function instead of collection to place your data in rows. See the below example, if it helps you........For one stockitem, it will continue to write in column... and if Stockitem != $$PrevObj, then increment row number and write and so on. [Function: RBVAT Odisha CSTFormI Export AnnexureA] Parameter : pIsCurrentExport : Logical : Yes;No ;;Yes Variable : vFileLocation : String : ##SVExportLocation + "\" + ##PrintFileName Variable : vRowNo : Number Variable : SVVATAnnexureName 000 : Set : SVVATAnnexureName : $$LocaleString:"Annexure-A" 005 : /*Do If : ##pIsCurrentExport : */Open File : ##vFileLocation : Excel : Write 010 : Add Sheet : ##SVVATAnnexureName 015 : Set : vRowNo : 6 020 : Walk Collection : Odisha AnnexA SummaryWithoutError 025 : Write Cell : ##vRowNo : 2 : @@RBVATODishaAnnexSrNo 030 : Write Cell : ##vRowNo : 3 : @@RBVATODishaAnnexAParty 035 : Write Cell : ##vRowNo : 5 : @@RBVATODishaAnnexAAddress 040 : Write Cell : ##vRowNo : 8 : @@RBVATODishaAnnexATIN 045 : Write Cell : ##vRowNo : 10 : @@RBVATODishaAnnexAVchNo 050 : Write Cell : ##vRowNo : 12 : @@RBVATODishaAnnexAVchDate 055 : Write Cell : ##vRowNo : 14 : @@RBVATODishaAnnexACommodity 060 : Write Cell : ##vRowNo : 17 : @@RBVATODishaAnnexAAsblVal 065 : Write Cell : ##vRowNo : 19 : @@RBVATODishaAnnexALRNo 070 : Write Cell : ##vRowNo : 22 : @@RBVATODishaAnnexALRDate 080 : Increment : vRowNo 085 : Do If : ##vRowNo = 16 : Break 090 : End Walk
Thankyou sir, I used the below query and got the table in the format that I wanted, I did not use any functions because I am very new to TDL, I can make only basic collections [Collection: Voucher] Type : Voucher [Collection: All Voucher] Source Collection: Voucher Walk: Inventory Entries By : PName : $PartyLedgerName By : IName : $StockItemName By: Date:$Date By: Amount:$Amount By:VoucherNumber:$VoucherNumber By:VoucherTypeName:$VoucherTypeName Aggr Compute: BilledQty:SUM:$BilledQty Is ODBC Table:Yes Also I wanted to know how can I make a collection to extract daily closing balance of each stock item from my vouchers, in the format which is there in the photo attached with this message. I trying something like this: [Collection: Voucher Collection] Type : Voucher [Collection: ClosingBalance] Source Collection : Voucher Collection Walk : All Inventory Entries By : Date : $Date Fetch : StockItemName, OpeningBalance, ClosingBalance, Billed Qty Is ODBC Table: Yes but my closing balance table
[Collection: ClosingBalance] Source Collection : Voucher Collection Walk : All Inventory Entries By : StockItem: $StockItemName Compute : StkItemClBalance : $TPG_StkClBalance:StockItem:$StockItemName Fetch : StockItemName, OpeningBalance, ClosingBalance, Billed Qty Is ODBC Table: Yes
Thankyou sir, but my closing balance column in the table has null values, any specific reason why it happened?
I actually want the closing quantity, the closing balance, and the closing rate of each stock item for each day, but I have no idea if that data is directly available so that I fetch that data or do I need to use a more complicated TDL
I dunno...... Through collection you can pick all....but that is based on the Vouchers.... if there are blank days when no transaction are there, there won't be any. You will have to write a function, where each day is incremented from Year beginning and extract your data. Hope other experts have a solution.
