Is it possible to have same RecId between header and line table ?

(0) Share

Report

Posted on by Ken Manhattan

508

Hi guys,

Recently I've been facing weird issue, whereby the RecId in Purchase Order (PurchTable) and its Line (PurchLine), are same. Could this be possible ? Cause all this while as per my understanding, Rec Id is always unique.

Is there any reason or it is just something wrong in my system ? and may I get advice how to check this ?

Thanks.

All responses (5)

Answers (1)

Verified answer

Martin Dráb 230,458 Most Valuable Professional on at

Like (2)

Report

Is it possible to have same RecId between header and line table ?

Giving you a "formal" resources may prove difficult, due to briefness of AX/F&O development documentation. Maybe Inside Dynamics AX books have it stated explicitly; unfortunately I'm not at home and can't consult them for you.

But you'll find it discussed at many places and you'll also proofs inside the application (if seeing that you have tables with identical record IDs isn't a sufficient proof for you). For instance, you can see that SystemSequences table holds information about record IDs by table ID.
Ken Manhattan 508 on at

Like (0)

Report

Is it possible to have same RecId between header and line table ?

Hi all,

Thanks you very much for the explanation. I, honestly just knew this, all this while I thought RecId is unique across the entire tables in the D365 FO system (or shall I say database). May I know is there any "formal" resource or document from Microsoft mentioned this ? Or some explanation about what is RecId and most importantly stated it is unique in scope of table, but not with other tables.

I tried to google it but unfortunately cannot find any.

Thanks in advance
Suggested answer

Layan Jwei 7,264 Super User 2024 Season 2 on at

Like (1)

Report

Is it possible to have same RecId between header and line table ?

Hi Ken,

Yes that's totally fine and it's a coincidence. PurchTable and PurchLine relates to each other with PurchId and not recid even if recids were similar. Also as Martin and Bharani said, recId is unique per table.

Thanks,

Layan Jweihan,

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
Suggested answer

Bharani Preetham Pe... 3,587 Super User 2024 Season 1 on at

Like (2)

Report

Is it possible to have same RecId between header and line table ?

Your understanding is right. RecId is always unique. But it doesn't mean that a RecId should be unique across all tables in D365. This is unique only at that table. So, this particular scenario can happen and it won't harm anything.
Suggested answer

Martin Dráb 230,458 Most Valuable Professional on at

Like (1)

Report

Is it possible to have same RecId between header and line table ?

It's completely possible, because RecId is a unique ID of a record in a table, not unique ID regardless of a table.

For example, when you create the first record in PurchTable and in PurchLine, both may get the record ID of one.

Is it possible to have same RecId between header and line table ?

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Meet the Top 10 leaders for December

Start Your Super User Journey

Leaderboard

Featured topics

Product updates

Is it possible to have same RecId between header and line table ?

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Meet the Top 10 leaders for December

Start Your Super User Journey

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates