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
Post a Comment

Dynamics GP Year-End Payroll Audit List for W-2

-


It's that wonderful time of year for payroll administrators, where you need to validate employee information prior to sending out your W-2 wage reports. 

The SQL script below can either be ran via SQL or inserted into SmartList Builder as a SQL statement and used to build a SmartList. 

It will return Employee and Employee Address Information.


Run the following Script against each company Database:  

select UPR00100.EMPLOYID ID, CASE INACTIVE WHEN 0 THEN 'ACTIVE' when 1 THEN 'INACTIVE' END AS STATUS, LASTDAYWORKED_I LASTDAY, EMPLCLAS CLASS, LASTNAME LAST_NAME, FRSTNAME FIRST_NAME, MIDLNAME MIDDLE, UPR00100.ADRSCODE ADDRESS_CODE, SOCSCNUM SOCIAL_SEC_NUM, CASE GENDER WHEN 1 THEN 'MALE' WHEN 2 THEN 'FEMALE' END AS GENDER, DEPRTMNT DEPARTMENT, DIVISIONCODE_I DIVISION, JOBTITLE TITLE, ADDRESS1, ADDRESS2, ADDRESS3, CITY, STATE, ZIPCODE from UPR00100 

left outer join UPR00102

on UPR00100.EMPLOYID=UPR00102.EMPLOYID and UPR00100.ADRSCODE=UPR00102.ADRSCODE

order by LASTNAME


Comments

Post a Comment

Popular posts from this blog

Formatting Phone Numbers in SQL Reporting Services

-
Image
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.

Read more

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

-
Image
Dynamics 365 Business Central (BC) vs. NetSuite and Other Competitors- Common Myths Debunked
A former colleague of mine was recently emailed a copy of the NetSuite partner monthly newsletter. The head article from NetSuite sales was regarding Business Central and it's upgrade versions, all taken from a personal blogger/system administrator. They were using this blog as facts as what was going on with Business Central. After digging on the World Wide Web a little deeper, I was able to find many sites and documentation from NetSuite on what appeared to be "facts" about Business Central (BC). I also found similar articles from other competitors: Acumatica and Intaact.Here are some of the common myths I am seeing published online:
Business Central is siloedBusiness Central doesn't have automated upgrades and users are all on different versionsBusiness Central is not a robust ERPBusiness Central is newBusiness Central doesn't have a lot of customersBusiness Central does…
Read more

Dynamics BC Top 10 Favorite Things #4-Viewing any Business Central Table in the Browser

-
Image
Microsoft Dynamics 365 Business Central   My Top 10 Favorite Things #4- Viewing any Business Central Table in the Browser

For all of those interested in viewing your Business Central data kept in the table versus the interface, I have a cool trick for you! I had to use it today to review some issues we were having with sales tax posting.

I needed to review the table where the data was being stored, as we have been integrating into the tables and review it against what was being manually entered for differences.

It is a very easy process to do this.

1. Open up your BC Environment via URL.
2. Go to the page that you are needing to review.
3. Click on the Question Mark in the upper right corner.
4. Choose help and support
5. Click on inspect pages and data
6. Find the table number on the page inspection page
7. In your current browser URL, find the place where your company name ends and there is a '&' in the URL. Remove everything to the right of your company name in the URL st…
Read more