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...
Category: D365 Business Central
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...
D365 Business Central : Delete Special Characters in Text
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...
D365 Business Central : Copy Production to Sandbox (the new way)
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...
D365 Business Central : Style Color
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...
D365 Business Central : Page Inspection
The page inspection feature enables you to get details about a page, providing insight into the page design, the different elements that comprise the page, and the source behind the data it displays. Page...
