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

Links

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
A_R_Consltnt
New Member Send Private Message
Posts: 2
New Member
12/3/2008 9:19 PM
Hello,

Can someone please help as to what is the best way to link the GLTrans and FBDetail table to get resonable and correct rows? The purpose is to create a report in crystal with budget and actual numbers. Thanks in advance.

A.
John Henley
Send Private Message
Posts: 3351
12/3/2008 9:24 PM
See this post: https://www.lawsonguru.co...ft/3198/Default.aspx

Save yourself some time/$$:
https://www.lawsonguru.co...ry=854095&id=3524447
Thanks for using the LawsonGuru.com forums!
John
A_R_Consltnt
New Member Send Private Message
Posts: 2
New Member
1/12/2009 5:54 PM
Hi again,

My enviornment requires me to limit queries and I have to use links to link the
FBDETAIL table and GLTRANS table. The links mentioned on our site have not been
able to get the results without giving
duplicate records. I have tried/tested several ways to link these two tables individually as well as
with other tables to remove duplicates but am unable to do so. There must be a way
where you can have the results shown without duplicates; for ex: for a particular
company the budget is shown (FBDETAIL table) and the incurred Tran_Amt (GLTRANS table)
is shown. Please provide info. Thanks in advance.