This is a continuation of the discussion of Number Series and Number Sequence. This time we will be testing in Cloud Business Central. We will also encounter unexpected results and try to understand the reasons. We will do SQL statement analysis as well.
Tag Archives: Number
Performance of Number Series and Number Sequence
It is fairly common practice to use Number Series to generate a key field value for a table in Business Central. This is very convenient, but do you know how slow it is? Let’s try to look at examples and performance measurements, talk about Number Series and Allow Gaps, as well as Number Sequence.
ELI5 Line numbers on documents in AL
Whenever there are lines in Business Central, there’s a very specific pattern applied because internals depends on it. In this video I give line numbers the ELI5 treatment. Check it out:
Dynamics 365 Business Central: Empty Posted Sales Invoice with only one comment “Document created to avoid gap in No. Series”? Why?
I was asked a very interesting question last week that I would like to share with you in this post. Why are there empty Posted Sales Invoices with only one comment “Document created to avoid gap in No. Series” in Business Central?
How To Create Items with Different No. Series Using the Item Template in Microsoft Dynamics 365 Business Central
If you are using Microsoft Dynamics Business Central Version 18 or older, you cannot see item, customer, or vendor templates, making the job of creating a new record more manual. In later versions, after Version 18 however, you can simply search for “Item Template”, “Customer Template”, or “Vendor Template” to find any of those templates
Do object numbers really matter anymore?
In this video, I look at object numbers, and try to figure out how much they still matter….
Keep your numbers sane with number series
Another entry in my long list of videos for AL beginners. This time it’s all about numbers series.