Available to Promise (ATP) in D365BC
Jan27

Available to Promise (ATP) in D365BC

Supply Managers and their teams work hard everyday to guarantee all the customer orders can be delivered ‘ontime’. But there are several constrains, limitations and new variables to turn this a difficult task to accomplish! One of the available tools to support these roles is Planning routines inside an ERP. This post will describe how the routine Available to Promise (ATP) inside Dynamics 365… Continue Reading...

Read More
What is planned for Business Central Wave 2 2022 release
Jan26

What is planned for Business Central Wave 2 2022 release

As we are gearing up for new release of business central and already the buzz is started for new version . Here I will list few upcoming features which I am looking forward in new version. In-Client Performance Profiler Demo tool and demo data for manufacturing scenarios Users can export report datasets to XML Introduce copy link option in the Share menu Guided tour that… Continue Reading Ammolh Saallvi’s Article on their...

Read More
Dynamics 365 Business Central 2022 Wave 1: what to expect
Jan25

Dynamics 365 Business Central 2022 Wave 1: what to expect

Microsoft has officially unveiled today the Dynamics 365 and industry clouds release plan for the 2022 release wave 1. The release contains hundreds of new features across the entire Dynamics 365 stack of applications, but here I want to focus on the list of planned improvements for Dynamics 365 Business Central 2022 Release Wave 1. As usual, there are investments on different areas and I will… Continue Reading demiliani’s...

Read More
REST API integration in S2S (Service to Service)
Jan23

REST API integration in S2S (Service to Service)

REST API integration in S2S (Service to Service) The consumption of the Business Central REST APIs via OAuth2 authentication has as a prerequisite an AAD user who has been associated with a paid license of Business Central. With Business Central 2021 release wave 1, release 18.3 or later, Microsoft introduces S2S authentication:

Read More
Tip: Get Current Callstack with a Collectible Error
Jan19

Tip: Get Current Callstack with a Collectible Error

The Code codeunit 50104 “Get Callstack” { SingleInstance = true; [ErrorBehavior(ErrorBehavior::Collect)] procedure GetCallstack() Callstack: Text var LF: Char; begin LF := 10; Error(ErrorInfo.Create(”, true)); Callstack := GetCollectedErrors(true).Get(1).Callstack; exit(Callstack.Substring(Callstack.IndexOf(Format(LF)) +… Continue Reading james’s Article on their blog Tip: Get Current Callstack with...

Read More
Printing 1D and 2D Barcode
Jan18

Printing 1D and 2D Barcode

Barcode Printing Microsoft recently added support for printing 2D barcode. If you are on cloud, you don’t need to purchase the barcode font because Microsoft has already provided and licensed them for you. The cloud font packages are provided by IDAutomation Inc. We are going to see how to print both 1D and 2D barcode. Read Microsoft documentation here to see the list of supported… Continue Reading thatnavguy’s...

Read More
Part 4: (Slightly) More Elegant Error Handling in Business Central
Jan17

Part 4: (Slightly) More Elegant Error Handling in Business Central

Collectible Errors In part 3 we had a look at the new platform feature, collectible errors. Long story short: it makes scenarios where you want to collect and display multiple errors together (e.g. checking journal lines) much easier to code and read, no messing around with if Codeunit.Run then, read the post if you’re interested. The only thing that let the team down was the horrible… Continue Reading james’s...

Read More
Selection Filter Management
Jan14

Selection Filter Management

G/L Account Totaling field Ever heard of SelectionFilterManagement codeunit ? It’s a centralized codeunit that is used to built up filter string based on multiple selected records on the page. An example of usage of SelectionFilterManagement codeunit can be seen on G/L Account Card under Totaling field. When you click on Assist Edit button on Totaling field, the G/L Account List lookup… Continue Reading thatnavguy’s...

Read More
Business Central Universal Code initiative: are you really so surprised?
Jan12

Business Central Universal Code initiative: are you really so surprised?

Yesterday Microsoft has officially presented the Business Central Universal Code initiative ( http://aka.ms/BCUniversalcode). For more details about this initiative, I suggest to read Waldo’s post here or my old post on Simplanova’s blog here. In summary, with this new offering, selling what is called “non-universal code” (alias extensions not targeted to work online) to new Business… Continue Reading...

Read More
Tip: List-Commits
Jan11

Tip: List-Commits

function List-Commits { cd ‘C:Git’ $Commits = @() Get-ChildItem . -Directory | % { cd “$_” if (Test-Path (Join-Path (Get-Location) ‘.git’)) { $Commits += git log –format=”$($_)~%h~%ai~%s~%an” | ConvertFrom-Csv -Delimiter ‘~’ -Header (‘Project,Hash,Date,Message,Author’.Split(‘,’)) } cd .. } $Commits | ? Author -EQ “$(git config –get...

Read More
Create a link to an Application Insights query programmatically
Jan11

Create a link to an Application Insights query programmatically

In our telemetry session at Directions EMEA in Milan we have presented how you can directly use Dynamics 365 Business Central to monitor its telemetries. We actually use this technique in many real-world projects and for one of them we’re doing something more in these days: We automatically send telemetry reports to administrators via email.We provide a link on the report to directly show… Continue Reading...

Read More
Business Central Code History
Jan10

Business Central Code History

Business Central code gets updated from time to time. It’s hard to keep track which ones get updated on each version. Thankfully, Stefan Maron has done a fantastic job creating and sharing the repository for us. GitHub – StefanMaron/MSDyn365BC.Code.History: Contains the Microsoft Business Central Code. Updated each month. This repository holds all versions of the Buisness Central Apps. The purpose is to quickly be able to...

Read More
Business Central: Send an appointment from Job Planning Line
Jan07

Business Central: Send an appointment from Job Planning Line

Feature In addition to using Business Central in Outlook, a feature that I think is interesting is that of being able to send an appointment to the planned resource directly from the job planning lines. This is not comparable to the mail sending functions present in the service module (there are some limitations) but it is still interesting and useful; we are moving towards project management… Continue Reading rs’s Article...

Read More
Microsoft Dynamics Navision Cumulative Update Summary For December 2021.
Jan06

Microsoft Dynamics Navision Cumulative Update Summary For December 2021.

Hi Readers, A new month and new cumulative updates. Microsoft Have Released Cumulative Update for December 2021. Please find below the details of Cumulative Updates Released for Microsoft Dynamics NAV 2017 & NAV 2018. Below are the Links to Download the Latest Cumulative Update. #NAV2017 & #NAV2018 Read Complete Article » Continue Reading Saurav Dhyani’s Article on their blog Microsoft Dynamics Navision Cumulative Update...

Read More
Dynamics 365 Business Central: AppSource submission of library apps used by different extensions
Jan05

Dynamics 365 Business Central: AppSource submission of library apps used by different extensions

Exactly about one year ago I’ve talked about the possibility to create Library Apps and submit them on AppSource. The original post is here if you want to read it. What is a Library App? It’s a normal extension (.app file) that your real extension (the extension you want to publish on AppSource and make it visible) depends on (dependencies setting on app.json file) and that you can… Continue Reading...

Read More
Microsoft Dynamics Business Central Cumulative Update Summary For December 2021.
Jan05

Microsoft Dynamics Business Central Cumulative Update Summary For December 2021.

Hi Readers, A New Month and a new set of cumulative update. Microsoft Have Released Cumulative Update for December 2021 for Business central 14, 17, 18 & 19. Please find below the details of Cumulative Updates Released for Microsoft Business Central 14, 17, 18 & 19. Below are the Links to Download the Latest Cumulative Update. #msdyn365bc14, #msdyn365bc17 #msdyn365bc18 #msdyn365bc19 Read Complete… Continue Reading Saurav...

Read More
Dynamics 365 Business Central, Service-to-Service authentication (OAuth) and Task Scheduler
Dec28

Dynamics 365 Business Central, Service-to-Service authentication (OAuth) and Task Scheduler

Just before Christmas I received a request from a partner about a feature that personally I never had the need to implement before (at least in this way). In the current Dynamics 365 Business Central implementation they have an API that permits to an external application to post records in a custom table and after that the application also creates a task in the Task Scheduler for processing… Continue Reading demiliani’s...

Read More
Happy Holidays!
Dec24

Happy Holidays!

Hey y’all. I just wanted to send my Holiday wishes to the community I value so much. It’s been another crazy year in terms of the world being upside down by this freaking virus. However, it has also shown us how strong this amazing community is – finding new ways to connect, share insights, or just hang out: The Beerinar, Virtual Conferences like DynamicsCon, the BC Launch Event,… Continue Reading waldo’s...

Read More
The “Universal Code Initiative”
Dec23

The “Universal Code Initiative”

A few months ago, I blogged about a new initiative from Microsoft: Microsoft Dynamics 365 Business Central Publisher program. At Directions EMEA, we got more insights to the program. There is still the same focus and intention – but with a different approach and name. I’d like to go more into details on that, as it simply gives me an opportunity to say “I told you so” a number… Continue Reading...

Read More
The Mysterious Case of Bin Content Quantity
Dec22

The Mysterious Case of Bin Content Quantity

I was working on getting inventory availability using Bin Contents and for some reason, I could never get the correct quantity for each Bin. Bin Contents Quantity field in Bin Content is a FlowField which means the field is not a physical field. It is calculated when needed from Warehouse Entry. Quantity is related to the Unit of Measure. Quantity (Base) is related to the Base… Continue Reading thatnavguy’s Article on...

Read More
Dynamics 365 Business Central workflows: Power Automate or Logic Apps?
Dec22

Dynamics 365 Business Central workflows: Power Automate or Logic Apps?

Serverless workflows are in my opinion an important piece of the architecture of a cloud-based ERP solution (and this is the reason why I’m pushing its adoption on different posts, training and speaking). Serverless workflows permits you to create complex integrations between systems by linking a series of serverless tasks together in a sequence defined by your business needs, without… Continue Reading demiliani’s...

Read More
Filtering OData Feeds
Dec21

Filtering OData Feeds

Last time we talked about getting OData Feeds into Excel, this time let’s talk about how to filter that OData Feeds. When you connect and pull data using OData, it pulls ALL the records from the feed that you have selected. If you are dealing with large data, it is expensive to pull large data every single time you do the pull. Historical data such as ledgers can take from minutes to… Continue Reading thatnavguy’s...

Read More
Getting D365 Business Central Data to Excel Using OData Feeds
Dec19

Getting D365 Business Central Data to Excel Using OData Feeds

Excel with OData Feed Apart from Open in Excel or Copy Paste, there is another way to get your data from D365 Business Central to Excel using OData feed. After pulling the data from BC to Excel, you can then use Excel functionality to do charts or pivots to produce the report that you want. Let’s take a look on how to do this. Start by searching for Web Services page. The Web Services… Continue Reading thatnavguy’s...

Read More
Azure AI in Business Central – The Forecasting Model
Dec19

Azure AI in Business Central – The Forecasting Model

Azure AI in Business Central – The Forecasting Model AI (Artificial Intelligence) can be used with Business Central; there are different possibilities of use and integration of Azure AI in Business Central. The technology integrated with Business Central is based on Azure Machine Learning, Azure AI Framework, Subscription and Web Services. Subscriptions for Business Central come with access… Continue Reading rs’s...

Read More
Cloud workflows: is the low-code approach always a good solution?
Dec16

Cloud workflows: is the low-code approach always a good solution?

Last week I wrote a post providing a solution for interacting with files saved in an FTP server directly from Dynamics 365 Business Central SaaS. As said at the beginning of that post, the solution was “what I think it’s one of the best solutions in terms of performances, scalability and reliability” and what we currently use on different cloud projects when we need to handle large… Continue Reading demiliani’s...

Read More
Dynamics 365 Business Central: are you doing cloud data migration? Please sanitize your database before doing it.
Dec14

Dynamics 365 Business Central: are you doing cloud data migration? Please sanitize your database before doing it.

I’ve decided to write this quick post after having spent some hours on supporting a partner in order to discover problems with a Dynamics 365 Business Central online instance. The partner has moved customer’s data from a Dynamics 365 Business Central v14 C/AL database (onpremise) to Dynamics 365 Business Central online. Migration was successful, but then he had a strange error on code when… Continue Reading...

Read More
Part 3: (Slightly) More Elegant Error Handling in Business Central
Dec13

Part 3: (Slightly) More Elegant Error Handling in Business Central

Intro This is a continuation of a series of posts started around a year ago – you can find the old posts here if you are interested. Briefly, the goal is this. I’m posting a journal and there are several checks that I need to perform on each line before they are posted. Instead of stopping and showing the first error I want to validate all of the lines and show all of the errors to the… Continue Reading james’s...

Read More
Dynamics 365 Business Central: handling files via FTP on SaaS
Dec07

Dynamics 365 Business Central: handling files via FTP on SaaS

I’ve written lot of time ago a post on how to save a file from Dynamics 365 Business Central SaaS to an FTP server. The solution can be found here. After this post I’ve received lots of requests about how to do the opposite: if someone sends me a file on an FTP server, how can I retrieve the file, parse it and then save the data into Dynamics 365 Business Central SaaS? There are… Continue Reading demiliani’s...

Read More
Purchase Order Dates
Dec06

Purchase Order Dates

Purchase Order Last time we talk about Sales Order Dates. Now let us talk about the purchasing side. Similar to Sales side, there are a lot of date fields on purchase orders which can be confusing, especially the dates on the Purchase Lines. However, if used correctly, you can use these dates to improve your purchase order processing. You can measure your vendor performance more… Continue Reading thatnavguy’s Article on...

Read More
Best Practices for (Per Tenant) Extensions | Protect Yourself
Dec03

Best Practices for (Per Tenant) Extensions | Protect Yourself

Time to get back to Best Practices for Per Tenant Extensions. This time we are going to discuss something that in my opinion should also be implemented by ISV’s in their AppSource solutions. By default, AL Objects are extensible. This means that everyone can take a dependency on your extension and therefor Microsoft does not allow you to refactor any code once it lands on… Continue Reading Marije Brummel’s Article on...

Read More
Contributing to “ALGuidelines.Dev”
Dec03

Contributing to “ALGuidelines.Dev”

I recently blogged about this new initiative .. the revival of the “NAV Design Patterns Wiki”: ALGuidelines.Dev . Time to talk a bit more on how you can contribute. I’m documenting this while I’m writing my very first pattern (I admit, I had this blogpost laying around for a while ;-)). Disclaimer We do have a contribution-page here: “Guide to Fork & PR :: AL Guidelines” that kind of…...

Read More
Sales Order Dates
Dec02

Sales Order Dates

There are a lot of date fields on sales orders. The dates can be confusing, especially the dates on the Sales Lines. However, if used correctly, you can use these dates to improve your sales order processing. You can fulfill your customer’s requirement better and measure your DIFOT more accurately. The dates can be located on Header only, Line only, or both Header and Line. If the date… Continue Reading thatnavguy’s...

Read More
Oh, TempBlob! What did you do?
Dec02

Oh, TempBlob! What did you do?

The alternative title for this blog post would have been something like… TempBlob, why did you waste my time! Or waste thousands of hours accross our community. The topics of my blogs tend to be about what happens in the freelance projects I work on, and last week this was two extensions that have a substantial size (1000+ objects) that had to be BC19 Compatible. BC19 is the first… Continue Reading Marije Brummel’s...

Read More
“GENERIC METHOD” | Brilliant or Anti Pattern?
Dec01

“GENERIC METHOD” | Brilliant or Anti Pattern?

I’ve been in doubt if I should write this post or not. Read it fast as it may disapear if I regret writing it. Ever since I started working with Navision, almost 25 years ago, I’ve had my own little stuborn ideas. These ideas got me where I am today, but just as often they got me in big trouble and caused personal relationships to shatter right before my eyes. I wrote a lot about the… Continue Reading Marije...

Read More
#msdyn365bc 2021 Release Wave 2 – Centralized Deployment of Office add-ins.
Dec01

#msdyn365bc 2021 Release Wave 2 – Centralized Deployment of Office add-ins.

Hi Readers, In this series we will discuss what's new in Business Central 2021 (Wave 2) a.k.a BC19. This article we will discuss about – Centralized Deployment of Office add-ins. With this series we will understand what's new the product and learn it before it becomes available for customers. #msdyn365bc #2021RW2 Read Complete Article » Continue Reading Saurav Dhyani’s Article on their blog #msdyn365bc 2021...

Read More
Business Central Online 19.1, 2D Barcodes Fonts are available
Nov30

Business Central Online 19.1, 2D Barcodes Fonts are available

Business Central Online 19.1, 2D Barcodes Fonts are available Yes, 2D Barcode Fonts are real. Business Central Online includes the following one-dimensional (1D) and two-dimensional (2D) barcode fonts and symbologies from IDAutomation. The fonts have different specifications for characteristics like encode numbers, symbols, uppercase, and lowercase text. Knowing the specifications is useful… Continue Reading rs’s...

Read More
Dynamics 365 Business Central and PropagateDependencies
Nov29

Dynamics 365 Business Central and PropagateDependencies

More than one year ago (March 2020) I wrote a post explaining a new propagateDependencies app property introduced with version 15.3 in the “hidden” Microsoft.Application app file. This property permits you to specify whether the dependencies of an extension should be propagated as direct dependencies of extensions that depend on this one. Unfortunately this property is only quickly… Continue Reading demiliani’s...

Read More
Vendor Lead Time vs Item Lead Time
Nov28

Vendor Lead Time vs Item Lead Time

Requisition Worksheets In Business Central, you can put a lead time against Vendor or Item card. One of my clients was asking what will happen if you put lead time on both Vendor and Item card. Will BC give suggestion based on Vendor or Item Lead Time ? To test the lead time, I create a Sales Order with Requested Delivery Date and Planned Shipment Date on 31 December 2021. If I run… Continue Reading thatnavguy’s Article on...

Read More
Using Azure Log Analytics on older Dynamics NAV versions
Nov28

Using Azure Log Analytics on older Dynamics NAV versions

Sometimes there are topics that I could swear I wrote about and then someone makes you realise this is not the case. This week that happened with my blog about what Page 9599 means when you see it popping up in Azure Telemetry. Some folks on twitter started asking how it was possible that Super Users were changing data by running tables. I understand the confusion because in newer… Continue Reading Marije Brummel’s Article...

Read More
Where is Edit/Open in Excel in BC19?
Nov25

Where is Edit/Open in Excel in BC19?

Dynamics 365 Business Central has recently been updated to October 2021 Wave 2 update. If you are wondering why you can no longer find Edit/Open in Excel, you are not alone. But don’t worry ! It’s still there. Microsoft decided to move it inside a new share icon (along with the new Teams sharing feature). Cool ! But what about my query/smart list page ? I couldn’t find the share… Continue Reading...

Read More
#msdyn365bc 2021 Release Wave 2 – Unhindered data entry across rows.
Nov25

#msdyn365bc 2021 Release Wave 2 – Unhindered data entry across rows.

Hi Readers, In this series we are discussing what's new in Business Central 2021 (Wave 2) a.k.a BC19. This article we will discuss about – Unhindered data entry across rows. With this series we will understand what's new the product and learn it before it becomes available for customers. #msdyn365bc #2021RW2 Read Complete Article » Continue Reading Saurav Dhyani’s Article on their blog #msdyn365bc 2021 Release...

Read More
Delete Special Characters in Text
Nov25

Delete Special Characters in Text

If you want to remove any specific characters in a text, such as removing -*!? characters, you can use below code. NewText := DelChr(OldText, ‘=’, ‘-*!?’); If you want to do it the other way around, such as keeping only A-E characters and remove the rest, you can use below code. NewText := DELCHR(OldText,’=’,DELCHR(OldText,’=’,’ABCDEabcde’)); Continue Reading...

Read More
#msdyn365bc 2021 Release Wave 2 – Open a file in OneDrive to view and share reports from Report Inbox and Attachments.
Nov24

#msdyn365bc 2021 Release Wave 2 – Open a file in OneDrive to view and share reports from Report Inbox and Attachments.

Hi Readers, In this series we are discussing what's new in Business Central 2021 (Wave 2) a.k.a BC19. This article we will discuss about – Open a file in OneDrive to view and share reports from Report Inbox and Attachments. With this series we will understand what's new the product and learn it before it becomes available for customers. #msdyn365bc #2021RW2 Read Complete Article » Continue Reading Saurav Dhyani’s...

Read More
Dynamics 365 Business Central: PTE + SyncMode problem and troubleshooting
Nov23

Dynamics 365 Business Central: PTE + SyncMode problem and troubleshooting

I think that you know that Dynamics 365 Business Central 2021 Wave 2 (version 19) introduced the possibility to do a forcing of the schema syncronization mode directly from the Extension Management page when uploading a new per-tenant extension. With this new option, it’s now possible to force any destructive table schema changes and circumvent the usual error when such changes are… Continue Reading demiliani’s...

Read More
Business Central Page 9599 | What is it?
Nov23

Business Central Page 9599 | What is it?

Time for a quick blog. Last few weeks I’ve been heads down in some performance tuning of Business Central using modern telemetry from KQL. This is much more powerful than the old SQL Profiler since it allows you to see the stack trace in AL where the problems are caused. AppObjectType: Page AppObjectId: 9599 This little guy was in my telemetry several times. Page 9599. And I could… Continue Reading Marije Brummel’s...

Read More
Cumulative Update 01 for Microsoft Dynamics Business Central 2021 Wave 2.
Nov23

Cumulative Update 01 for Microsoft Dynamics Business Central 2021 Wave 2.

Hi Readers, All of us were waiting for Cumulative Update 01 for Business Central 2021 Wave 2 (BC19). Microsoft Have Finally Released Cumulative Update for 01 for Business Central 19. Please find below the details of Cumulative Updates Released for Microsoft Business Central 19. #msdyn365bc19 Read Complete Article » Continue Reading Saurav Dhyani’s Article on their blog Cumulative Update 01 for Microsoft Dynamics Business Central...

Read More
#msdyn365bc 2021 Release Wave 2 – Additional accessibility improvements for mobile and tablet mode.
Nov22

#msdyn365bc 2021 Release Wave 2 – Additional accessibility improvements for mobile and tablet mode.

Hi Readers, In this series we are discussing what's new in Business Central 2021 (Wave 2) a.k.a BC19. This article we will discuss about – Additional accessibility improvements for mobile and tablet mode. With this series we will understand what's new the product and learn it before it becomes available for customers. #msdyn365bc #2021RW2 Read Complete Article » Continue Reading Saurav Dhyani’s Article on their...

Read More
Business Central Online: “Restart Environment” feature is available
Nov21

Business Central Online: “Restart Environment” feature is available

Hi, good news for today! The long-awaited feature has finally been released: the Restart of environments. Great! Restart is available for all environments, Sandboxes and Production. “How-to restart” and Environment The procedure is very simple. Select the Environment Ex: Production Open “Sessions” Click on “Restart environment” button “Confirm” and wait for completition. Have a… Continue Reading rs’s Article on...

Read More
Business Central Design Patterns & Best Practices
Nov19

Business Central Design Patterns & Best Practices

Business Central Design Patterns & Best Practices a New project… and a new site “This site is meant to house some of the community’s knowledge about Microsoft Dynamics 365 Business Central AL Development best practices, particularly around hosting Design Patterns” Site & GitHub Home :: AL Guidelines This site is meant to house some of the community’s knowledge about Microsoft Dynamics 365 Business Central AL Development...

Read More
Dynamics 365 Business Central and availability tests
Nov19

Dynamics 365 Business Central and availability tests

Dynamics 365 Business Central is an absolutely reliable SaaS service that runs on the Azure platform. It’s a cloud service with a global reach and scale running on one of the world’s largest hyper-scale infrastructures (Azure) with data centers in regions all over the world.  However, despite the guaranteed reliability of the cloud service, moments where a problem can affect the… Continue Reading...

Read More