Who's On?

	Membership:
	Latest: TomV
	Past 24 Hours: 1
	Prev. 24 Hours: 2
	Overall: 5186

	People Online:
	Visitors: 291
	Members: 0
	Total: 291

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

Crystal Report for PO23 Orphaned Items

Sort:

You are not authorized to post a reply.

Author

Messages

brupp

Veteran Member

Posts: 165

9/15/2016 10:18 AM

Hello - I have a Crystal Report for POINTERFAC with ORIGIN_CD=IC to catch those items that do not add to or create a PO due to having the wrong replenishment vendor (or whatever the reason). It works fine except for 6 items that I cannot find either in PO23 or on a PO100 error report. I just need them to go away & cannot figure out the required action in Lawson. Any ideas? Thanks.

JonA

Veteran Member

Posts: 1162

9/15/2016 12:10 PM

Are you saying that without any filters used these items do not appear in PO23 but they show in your Crystal report?

brupp

Veteran Member

Posts: 165

9/15/2016 2:18 PM

That is correct. I've tried with no filters, or filtered by ship to location without Origin = IC. Just can't seem to locate the reason these are hitting my report.

JonA

Veteran Member

Posts: 1162

9/15/2016 7:14 PM

That is strange. Maybe some corrupted data? Can you trace the records to a single document number. When IC140 runs it assigns a sequential document number to the batch.

brupp

Veteran Member

Posts: 165

9/15/2016 8:28 PM

No I can't get to a document number but I ran POINTERFAC wide open just to try to spot something weird & sure enough - all 6 items have a six digit LINE_NBR. Would there be a paint screen to delete those, do you know?

JonA

Veteran Member

Posts: 1162

9/16/2016 11:37 AM

You should open a case with Infor. There may be more tables that should be corrected than just POINTERFAC.

brupp

Veteran Member

Posts: 165

9/16/2016 7:00 PM

OK will do, thanks for your help!

You are not authorized to post a reply.