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...
D365 Business Central : Report Limit
To ensure the availability and quality of Business Central services, Microsoft put a certain limitation on the reports, such as Max Execution Timeout to prevent report running continuously for days. You can see this...
D365 Business Central : Sandbox Cleanup Event
When a sandbox is created as a copy of a production environment, BC will do the following things automatically: The job queue is stopped Any base application integration settings are cleared Outbound HTTP calls...
D365 Business Central : Red Color in User Permission Set
After upgrading to BC19, I noticed that some user permission sets are highlighted in red. Checking on the code reveals that Microsoft added new Style and StyleExpr on the field. The permission sets are...
D365 Business Central : Checking Lot Numbers in Bin Content
When we use Item Tracking, BC will capture the Serial or Lot Number by Location in the Item Ledger Entries table, and by Bin in the Warehouse Entries table (if we enable “Lot Warehouse...
D365 Business Central : Page OnLookup Trigger
There are multiple ways in BC to create a Lookup button for a variable in a page or report. Generally speaking, I have seen three following methods being done to achieve the lookup button....
