How can i use "Input User Parameter" in Electronic Reporting in D365?

(0) Share

Report

Posted on by Zahra Mirzazadeh

156

Hi All,

I want to add the user input parameter in my desired Report.

I created an Input user Parameter, but this parameter doesn't appear in my report.

How can I use "Input User Parameter" in Electronic Reporting in D365?

Anyone can help me and send me an example or guidance?

Best Regards,

Zahra

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Zahra,

Can you provide some additional information about this parameter?

What are users supposed to enter?

What kind of business process do you want to incorporate?

Best regards,

Ludwig

Was this reply helpful? Yes No
Zahra Mirzazadeh 156 on at

Like (0)

Report

Hi Ludwig,

Thanks for your replying,

I need a report Based on TaxTrans table, as I know Taxtrans table has relation with VendInvoiceJour:

Taxtrans.Voucher=VendInvoiceJour.LedgerVoucher and Taxtrans.transDate=VendInvoiceJour.InvoiceDate

1-I created a TableRecord and I select "Ask for query":

2- in relationTab i got to my another field for my Report Result:

3- I derived from my model and biding my fields.

4- I selected "Run" it shows all of the fields in "TaxTrans" table that in step 1 I had done as my parameters("Ask for query").

5- now user wants another field that I should add to my parameters . It is "invoiceaccount" ,this field does not exist in "TaxTransTable" but it exists in "VendInvoiceJour" table.

I stuck in this issue, I don't know what should I do for adding "invoiceaccount" as my input user parameter?

I appreciate you for helping me.

Best regards,

Zahra

Zahra

Was this reply helpful? Yes No
Zahra Mirzazadeh 156 on at

Like (0)

Report

Good afternoon,

I Should add some additional information:

1- In my Desired Data model I grouped by base on taxtrans table and bound this group by to "Payment".

2- Before running the Report, all of the fields of taxtrans table appeared, I wanna add One Parameter to my previous parameter which exists in "vendorInvoiceJour" table.

Would you give me guidance?

Best Regards,

Zahra

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi Zahra,

About the additional filter criteria that you are look for:

When you open the filter form you can add additional linkages to related tables.

Simply click the joins tab and then select the related table and press the upper 'add table join' button, not the lower 'ok' button.

If you have done this navigate to the range tab, select the additional table and field and apply your filter.

Best regards,

Ludwig

Was this reply helpful? Yes No
Zahra Mirzazadeh 156 on at

Like (0)

Report

Hello Ludwig,

Thank you very much the way you mentioned about that, it works well :)

I appreciate your guidance.

Kind Regards

Zahra

Was this reply helpful? Yes No