What tables does MM280 pull from? Trying to match the data in a report.

Sort:
You are not authorized to post a reply.
Author
Messages
willz06jw
Basic Member
Posts: 24
Basic Member

    Hi and thanks for your help,

    I am trying to pull information from the Lawson database that will give me a departmental expense report exactly like MM280.  I am using Crystal reports to turn the information into a series of nice looking graphs.  I have to use the accounting-unit to group my data.

    Unfortunately, I cannot make my data pull equal what MM280 shows.  My management is not too pleased about this

    I am currently pulling using two tables: the POLINE table (using PURCHORDER.PODATE as the date) and using ({POLINE.QUANTITY}-{POLINE.CXL_QTY})*{POLINE.ENT_UNIT_CST} to add up the data.

    For the issues I use REQLINE table using this selection query:
    {REQLINE.KILL_QUANTITY} <> {REQLINE.QUANTITY} and
    {REQLINE.R_STATUS} = 9 and //to only pull the issues
    {REQLINE.CREATION_DATE} in lastfullmonth

    and this to add up the data:
    ({REQLINE.QUANTITY}-{REQLINE.KILL_QUANTITY})*{REQLINE.TRAN_UNIT_COST}

    Any idea why this would return the wrong information?

    Thanks,
    W

    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
      If it's not too late:

      MM280 - Departmental Procurement Expense Report

      Run this report to show general ledger postings broken down by accounting unit and accounts.

      Updated Files

      ADDRDATA - No Description Available.
      CKPOINT - No Description Available.
      GLTRANS - No Description Available.



      Referenced Files

      APCOMPANY - No Description Available.
      APDISTRIB - No Description Available.
      APINVOICE - No Description Available.
      APVENGROUP - No Description Available.
      APVENMAST - No Description Available.
      GLADDRESS - No Description Available.
      GLCGCPY - No Description Available.
      GLCHART - No Description Available.
      GLCHARTDTL - No Description Available.
      GLCPYGRP - No Description Available.
      GLNAMES - No Description Available.
      GLSYSTEM - No Description Available.
      ICCOMPANY - No Description Available.
      ICTRANS - No Description Available.
      INSTCTRYCD - No Description Available.
      ITEMMAST - No Description Available.
      MAAOCDTL - No Description Available.
      MACOMPANY - No Description Available.
      MAINVDTL - No Description Available.
      MMDIST - No Description Available.
      MXLISTMBR - No Description Available.
      POCOMPANY - No Description Available.
      POLINE - No Description Available.
      POLINESRC - No Description Available.
      PORECLINE - No Description Available.
      PORETURNHD - No Description Available.
      PORETURNLN - No Description Available.
      PROCUREGRP - No Description Available.
      REQLINE - No Description Available.
      RQLOC - No Description Available.
      SYSTEMCODE - No Description Available.
      John Crudele
      Veteran Member
      Posts: 50
      Veteran Member
        You are pulling your data from the purchase order tables. The amounts in the po tables may or may not be the actual amount.

        MMDIST and ICTRANS would have the actuals
        You are not authorized to post a reply.