Do you need to customize Microsoft Dynamics Business Central on premises? Read this blog to learn how to do it using the String function.
Tag Archives: Function
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.
How to: Customize Microsoft Dynamics Business Central On Premises Using AL Code Functions
If you’re new to Microsoft Dynamics Business Central on premises, you need to know how to easily customize it. In this blog, you’ll learn how to do customizations using AL code functions, including use of Message statements, how to insert a record, and how to modify a record, which makes it easy and fast. This example discusses how to display the information and insert and modify a record in the Customer table using AL Code.
Using Function.ScalarVector() To Optimise Calls To M Functions
One of the most common issues faced when calling web services in M is that the the easiest way of doing so – creating a function that calls the web service, then calling the function once per row in a table using the Invoke Custom Function button – is very inefficient. It’s a much better idea to batch up calls to a web service, if the web service supports this, but doing this forces you to write more complex M code.
Invoking M Functions In Parallel Using List.ParallelInvoke()
I was looking at the list of M functions supported in custom connectors and not in Power BI Desktop (using the technique I blogged about here) in the latest version of the Power Query SDK when I came across an intriguing new function: List.ParallelInvoke(). It doesn’t seem to be documented anywhere, but I think I’ve worked out what it does and it’s very exciting!
Function Overloading in AL
In C/AL we never had the ability for overloading a function. You know: using the same function name with a different context (parameters).
Now – YES WE CAN! It’s all pretty well described on docs:
An In-Depth Look At The Csv.Document M Function
CSV files are one of the most commonly used data sources in Power BI and Power Query/Get&Transform, and yet the documentation for the Csv.Document M function is very limited and in some cases incorrect. In this rather long post I’ll show you as many of the capabilities of this useful function as I’ve been able to discover.