Who's On?

	Membership:
	Latest: Zac Shields
	Past 24 Hours: 1
	Prev. 24 Hours: 1
	Overall: 5210

	People Online:
	Visitors: 216
	Members: 0
	Total: 216

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

Finding PO line related to a GLTRANS record

2 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

cricketeer1

New Member

Posts: 2

9/7/2006 1:38 PM

GLTRANS.OBJ_ID value of 1619218 shows transaction amount of $3,658.81. GLTRANS.R_SYSTEM is 'PO' so we should be able to find the details of this GLTRANS record in MMDIST. Linking to MMDIST with query

SELECT *
FROM GLTRANS inner join mmdist on gltrans.obj_id = mmdist.rni_obj_id
WHERE gltrans.obj_id=1619218

shows 4 records totalling $3,109.81. 1 MMDIST record is omitted. We can find it in MMDIST because we were told by the client is it PO 69546. For that record, the value of MMDIST.RNI_OBJ_ID = 1744634 and MMDIST.GLT.OBJ.ID = 0. So we can't find a way to link to that from GLTRANS.

Question is how to find the details of this record when all we know about it is that it's associated with GLTRANS.OBJ_ID=1619218. We cannot select from MMDIST by POSTED_DATE because this record shows a POSTED_DATE out of the range of the month of the GLTRANS record it is associated with.

John Henley

Posts: 3353

9/7/2006 2:22 PM

On the "missing" MMDIST record, what is the SYSTEM_CD, DOC_TYPE, POSTING_TYPE, and STATUS?

What does the GLTRANS record look like for OBJ_ID = 1744634 ?

John Henley

Posts: 3353

9/7/2006 4:46 PM

The MMDIST record has SYSTEM_CD='PO', DOC_TYPE='PT', POSTING_TYPE='A', R_STATUS=2.

Based on these values from MMDIST, this is an AOC record. My understanding is that these don't get posted to GL when received; they are posted/expensed when invoiced.

As for why the other MMDIST records (you should only be looking at mmd.status = 1) don’t equal GLTRANS, that may be a bug--look for CTPs for PO135...