How to have your vendors and customer self onboard in Business Central using Power Automate (Flow) and BC

on
0

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

on


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

  1. BestJune 13, 2021 at 12:24 AM

    I appreciate the time and effort us put into this post. This article gives you a clear idea about Audit. It is, without a doubt, an informative article that will help us expand our knowledge. Thank you for bringing such interesting posts to our attention.
    Fedex Audit

    ReplyDelete
  2. KMK & Associates LLPJuly 25, 2021 at 12:52 AM

    I'm blown away by the little print you've provided information about Outsourced Accounting Firms India . It is an enlightening article for both myself and others. Thank you for bringing such interesting topics to our attention.

    ReplyDelete
  3. Harry jackSeptember 5, 2021 at 3:54 AM

    A cruise deliver lacks the ballast of a sail boat. If used similarly to the principle engine(s) the kite will growth gasoline efficiency.Shipping from china

    ReplyDelete

Post a Comment