4 Replies Latest reply on May 31, 2013 9:12 AM by Leno Sun

    How to validate duplicate records in WEBADI

    979947
      Hello All,
      I have a requirement to validate if any duplicate records were being uploaded through excel sheet(WEBADI Template).

      I am below information in my excel sheet:

      1) Receipt Num
      2) PO Ref Num
      3) Trx Date
      4) Trx Type
      5) Currency
      6) GL Date
      7) Source.. etc

      if user enters any duplicate (PO Ref Num) in the excel sheet it should error out the record saying "duplicate record' can any one please help if they have done this in past.

      Thanks,
      Mahesh