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
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
    Posts: 3353
    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
      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.