• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Table Joins - MMDIST & GL

 2 Replies
 1 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
brupp
Veteran Member
Posts: 165
Veteran Member
New Poster
New Poster
Congrats on posting!
5/6/2016 3:43 PM
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
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
5/9/2016 11: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
Veteran Member
Posts: 165
Veteran Member
New Poster
New Poster
Congrats on posting!
5/9/2016 2:47 PM
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?