Small and medium business | Business Central, N...

Error: The record in table Sales Price already exists. Identification fields and values

(1) Share

Report

Posted on by MR-29040713-0

I already customize this sales price table line to add new field from region table.

But when i key in new line in the table line level, its not detected region field as identification field to be unique. Should be the infolog error is not there if the region is different. But now the if the region is changing, the error still there. how do i add region field to be one of the logic to detect if region field is same then pull the error, and if region field is different then accept the new line and save.

Is it something to do with key?

Thanks

All responses (4)

Answers (0)

MR-29040713-0 7 on at

Like (1)

Report

Error: The record in table Sales Price already exists. Identification fields and values

Hi,

This is key setup inside sales price table extension:

This is the list of keys inside sales price table:

May i know how to add key? because when i add key and include region field in table extension, the error still there. How to add and make sure the validation include the region field?

Thanks.

Regards,

Aliff
Suggested answer

KasparsSemjonovs 4,448 Super User 2025 Season 1 on at

Like (1)

Report

Error: The record in table Sales Price already exists. Identification fields and values

You would need to add a new Key, that includes the new field, otherwise it is just an extra field, and the same validation exists, that the records cannot have duplicates, where all values in key fields are the same.
MR-29040713-0 7 on at

Like (0)

Report

Error: The record in table Sales Price already exists. Identification fields and values

Hi Mohamed,

This is the table extension customization done in sales price table, simple one just to add new field regionccode from table region:

and this is the customization that i add the field in table line in that page:

Regards,

Aliff
Mohamed Amine Mahmoudi 24,665 Super User 2025 Season 1 on at

Like (0)

Report

Error: The record in table Sales Price already exists. Identification fields and values

Hi,

Can you please share with us the customization on sales price table ?

Best regards,

Mohamed Amine MAHMOUDI