Cannot drop down in filter no of Purchase - Quote Report

johanna

Dear All,

When I run Purchase - Quote Report in RTC, why I could not drop down the No. filter?
What should I do to make drop down available when filter No. in Purchase - Quote Report?
Please help.. Thank you..

kine

Because this table have complex primary key, the lookup is not working, because each "document type" could need different lookup form/page.

johanna

Thanks Kine..
Is there a way to make drop drown available for filter No. in Purchase - Quote report ?
Thank you..

mohana_cse06

You can try by adding the table relation to No field in Sales Headder table

"Sales Header".No. WHERE (Document Type=FIELD(Document Type),No.=FIELD(No.))

But I dont know the side effects of this..

johanna

Thanks mohana_cse06,
I think that is not applicable. If we use table relation, we must lookup No. that is already exist only..

mohana_cse06

johanna wrote:

Thanks mohana_cse06,
I think that is not applicable. If we use table relation, we must lookup No. that is already exist only..

I didnt get your reply..

did you try that?

johanna

Oh, I mean that I cannot use table relation for primary key No. of Purchase Header or Sales Header because if I use that, I cannot fill No. with new No. and I only can lookup to No. that is already exist..

mohana_cse06

for testing purpose I Added table relation in Sales header and I can create new No.'s..

vijay_g

Then you have only one option that is put all filter fields in Request option page.

johanna

Oh, sorry Mohana, I test it with run table and insert record then it's failed.. :">
In the form, i test it sucessfully.. but in the form, dropdown button for No. is strange
btw, thanks ^^

mohana_cse06

johanna wrote:

Oh, sorry Mohana, I test it with run table and insert record then it's failed.. :">
In the form, i test it sucessfully.. but in the form, dropdown button for No. is strange
btw, thanks ^^

Welcome