Finding PO line related to a GLTRANS record

Sort:
You are not authorized to post a reply.
Author
Messages
cricketeer1
New Member
Posts: 2
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
    Senior Member
    Posts: 3348
    Senior Member
      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
      Senior Member
      Posts: 3348
      Senior Member
        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
        You are not authorized to post a reply.