Who's On?

	Membership:
	Latest: Raju
	Past 24 Hours: 0
	Prev. 24 Hours: 1
	Overall: 5205

	People Online:
	Visitors: 212
	Members: 0
	Total: 212

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

Multiple w-2's

6 Replies

0 Subscribed to this topic

68 Subscribed to this forum

Sort:

Author

Messages

slm4

Basic Member

Posts: 13

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

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

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

Veteran Member

Posts: 330

1/16/2013 1:28 PM

The PR297 allows you to create a csv file format

slm4

Basic Member

Posts: 13

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

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

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