From the Microsoft Dynamics 365 Business Central and NAV Blogs: Timeline; Log in; Database; AL code

July 26 2019

This week on the Microsoft Dynamics 365 Business Central and NAV blog roundup:

  • How to create a timeline in a report dataset in AL
  • Dynamics 365 Business Central "lock by another user" or "something went wrong" alerts
  • Boosting Business Central on-premises performance to the max with Azure SQL database hyperscale
  • Business Central AL automated tests: How do you get started?

How to create a timeline in a report dataset in AL

On his Think About IT blog, Steven Renders stated that someone recently asked him how to visualize or create a dataset that can show and fetch information on a timeline. For instance, you have a timesheet and you want to visualize the hours employees worked on certain projects, per day, week, month, year, and so on.

In his blog post, Renders offered the example of an order intake report because you can use the standard demo data in Business Central.

The order intake can be defined in different ways, the definition that I will use is: the amount or quantity of sales that has not yet been posted to the ledgers.

In Business Central, you have to fetch the information from the sales line table and present it on a timeline.

You can find out how to do that here.

Unable to log in to Business Central “lock by another user” or “something went wrong” alerts

On the Roberto Stefanetti blog, Stefanetti summarized opinions from a number of MVPs responding to a forum post.  In the scenario he shared, a customer can't access Business Central and when they try to log in, they see a screen with one of the following error messages: "Lock by another user" or "Something went wrong."

In that case, you would need to “log out” and “log in again” to get a fresh session (“Force Asking for a New Session”) but that’s not possible because there is no log out option on that screen; waiting for a timeout is possible, but you have to wait for a lot of minutes then.

You can find the workarounds for this issue here.

Boosting Business Central on-premises performances to the max with Azure SQL database hyperscale

About MSDW Editorial Team

More about MSDW Editorial Team