Table Locking is a very common problem in Microsoft Dynamics 365 NAV / Business Central. If the problem is understood correctly and the right technique is used, Locking Errors can be solved very easily. This post explains different techniques that can be used to solve Locking errors.
Tag Archives: Table
Quick tip: How do I use table information in Power BI?
Recently Microsoft added the Table Information page to Business Central. See here. And underlying are these objects: Table Information (8700, List) Table Information (2000000028) So I was thinking, hey let’s use this in Power BI.
Using tables instead of table extensions
Recently James Crowter wrote an excellent article about table extensions and how they affect performance. In short, table extensions are great for flexibility and ease of development, but performance decreases when the number of table extensions is adding up. Especially when table extensions are used for hot tables. With hot tables I mean tables that are used often, like Item, Customer, Sales Line, Item Ledger Entry, etc.
Source : Kauffmann @ Dynamics 365 Business Central
Read more…
Blog Series Part 2: How to Develop Table for AL in MSDYN365BC
In this lockdown situation, let’s keep ourselves motivated and utilize this time for learning AL. I have provided a Customer Requirement and will be writing series of blog to develop the functionality which will consist of multiple objects in AL.
What’s faster than temporary tables?
I’m currently working on a new app (for AppSource) and I need fast accessible information throughout a user session that I can look up without having a performance impact on the user experience.
Table.Buffer() Does Not Buffer Nested Values
It’s actually really difficult to come up with a simple demo query to prove this though (the Power Query engine is too clever about not evaluating things it doesn’t need for the final output of a query), but it’s fairly easy to understand the principle. Whenever you have an expression that returns a table something like this:
How To: Customizing Microsoft Dynamics Business Central on Premises Using Tables and Table Types
In Microsoft Dynamics 365 Business Central, there is a table where customer information is stored. In addition, there is a table for vendor data, a table for item data, and so on. Tables let you organize and structure the data within your solution. There are different types of tables based on their technical implementation as well as their functional use.