Skip to main content

Hi,

I have the below parameter in my quick report

AND  t.tax_code = NVL('&;MC--L]STATUTORY_FEE.FEE_CODE', '%')

But it is not showing the relevant LOV dialog for the above parameter 

 


For some fields it’s working fine
Did I miss something here ? 🤔

@tharindukshan The quick report shows the LOV for the Entity that the column references. STATUTORY_FEE.FEE_CODE doesn't reference anything else as it is the basic data table itself. If you use e.g. INVOICE_ITEM.VAT_CODE as your Quick Report parameter (which references the desired STATUTORY_FEE.FEE_CODE) it should work!

 

PS: Having an NVL around the parameter kind of  contradicts defining the parameter as mandatory (yMC--L])!

Hi @Jonas Feigl 
Thank you so much. Yeah it works 😀

Would it be possible to put a filter to that view? Like filtering from the Company
Without the filter INVOICE_ITEM.VAT_CODE shows all the VAT codes for all the companies.

@tharin

I don’t think this is possible, sorry!

Thank you @Jonas Feigl  for the support ☺️

Terms & ConditionsCookie settings