Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Report Filtered by Multiple Memo Fields

Questions on using, creating, or understanding data in Fund Manager reports.

Postby ssherbin » Fri Nov 30, 2012 11:36 am

Is it possible to combine text strings from separate memo fields in order to filter for a report? I'd like to generate a report that includes only transactions that contain any of the following 3 memo fields:

CA STATE TAX W/H IRA7
FED INC TAX WHLD IRA7
J7NORMAL TO

Using "TAX" as the filter gives me both state and fed transactions just fine, but not the 3rd memo field. Using "7" picks up all 3 of interest, but also includes any other transaction that coincidentally includes a "7" when the amount or quantity is automatically copied to the memo field by FundManager.

Thanks!
ssherbin
 
Posts: 15
Joined: Sun Apr 03, 2011 11:11 am

Postby Mark » Fri Nov 30, 2012 11:56 am

Hi ssherbin,

Sorry, no, this isn't a feature of that filter option. We could consider adding some flexibility here, like using either OR or || in the filter string so that you can accomplish what you're describing here. With this, you could enter something like:

TAX || J7NORMAL

for the filter, and then it would find all 3 of these transactions.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11674
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby ssherbin » Fri Nov 30, 2012 12:21 pm

That would be a great fix! Hope you can add it sometime to the functionality of report filtering.

Thanks.
ssherbin
 
Posts: 15
Joined: Sun Apr 03, 2011 11:11 am

Postby ssherbin » Wed Jan 21, 2015 5:45 pm

I finally figured out a work-around to display all IRA distributions.
1. Run the predefined "Transaction Report" for the specified period of interest
2. Select "Edit Report Settings" from the report menu bar drop-down
3. Select "Filter
4. Select (check) "Include only portfolio external transactions"
5. Memorize new report with appropriate, unique title.
ssherbin
 
Posts: 15
Joined: Sun Apr 03, 2011 11:11 am


Return to Reports

Who is online

Users browsing this forum: No registered users and 23 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2025 Beiley Software, Inc. All rights reserved.