The feature of surrogate keys that was introduced with AX 2012 is powerful, but at times creates ambiguity on their usage. A surrogate key is a key whose value has no meaning to people. A large number generated by the system, such as
Recid, could be a surrogate key. The goal of this recipe is to clarify and showcase examples that use surrogate keys in possible patterns. This recipe is divided into two sections: the first section will discuss the usage of surrogate keys in a query-based report, followed by the section that details their application in RDP-based reports.