Excel to Tally Receipt Voucher

Discussion in 'Tally Developer' started by Partha Mondal, Sep 13, 2019.

    
  1. Partha Mondal

    Partha Mondal Member


    Dear Admin
    I am new in TDL. I just created a TDL for import from Excel to Tally Receipt voucher.

    Here I create three UDF in Receipt voucher. Code is working fine. But I want prevent duplicate when import
    from Excel.

    I give you example. If (Same Date, Same Receipt No. [UDF] & Amount) is found in tally data which is already saved then show message "Already imorted" and stop otherwise it will imported. I share my code & Excel sheet.

    Can it is possible in through integration?

    Please help me sir.
     

    Attached Files:



  2. drive

    drive Active Member


    create function to check first as per your condition then import your voucher if false value.
     


  3. Partha Mondal

    Partha Mondal Member


    Thank u for reply.

    Can you give some example pl?
     


  4. drive

    drive Active Member


    like this function
     

    Attached Files:



  5. Partha Mondal

    Partha Mondal Member


    Thank you for reply.

    But as per your example I add system formula but now code is not working. even duplicate also.

    Here you use MasterID. But sir I don't understood this. can you explain why use MasterID

    [Collection: MyColl_1]
    Type : Vouchers : VoucherType
    Child Of : $$VchTypeReceipt
    Belongs To : Yes
    Fetch: Date, TSPLRegNo, TSPLRcptNo, Amount, MasterID
    Search Key: $Date + $TSPLRcptNo


    [System: Formula]
    mFor_duplicate : $$ReportObject:$$CollectionFieldByKey:$MasterID:mad:@mFormula:MyColl_1
    mFormula : ##RPDate + ##RPRcptNo


    I use this [ mFor_duplicate : $$ReportObject:$$CollectionFieldByKey:$TSPLRcptNo:mad:@mFormula:MyColl_1 ]

     


Share This Page