Finding duplicate data on different records

Smashed_Pumpkin

Hi all,

I need to find a way to display the Sales Header table but to only show records that have duplicate data in the External Document No. field. (i.e., two or more sales header records that have the same external document number). How can I do this?

Thanks in advance for any help/suggestions.

Marije_Brummel

You can perform a search in the OnValidate field and. Search the Sales Header table for records with the same values.

Normaly (for purchases) this is done at posting.

Suja

I want to search for the duplicate record also upon entering data in IC field..How to acheive this

Alex_Chow

Put code on the OnValidate trigger.

Savatage

External Document No. - OnValidate()

IF "External Document No." <>'' THEN BEGIN
  SalesHeader.RESET;
  SalesHeader.SETRANGE("Document Type","Document Type");
  SalesHeader.SETRANGE("Sell-to Customer No.","Sell-to Customer No.");
  SalesHeader.SETRANGE("External Document No.","External Document No.");
    IF SalesHeader.FIND('-') THEN
       MESSAGE('External Doc No Already Exist for %1 %2',SalesHeader."Document Type",SalesHeader."No.");
END;

you can leave out:

SalesHeader.SETRANGE("Sell-to Customer No.","Sell-to Customer No.");

If you just want to compare it to all the headers not just one's with the same customer no. But why would you want that.