Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to schedule a custom weekly GL report, which includes date parameter of "PostedDate-7"

Summary: Custom GL Report which needs to run at 12:05 AM weekly on Tues night and include data only from the previous week.

If PostedDate = Aug 6, the report should include data from July 30 to August 5

For the next week, PostedDate = Aug 13 and report should include data from August 6 to August 12.

Do we need to add Trigger to Data Model? If the parameter of PostedDate is set when the report is first scheduled, how would the parameter date be updated for the follwoing weeks?

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):


24B (11.13.24.04.0)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!