Who's On?

	Membership:
	Latest: John Bonin
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5270

	People Online:
	Visitors: 196
	Members: 0
	Total: 196

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

GLTRANS attributes

1 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

Sherry Shimek

Advanced Member Send Private Message

Posts: 43

5/11/2015 6:11 PM

We have 3 source codes that post to the General Ledger with GLTRN object attribute values. One has one attribute; this is easy. The other two use the maximum three attributes. Is there a way to run a GLTRANS query with all three attributes without triplicating the records? (Using OTM set at 3 we can get all three attributes in the query but it provides the actual records once for each attribute. This results in triplicate data if the transaction had all three attributes for that system code.)

I have tried using the Category tables in the query, but haven't found a way to get all three mx values in the results.

I am working to get this information using ODBC queries but would prefer this in MS Addins that our users can duplicate.

Thanks,

Sherrill Shimek

CHI Connect Financial Systems

Catholic Health Initiatives

JonA

Veteran Member Send Private Message

Posts: 1163

5/15/2015 10:51 AM

I'm not very familiar with attributes but it's been my experience with Addins and ODBC queries that if Table1 is linked to Table2 via common fields and there are multiple record matches in Table2, the output will result in duplicate records out of Table1- one for every match in Table2. I've not found any way around this.