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...
Tagged: Functional
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,...
D365 Business Central : Sales Order Dates
There are a lot of date fields on sales orders. The dates can be confusing, especially the dates on the Sales Lines. However, if used correctly, you can use these dates to improve your...
D365 Business Central : Vendor Lead Time vs Item Lead Time
In Business Central, you can put a lead time against Vendor or Item card. One of my clients was asking what will happen if you put lead time on both Vendor and Item card....
Where is Edit/Open in Excel in BC19?
Dynamics 365 Business Central has recently been updated to October 2021 Wave 2 update. If you are wondering why you can no longer find Edit/Open in Excel, you are not alone. But don’t worry...
