Who's On?

	Membership:
	Latest: Hitman
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5208

	People Online:
	Visitors: 384
	Members: 0
	Total: 384

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

Drill from GL to AP detail

1 Replies

0 Subscribed to this topic

12 Subscribed to this forum

Sort:

Author

Messages

Eddie Smith

Advanced Member

Posts: 39

8/18/2010 8:49 PM

I know per Lawson KB articel 556138, that if the system code and the source code are AP, then drill back is not available (we are seeing that on GL90.1 drill around); however, we are trying to create a portal page with DME queries that start from APPAYMENT but cannot seem to get back to APDISTRIB. Has anyone been able to do this using DS? We are able to get back to APINVOICE and get the first distribution record associated with the payment using related tables, but how can we get all?

John Henley

Posts: 3353

8/18/2010 9:18 PM

You can't. First of all, it's a multi-level join, which DME can't do. And (theoretically and often practically) it's a many-to-many-to-many join. =