How to validate report selections in Business Central

Recently I had to validate some filter selections on a report in Business Central and found out it was not so straight forward to do. What happened when using the trigger OnPreDataItem() or trigger OnPreReport() triggers was that I was able to validate the filter selections by user but the user experience was not optimal since the selection page closed when the validation error occured. What I came up with was using the trigger OnQueryClosePage(CloseAction: Action): Boolean trigger on the requestpage itself....

November 9, 2023 · Villem Heinsalu

Business Central, BC2ADLS and Microsoft Fabric

I got interested in very cool project I found in github which was originally created by Microsoft and now is maintained in this repo https://github.com/Bertverbeek4PS/bc2adls What this project is is a framework and Business Central app to load data from Business Central into Azure Datalake and then transform the data and analyse it. BC2ADLS allows you to choose which tables and columns you need and will take care of incremental loading so you will only get the changed data....

October 3, 2023 · Villem Heinsalu

Add reservations to Sales Quotes in Dynamics 365 Business Central

Out of the box Business Central doesn’t allow to reserve items for Sales Quotes. But some business might require this and luckily its very easy thing to add. First we need to create action to the Sales Quote Lines: pageextension 50100 "Sales Quote Subform" extends "Sales Quote Subform" { actions { addlast("F&unctions") { action(Reserve) { ApplicationArea = Reservation; Caption = '&Reserve'; Ellipsis = true; Image = Reserve; Enabled = Rec.Type = Rec....

August 7, 2023 · Villem Heinsalu

How to enable extrernal access to D365 Business Central without asking the users to register using external web portal

For my recent project https://bcrfq.com which is a Request For Quotation app made for Business Central that allows vendors to send their quotes to BC I needed a way to allow the vendors to do it without asking them to sign up to anything. I just wanted to share a link to them and be done with it. Basically its a web app and the user will get a unique url pointing to the document that is assigned to them....

July 6, 2023 · Villem Heinsalu

How to design a high performant inventory report in Business Central

If we want to answer a simple question in Business Central - “How many items we have in each location?” then there aren’t that many great built in reports available. There is the standard “Items by Location” report that is not that great. It doesn’t offer exporting, doesn’t offer filtering, you can’t see item values etc. So how do we create a better report? To start designing a report the first thing we need to think about is that we need to calculate the inventory for each item in each location by summarizing the Item Ledger Entries....

June 1, 2023 · Villem Heinsalu

AI

AI is here and there’s no way around it. I don’t think I am the only one who is wondering what will happen in the future. Will my job as a software developer and consultant be obsolete? Will somebody’s elses job as something will be obsolete? Will all the wedding and birthday and graduation speeches in the future be written by AI? I have no idea but probably answer to some of these questions is yes....

March 18, 2023 · Villem Heinsalu

How to manage Financial Instrument Values in Business Central

A way to manage Financial Instruments (ETF’s, Stocks etc) in Business Central and keep their values up-to-date automatically I wanted to find a way to track the values of the different financial instruments my company owns. For example my company can own stocks, ETF’s, options etc and their value will fluctuate because they are listed in the stock market. These instruments must be a asset in my books and I want to keep their values up-to-date daily....

March 14, 2023 · Villem Heinsalu

Business Central & Analysis Views

Today was the first day I got to play with the new analysis views in Business Central and I made a little experiment. I Created a new table: table 50100 "Large Table" { DataClassification = ToBeClassified; fields { field(1; "Entry No."; Integer) { DataClassification = ToBeClassified; AutoIncrement = true; } field(2; "Some Date"; Date) { DataClassification = CustomerContent; } field(3; "Some Amount"; Decimal) { DataClassification = CustomerContent; } } keys { key(Key1; "Entry No....

March 2, 2023 · Villem Heinsalu

Business Central ja Eesti

Hiljuti tuli jutuks, et kas Microsoft Dynamics 365 Business Central sobib väiksematele Eesti ettevõtetele äritarkvaraks või mitte. Esimene reaktsioon Business Centrali vastu oli see, et see on mõeldud suurtele, see on kohmakas ja vanaaegne. Ma olen kokku töötanud erinevate ERP tarkvaradega üle 12 aasta ja viimased kolm sellest olen töötanud ainult Business Centraliga nii Eesti, EU, Usa ja Kanada klientidega ja mõtlesin, et panen kirja oma mõtted, et mis Business Central on ja kuidas ta suhestub kahe teise Eestis populaarse äritarkvaraga (Directo ja Merit) ja Eesti turuga üldse....

February 28, 2023 · Villem Heinsalu

Business Central and Power Apps - Ship Goods from Warehouse

Few weeks ago I experimented with Powerapps and Business Central integration. I liked it and I wanted to do more with it. So here’s another try to push a bit the Powerapps and see how flexible it can be to handle more complicated business requirements. My business requirements are the following: I want to sell products to a Customer via Sales Orders. From Sales Order I will create a Sales Shipment document so the warehouse can ship the goods....

February 21, 2023 · Villem Heinsalu