Import payment vouchers from Excel with BankAllocations

Discussion in 'Requests' started by Mansur Kalyankar, Feb 11, 2013.

    
  1. Mansur Kalyankar

    Mansur Kalyankar New Member


    Dear all,

    I am trying to use TDL shared at http://tdlexperts.com/index.php?threads/import-payment_vch-excel-to-tally.251/#post-564 for importing payment vouchers with BankAllocations details.

    I used the following additional lines in addition to the original TDL (used it with & without WALK COLLECTION):

    91:WALK COLLECTION: BankAllocations
    92:INSERTCOLLECTION OBJECT: BankAllocations
    93:SET TARGET: LedgerEntries
    94: SET VALUE: InstrumentDate: $DSDInstDate
    95: SET VALUE: InstrumentNumber: $DSDInstNo
    96: SET VALUE: PaymentFavouring: $DSDPayee
    97: SET VALUE: ChequeCrossComment: $DSDCrossing
    98: SET VALUE: ChequeIssuePlace: $DSDIssuePlace
    99:SET TARGET: ..
    100:END WALK

    I am getting the following error:
    FUNCTION: 'Import Of Payment Voucher' LABEL: 91 : Collection 'BankAllocations' could not be found!
    FUNCTION: 'Import Of Payment Voucher' LABEL: 91 : Action execution failed!
    FUNCTION: 'Import Of Payment Voucher' LABEL: : Action execution failed!
    FUNCTION: 'Import payment' LABEL: 001 : Action execution failed!
     

    Attached Files:



  2. admin

    admin Administrator Staff Member


    Place Label 90 after 100
     

    Attached Files:



  3. Mansur Kalyankar

    Mansur Kalyankar New Member


    Dear Mr. Kiran,

    I used the file attached by you with label 90 after 100, still getting the same error.

    Appreciate your help.

    Thanks in advance
    Mansur
     


  4. Mansur Kalyankar

    Mansur Kalyankar New Member


    I managed to make some corrections & now the vouchers are getting imported but without "BankAllocations", can you please help me correct the same?

    I have attached revised file.

    Thanks in advance
     

    Attached Files:



  5. Mansur Kalyankar

    Mansur Kalyankar New Member


    Working TDL. Handy for Saudi Arabia with additional UDF for Issue Place on cheque.

    Thanks to all experts/members for their contribution & support.
     

    Attached Files:



  6. manjappa

    manjappa New Member


    Dear All,

    Anybody having tdl with format for importing from excel to tally.

    Kindly help me.

    I have done but I am getting error like "LABEL: 001 : Action execution failed"

    Herewith I am attaching my tdl code file your reference.

    My e-Mail Id: manjappa1978@gmail.com
     

    Attached Files:



Share This Page