Hi All,
As per customer requirement, we will send a dunning letter following Customer Order Nbr.
So, on the Dunning Letter AR661000, we want to add a filter that allows us to select multiple documents belonging to 1 Dunning Letter and print it.
Is it possible to add a parameter with the multiple-selected option? If yes, how can we do that?
Thank you,
Yên Chi
Best answer by BenjaminCrisman
This is not a viable solution with invoices due to obvious reason, but even still if a new project manager is added then the attribute would need to be updated to include the new entry.
I haven’t tested something like this specifically in reporting to see what the additional report configurations would look like, but it certainly seems like it could work.
+4Hi
You could setup individual parameters for each document you want to select and then create filters for each one to make sure if it is filled in, that it is used in the report. The parameters wouldn’t be dependent on the dunning letter so the user would need to select them manually and know which ones to select, which could be a hassle.
Otherwise you may need to create a custom table which uses a dependent relationship based on the dunning letter to populate the associated invoices.
I checked to see if this dependent connection exists already but I did not see that it does, so it would need to be created, at which point if you are creating custom table then it might be possible to incorporate a multi-select option built into it, but it might also need to be something where there are multiple parameters, one per invoice, and if there are lots, then I think this may not be a feasible option.
Perhaps there could be a more useful option to just filter out the invoices which you don’t want to show in the report instead?
This is really a good question. We are also looking for similar solution where we can select multiple project managers in report filter.
At present, we don’t have straight forward solution. We are evaluating alternative solutions.
I will post a solution that works.
+4This is not a viable solution with invoices due to obvious reason, but even still if a new project manager is added then the attribute would need to be updated to include the new entry.
I haven’t tested something like this specifically in reporting to see what the additional report configurations would look like, but it certainly seems like it could work.
Thank you so much for your quick reply. Much appreciated!!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
