When you refresh a form data source in Dynamics AX or Dynamics 365 for Finance and Operations, the current selection is often lost — the cursor jumps back to the first record. This can be frustrating, especially if you want the user to remain on the same record after an update or refresh. Here’s a simple and reliable way to restore the cursor to the same record after the data source is refreshed. 🧩 Scenario Suppose we have a form displaying records from MyTable . When we refresh the data source — for example, after updating a field or calling executeQuery() — we want the form to return to the same record the user was viewing before the refresh. ✅ Solution: Use ds.cursor() We can achieve this using a record buffer and the cursor() method of the data source. public void refreshDataSource() { MyTable myTableRec; // buffer to store current record // Store the current record myTableRec = MyTable_ds.cursor(); // Refresh the data source MyTable_ds.r...
/** * Calculate the managed cost for a given item and site. * * @param _itemId The ItemId for which the managed cost is to be calculated. * @param _siteId The SiteId for which the managed cost is to be filtered. * * @return The calculated managed cost for the given site. */ private real calculateManagedCostBySite(ItemId _itemId, InventSiteId _siteId) { Query query; QueryRun queryRun; QueryBuildDataSource inventSumDS, inventDimDS, inventTableDS; InventSum ...