🤓 Xplan Hint: Client List - generating a report
Hi laura.capozzi, We have always struggled to get a decent overdue tasks list that is a bit more succinct. Do you have any ideas how I could achieve this. Ideally, I would want a report every Monday for our team meeting that could be automated? ie something from scheduler.
- laura.capozzi2 months ago
Iress Contributor
Hi Luke,
What a great question! I would suggest that an Xport report would be the way to go as you can set it to pick up tasks on a rolling date basis and you can even determine if you only want tasks specific to certain threads/cases. When you are building an Xport report, always remember to keep it simple. Too many data sources can complicate the report, and you can end up with duplicate or even triplicate lines in the output.
Then you can set Scheduler to run this weekly so the report is sitting in your notification bell icon or even emailed to your inbox, ready for your meeting. (By the way, keep an eye out for our upcoming article on Scheduler.)
Alternatively, you could have a coded Xmerge report (whether in word or excel), however this might require you to add in a search criteria step in scheduler before running the report, so that you can find the clients to run it against. The advantage of using an Xport report over the Xmerge is that you can refine the search within Xport making the run time faster than having an Xmerge run against and check every client.
Hope this has given you some ideas. Please feel free to share which direction you have decided to take and how it has helped.
Recent Discussions
🤓Xplan Hint: Supercharge your Searches with Syntax
Did you know you can use search syntax in Xplan to create powerful and specific advanced searches—beyond what the basic interface allows? With just a few lines of code, you can target contact detai...andrew.wilson.02 hours agoIress Contributor4Views1like0CommentsRisk Researcher - How can I update the owner to super fund for super-owned cover?
Hi brain trust, When I click REC button in Premium Estimates section, this product appears on Recommendations section. However, ownership for super-owned policy is the client's name. How can I set ...mymy.nguyen52 days agoNetwork Navigator11Views1like1CommentThread linking to incorrect opportunity when there are 2 active opportunities.
Hi, I created 2 opportunities for a client - one an ad-hoc workflow and the second - a review workflow. I worked through the tasks via the ad-hoc opportunity however when I got to the implementati...michelle.tarr4 days agoNetwork Navigator22Views2likes2CommentsThe Meeting System Myth: Why Structure Beats Style Every Time
A well-run financial planning business doesn’t just deliver advice – it delivers it predictably. Inconsistency across key meetings – the Initial Appointment, the Statement of Advice Presentation, or ...marklewin17 days agoValued Supporter44Views5likes1Comment