Date fields on NAV 2018 sales orders can be confusing, but used correctly, they will improve your sales order processing. The dates are designed to allow you to plan the shipments to meet your customer’s delivery expectations.
Tag Archives: Date
How To: Use Purchase Order Dates in Microsoft Dynamics NAV 2017
Date fields on NAV 2017 purchase orders can be confusing, but used correctly, they will improve your purchase order processing. The dates are designed to allow you to schedule the receipt of product in time to meet your shipment commitments and your customer’s delivery expectations.
Query by Example to Extract YYYY-MM from a Date Column
I was answering a question for a student in one of my online training courses this week. The question was, “Do you know of a way in power query to efficiently extract YYYY-MM from a Date column?” This can be done ‘manually’ with multiple steps including:
How to Use Date Functions in Microsoft Dynamics Business Central On Premises
There are various places throughout Microsoft Dynamics 365 Business Central where you can enter dates in fields. In fact, a good deal of data in the application is linked to dates. For example, in a sales order, you can set the shipment date. When filtering lists or report data, you can enter dates and times to pinpoint only the data you want to see. If you look at a sales order, an invoice. or a credit memo, there are document dates, posting dates, and date of entry.
Show the refresh date\time in a Power BI report and dashboard
A short post today. Someone recently asked me: “How can I show the date and time this data has been refreshed last in my report and dashboard?”. Here are 2 simple tricks to help you visualize this.
Creating a Date Table in Power BI
Learn how to create a calendar or date reference for your data and organize it by building a DAX date table in Power BI.
Use of Virtual Table : Date – Microsoft Dynamics NAV
This blog post is about something powerful but hidden within Microsoft Dynamics NAV. I believe many developers always work with dates over and over during their day-today life and i’m sure many of you have done many functions which convert, split and do all sort of things with date.