Who's On?

	Membership:
	Latest: Pat
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5296

	People Online:
	Visitors: 500
	Members: 0
	Total: 500

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

Criteria used for Lawson reports

5 Replies

0 Subscribed to this topic

14 Subscribed to this forum

Sort:

Author

Messages

Basic Member

Posts: 8

2/5/2009 12:55 PM

Is it possible to determine the criteria used behind a particular Lawson report? More specifically, the AP221 Potential Duplicate Payments report. What is criteria is used to determine whether or not an invoices gets flagged as a potential duplicate?

Please forgive me if I posted this in the wrong section.

k-rock

Veteran Member

Posts: 142

2/5/2009 5:54 PM

You can find the logic in the Lawson Documentation. Search for the form number in the docs.

Chris Martin

Veteran Member

Posts: 277

2/5/2009 10:04 PM

PZ,

k-rock is referring to the Technical Text (broken out by system code). However, if you are looking to reverse engineer the AP221 program, you will have to look (and be able to make sense of) the COBOL code.

Chris

Basic Member

Posts: 8

2/6/2009 6:01 PM

Thank you both for the feedback. I'm not looking to reverse engineer the report, just trying to figure out how it pulls the duplicates. Can you give me a little more direction as to where I can find the documentation/technical text. Can this be access directly from the portal or is it online somewhere? I've just started using this system so I'm not familiar with the navigation yet. Our IT department provided me with a few data dictionaires in PDF format but I didn't receive any hits when searching for AP221.

Thanks again.

k-rock

Veteran Member

Posts: 142

2/6/2009 6:51 PM

technical text is accessed from support.lawson.com or the ERD section of this site.

John Henley

Posts: 3355

2/6/2009 9:17 PM

In the case of AP221, the technical text is, uh, lacking. You'd have to look at the COBOL itself. The way it detects duplicates is by looking at the company, vendor, invoice amount, and the fields you select on the 'Sort' tab. In other words, anything besides invoice number that makes it look like it might be a duplicate.