OTBI Report: Accrual Balance Based on Effective Date
Hello Experts,
We have a requirement to extract accrual balance details using an OTBI report based on an effective date parameter. This effective date should be compared with the balance calculation date.
For example:
- If the effective date is 01-Jan-2025, the report should display the accrual balance as of that date.
- If the effective date is 30-Apr-2025, the report should show the accrual balance as of 30-Apr-2025.
Has anyone come across a similar requirement? If yes, could you please share your inputs or approach?
Thanks in advance!
Regards,
1