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

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

Popular posts from this blog

Formatting Phone Numbers in SQL Reporting Services

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

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