Hello All,
We’ve setup a Business event that triggers the users for an AP check but currently it displays the info to whom the report is being sent instead of the vendor name in the report.
The yello highlighted field displays the info of the receiver instead of the vendor. How can I resolve this?
But when I run this particular report manually in the system, it displays the correct vendor info.
Best answer by Harry
View original
Hi
What is the relation between the 1st and 2nd screenshot? The 1st appears to be a report, and the 2nd is an email template. The information in the template is different than the 1st screenshot. Is the report being attached to the email?
if the incorrect info is appearing in the 1st screenshot, then it likely needs to be changed in Report Designer rather than the email template.
+12
Hi
Could you please share the Business events, GI and Notification template for us to verify. Also please elaborate the issue as
Hello
Yes, the report has been attached to the email template.
GI:
Business Event setup:
Kindly let me know what needs to be done.
Attached below is the screenshot of the email notification getting triggered:
and the report attached is a different one:
Whereas the original report is:
What needs to be added ?
+12
Hi
Generally how you run the report, Using parameter ?
Please update the parameter of vendor in Email template.
Hi
Generally how you run the report, Using parameter ?
Please update the parameter of vendor in Email template.
Yes, we are currently running the report using the below parameters.
We currently dont have parameters added up for vendor in the report:
+12
Hi
Could you please pass the report,xml of Generic inquiry with email template.
Thanks
Hello
Just to mention I updated the date ranges from 90 days to the current one in the Parameters tab for testing purposes.
How can I export report into xml format? Please guide.
Hello
Attaching the report in the format of Customization project folder. The instance version is 23R1.
In your notification template > ATTACHED REPORTS tab, you must tick Use Event as Data source and then add the parameters underneath that. You are sending the report with empty parameters (defaults) so that is why
In your notification template > ATTACHED REPORTS tab, you must tick Use Event as Data source and then add the parameters underneath that. You are sending the report with empty parameters (defaults) so that is why
Hey
its now running fine.
In your notification template > ATTACHED REPORTS tab, you must tick Use Event as Data source and then add the parameters underneath that. You are sending the report with empty parameters (defaults) so that is why
As you can see, I tried the below scenario,
I am not able to understand why is it showing source table as Vendor, whereas we dont have the vendor field mentioned as a parameter in the report.
And it is taking the parameter values from the GI and parameter name from Report.
Hello
+12
Hi
Unfortunately the report is not loading in my instance, could you please select from schema option?
In your notification template > ATTACHED REPORTS tab, you must tick Use Event as Data source and then add the parameters underneath that. You are sending the report with empty parameters (defaults) so that is why
As you can see, I tried the below scenario,
I am not able to understand why is it showing source table as Vendor, whereas we dont have the vendor field mentioned as a parameter in the report.
And it is taking the parameter values from the GI and parameter name from Report.
Do all the parameter Values show up as options being the data in your generic inquiry columns?
The Source Table normally comes from what is on the grid tab of your generic inquiry.
Your generic inquiry needs to contain the source data to complete the report parameters.
You can also hard code certain parameters by putting in a text value in the parameter value, or using the tick box From Schema to select a particular fixed value.
The Parameter Name is the report parameters available
The Parameter value is the source of where to get the value for that parameter, which is normally a reference to a column in your GI, or as mentioned you can hard type it in for fixed values.
Hello
I have resolved it. The issue was at the triggering condition level. So now I changed the triggering condition to the status as:
And now it triggers the correct report.
Thank you all for your prompt suggestions. Happy to be a part of such a great community where i would have people like you to guide all of us.😇. Thanks once again.
Thank you for sharing your solution with the community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
