Hi @STMVALENTINE, This RMB option is used to send the PO as a PDF attachment to the Supplier. When you use this it will trigger the PDF_REPORT_CREATED as you mentioned and send a email using IFS/Connect with the PDF created from the event. In order to work this functionality you need setup the IFS/Connect, PDF_REPORT_CREATED event with the rule, Supplier Contact used in PO should enabled for E Mail Communication and Purchase Order check box should be enabled in Supplier master data. Hope this will Help Regards, Akila Thanks for your response. Very similar to what IFS responded with. However, this PDF_REPORT_CREATED event would also trigger anytime anyone just normally prints a purchase order as well. Thanks IS NOT what I want. I want this email to happen ONLY when I choose the option from the RMB menu on the purchase order and choose to email it. If there is any help in this issue I would appreciate it.
Thanks for your responses. I am going back to find out the report needs and might just attempt to create a new one or just a SQL query. The CR was a mess and half the data didn’t make sense to me anyway.
Looks to me as though you have created a parameter, but you will need to link in the parameter to the record selection formula. I have looked at this and there is code there to use for the filter. It just does not show when looking at the SQL query. It’s like it has a mind of it’s own to exclude the code. This is the problem when looking at existing reports created by someone else. :(
I looked into this once and i didn’t think it was possible using data migration, because the targets are blobs/clobs. I half managed to create a PL/SQL script that would do it, but it wasn’t very good and I’m afraid i did not keep it. Too bad you didn’t keep it, I might have liked looking at it. :)Maybe someone else has had this come up before….
Seems like they would at least need the database objects related to: Invoice_API Mainly the Invoice_API.Get_Invoice_No function. Hope that leads you down the correct path….
Is it so that you do not have any values at all in that tab? Than you have to create a new record in the tab by placing cursor in a field in the tab and press + and save. Or do you see a value but are not allowed to change it? That could be security rights since it seems to be no other limitations, at least in the database. Oops, I guess I just earned the idiot badge. I didn’t even see that it had the ability to add a new record. It didn’t look like the screen to have records to it. Thanks! I will explore this option and do some testing.~JV
If you are creating a new event action to a standard event, to new event action to get executed you have to disable the standard event action. I appreciate your response. I am not sure what a ‘standard’ event is, but I have plenty of events that have multiple event actions all enabled and they all work. The event I am working with is an ‘Application Defined’ event and not a ‘Custom Defined’. Still trying to get this to work, I think another reply might be on the right track with some of the base setup for the company. Just trying to see how to change those options as it won’t let me choose the options from the drop down.~JV
If it is a new environment. Can the basic data be different? For example, does your authorizers have the checkbox “Notify User“ checked? They must have that checked to get the e-mail created. Second, is your company setup for consecutive authorization? It must be to get the e-mail created. Thanks for your reply….I did find out that your second part does look different in my environment that is not working compared to the working environment. However, it does not seem to allow me to change the Authorization Routing choice. Any ideas?~JV
Thanks for your reply….This is in the main report itself. And I am using CR2016, and I have a parameter prompt for filter conditions….however…..when I ‘show SQL query’ it does not put in all the parameter filters.Any additional help as to where and how I can make sure the SQL query is passing all the ‘WHERE’ conditions?~JV
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.