
Building Dashboards with Microsoft Dynamics GP 2016
By :

As Dynamics GP uses SQL Server for the database, and SQL Server tracks dates with the time, GP dates have a time attached to them. As cool as this may sound, GP doesn't use the time portion, so the time is always defaulted to midnight (12 AM).
There are a few places where time is tracked (for example, the advanced purchase order feature of purchase order approvals). In these rare exceptions, GP will use one Date/Time field for the approval date and a separate Date/Time field for the approval time.
When a record has a date on it, such as an AP invoice, it's probable that we'll want to see data grouped by elements of that date (for example, years, quarters, months, weeks, and/or days). A due date for an AP invoice is an excellent example of this. We usually like to see our AP invoices grouped by 30-day ranges of the due date, resulting in what we call aging buckets.
The Query Editor in Power BI makes working with dates and times a child's play...
Change the font size
Change margin width
Change background colour