By using this website, you agree to our Terms of Use (click here)
Is there a way to burst reports by on a report value and email them to the correct users? We can add the user name or email to the report.
If the user name or email was on the report, can we send just those pages out by email? We can do Notifications based on screens, but i have not seen anything about working with reports.
If not, I guess I can build them in OData and use excel to burst, but I lose the use of the Scheduler when doing that.
I think you would need to setup multiple templates and parameterise whatever user level filtering is required so that each user only gets the data applicable to them. Then you need to schedule all the templates. Depending on your user count, might be a lot of work.
Failing that you would need a third party product - google on "pdf splitter and email" - I have no recommendations on any of these products.
Liason Software, an Acumatica ISV, has a solution that is designed to automate this exact type of process. They have been around for a lot of years integrating with other applications like Platinum for Windows (where I first met them in the 1990's, Sage 100, Microsoft Dynamics GP, and others.
Reach out to Tom Nielsen. 800.811.4618 x 201 / tom@liaisonsc.com / www.liaisonsc.com