Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

ICTRANS Location w-Name

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
brupp
Veteran Member Send Private Message
Posts: 165
Veteran Member
6/15/2016 4:14 PM
Hello - I have a Crystal Report with ICTRANS.FROM_TO_LOC & I need to add the name of the location to the report. Sometimes this is a par location & sometimes it is a requesting location. It is working with our par locations that have IC81 headers using ICLOCATION, but I'm losing the requesting locations since those are in RQ01/REQLOC. Any suggestions? My knee jerk reaction is to add our req locs to IC81 as a header only but I believe these will create ghost IC02's which may cause an entirely different headache if requesters try to use req locs as ship to locs on their reqs & PO's. And I hate the idea of going against normal practice in Lawson just to make a report work. Any help would be appreciated. I've been working on this on & off for a very long time :) Thanks.
JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member
6/16/2016 2:30 PM
The names for all of your Requesting Locations, including the Par Locations, are in the RQLOC table. Link ICTRANS.FROM_TO_LOC to RQLOC.REQ_LOCATION.
Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
brupp
Veteran Member Send Private Message
Posts: 165
Veteran Member
6/17/2016 12:17 PM
Thank you so much! As usual I was overthinking it Hope you don't mind another question - In another post I asked about joining MMDIST & GLNAMES to have descriptions for cost centers. I get the right number of records but descriptions only appear for 1 company. Any suggestions? The post is in this forum from 5/6/2016 if you'd prefer to reply there.