• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Financial Management Lawson S3 Financials

Activity Commitment Detail Report link to PO Line Detail

 1 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Carl Gifford
Basic Member Send Private Message
Posts: 11
Basic Member
8/24/2010 3:02 AM
I am trying to write an AC Committment Detail report in Crystal (using SQL) and would like to be able to reference the specific PO Line (POLINE) record. Is this possible.

I am using the ACCOMMITX table and can find the PO from this table, but I cannot seem to find a link to the specific PO Line. Is this possible?

Thanks,
Tags: Commitments
Eddie Smith
Advanced Member Send Private Message
Posts: 39
Advanced Member
8/24/2010 11:04 AM
To get the PO information you will need to join the MMDIST table to your query. Below is a query we use to get both RQ and PO information on our activities.

select T1.ACTIVITY
,T2.DOC_NBR_NUM
,T3.NAME
,T2.LINE_NBR
,T2.DOC_NUMBER
,T1.TRAN_AMOUNT
,T1.SYSTEM
,T1.PERIOD
,T1.FISCAL_YEAR
from LAWPROD901.dbo.MMDIST T2
,LAWPROD901.dbo.ACCOMMITX T1
,LAWPROD901.dbo.GLSYSTEM T3
where T2.COMPANY=T1.COMPANY
and T2.ACCT_UNIT=T1.ACCT_UNIT
and T2.ACTIVITY=T1.ACTIVITY
and T2.ACCT_CATEGORY=T1.ACCT_CATEGORY
and T2.ATN_OBJ_ID=T1.ATN_OBJ_ID
and T3.COMPANY=T2.COMPANY
and T1.COMPANY=115
and rtrim(T1.ACTIVITY_GRP)='CAPPROJ'
order by 1 asc, 2 asc, 5 asc
Tags: Commitments