- Print
- DarkLight
- PDF
There is a statement style field on the Fund 2 tab. How can I use this for fund statements?
For example: An endowed statement might have investment earnings detailed by realized and unrealized gains, interest, dividends and fees. A statement for a pass-thru fund might only have Interest.
- Statements might have different language or terminology used because of the audience.
- You might have different styles for different divisions.
- Regardless of the reason, the merge document created will point to a different data set so that when merged each fund will use the correct style.
- The statement style code is similar to the grant letter or the acknowledgment code.
- It is used during a merge to identify which merge document should be used for this particular fund.
Notes:
1. If you use Auto Launch:
- FIMS will use the merge document specified as the Statement Merge Document for all funds that do not have a statement style code.
Example of merge document used for statements with no statement style code as defined in the fund statements export:
- Statement style codes are not defined in the export, rather on the fund 2 tab of the fund using the corresponding code setup in File Maintenance > Fund Code Maintenance > Fund Statement Style
Example statement style code with associated merge document:
- For any funds that do have a statement style code, the auto-launch process will instead automatically use the merge document specified in File Maintenance > Fund Code Maintenance > Fund Statement Style
- What will happen is that you will see multiple merge documents opening, one will be the merge document defined in the export for funds with no statement style and you will see other documents open which are the specific merge documents pertaining to the statement styles for the funds in question as defined in File Maintenance > Fund Code Maintenance > Fund Statement Style.
Example showing the result of auto-launch. Form Letters1 is the statement merge document that pertains to the statement style code as defined in File Maintenance > Fund Code Maintenance > Fund Statement Style as shown in the screenshot example above. Note, if you have multple statement styles, you will see multiple documents open for each statement style code. Form Letters2 is the statement merge document that is defined in the fund statements export.
2. If you do not use Auto Launch:
- In order to merge statements for funds that have a specific statement code, you have to open up that specific merge template that you would like to use for that style code that is shown in File Maintenance > Fund Code Maintenance > Fund Statement Style and link it to the other data source that pertains to that code such as c:\fndstat_C00.txt and then merge.
- To link the other merge templates to the correct data source for their statement style, in MS Word, open the template in question and then go to Mailings\Select Recipients and choose the main data file that pertains to that statement code to be used for the statement. It needs to be a file starting with fndstat, for example fndstat_C00.txt. Do not use the fndstat.txt file because that is to be used for the main mail merge document for funds with no codes, you need to use the fndstat file that pertains to the statement code used for the merge template to be used for that statement style.
- To further explain the data source; when you export data in the Fund Statements Export and you use fund statement styles, the export will create data filenames based on the names entered on the Send To tab, plus an underscore and the Style code. For example, the main data filename might be c:\fndstat_C00.txt.
Here is an example of those other data sources. Note that this is just an example, your files may be in a different folder depending on how the export is configured and what your fund statement style codes are:
For a common error that can occur during merging using statement styles, see page 10 of the document attached to this article:
What are some Common Issues with Fund Statements?
See the following for some additional discussion on how and why to use statement styles and how they work.
All funds not shown when running fund statements into a merge document
Can I suppress fund statements for retired funds?