Anything about Microsoft Dynamics NAV and Microsoft Dynamics 365 Business Central Consultancy
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...
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...
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...
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,...
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...
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....
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...
If you want to remove any specific characters in a text, such as removing -*!? characters, you can use below code. If you want to do it the other way around, such as keeping...
We used to be able to create a copy of production to sandbox under New button. I noticed this morning that the option is no longer there. Microsoft has moved the option to the...
Highlighting your field can be a very helpful for your user. For example, overdue invoices are colored in red, so users can quickly recognize and pay more attention on those invoices. Business Central offers...
