There are many data types that are used in the AL programming language, used to modify code in Dynamics Business Central On Premises. This blog explains how to use the Dictionary, RecordID, RecordRef, and BigText data types.
I was delivering some training last week for a customer in Sydney and they participants had an interesting problem where they needed to be able to report on a rolling time window. Think of it a bit like Rolling 12 Months Sales, or average weekly sales over a rolling 4 week period, but instead this problem uses a rolling time window of just a few hours. I have decided to demonstrate how to solve this problem using my own solar electricity data and build a rolling average 3 hourly kWh consumption.
I have had a couple of requests for help during my live training classes and online training classes on how to build a Six Sigma Control Chart. Now I am not professing to be a Six Sigma black belt, but I do know how to write DAX and I do know how to use Power BI. So here goes. This is what I am going to build.
Now that Microsoft decided not to include C/Side with Business Central knowing how to develop in AL language and how to quickly transfer your solution from C/AL to AL is crucial. In this article, we will talk about how to use Microsoft’s TXT2AL tool to convert your C/Side solution to AL language.
In Microsoft Dynamics NAV or Business Central, you can use work type codes to control your job costs and prices. On the Resources card, you can have a general rate for the resource, but for the work type, you can control the rate based on a state they work in or the type of work they do or other variation.