Excel to Tally Import Issue

Discussion in 'Free Source Codes' started by Sanjay preethi, Aug 12, 2021.

    

  1. Dear Delvelopers,,,

    try to import bank statement excel to tally

    Entry's import is very well ,,payment Entry no issue
    but receipt entry Dr,Cr Ledger Mismatch (Interchanged)

    any one help me....

    ;;;;;my code below;;;;;;;;;;;

    [Function:BankFUNCTIONEntry]


    Variable:isAccLedgerName:String



    38 : Walk Collection: IsVchCollval

    39 : New Object: Voucher
    40 : Set : SVViewName : $$SysName:AcctgVchView
    42 : Set Value : PersistedView : $$SysName:AcctgVchView
    44 : Set Value : VoucherTypeName : $LVoucherType
    48 : Set Value : VoucherNumber : $LDocumentNr
    50 : Set Value : Date : $$Date:$LVoucherDate
    52 : Set Value : Reference : $LDocumentNr
    54 : Set Value : ReferenceDate : $$Date:$LDocumentDate
    56 : Set Value : Narration : $LNarration
    58 : Set Value : PartyLedgerName : $$String:$LPartyName


    90 : Walk Collection:IsAccLedger
    91 : Set:isAccLedgerName:$$LocaleString:$LAccLedgerName

    92 : Insert Collection Object: LedgerEntries
    94 : Set Value : LedgerName : $LPartyName
    96 : Set Value : IsPartyLedger : No
    98 : Set Value : IsDeemedPositive : Yes
    100 : Set Value : Amount : $$AsAmount:$IsGrossAmount * -1

    104 : Set Target:..

    106 : End Walk

    260 : Insert Collection Object:LedgerEntries

    262 : Set Value : LedgerName : ##isAccLedgerName
    264 : Set Value : IsPartyLedger : No
    266 : Set Value : IsDeemedPositive : No
    268 : Set Value : Amount : $$AsAmount:$IsNetAmt

    286 : Set Target:..

    2178 : Save Target
    2180 : End Walk
    2766: Msg Box: "Status" : "Bank Vouchers \nPassed Successfully"
     

    Attached Files:

    • 1.jpg
      1.jpg
      File size:
      205.6 KB
      Views:
      142
    • 2.jpg
      2.jpg
      File size:
      190.9 KB
      Views:
      137
    • bANK.xls
      File size:
      24.5 KB
      Views:
      93



  2. finally Done..!!!!
     

    Attached Files:

    • 01.jpg
      01.jpg
      File size:
      130.7 KB
      Views:
      131
    • 1.jpg
      1.jpg
      File size:
      119.3 KB
      Views:
      145
    • 2.jpg
      2.jpg
      File size:
      242.7 KB
      Views:
      138
    psr likes this.


  3. arihantl

    arihantl New Member


    Can you please share revised code
     


  4. Kamlesh Choudhary

    Kamlesh Choudhary New Member


    Can you please share code for importing excel to tally. Bank statements/Sales/Purchases
     


Share This Page