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: 0
New Member
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: 3364
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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 ?
Thanks for using the LawsonGuru.com forums!
John
John Henley
Posts: 3364
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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...
Thanks for using the LawsonGuru.com forums!
John