Excel to Tally Voucher Import via ODBC

Discussion in 'Requests' started by anish, Jul 15, 2021.

    
  1. anish

    anish Member


    Dear all
    Attached find the tdl and excel file . I am trying to import voucher from Excel to Tally Voucher Import via ODBC . Code process and shows no error but no voucher import-entered in tally.
    Need Help !!!
     

    Attached Files:



  2. Lynch

    Lynch Member


    modify your label 40
    as per the following code
    ................
    ...............
    Code:
    40:set value: date: $$date:@@DateStr
    
    .........................
    .......................

    And add the following code as well....
    Code:
    [System : Formula]
    DateStr : ($$StringPart:$_1:7:2) + "-" + +
    ($$StringPart:$_1:4:2) + "-" + +
    ($$StringPart:$_1:0:4)
     
    anish likes this.


Share This Page