I've not found a one-report solution to this dilemma, so I figured I'd put this out to other Crystal users...here goes:
I often get requests to build a Crystal report which displays all PO lines for a supplier for a given date range. A simple POLINE/PURCHORDER query gets the foundation of the report built, however, if a user wants the ACCT_UNIT and ACCOUNT for each POLINE, I have to use the MMDIST table to get those fields. MMDIST works super when reporting on Types X, S, or N items, however, once MMDIST is added, I lose all of the Type I PO lines in the report (even if I use a left outer join link from POLINE to MMDIST).
My simple solution is to build a spearate query to capture Type I lines (without the MMDIST table, of course), but I sure would like to know if there's a way to have ALL Types of PO Lines on a single query (i.e., not using a subreport) where Type I lines would display (with no MMDIST data), but all other types of items would display with ACCT_UNIT and ACCOUNT data from MMDIST.
As an aside, my guess is that MMDIST is not applicable for Type I lines since those are for perpetual inventories (i.e., no "distribution", per se).
We're on version 9.0.1.8 and below are the MMDIST to POLINE file relations I use per Lawson's Data File Text:
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
Thanks!
