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


Send Message:

--
03/01/2010 9: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 Dirst
    Advanced Member
    (67 points)
    Advanced Member
    Posts:25


    Send Message:

    --
    03/02/2010 7: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 Jones
    Private
    Private
    Veteran Member
    (1194 points)
    Veteran Member
    Posts:442


    Send Message:

    --
    03/03/2010 7: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 Henley
    Private
    Private
    Senior Member
    (8864 points)
    Senior Member
    Posts:2972


    Send Message:

    --
    03/03/2010 8: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
    stephanie
    Private
    Private
    Veteran Member
    (868 points)
    Veteran Member
    Posts:310


    Send Message:

    --
    03/03/2010 8: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'Toole
    Private
    Private
    Veteran Member
    (709 points)
    Veteran Member
    Posts:279


    Send Message:

    --
    03/03/2010 9: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!
    ichiben
    Private
    Private
    Advanced Member
    (59 points)
    Advanced Member
    Posts:21


    Send Message:

    --
    03/24/2010 12:44 PM
    We would certainly be interested.
    Shane Jones
    Private
    Private
    Veteran Member
    (1194 points)
    Veteran Member
    Posts:442


    Send Message:

    --
    06/12/2010 5: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...
    Lorena
    Private
    Private
    Advanced Member
    (85 points)
    Advanced Member
    Posts:37


    Send Message:

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


    Send Message:

    --
    06/22/2011 9: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 Jones
    Private
    Private
    Veteran Member
    (1194 points)
    Veteran Member
    Posts:442


    Send Message:

    --
    07/01/2011 4: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.