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.
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@mFormula:MyColl_1 mFormula : ##RPDate + ##RPRcptNo I use this [ mFor_duplicate : $$ReportObject:$$CollectionFieldByKey:$TSPLRcptNo@mFormula:MyColl_1 ]