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. 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?
     


  4. Reshma

    Reshma Member


    I am also facing same problem.. plz help
     


  5. Sudhir83411

    Sudhir83411 New Member


    Hi
    shnkarmahdev...

    Can u share process
    How to establish Connection in SQl Server Management studio With Tally Prime Through ODBC?
     


  6. Vijay Shetye

    Vijay Shetye Member


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


  7. Vijay Shetye

    Vijay Shetye Member


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


Share This Page