If you can’t beat ’em, get joining some tables!

You can’t always get all the information you want or need from one table or default view in F&O. For example, viewing the Open purchase order lines form gives valuable access to all lines, across all purchase orders, that have the status “Open order”. But what would you do if you wanted to filter on …

A spectacular survey of sales orders

If you’re trying to learn about a new system like D365 F&O, whether as a junior consultant or an end user, it’s not easy! First you need a sandbox environment that’s safe to “play” in, then you need a user with a security role with sufficient permissions to see and test all of the options …