Kinetic Dynamic dates don't work in Criteria reports

Kinetic ERP
, ,
1

When scheduling a report using the Kinetic version and attempting to use dynamic dates, specifically Last or Next or any of those, the system completely ignores my selection and uses whatever date I had ran last with the form. If I haven’t picked one it just runs it as today. Support just gaslights me telling my it’s working fine and it’s my problem. Can any one confirm if this issue exists for you?

I setup a simple baq with data parameters and it works no problem in classic, but in Kinetic I get this behavior.

In scheduled reports, this is what is created in the SystemAgentTaskParam under Paramater UserCriteria.

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<UICriteria>
  <RptCriteriaSet>
    <Company>12345</Company>
    <RptDefID>sample</RptDefID>
    <RptCriteriaSetID>default</RptCriteriaSetID>
    <Description>default</Description>
  </RptCriteriaSet>
  <RptCriteriaPrompt>
    <PromptID>1</PromptID>
    <PromptValue>2025-05-08T00:00:00</PromptValue>
    <IsToken>false</IsToken>
    <PromptName>EndDate</PromptName>
    <DataType>datetime</DataType>
    <Label>EndDate</Label>
  </RptCriteriaPrompt>
  <RptCriteriaPrompt>
    <PromptID>2</PromptID>
    <PromptValue>2025-05-08T00:00:00</PromptValue>
    <IsToken>false</IsToken>
    <PromptName>StartDate</PromptName>
    <DataType>datetime</DataType>
    <Label>StartDate</Label>
  </RptCriteriaPrompt>
</UICriteria>

The baq is very simple.

select 
	[JobHead].[JobNum] as [JobHead_JobNum],
	[JobHead].[ClosedDate] as [JobHead_ClosedDate]
from Erp.JobHead as JobHead
where (JobHead.ClosedDate >= @StartDate  and JobHead.ClosedDate <= @EndDate)

I’m using a Report Data Definition with a parameter set and using the Report Style to create the report. I tried setting the Date to Datetime and to date, both with the same result. It also works the other way around where if I schedule the report to run for the last year by selecting the actual dates, it runs fine and shows me the last year, but then when I switch it to dynamic dates and say last Monday to last Friday, it will still show me the last year.

2

Have reported it multiple times, just reported it again last week. Please open your own case on this. I think not enough people are using the kinetic report screens so Epicor doesn’t realize how broken they are no matter how many cases I log. This is one of many issues that makes the kinetic versions unusable which is simply unacceptable with the classic sunset less than a year away.

1 Like
3

I wonder if support don’t know the difference between a Dynamic Criteria report and a BAQ report

1 Like