Posts

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....

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....

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....

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....

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....

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....

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....

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....

Here’s an example of how to use your phone scanner as barcode scanner within Business Central default mobile application. This uses https://github.com/mebjas/html5-qrcode library to achieve this. Code example can be found from https://github.com/nocubicles/bc-barcode-scanner This is not perfect yet as I didn’t find a way to remember the user access grant for example. But its a start and usable already. The example I made will add a button to Purchase Order which opens the scanner and then you can scan a barcode....

Timber material in ERP Handling timber is in ERP is suprisingly hard in ERP. The thing it makes it difficult is that its handled both in Cubic Meters (M3), running meters and in PC’s. Take a batch of timber with measurements (MM) 50x150x4500. Each piece of timber is about 0.03375 M3. ((50/1000)(1501000)/(4500/1000)) = 0.03375 M3. Each batch of timber has different qualities - It has % of moist, FSC/PEFC quality marking, stress test and many more....