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 add OTBI report parameter to filter out those zero outstanding balance and date in range?

edited Jul 2, 2019 2:27AM in Reporting and Analytics for ERP 3 comments

Summary

Add report parameters to filter those zero outstanidng balance and date in range

Content

hi all,

I have two OTBI report parameters would like to add:

1) In the Subject Area = 'Payment Schedules" and there is a field "Entered Amount Due Remaining". How can I add a report parameter to filter those zero remaining so that the report only shows the record with outstanding? the concept should be something like > 0. But how to do it in OTBI.

2) Add a report parameter to submit in date range? like the accounting date between "01-Jan-2019 and "30-Jun-2019". How to do it?

Please share.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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