• Search Forums
    Advanced Search
Prev
Next
Forums Financial Management Lawson S3 Financials

Replicate MA236 form in Crystal

 1 Replies
 0 Subscribed to this topic
 44 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