Eesti ERP tarkvara konsultatsiooniturg

Hiljuti tuli mulle meelde, et kunagi ehitasin ma ühe väikese programmi, mis suutis võtta EMTA lehelt kõik nende avaldatud excelid ja need andmebaasi salvestada. Kuna ma tegelen ise igapäevaselt Microsoft Dynamics 365 Business Centrali juurutamise ja arendamisega, siis mõtlesin, et teen endale väikese analüüsi kui suur üldse Eesti ERP tarkvarade konsultatsiooni turg on ning milline on erinevate tarkvarade osakaal. Eesti ERP tarkvara konsultatsiooni turu suurus 2020-2023 Kõik need valimisse sattunud ettevõtted minu teada tegelevad kas ERP tarkvara tootmise, müügi, juurutuse vms sellise tegevusega....

February 26, 2024 · Villem Heinsalu

Business Central and Related Dimension Values

I had recently a request from a customer that they want to relate dimensions in Business Central. I.e you have a Sales Person dimension and you want to assign these dimensions values to a Sales Department dimensions. Thats not possible to do out of the box in Business Central and needs some customization. In standard Business Central you need to add all the dimensions one by one and that is very time consuming and error prone....

February 8, 2024 · Villem Heinsalu

Taking a picture with Business Central Mobile app and saving that picture to Sharepoint

Since the storage is pretty expensive in Business Central and you only get 80GB for all your Dev, Test and Live environments it doesn’t make much sense to store large files in Business Central. Lets say we have a business requirement that every time we create a sales quote we need to take a picture with a mobile phone and save that picture somewhere where its related to the Sales Quote in Business Central....

February 6, 2024 · Villem Heinsalu

Business Central, Azure Storage Queues And Jira

Youtube video of demonstrating the project https://youtu.be/Y0uUsBXPBMU Github link to the project https://github.com/nocubicles/jiraandbcintegration I had a need to improve how I work with customers and how I record the tasks and time and bill the customers. So I decided to start using Jira + Business Central. But the problem is that there is no integration available between these two and so I had to built this myself. I need to sync Projects and Tasks and Time entries from Jira to Business Central and when the time comes post the time entries against the Job Task to be able to bill the customer....

December 15, 2023 · Villem Heinsalu

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