Stop Duplicate records based on new field

(0) Share

Report

Posted on by kvnkk

800

Hi All,

I have small query about controlling duplicate records based new field created on salesTable

We have added new field in SalesTable called "XReference" and Field data getting inserted when sales order is getting created from 3rd party application(By service).

We want to maintain uniqueness based on xreference and salesid. So we have added a condition to avoid duplication at service level but in some scenarios two sales orders having sames Xreference. (There are some calls are happening exactly at same time not even having difference in seconds )

we can't create new unique index(combination of SalesId and Xreference) as we have many duplicate records with this combination(Settle credit not for those ordes).

how we can control duplication records(Based on combination of Sales ID and Xrefence).

We can handle at 3rd party application level but due some reasons we are unable to do.it

Regards

KVNKK

All responses (1)

Answers (0)

WillWU 22,352 on at

Like (0)

Report

RE: Stop Duplicate records based on new field

Hi Kvnkk,

What do you mean by "duplication records", you could use RecId to avoid duplication records.

Although their XReference is the same, will it affect the data insertion?

And you could always use salesTable::exist(XReference xReference) to check if you have the same record.

You could make some changes to the xReference if the exist() method return true.