When you open QuickBooks Statement Writer (QSW)*, you receive one of the following errors:
- Office document customization is not available. The customization assembly could not be found or could not be loaded. You can still edit and save the document. Contact your administrator or the author of this document for further assistance.
- Unsupported Folder Location
Why this is happening
These errors occur because your My Documents folder is redirected to an alternate location over a network drive.
If the Default Save Locations for Reports and Templates ARE already set to the local drive (usually C:\) please refer to Circular Reference Warning in QSW/ISW instead.
In some cases, the error occurs because of the length of your company file name. See Solution 1.
How to fix it
Intuit recommends several solutions for this problem. The first solution may solve your problem, or you may need to try them all to resolve the issue. For best results, perform the solutions in the order shown.
In some cases, this error can be caused by a long file name (11 characters or more). Before you attempt solution 2 or 3 below, please do the following.
- Browse to, or search for, your company file, which will have a .qbw file extension (for example, mycompanyname.qbw) and check to see how many characters it contains.
- If it is 11 characters or longer, change the filename to less than 11 characters.
- Open Statement Writer.
If you continue to receive the error, proceed to Solution 2.
Important: You need to have administrator rights to your Windows user login to carry out these steps successfully.
- Open QSW, when you get the Office Documentation Customization error message, close QSW and proceed with the rest of these steps.
- Choose Reports > QuickBooksStatement Writer.
- Click Preferences and Formats.
- Be sure that the path for the reports & templates points to a network location:
- If your My Documents folder is redirected, it should show the redirected server path. If My Documents is not redirected (it is local), then you can specify whatever path you want.
- If you see C:\ listed and you want to change it to the network drive that your My Documents is redirected to, change it to the path you got from step 1 (if My Documents is redirected). If My Documents is local, then you can change it to whatever network path you wish. For example, if My Documents is being redirected to the H:\ drive (as in the screen shot below), you can just leave the preference set to H:\, but you will need to have a folder structure setup like that illustrated in the screen shot.
Important: QSW will not create folders from the preferences window, so you will need to manually create 3 new folders on the network drive (whichever path over a network you want to open QSW from):
- Name the top level folder Intuit.
- Inside of that create a Statement Writer folder.
- Inside of that create a Templates folder.
- Once you have set the paths, click OK to close the Preferences window.
- Download the ISW Network Fix Tool and save it to your Windows desktop. This file grants full trust to the ISW .dll files, checks to see if and where the My Documents folder is redirected, and grants full trust to the specific network location of the My Documents folder through the Microsoft .NET Framework 2.0 assemblies.
- After the file is downloaded and saved to your Desktop (you will need to unzip it to the desktop), double-click the Primary file and follow the onscreen instructions (if you are using Vista or 7, you may need to click Yes to the UAC prompts a few times). IMPORTANT- The two tools within this zip file must be on the desktop, not in a folder on the desktop, but physically on the desktop.
- Once the tool completes, open QSW and verify that it is working.
If the issue is not resolved, continue to Solution 3.
Important: If you are using QuickBooks Statement Writer 2012, before you perform the following steps you should check to ensure that the default folder locations are correct, then click the checkbox for Advanced to let you run the fix manually.
If you do not select Advanced, then performing the steps below will place you in a loop and not resolve the pathing issue.
- Run the Secondary ISW Network Fix which was added to your desktop when you downloaded the ISW Network Fix tool.
- Reopen QSW and make sure the issue is resolved.
- After running the ISW Fix Tool, if your My Documents was local and was then changed to a network location, you will need to repeat Solution 2, step 7 above.
- If the My Documents folder was redirected over a network and is now redirected back to being local, you will not need to run the Fix Tool.
- If you are working with QSW in a Terminal Services/Citrix environment, you need to make sure your ISWprefs.ini file is set to not delete itself when the user logs out. The file is located in C:\Documents and Settings\USER NAME\Local Settings\Application Data\Intuit\Statement Writer or C:\Users\USER NAME\AppData\Local\Intuit\Statement Writer if your are using Windows 7, Vista or Server 2008. Consult your IT professional for more information on accomplishing this.
- If running the tool normally does not work, you can try to run the tool from an elevated command prompt. You must run the tool as the Administrator.
If the issue is not resolved, continue to Solution 4.
- Show file extensions in Windows
- Rename the QSM file to something else then revert to its original name.
- Locate the .qsm file: C:\Users\<user name>\Intuit\Statement Writer\Financial Statements\Report Template.qsm
- Navigate to the directory containing the QSM file in Windows Explorer.
- Rightclick the QSM file and select Rename.
- Add a character to the file name and click Enter.
- Revert to the original file name. Check and see if the statement will open.
- Rename the folder containing the QSM file and revert to its original name.
- In Windows Explorer, navigate to the directory containing the QSM file.
- Right click the folder containing the QSM file and select Rename.
- Add a character to the name of the folder.
- Revert to the original folder name. Check and see if the statement will open.
- It may be necessary to rename and revert to original name additional folders moving down the branches of the directory.