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…
Teddy
84
Posts
26,053
Views
Experienced NZ-based NAV Developer and Consultant with 10+ years of experience leading multiple IT projects, performing business analyst, developing, implementing, and upgrading Dynamics NAV and Business Central. I have led multiple Dynamics NAV and Business Central projects for businesses in Asia, such as Japan, Singapore, and Indonesia, and currently in both Australia and New Zealand. I am passionate to deliver solution that focuses on user-friendly interface while keeping high standard of compliance with the needs. I believe in adding value to people’s lives and try to leave people better than when I first met them.
Getting D365 Business Central Data to Excel Using OData Feeds
Excel with OData Feed Apart from Open in Excel or Copy Paste, there is another way to get your data from D365 Business Central to Excel using OData…
Purchase Order Dates
Purchase Order 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…
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…
Vendor Lead Time vs Item Lead Time
Requisition Worksheets 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…
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…
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. NewText := DelChr(OldText, '=', '-*!?'); If you…
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. Where…
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…
Page Inspection
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…