Table Joins - MMDIST & GL

Sort:
You are not authorized to post a reply.
Author
Messages
brupp
Veteran Member
Posts: 165
Veteran Member
    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
    Veteran Member
    Posts: 50
    Veteran Member

      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
      Veteran Member
      Posts: 165
      Veteran Member
        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.