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

  1. 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. 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. 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
  4. Where the reels are marked to stop in order to to} match paylines are commonly referred to as “Reel Stops”. Lining up certain combinations of symbols in three, 4, 5 or extra reels, relying on the slot machine, provides the player a winline. Always hold this in thoughts, especially when you love playing in} slots with progressive jackpots. Many games provide you with entry to the top wins only whenever you wager the maximum — and that is why an accurate slot strategy and bankroll strategy are important to have an opportunity to successful at slots. All the measures in 슬롯커뮤니티 place are there to help you|that will help you|that can help you} play slot machine games on websites that use audited random number turbines and pay out winnings to their gamers. We a glance at|have a glance at} over 25 sorts if slot machines throughout the most effective PA on-line casino and NJ on-line casino websites and we found out that the payout share has very little to do with the games' reputation.

    ReplyDelete

Post a Comment

Popular posts from this blog

Formatting Phone Numbers in SQL Reporting Services

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

Dynamics 365 Business Central (BC) Growth is Insane!