Report Request Page in Job Que Entries

Business Central/NAV General Discussions
1

I’m working in NAV 2015, I’ve set-up serveral reports to automatically run. They have all been set-up via “Job Que Entries”. How do I get the date field on this report to update automatically daily? We’ve tried several date options, but nothing seems to update it. Please advise. Thank You!

FOR EXAMPLE:
<CD+1D

2

You cannot do to automatically update it.
Or you should modify the report that will pick the workdate +1 day. for the date option.

3

So if I an unable to modify reports I would need to contact our Software Provider to made these updates?

4

Yes indeed. You are right. You must contact your software provider.

5

Lisa,

First contract your Partner to update the Job Queue for you. Seems like you want the report to always reflect Work Date or TODAY when running. They can accomplish with the Job Queue code for the specific report.

Hope this helps.
Thanks,
Steve

6

In NAV 2015, you can use the “CD+1D” expression to update the date field on your report automatically daily. However, it seems that you’ve mentioned that this expression is not updating the date field as expected.

To troubleshoot this issue, here are a few suggestions:

  1. Ensure the correct syntax: Double-check that the expression “<CD+1D” is written correctly without any typos. The expression should add 1 day to the current date.
  2. Verify job queue setup: Make sure that the job queue entry for running the report is configured correctly. Check the schedule and recurrence settings to ensure that it is set to run daily.
  3. Check system date and time: Confirm that the date and time settings on your NAV server are accurate. If the system date or time is incorrect, it could affect the execution of scheduled tasks.
  4. Consider data limitations: If the report relies on specific data filters or conditions, verify that the data exists for the updated date. For example, if the report is based on sales data, ensure that there are transactions for the specific date.
  5. Review report design: Examine the report layout and code to ensure that the date field is correctly bound to the expression “<CD+1D”. Verify that the field properties and data source are set up appropriately.

If the issue persists after trying these steps, it may be helpful to consult with a NAV developer or support resource who can examine your specific configuration and provide further assistance.

7

A developer could monkey around with the Parameter String on the job queue and customize the report to use the parameter string to build the date.