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

Business Central and Power Apps

TL/DR: I got interested in Power Apps, set some goals and managed to build a simple app to Receive Purchase Orders: Why Power Apps I’ve been against Low Code/No Code for as long as I can remember. I’ve always thought that these tools don’t scale, make spaghetti code, restrict me too much and just that I don’t need them. I can code everything from scratch and then be ready with my architecture when my application becomes next Twitter or Tiktok....

February 12, 2023 · Villem Heinsalu

How to automatically log changes to a field without setting up Change Log Entries in Business Central

In Business Central you can set up Change Log Entries to log insert/modify/delete events for all the fields in all the tables. But can you do this automatically in the code without even setting up the Change Log Entry? It is quite easy actually. Lets say we want to log the change every time someone updates Payment Reference on the Posted Purchase Invoice. We would then create a procedure and attach it to the Purch....

February 1, 2023 · Villem Heinsalu

How to make chicken soup with Business Central using the Assembly Orders

P.S this image is generated by https://deepai.org/ Making chicken soup is easy - you just need chicken, vegetables, spices and water. Mix it all up, boil it and its done. But how to make chicken soup using Business Central Assembly Order? First it sounds easy, we can define the assembly BOM, create Assembly order and its done. But in reality when we plan to make 100 litres of soup in the end we only might get 96....

January 29, 2023 · Villem Heinsalu

Restricting Role Selection in Business Central for Users

In Business Central there is no way to restrict role selection to users. All users can select between all the available roles. In standard BC you have these roles: What if you want to restrict the role selection for some users only to one or two roles? While i’m sure there are many ways to do it then one way to do it is the following: Lets create new table and page called “User Type” In this table we can define different user types....

December 27, 2022 · Villem Heinsalu