Showing posts from July, 2019

Dynamics 365 Business Central (BC) Growth is Insane!

  The latest announcement coming out of the Dynamics Business Central (BC) Microsoft virtual event last month was the extremely rapid growth of the software. There are now over 10,000 customers using D365 Business Central cloud-based ERP software with a strong 125k on-premise base. That’s a 250% growth rate! The momentum for this product is amazing! It is no surprise with the amazing ease of use features, monthly subscription fees (not annual), fast implementation, and full integration with Microsoft Office 365 functionality.  To imagine what the software will be 5-10 years from now, let's assume we keep on the same trajectory for a 250% year-over-year growth. What does that look like in terms of numbers of users using BC Cloud? If you look at the graph below, at this current rate, BC will exceed 25,000 customers next year and be well over 100,000 customers by 2023. I believe based on what I am seeing and hearing from the market that this growth rate will continue for at least the

Formatting Phone Numbers in SQL Reporting Services

Every time, without fail, I need to create a phone number on an SSRS report for a client and get stuck with phone formatting. Every time I am searching forums. I thought it would be awesome if it was in some amazing blog that I could visit and copy from each time. So... here it is, if not for myself, then for others: In Report Builder or visual studio, add your phone number field to the report.  Right click on that text box where you added the field and click on expression.  Clear the formula box and type in the expression below. Formula to Use:  =IIF(Fields!Phone.Value Is Nothing, Nothing, IIF(IsNumeric(Fields!Phone.Value), Format(Val(Fields!Phone.Value), "(000) 000-0000"), Fields!Phone.Value)) Note:  My field is actually called Phone. If your field is not called phone, you will need to replace it with your phone field name. (Like: Fields!E_T_PHONE_HOME.Value) Then click on OK at the bottom of the expression box. Run your report.

Verifying Email Messages Sent from Business Central

In Dynamics GP, you could always track if an email was sent by visiting the sent box of your inbox after sending the emails.  After much research, this does not occur with Dynamics BC. When setting up email, you set up one universal email account and therefore it does not prompt you for credentialing when sending emails. This leaves the user to wonder where will you find if an email was sent to a customer or vendor and how do you resend it? Enter- Interaction Log Entries in Dynamics Business Central In the search box, look for Interaction Log Entries.  The first checkbox will show you if the interaction was cancelled. The second will show you if the attempt failed.  If you go to Actions in the taskbar, you can several other options for the interactions.  If a user needs to create an interaction in 365 for Sales/BC, they can do that from this window. You can also evaluate the interaction as well.  If the user did not get the email, from here