• Search Forums
    Advanced Search
Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

Multiple w-2's

 6 Replies
 0 Subscribed to this topic
 69 Subscribed to this forum
Sort:
Author
Messages
slm4
Basic Member
Posts: 13
Basic Member
1/15/2013 9:25 PM
I am reading QUARTDED table, adding up wages to produce w-2's to send to third party.
I am doing a DB-BEG-RNG read using QTDSET1.  This does not work properly for people who should be getting multiple w-2's because they worked in multiple companys with different tax-ids.  How can I solve this problem?
Margie Gyurisin
Veteran Member
Posts: 538
Veteran Member
1/16/2013 12:56 PM
Have you considered running the PR297 and then sending the output from that program? 
slm4
Basic Member
Posts: 13
Basic Member
1/16/2013 1:19 PM
The vendor has to have it in their format.  I am new to Lawson, can you save the output of PR297 in a format that can be read and reformated? 

stephanie
New Member
Posts: 0
New Member
1/16/2013 1:28 PM
The PR297 allows you to create a csv file format
slm4
Basic Member
Posts: 13
Basic Member
1/16/2013 6:51 PM
I really need to add a sort of the quartded table to my program does anyone know how to do that?
Carolyn Lee
Veteran Member
Posts: 53
Veteran Member
1/17/2013 6:30 PM
Group by report_entity which will split out the data by company. But you will need more than quartded to recreate the w-2's. As Stephanie suggested the PR297 already creates a w2 csv in the print file, already split by company as long as you ran it for all.
Vijay S
Veteran Member
Posts: 174
Veteran Member
New Poster
New Poster
Congrats on posting!
1/21/2013 6:03 AM
Recently we worked on the same. We used PR297 output (csv) as i/p and formatted it according to the third Party requirement. The o/p of PR297 is in CSV format. You can write a 4 GL code to format the o/p of PR297. Just have a look on o/p PR297.

Thanks,
Vijay