PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 05/09/2016 10:47 AM by  brupp
Table Joins - MMDIST & GL
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
brupp
Mgr Supply Chain Systems
UC Health
Veteran Member
(333 points)
Veteran Member
Posts:143


Send Message:

--
05/06/2016 11:43 AM
    Hello - I am trying to build a Crystal Report for Inventory transactions - I have everything in place except for descriptions for AU's. I have GLMASTER, GLNAMES & GLCHARTDTL available. I'm only getting results for one of our companies. I've played with the joins but no success. Perhaps I'm missing a parameter - any suggestions?
    Randy
    Systems Administrator
    Rochester Regional Health
    Veteran Member
    (101 points)
    Veteran Member
    Posts:37


    Send Message:

    --
    05/09/2016 7:18 AM

    Join MMDIST -> GLNAMES

    MMD-COMPANY -> GLN-COMPANY
    MMD-ACCT-UNIT -> GLN-ACCT-UNIT

    Join dbo.GLNAMES on MMDIST.COMPANY = GLNAMES.COMPANY and MMDIST.ACCT_UNIT = GLNAMES.ACCT_UNIT
    brupp
    Mgr Supply Chain Systems
    UC Health
    Veteran Member
    (333 points)
    Veteran Member
    Posts:143


    Send Message:

    --
    05/09/2016 10:47 AM
    Hi Randy - Your info got me to the right number of records but I'm still getting descriptions returned for 1 company & not the others. Any ideas?
    You are not authorized to post a reply.