News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Unique Field on CustIn...

Finance | Project Operations, Human Resources, ...

Suggested answer

Unique Field on CustInvoiceLineTemplate

(0) Share

Report

Report

Posted on by capedcrusader

31

I have created a Custom field called /RID/ on the CustInvoiceLineTemplate Table, I want this field to be unique and not allow duplicates. I have created an index for this table with the RID field, yet it still allows duplicates, is there a way I can go about ti

All responses Img

All responses (2)

Answers Img

Answers (0)

capedcrusader 31 on at

Like (0)

Report

Unique Field on CustInvoiceLineTemplate

I had done this but the field still allows duplicate records
Suggested answer

Kevin Xia Microsoft Employee on at

Like (0)

Report

Unique Field on CustInvoiceLineTemplate

Hi,

That can be achieved by adding an index to the table. Just add the field/s that make up the key, and set the property Allow duplicates to No for that key. You can refer to this thread: www.dynamicsuser.net.

Best regards,

Kevin

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans