Posts

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

Maybe signing documents virtually is not the most legal signature but its cool anyway. This example here uses signature pad and implements in Business Central so you can save hand written signatures to documents inside Business Central. This example uses standard Sales Order page. Not 100% sure if its useful or not but maybe it is. For example collecting customer signatures on the field for service orders or maybe letting the customer pay the invoice by drawing a cat picture....

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 focuses on Unit Price etc. Al Code: pageextension 50100 "Ext. Sales Order Subform" extends "Sales Order Subform" { layout { addlast(content) { usercontrol(SetFieldFocus; SetFieldFocus) { ApplicationArea = All; trigger Ready() begin CurrPage....

When page is missing ApplicationArea and UsageCategory it is not searchable in the searchbar and its not possible to bookmark the page to Role Center. For example page 5407 “Prod. Order Comp. Line List” is defined like this: Its not possible to change ApplicationArea or UsageCategory in Page extensions. But what if users still want to find page 5407 “Prod. Order Comp. Line List” in search bar and bookmark it?...

If you try to publish app via Powershell to onprem or Docker sandbox environment and you get error Unsupported symbol type 393316 where the number can be whatever then it just means that the version of the app you are trying to publish is not compatible with your installed BC version. If you download symbols from your Business Central you try to publish and try to build the app when you will get the actual error and missing types....

It very easy to setup and use Azure Insights in Business Central. You can read how to set it up here But how to actually analyze the logs in Azure? First I’ll set up some custom events that I want to send to Azure. Little wrapper around the Session.LogMessage so its easier to use: local procedure LogMessage(EventId: Text[50]; Message: Text[200]; Dimension: Text[50]) var TelemetryDimensions: Dictionary of [Text, Text]; begin TelemetryDimensions.Add('Method', Dimension); Session....

Important detail that caused me a bug recently and I want to share with others who are writing AL Code for Business Central. When you pass a record to a procedure then you can do that either by pass-by value or pass-by reference. When you have code like this: CurrPage.SetSelectionFilter(ApprovalEntriesSelected); ApproveEntry(ApprovalEntriesSelected); and you pass-by value: procedure ApproveEntry(Entry: Record "Approval Workflow Entry") then all filters are cleared on the record and you get a empty record on your procedure....

Here’s a example of how to post Assembly orders and lines and add item tracking to the lines and header via Odata web services in Business Central. First API page to create/read/update assembly orders: page 50130 AssemblyOrders { PageType = API; APIGroup = 'BCPortal'; APIPublisher = 'BCPortal'; APIVersion = 'v1.0'; EntitySetName = 'assemblyOrders'; EntityName = 'assemblyOrder'; DelayedInsert = true; SourceTable = "Assembly Header"; layout { area(Content) { repeater(AssemblyHeader) { field(SystemId; Rec....

Last month I had some time to play around and I did small project which implemented Azure Storage Queues in Business Central. What are Azure Storage Queues? They are service in Azure which allows to store some message in queue over HTTP and then poll these messages in some message receiver. Why are they useful? They are useful in some integration scenarios where you have large amounts of incoming data and you cannot process them in real time....