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

Incrimental logic for fetching the data in Custom report is not working as expected

edited Oct 31, 2024 5:29PM in Receivables & Collections

Summary:

Hi Team,

We have a custom BI report which fetches Customer Invoices related columns. The ESS job for this report is scheduled to run every 15 minutes. The report logic is such that it picks up only incremental Invoice records in each ESS job run.
Attaching the query for your reference to check the incremental logic.

It has come to our observation that one of the Invoice has not got picked up by the query and unable to understand why the data has not been retrieved.

Customer Invoices and ESS job details are as follows:

Invoice Number: XXXXXXXXXX

Last Update Date of Invoice: 2024-07-01T20:46:45.000+00:00

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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