Share
ReportWhen we run the Revenue Recognition PA.REV.00 in a previous month for a specific job, several jobs show up on the report. For instance, if I ran the following:
GL Subaccount: 02
Project: 0213-0020
Fiscal Period: 06-2013
It returns 92 results with over 20 different projects and every GL Subaccount, not just 02. The report WHERE statement (at the top of the report under Transaction List By Batch) has ({PJtran.BATCH_ID} = '0000040051'). So it looks like this report is selecting everything with this batch number, which, when I look in the PJtran database, there are 35 distinct projects with that same batch ID.
The query:
SELECT [project]
,[batch_id]
,[fiscalno]
,[gl_subacct]
,trans_date
FROM [S4THEESCOGROUP].[dbo].[PJTran]
WHERE batch_id = '0000040051'
ORDER BY trans_date, project
Looks like what this report is returning when it should be:
SELECT [project]
,[batch_id]
,[fiscalno]
,[gl_subacct]
,trans_date
FROM [S4THEESCOGROUP].[dbo].[PJTran]
WHERE gl_subacct = '02' AND project = '02130020' AND fiscalno='201306'
ORDER BY trans_date, project
This report is a built-in report in Dynamics, it should just work without me having to create a custom report. If I need to, I can, but I would rather fix this issue that just work around it.
Thanks
*This post is locked for comments
All responses (
Answers (
291,711
