This is something I first discovered some months ago, and back then I didn’t think that much about it. Recently someone asked me if it was possible, and I thought it would be worth a quick small blog post. Yes, you can sort on multiple columns in Microsoft Dynamics NAV 2013 (with some limitations though). You do it by holding the shift key down while clicking the next column(s). This way Dynamics NAV sorts the data based on multiple columns. (more…)
One of the new features in Microsoft Dynamics NAV 2013 is the ability to enter formulas like ‘%me’ and ‘%myitems’ while setting filters. Dynamics NAV then replaces the formula with values while applying the filter. Some of the formulas that comes standard are for example; ‘%me’ and ‘%user’ will be converted in to the USERID, ‘%company’ will be converted into the COMPANYNAME, ‘%myitems’ will be converted into a string with the item numbers you listed in the My Items role center part (same goes for ‘%mycustomers’ and ‘%myvendors’). This is nice but what is great is that you can also...