D365 Business Central : Using Excel Layout for Reporting
Since Business Central 2022 Wave 1 (BC20), we have the ability to use Excel Layout for reporting. Excel layouts work the same way as Word and RDLC layouts in that they can be edited...
Tagged: Functional
D365 Business Central : Notify on Changed Permission Set
D365 Business Central contains a number of predefined permission sets (categorized by type System or Extension) that are added by Microsoft or by your software provider. We can use these Permission Sets as it...
D365 Business Central : Edit Table Data Directly
D365 Business Central does not allow you to directly modify the table data, especially for Cloud SaaS customers. There are some good reasons why we are not supposed to do that, such as for...
Date Formula in Business Central
If you are working with NAV / Dynamics 365 Business Central, you will hear the term Date Formula. A date formula is a formula, abbreviated using combination of signs, letters and numbers, to calculate...
D365 Business Central : License Configuration
D365 Business Central 2022 Release Wave 1 (BC20) is almost here. One of the new features in BC20 is the License Configuration. When you get new users in Business Central, BC will automatically assign...
D365 Business Central : Quantity Rounding Precision
Microsoft introduced Quantity Rounding Precision on BC 2021 Wave 2. The purpose is to reduce rounding issues when converting between unit of measure. I first noticed this when I got an error when I...
D365 Business Central : 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. Quantity field in Bin Content is a FlowField which means...
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...
Getting D365 Business Central Data to Excel Using OData Feeds
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...
D365 Business Central : Purchase Order Dates
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,...
