I have Dr and Cr parts of voucher, As you can see below: I declared a collection, got the values from SQL, But i can't map the Dr and Cr Ledgername and amount inside walk collection, As they are 2 separate rows. This is the method i follow to pass the objects as voucher entry: Someone please help me out with this!
Basically you have to make 2 collection 1st colletion will be of the Main Voucher [Collection : MyMainVoucher] Source Collection : OdbcTally By : VoucherNumber : $VoucherNumber 2nd Collection has to be filtered for the same voucher number which represent the DR and CR lines
Hi shnkarmahdev... Can u share process How to establish Connection in SQl Server Management studio With Tally Prime Through ODBC?
You will have to create an ODBC DSN with all required credential and then use the same as connecting string In case you have you can contact me on 9820309919 or mail me at vijayshetye9919@gmail.com will help you out
Since you have created only one collection Tally will treat as 1 line as 1 Voucher and hence probably give you an error say dr cr doesnot match Instead create Two Collection one for for Posting Voucher which shall be grouped by Voucher Number and Pass the Voucher Number in Variable and Second Collection for Ledger Entries which will have voucher Number wise Filter In case you are not able to do the same you can contact me on 9820309919 or share me the code on mail at vijayshetye9919@gmail.com will help you out