Who's On?

	Membership:
	Latest: DaptonConsultancyServices
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5206

	People Online:
	Visitors: 257
	Members: 0
	Total: 257

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

Unique Identifer from GLTRANSREL to GLTRANS

4 Replies

0 Subscribed to this topic

44 Subscribed to this forum

Sort:

Author

Messages

Sam Mathew

New Member

Posts: 4

New Poster

7/26/2019 2:25 PM

Hi Everyone, I am trying to uniquely pin point transactions from GLTRANSREL table to GLTRANS , how can we achieve this?
is there a column where you can add a unique identifier which gets populated in GLTRANS once journals are posted?

Thanks
Sam

John Henley

Posts: 3363

New Poster

Engaged Reader

Avid Reader

7/26/2019 2:47 PM

You’re really limited to using a custom system code,source code, and the 10-char reference field which you’ll probably want to code as a unique sequence number. Also don’t rely on fiscal year and period as part of your uniqueness since a user can move a transaction between periods

JimY

Veteran Member

Posts: 510

7/26/2019 2:49 PM

What are you trying to accomplish? Not sure that you want to add a field to the table. You might try populating the REFERENCE field.

Sam Mathew

New Member

Posts: 4

New Poster

7/26/2019 5:15 PM

Excellent, i was able to do the same populate a alphanumeric string in reference field in GLTRANSREL and it showed up in GLTRANS table and we are able to match the transactions.

Thanks you very much for the info.
Have a great weekend!

Thanks,
Sam

Sam Mathew

New Member

Posts: 4

New Poster

7/26/2019 5:16 PM

Thank you JimY- Reference field was the way to go! appreciate the help!