SQL to Tally ODBC. How to map dr and cr with objects inside walk collection..

Discussion in 'Tally Integration' started by shnkarmahdev, May 22, 2020.

         
  1. shnkarmahdev

    shnkarmahdev New Member


    I have Dr and Cr parts of voucher, As you can see below:

    upload_2020-5-22_19-54-28.png

    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:
    upload_2020-5-22_20-1-16.png
    upload_2020-5-22_20-1-33.png
    upload_2020-5-22_20-1-46.png

    Someone please help me out with this!
     


  2. sanjaybjthakkar

    sanjaybjthakkar New Member


    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
     
    shnkarmahdev likes this.


  3. shnkarmahdev

    shnkarmahdev New Member


    Can you please elaborate, good sir?
     


Share This Page