Dynamics SL and Extended Events

posted on April 16, 2019 by | 1 Comment

I’ve been using Profiler to explore Dynamics SL’s database calls for years. Recently, I learned about Extended Events, which is Microsoft’s replacement for Profiler. They’ve done an excellent and, for me, compelling job of replacing Profiler. I’ll abbreviate Extended Events as XEvent(s) or XE below. If you download SSMS 17 from the Microsoft web site, you’ll see something called XEvent Profiler at the bottom of Object Explorer. There are two pre-configured sessions to watch live events. No need to launch... Continue reading →

Setting Dynamics SL Customization List Checkboxes

posted on April 9, 2019 by | No comments

Have you ever wondered how a Dynamics SL screen customization indicates if a checkbox in a list is checked or unchecked? Perhaps not, but just in case, here’s how it’s done. Checked list items have the ID followed by a semi-colon, then the description. Unchecked items have a colon between the ID and the description. In the list below “GP:Goods for Project” is unchecked. The rest are checked. DL;Description Line,FR;Freight Charges,GP:Goods for Project,MI;Misc Charges,GN;Non-Inventory Goods,SE;Services for Expense,SP;Job Purchases If you... Continue reading →