Who's On?

	Membership:
	Latest: Saef
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5226

	People Online:
	Visitors: 408
	Members: 0
	Total: 408

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

GL Sub Account Validation

2 Replies

0 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

Jan

Veteran Member

Posts: 55

7/10/2009 2:15 PM

Does any one know of a small Lawson table that contains valid SUB-ACCT values?

I'm creating a Crystal Labor Utilization Report to be published into LBI. In my Crystal sql, I'm trying to find a smaller Lawson table where I can query for a list of valid Sub Accounts. I have to categorize these sub accounts using logic I'll include in the sql. I could query PRDISTRIB for a unique list DST-SUB-ACCTs but that table is very large.

muffntuf

Advanced Member

Posts: 41

7/10/2009 2:26 PM

Could you use a inner select query that will derive only the unique sub accounts within your sql? (Or move the whole thing to a view or sp depending on frequency of use).

Matthew Nye

Veteran Member

Posts: 514

7/10/2009 2:34 PM

The IF subsystem is what you want to use. Specifically you can pull this listing from GLCHARTDTL.