1
Because RecordId() is a system procedure and not an actual table field, users cannot cannot join data on Record IDs in reports/queries.
If this were a value stored as a system field (like Created/Modified User/Date-time), then these would be easier to achieve.
I get that System ID is the alternative; however, RecordID has some functionality associated RecordRef that I would like to leverage in conjunction with joining on RecordID.
STATUS DETAILS
Needs Votes
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team