On the File menu, point to Source Control, Advanced, and then click Workspaces.... In the Manage Workspaces dialog box, tick the Show remote packages checkbox. Under the Name column, select the workspace that you want to remove, and then click Remove. In the Confirmation dialog box, click OK.
AX / D365FO – COnverts String in Upper case
Use strUpr to convert string in upper case in x++ info(strUpr('abc')); This returns ABC
SQL SERVER – Troubleshoot high-CPU-usage issues
Good article that helps you to find the causes of high CPU usage in SQL SERVER : https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-high-cpu-usage-issues
AX / D365FO – How to do an Inventory recalculation for on-hand Qty
Sometimes you may see some discrepancy in InventSum table for any item then you may need to recalculate inventsum for particular item. You can try in 2 different ways : With D365FO User Interface With X++ code With D365FO User Interface Go to System administration > Consistency check Choose : "Inventory management" Module Just do … Continue reading AX / D365FO – How to do an Inventory recalculation for on-hand Qty
AX / D365FO – Clear Work user sessions on Warehouse Mobile app
Sometimes it may happen that the session of a user logged into the Warehouse mobile app remains blocked or an error prevents you from working. What you have to do in these cases is to close the user's session.To do this, follow these instructions : Go to : Warehouse management > Inquiries and reports > … Continue reading AX / D365FO – Clear Work user sessions on Warehouse Mobile app
AX / D365FO – X++ exception handling
Nice post that explains hoew to manage exceptions in X++ : https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/dev-ref/xpp-exceptions
AX / D365FO – Configuring Batch job e-mail Alerts
To configure Batch jobs processing e-mail alert you must : Configure D365FO E-Mail parameters Set your e-mail Address in D365FO Set the Batch job Alerts parameters to E-Mail Configure D365FO E-Mail parameters Go to System Administrator > Setup > Email > Email parameters Configure your SMTP Server Settings and insert a Sender Email user Set … Continue reading AX / D365FO – Configuring Batch job e-mail Alerts
SQL SERVER – Update top n records in sql server
This code willupdate first 100 rows of your table update top (100) table1 set field1 = 1
SQL SERVER – How to get last char in a string in sql server
select right('abc', 1) This will give "c" as result
AX / D365FO – Get Current Company in AX
static void curExtExample(Args _arg) { str curCompany; curCompany = curExt(); //This gets the current company }
AX / Dynamics 365 For Finance and Operations blog 