Get the last inserted record from table using x++

In Microsoft Dynamics 365 for Finance and Operations and Microsoft Dynamics AX 2012, if you want to get the last inserted record form table using X++. You need to order the records as descending by RecId.

RecId is the unique value stored with every row in every table in Microsoft Dynamics 365 for Finance and Operations and Microsoft Dynamics AX 2012 and often known as RecId. So, if we use the ORDER BY clause and use DESC keyword, it will sort the table in descending order by field you use. So, in this case we will use RecId field because it is unique and incremental in nature.

I have shared the code on my GitHub repository. Please download the code to get the last inserted record from table using X++ and use it as per your requirement.

Blog: Click here

YouTube: Click here

GitHub: Click here

Big dreams have small beginnings.

Moeen Ahmed Sultan

I am Moeen Ahmed Sultan from Pakistan, an Independent technical consultant for Microsoft business applications. I am Microsoft Certified Professional, I always seek opportunities to showcase my skills in the extensive field of Computer Science. I have successfully championed to the enterprise by working in extensive areas including Microsoft Power Apps, Microsoft Dynamics AX 2012, Microsoft Dynamics 365 for Finance & Operations, and Microsoft Share Point Online thereby fueling the industry-wide transition.