Hi all
I was working with a report which shows all the invoices for a particular supplier. There was a requirement to show only the validated invoices and remove cancelled invoices from thereport and accordingly i added one condition " cancelled_flag <>'Y'. so that it retrieves data where cancelled flag is not 'Y'.
Now in the apps environment, there is a parmaeter to show only the cancelled invoices. When it is checked YES then no data is coming in the output. How can i handle this problem with respect to the parameter. Can i use two queries in the data model that gets selected based on parameter in apps environment.
please help
thank u
I was working with a report which shows all the invoices for a particular supplier. There was a requirement to show only the validated invoices and remove cancelled invoices from thereport and accordingly i added one condition " cancelled_flag <>'Y'. so that it retrieves data where cancelled flag is not 'Y'.
Now in the apps environment, there is a parmaeter to show only the cancelled invoices. When it is checked YES then no data is coming in the output. How can i handle this problem with respect to the parameter. Can i use two queries in the data model that gets selected based on parameter in apps environment.
please help
thank u
Comment