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

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,…

Heres an example of how to set field focus in Business Central using one line of Javascript. Setting focus on fields can be useful for example when using barcode scanners or doing some other quick data entry. This example extends sales order lines and after entering the Item No. focuses on Quantity and after quantity…

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…

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

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…

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…

Using job queue parameters you can pass some data to your codeunits that you run via Job queue. How it works? Define your codeunit with TableNo = “Job Queue Entry For example: This job queue gets sales order number via the parameter string and then updates the sales order external doc no when sales order…

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…

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…