Prev
Next
Forums Financial Management Lawson S3 Financials

Replicate MA236 form in Crystal

 1 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
imty
Advanced Member
Posts: 35
Advanced Member
11/27/2012 2:20 PM
    Hello All,

    I am trying to replicate the MA236 form "PO received but not invoiced" using Crystal since we need an additional field (invoice date) to be added to the report and is currently not included in the report Lawson produces. I have identified the tables that I would need to create the report but I am not sure how to link them properly. I have identified the following tables:

    APVENMAST
    APINVOICE
    POLINE
    MMDIST

    I like to know what the proper relationship is between these tables and how can they be linked in the most efficient manner. What I perceive to be the problem is when I join the MMDIST table to the POLINE table and query, the report does not run efficiently. There seems to be a disconnect here.

    Any idea on how to make this relationship work properly is much appreciated.

    Thank you.

    Imtiaz.
    Ruma Malhotra
    Veteran Member
    Posts: 412
    Veteran Member
    11/27/2012 6:48 PM
      The MMDIST to POLINE can have a one to one relationship. Here are the links:, where MMD stands for MMDIST

      Poline POLINE Required
      When MMD-SYSTEM-CD = "PO"
      And MMD-DOC-TYPE = "PT"

      MMD-COMPANY -> PLI-COMPANY
      MMD-DOC-NUMBER -> PLI-PO-NUMBER
      MMD-DOC-NBR-NUM -> PLI-PO-RELEASE
      MMD-PO-CODE -> PLI-PO-CODE
      MMD-LINE-NBR -> PLI-LINE-NBR