W2 Fields and Table...
Last Post 07/01/2011 03:54 PM by Shane Jones. 10 Replies.
Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Shane JonesUser is Offline
Private
Private
Veteran Member
(1185 points)
Veteran Member
Posts:439
Shane Jones

Send Message:Send Private Message

--
03/01/2010 08:30 PM
    Anyone know if there are fields in a table for each of the fields that are displayed on the W-2???? I was hoping that I might be able to build something to create an online W-2 for associates.

    (I know that MHC has an add-on to display W2 pdfs but I would rather not add-on their solution if I could just create a page to pull the fields.)
    Shane Jones
    Tools: HR, Payroll, Benefits, PFI, Smart Office, BSI, Portal and Self-Service
    Systems: Lawson, Open Hire, Kronos, Crystal Reporting, SumTotal Learning
    ** Teach others to fish...
    Chad DirstUser is Offline
    Private
    Private
    Advanced Member
    (67 points)
    Advanced Member
    Posts:25
    Chad Dirst

    Send Message:Send Private Message

    --
    03/02/2010 06:57 AM
    The wage and deduction fields are stored in the QUARTWAGE and QUARTDED files and would need to be summarized. Another option would be to use the output of the PR297 program as the input to the online W-2 forms.
    Shane JonesUser is Offline
    Private
    Private
    Veteran Member
    (1185 points)
    Veteran Member
    Posts:439
    Shane Jones

    Send Message:Send Private Message

    --
    03/03/2010 06:12 AM
    Thanks....
    However, QUARTWAGE and QUARTDED are the quarterly amounts and not all of the fields that display on a W-2. I guess I was hoping that there was a table that held each of the W-2 fields - as individual fields... nothing I would need to total, combine or interpret before displaying on a page.

    I just get frustrated around this time of year because Lawson does not have their own solution for providing W-2's through ESS. I think I pay enough for Lawson and don't want to buy another solution to provide online W-2's. It is just displaying data - should not be that difficult to provide...

    Shane
    Shane Jones
    Tools: HR, Payroll, Benefits, PFI, Smart Office, BSI, Portal and Self-Service
    Systems: Lawson, Open Hire, Kronos, Crystal Reporting, SumTotal Learning
    ** Teach others to fish...
    John HenleyUser is Offline
    Private
    Private
    Senior Member
    (8747 points)
    Senior Member
    Posts:2933
    John Henley

    Send Message:Send Private Message

    --
    03/03/2010 07:23 AM
    Is this an add-on to ESS that others would be interested in? If so, I can probably develop it and post it in the store. =

    Thanks for using the LawsonGuru.com forums!

    John
    stephanieUser is Offline
    Private
    Private
    Veteran Member
    (844 points)
    Veteran Member
    Posts:302
    stephanie

    Send Message:Send Private Message

    --
    03/03/2010 07:38 AM
    We've just recently done the same in house - quite a challenge! Clients have been asking Lawson for this functionality for years, and just recently, I received this response from Lawson regarding at least one ER - "The status of Lawson Enhancement Request Number 14832 has been updated.
    NEW STATUS: Not Being Considered
    The reviewer has determined that this is not in future Lawson Development Plans and if the ER is to continue, must be modified and re-submitted.
    Brief Description:
    I would like to request that W2's be offered through emss just as pay checks are issued through emss. Along with the last years W2's should be a history option to view previous years W2's.
    Reviewers Comments:
    Our strategy has been to partner with other organizations to support electronic W-2 functionality. There are broad considerations around the creation and storage of, as well as electronic access to, W-2 forms and information. This is not something we are planning to build into Lawson products at this time, but will continue to pursue improved and expanded partnerships to support this type of Payroll specific functionality."


    John - if you were to develop it and post it in the store, I think you may find it's a gold mine!!
    Joe O'TooleUser is Offline
    Private
    Private
    Veteran Member
    (689 points)
    Veteran Member
    Posts:271
    Joe O'Toole

    Send Message:Send Private Message

    --
    03/03/2010 08:44 AM
    I'm not surprised that Lawson is not creating their own W2 solution since they are closely partnered with MHC. We did not consider creating our own due to the effort / expense required and ended up buying the MHC W2 solution which is "supported", relatively reasonable and works well. Keep in mind there is more functionality to this that you may need other than rendering the fields. I'm fairly certain that state or Federal Legislation requires that the user "consent" to electronic delivery and this data needs to be stored for audit purposes - unless you print the W2 anyway which defeats the purpose of electronic delivery. Packaged solutions also offer access to multiple years of W2's and allow you to print the PDF for your tax preparer. As with all in house developed solutions, supporting it when breaks from an upgrade or the IRS changes required fields on form W2 needs to be kept in mind. Good Luck!
    ichibenUser is Offline
    Private
    Private
    Advanced Member
    (59 points)
    Advanced Member
    Posts:21
    ichiben

    Send Message:Send Private Message

    --
    03/24/2010 11:44 AM
    We would certainly be interested.
    Shane JonesUser is Offline
    Private
    Private
    Veteran Member
    (1185 points)
    Veteran Member
    Posts:439
    Shane Jones

    Send Message:Send Private Message

    --
    06/12/2010 04:36 PM
    I have a solution for providing W2's online. This required no additional software purchases and seems to be a low maintenance option.

    It works for us because:

    1. We have individual W2 documents in PDF format for each associate.
    2. We use active directory user accounts for logging into Lawson ESS/MSS. (The solution could also email documents - but we are not going to email...)
    3. We have Process Flow Integrator and ESS/MSS.
    4. We are planning to mail W2's and provide them online next year ... (We might change our decision and provide online only but that will probably not be considered for a while.)

    If you have each of these and want to deliver W2's online let me know.

    Shane Jones
    Tools: HR, Payroll, Benefits, PFI, Smart Office, BSI, Portal and Self-Service
    Systems: Lawson, Open Hire, Kronos, Crystal Reporting, SumTotal Learning
    ** Teach others to fish...
    LorenaUser is Offline
    Private
    Private
    Advanced Member
    (84 points)
    Advanced Member
    Posts:36
    Lorena

    Send Message:Send Private Message

    --
    06/22/2011 12:16 PM
    Hi Shane,
    We want to deliver W2's online and we have everything that you said. How did you implemented it?
    Shane JonesUser is Offline
    Private
    Private
    Veteran Member
    (1185 points)
    Veteran Member
    Posts:439
    Shane Jones

    Send Message:Send Private Message

    --
    06/22/2011 08:07 PM
    Lorena,
    Email me and we can review what you are trying to accomplish. shanesmj@yahoo.com

    Thanks
    Shane
    Shane Jones
    Tools: HR, Payroll, Benefits, PFI, Smart Office, BSI, Portal and Self-Service
    Systems: Lawson, Open Hire, Kronos, Crystal Reporting, SumTotal Learning
    ** Teach others to fish...
    Shane JonesUser is Offline
    Private
    Private
    Veteran Member
    (1185 points)
    Veteran Member
    Posts:439
    Shane Jones

    Send Message:Send Private Message

    --
    07/01/2011 03:54 PM
    I have had a couple questions for this:

    A portal bookmark can use variables for example:
    http:// server.domain.com / foldershare / <<EMPLOYEE>>/W2index<<EMPLOYEE>>.html
    (Using this bookmark opens a shared folder where each associate has a secure folder with their W-2 files.)

    Other bookmark variables that might be interesting:

    <COMPANY>
    <CUSTOMER>
    <EMAIL>
    <FIRSTNAME>
    <LOGIN>
    <PRODLINE>
    <PRODUCTLINE>
    <TYPE>
    <USERNAME>
    <VENDOR>
    <VENDORGROUP>
    <VENDORLOC>
    <VIEWCONTRACTS>
    <WEBUSER>
    MANY OTHERES ARE AVAILABLE.... Just use << before and >> after
    Shane Jones
    Tools: HR, Payroll, Benefits, PFI, Smart Office, BSI, Portal and Self-Service
    Systems: Lawson, Open Hire, Kronos, Crystal Reporting, SumTotal Learning
    ** Teach others to fish...
    You are not authorized to post a reply.