Business Central Versus NetSuite- Side by Side Comparison

Image
Side-by-Side Comparison After my last blog post, I have received lots of requests for my version of a side-by-side comparison chart for Microsoft Dynamics 365 Business Central vs. Oracle NetSuite. Here you go! Feel free to Share the Business Central love! 
Dynamics 365 Business Central vs. NetSuite Features Comparison ChartFeatures ComparisonDynamics 365 Business CentralNetSuiteCore Financial Capabilities (GL, AP, AR, BR) IncludedIncludedMulti-Budgets, Currencies, Fixed assets, Distribution, Manufacturing, Job CostingIncludedAl La Carte PricingModern  InterfaceIncludedNot IncludedUsers Can Personalize All WindowsIncludedNot IncludedNumber of  Included Upgrades per Year

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.








Magic...
Until next time.

Comments

Post a Comment

Popular posts from this blog

Top Things to Not Miss at GPUG/ User Group Summit in Orlando

Dynamics 365 Business Central vs. NetSuite and Other Competitors- Common Myths Debunked