Finding duplicate data on different records

Smashed_Pumpkin · 2006-09-26

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 · 2006-09-26

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 · 2010-08-17

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

Alex_Chow · 2010-08-17

Put code on the OnValidate trigger.

Savatage · 2010-08-17

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.

Finding duplicate data on different records

Comments

Categories