Finance | Project Operations, Human Resources, ...

Dynamic parameters on Inventory Value Report when run in a batch job

(1) Share

Report

Posted on by PG-16052038-0

I am trying to run the inventory value report as a batch job that runs every Wednesday. When it runs, I want the 'From date' and 'To date' to populate as the previous Sunday-Saturday week. For example, if it ran on 2/7/2024, I want it to run the report with data from 1/28-2/3.

There is this 'Date interval code' in the parameters on the batch task that allows you to select a code for 'Previous week'. In the example mentioned earlier, the issue I am experiencing is that the batch job runs on 2/14, and still runs the dates 1/28-2/3.

How do I get this to run correctly, such that every Wednesday when the batch job runs the report, it runs for the previous week, and not a static set of dates?

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Martin Dráb 239,451 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
I'm not familiar with this report, but as I'm looking at code, your approach should work (as long as the date interval is configured correctly).

Do you see expected dates if you open the date interval (General ledger >Ledger setup > Date intervals)?

Just for future reference (if debugging is needed), the initialization of dates is done InventValueReportInit.adjustFromAndToDateToDateInterval().

General ledger

Ledger setup

Date intervals

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,055 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

I think it should work with interval code what you have defined , it should pick the dates based on run date .

Did you try with Inventory value report storage option in cost management ?

Was this reply helpful? Yes No
PG-16052038-0 21 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

This is my date interval setup, though nothing looks out of place to me.

Was this reply helpful? Yes No
Martin Dráb 239,451 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

It indeed looks good to me.

To be sure: how do you determine for which dates it ran?

I suspect it'll need debugging to understand what's going on, if you can do it or you have someone who can.

Was this reply helpful? Yes No
PG-16052038-0 21 on at

Like (0)

Report
Copy link

Link copied!

When the batch job runs, it sends the report to my email, and I can see the from date and to date at the top of the report. Every time it has run it has displayed the same date range rather than updating each week.

Was this reply helpful? Yes No