BC Workflow- No Approval, Rejection, Delegate comments in notification emails

Image
  According to Microsoft, there is no roadmap to add workflow approval, rejection and delegate comments to the BC out of the box email notifications. You can always add an extension, but this should be OOB.  I need the community to help vote this up!  Please go here and vote today:  https://experience.dynamics.com/ideas/idea/?ideaid=a2be05ef-3d3c-eb11-8fed-0003ff68d921

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

Business Central Versus NetSuite- Side by Side Comparison