D365 Business Central : Adding Total to Sales Order Page
If you look at the Sales Order page, you can see that there are total fields under the Lines section. I recently had a request to add another total field to it, such as...
Category: D365 Business Central
D365 Business Central : Amount Excluding VAT in Journal Entry
When we are entering amount on journal entry page, such as General Journal, we only have option to use Amount Including VAT. Entering the value on the Amount field will automatically calculate the VAT...
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...
D365 Business Central : Using Query to Get Distinct Values
When working with table data, there will be times when we need to retrieve a unique record value from the table (also called SELECT DISTINCT). Unfortunately, D365 Business Central does not provide this logic...
D365 Business Central : Send Invoice Email with Attachments
By standard, D365 Business Central can send posted sales invoice email to the customer. What if you want to include other files in the email as well ? I will describe it here on...
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 : Duplicate BC Container
I recently have an issue where I need to spin up a new D365BC docker container for the same project. Because I already have some data in my current container, I want to duplicate...
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...
D365 Business Central : Hide Enum Values
Enum is great way to centralized your list of options in Business Central. You can define an enum, then use the enum on every objects (such as table, page, report, etc) and they will...
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...
