Who's On?

	Membership:
	Latest: Naina
	Past 24 Hours: 0
	Prev. 24 Hours: 1
	Overall: 5310

	People Online:
	Visitors: 234
	Members: 0
	Total: 234

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3290
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244

Links

2 Replies

0 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

A_R_Consltnt

New Member

Posts: 2

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: 3359

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

A_R_Consltnt

New Member

Posts: 2

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.