logo (c) 1996 Argosy Legal Systems         
Home Closing Resources Power Closer Support Contact Us
  
    
    

 

 

Troubleshooting Tips

... Common problems

On this page:

 See also these pages:


Power Closer normally installs and runs without difficulty. Re-starting Windows usually solves problems caused by Windows. Here are other items that it may be helpful for you to know about, although most people will not experience any of these problems.


Installation, setup, date format, HUD footnotes

"Only one user can open Power Closer at a time."

It is normal for Power Closer Jr. Single User and Power Closer Standard Single User to limit access in this way. Consider an upgrade to the Power Closer Network Site license.

If you have upgraded to Power Closer Network Site, and one or more workstations cannot log in when another user is using Power Closer, it is possible that the old single user version has been inadvertently reinstalled. Try reinstalling the most recent Power Closer CD at each workstation.

See also "Error 3050: Can't lock file."
 

"I installed Power Closer but it does not run properly."

If Power Closer does not run properly after being installed, the program may not be installed correctly. This may happen even though no errors are reported during installation. The most likely cause is that some other program was running during installation and this prevented the installation of newer copies of some files because the files were being used by the other program. Programs that are known to cause this installation problem include MS Office Manager Toolbar, some Virus checking programs and some Printer and Scanner management programs. To re-install, use the Windows TASK MANAGER to shut down the other programs and re-run the SETUP program. It should not be necessary to remove or un-install any Power Closer files. If you are still getting a problem, then it may be necessary to temporarily remove any program(s) from your Windows StartUp folder, then re-boot Windows and run the SETUP program.
  

I'm using the Demo and I can't open a closing file

On the menu, go to 'File... Open...' and click on the OK button, then select one of the two files available in the file list and double-click or hit enter. The demo does not create new files. It comes with two files that you can use to do closings and explore most parts of the fully licensed program.
 

"I have a problem entering dates."

Date problems may be caused by an incorrect system date format in the Windows Control Panel. Go to Control Panel, Regional Settings, Date Format, and set the date format to M/d/yy.
 

"How do I edit the footnote on the HUD-1?"

Edit the footnote by going to the Options menu. To edit the default template, select Default Template. To edit the currently open closing or template file, select This File. On the Options screen, select the HUD Footnotes button which presents an editing screen. For more about customizing Power Closer, see Setup.

Monitor resolution: at least 1024 x 768

If you do not see the right-hand scroll bar on the main Power Closer screen, or cannot see the entire width of the screen all at once, then your monitor resolution is probably set to less than the required 1024 by 768. If your monitor is capable of 1024 by 768 resolution, you can set the monitor resolution by right-clicking on a blank area of your Windows desktop, and selecting Properties to invoke the Display properties window, where you can select the Settings tab, and change the monitor resolution to at least 1024 by 768.

Printing

"I can't print."

The printer paper size and paper source must be set up correctly in Power Closer. Use the Options...Workstation menu item to get to the printer setup screens and check there.

Error 6: “Overflow” is caused by some versions of HP PCL5e driver and also by some other vendor’s drivers. Install a different printer (such as PCL6 for HP-- visit www.hp.com for updates) and set up Power Closer to use it. Note you may leave the existing printer driver as the Windows default printer because Power Closer can be set up to use any installed driver.

"I printed okay yesterday, but I can't print today."

If printing worked yesterday but you get a printing error today, chances are Windows has stopped communicating properly with the printer driver. You might get a variety of errors, such as "This program requires a printer driver" or "Printer error sub AB".

  1. Exit from Power Closer.

  2. Change Windows default printer driver to another driver, then change it back to original. To do this, go to the Windows start menu (or the Control Panel) and  find the Printers window. Notice which printer is checked as the default printer. Select another printer and set it as the default (right click and select default, or highlight and use the File menu, and select Set as Default Printer). Then reverse the process, right-clicking the original printer and choosing "Select as Default Printer".. 

  3. Start up Power Closer and try to print.

That usually fixes the problem. Other things to try include turning the printer off and on, restarting Windows, or reinstalling the printer driver. You could decide to use a different printer driver. If you do that, be sure the new driver is set up in Power Closer's workstation options as a printer. Call for technical assistance.

"I updated from 3.0 or older and now I can't print."

Power Closer's printer setup changed in Power Closer 3.2 (November, 2000).

When updating from Power Closer 3.0 or older, visit Power Closer's workstation options at each workstation running Power Closer, and set up printers.

"I need to print the HUD-1 form on letter-size paper."

If your printer can be set to automatically "shrink to fit" or "fit to page" or "scale", then do this: Add a new special Windows printer that duplicates your current printer driver and prints to your physical printer. Right-click on this special printer in the Windows Printers folder, and set its preferences to one of the following, given in the order of your likely preference: "shrink to fit" or "fit to page" or scale to 76% or 78%. (Note: "Shrink to fit" would shrink legal to letter size. "Fit to page" would also expand smaller pages if any to letter size. Scale would simply scale all pages.) You might rename the special windows printer by adding descriptive language such as "Shrink to fit" so that it is not used by mistake or inadvertently reset to print normally. Finally, set Power Closer's options at your workstation to use this special printer. If it is set to "shrink to fit" or "fit to page", then you would likely set it in Power Closer as Power Closer's default printer because it should handle both letter and legal pages. However, if it is set to scale, then you will probably need to print legal and letter-size pages separately in Power Closer, and manually select the alternate printer at the time of printing when necessary.

If your printer does not shrink, fit to page or scale, try this: Print the HUD-1 form to a pdf file. Then, when you print the pdf file from Acrobat, choose to print on letter size paper and "Shrink to fit" or "Shrink oversized pages to paper size". 
 

Error messages

"Run-time error '70'. Permission denied."

If running Power Closer with Windows Vista, upgrade all workstations to at least Power Closer 3.3.
 

Error message: "Error 7: Out of Memory"

If running Power Closer on Windows XP, make sure that you are not using Windows 95 or 98 Compatibility mode. Right click the Power Closer Shortcut and select Properties. On the Properties screen select the Compatibility tab and turn off compatibility mode.
 

"Error 429: ActiveX component can't create object"

Required Windows system files are incorrect or not a matched set. Re-installing Power Closer may solve the problem. Otherwise look in c:\P-Closer\ver.txt to detect .DLL version problems.

If the problem persists, examine the properties of the file generally located at C:\Program Files\Common Files\
                      Microsoft Shared\DAO\DAO350.DLL.
That file should have a version number of 3.51.1608. If that file has a version number of 3.50.x and a date later than year 2002, then it might be a bad file. The fix would be to rename the file, e.g. re-name DAO350.DLL as DAO350x.DLL, and then reinstall Power Closer.

"Run-time error 3447: The Jet VBA file...failed to initialize."

Examine the properties of the file commonly located at 
      C:\Program Files\Common Files\
                      Microsoft Shared\DAO \DAO350.DLL.
If that file has a version number of 3.50.x and a date later than year 2002, then it is possibly a bad file. The fix would be to rename the file, e.g. re-name DAO350.DLL as DAO350x.DLL, and then reinstall Power Closer.

"Error 3050: Can't lock file."

The system is not giving the affected user or client workstation read/write/open/delete access to the folder containing the Power Closer database. Try configuring network access permissions. Locate the database folder. Set up the permissions or access rights to permit read/write/open/delete access to the folder. It is insufficient to give rights only for the database file itself. Rights must be given for the folder too.
 

Error message: "The old database requires updating"

When you open Power Closer, you may encounter a message stating that "The old database (CDB.MDB) requires updating. Please rerun setup."

This could happen after installing a Power Closer software update or upgrade, and subsequently restoring a database that was created using an older version of Power Closer. 

If you are having trouble opening a database that needs to be updated, make a backup copy of the database file if desired, and then reinstall Power Closer. Power Closer installation and update routines are designed to update the database file to the current version automatically.

Alternatively, you may run Pconvert to update the old database. This utility is located in the program folder, normally C:\P-Closer\Pconvert.exe. 
 

Error message: "Database not found. Create one?"

The database may have been moved or been deleted, or Power Closer is looking for the database in the wrong location. Power Closer offers to create a new, empty database. You may do this in an emergency to carry on working. However, when possible it is preferable first to reconnect Power Closer to the proper database. See "How do I move the database to a new location?"
 

Error message: "Could not open database."

When Power Closer cannot open the database because the database file is not in the expected format, then it gives the message "Could not open database: 3343 unrecognized database format". 

This suggests that the database has become corrupted. That could happen as the result of a power outage, a disk crash, unexpected network disconnection, or other serious system problem.

If this ever happens, everyone must quit Power Closer, and the database must be repaired or recovered from backup. Have everyone exit Power Closer as soon as possible to maximize the potential of being able to fix the corrupted database. Continuing to enter data into a corrupted database can make it harder to repair the database.

Several utilities can troubleshoot and reconstruct a corrupted database file. Contact tech support about how best to attempt to repair the database. 

If the database is shared over a network, see also "What's corrupting the database?" (Troubleshooting) below.
 

Error message: "... is not an index in this table."

If you see this message, the database is corrupted.  This is typically a result of network errors. Restore your backup database (CDB.MDB) and re-key data entered since the backup was made.
 

Error message: "Disk or Network Error"

This usually indicates a network error. If this happens regularly, the problem should be fixed to prevent database corruption. If not accessing the database over a network, you should check your local disk drive for errors.
 

Network Problems

"What's corrupting the database?" (Troubleshooting)

Database corruption can happen when a user is disconnected from the database. This is usually an isolated event of obvious cause, such as a disk crash or power outage. A recurring problem is likely to involve a network connection.

If a user becomes disconnected from the database, and others are continuing to use the database, someone should try to restart Power Closer from any workstation and try printing the HUD and Balance Sheet from a recent closing to verify database integrity. If no problem is encountered, the database is probably good. In the unlikely event that Power Closer gives a message that it does not recognize the data format, then all users should exit Power Closer as soon as conveniently can be done to maximize the potential for repairing the database as described in Could not open database above.

The following procedure can help diagnose disconnection from the database.

  1. Right-click the Power Closer (house) program shortcut and select Properties.

  2. On the Properties screen, note the " Start in" location, which is where the database file CDB.MDB is located.

  3. On the Properties screen, click the Find Target button at the bottom. This takes us to the program folder, which contains a utility program called LDBView.

  4. Run LDBView and open the CDB.MDB database that was located in step 2.

  5. In LDBView, look at the "Users Listed in the Database". If any user is listed, then look at the "suspect" column to see if any workstation is suspected of causing database corruption.

  6. Fix any network connectivity problem that may be discovered. In the meantime, to prevent further database corruption, avoid accessing the Power Closer database from a workstation that is suspected of causing problems.
     

Allocating checks

Creating a check for the Yield Spread Premium

In Power Closer, go to the New Loan screen by pressing the button on HUD line 202, and enter the Lender Funds Into Trust in the top right corner of the screen. The lender should send you enough funds to cover the Yield Spread Premium check.

Enter the Yield Spread Premium as a POC item by placing a cursor in a line in the HUD 800 section and using the POC Window menu item.

Look at the checks in the Disbursement Window. Your objective will be to use the funds collected from the borrower in the HUD 800 section to create the Yield Spread Premium check and possibly an extra check to the lender for any loan charges that the lender did not already deduct from the loan funding ("net funding").

If you find a Combined check to the lender totaling the amount of the yield spread premium, most likely you do not need to pay the lender for the underlying HUD line charges, and you can edit the check to change the payee from the lender to the mortgage broker.

If the check to the lender includes one or more items that were not "net funded" and should actually be paid to the lender, then uncombine those items by selecting them in the list of supporting data at the bottom of the Disbursement Window and clicking the Uncombine menu item, and then recombine them into a new check to the lender using the Combine menu item. That should leave a check in the exact amount of the Yield Spread Premium. Edit the name of the payee on that check as needed.

If you do a lot of closings that involve allocating the same HUD line items to create a Yield Spread Premium check, you can make these same changes in a special Power Closer closing template. Any closing you start based on that template will automatically create the Yield Spread Premium check.
 

Bookkeeping software

"QuickBooks reconciliation's opening balance is wrong."

Consider carefully before changing items that have been cleared in a previous bank reconciliation. Changing cleared transactions in QuickBooks disrupts the reconciliation process. When you reconcile the trust account bank statement, QuickBooks calculates an Opening Balance per bank based on the data in QuickBooks. The following things could make the opening balance wrong and require corrective action:

  • Voiding a cleared item. (QuickBooks gives no warning!)
     
  • Changing the amount of a cleared item. (QuickBooks warns "You have changed a transaction that has already been cleared. Do you want to record your changes?")
     
  • Deleting a cleared item. (QuickBooks warns "Are you sure you want to delete this reconciled transaction?")
     
  • Changing the cleared status of an item by clicking to add or remove a checkbox in the "cleared status" column of the account register, outside of the reconciliation process. (QuickBooks warns "You have changed the transaction. Do you want to record your changes?" For cleared items, QuickBooks then also warns "You have changed a transaction that has already been cleared. Do you want to record your changes?")

If you identify such a problematic edit and correct it, QuickBooks will recalculate the Opening Balance. When all is correct, you can proceed with the bank account reconciliation. If you try to complete the reconciliation without fixing the problem, QuickBooks will offer to make an adjusting entry automatically, but this only memorializes the date of discovery of the problem and the amount of the discrepancy, and it does not fix the problem.

Here are some things you can do that might help:

  • Refer to detailed reconciliation reports to locate discrepancies.
     
  • Turn on the audit trail feature in QuickBooks and use the audit trail report to identify improper changes.
     
  • After each reconciliation, lock QuickBooks transactions through the date of the last cleared item and require a password to edit locked transactions. See the QuickBooks Help topic "Closing your books".
     

"QuickBooks does not report the amount of the check."

QuickBooks can hide "split detail" and just show one line per check when printing a trust account ledger showing all the closings sorted and totaled by closing, but not when reporting a single closing (i.e. filtered by closing). In that case the check shows up as several HUD line items and amounts which, if added together, equal the amount of the check. The total of the check is not printed.

If this is important to you, you may turn off (uncheck) Power Closer's site option for exporting "split detail", thereby avoiding this problem in the future. Of course, the check voucher will not show the "split detail" itemization either.
 

How do I make a summary report in QuickBooks?

QuickBooks can do a summary report showing one line per closing. This is a "custom summary report". On the Custom Reports screen, set the Report Dates to All Dates, the report basis to Cash, the Column axis to Total only, the Row axis to Class. If desired, to exclude zero balances, click the Advanced button and select Display Non Zero Rows. Set a filter for Account to include either "All bank accounts" or a particular named bank account and set Split Detail to include Details matching "All liabilities".
 

"Does QuickBooks have a limit on number of closings?"

The most important QuickBooks limitations for Power Closer are the maximum of 10,000 Classes and 10,000 Other Names. QuickBooks uses one Class entry for each closing, and it uses one Other Name entry for each unique payee on imported checks. If you do about 100 closings a month, you might reach one of these QuickBooks limits in something like five or six years, at which point you might decide to start using a new, empty QuickBooks company file and a new trust account.

To see if you are nearing the QuickBooks maximums, press F2 in QuickBooks to display the Product Information window, and check the List Information to the lower right.

Note: Older versions of QuickBooks do not report the List Information. In that case, try exporting the lists of Classes and of Other Names, then open each list in notepad and the count the lines. To count the lines, try copying the list from Notepad into a blank MS Word document, then select Word's Tools | Word Count, note the number of paragraphs it reports, and subtract two from that to get the number of items in the list.

Generally the solution for dealing with the QuickBooks limitation is to start using a new, empty QuickBooks company file. You can still open the old company file in QuickBooks in order to finish the monthly reconciliation process for the old checks until they all clear the bank. It can work well to open a new trust bank account at the same time you start the new QuickBooks company file.
 

"Quicken 2005 does not import my checks"

Intuit, the maker of Quicken, has indicated Quicken 2005 and later will not import bank account transactions in QIF format. Therefore users of earlier versions of Quicken should not upgrade to Quicken 2005 if they want to export closing checks and deposits from Power Closer into Quicken.
 

Quicken does not import addresses

Beginning with Quicken 2001, Quicken's QIF import does not import check addresses for window envelopes in check transactions.

This limitation affects those who want to import check address information into Quicken, particularly those who might purchase or upgrade to Quicken 2001, Quicken 2002, or later versions. 

Note: This limitation has not appeared in any version of QuickBooks, which continues to be trouble free.
 

"Quicken stopped importing my checks"

Quicken users have very occasionally reported that Quicken has unexpectedly stopped importing checks. We do not claim to understand this. The following approaches have fixed or may fix problems of this nature.

Run Quicken's Validate utility to fix the Quicken database file. 

If Validate leaves a problem unresolved, read Validate's log file to determine which item of data is involved. You may be able to edit that item, or delete it and re-enter it, and so fix the problem.

If the problem persists, restore a recent Quicken backup, and re-import checks for recent closings as appropriate. We would expect this to work if you start with a Quicken database file that Quicken can import into. 

Alternatively, switch from Quicken to QuickBooks. We recommend QuickBooks for use with Power Closer. Normally QuickBooks converts Quicken data quickly and effortlessly. However, in rare cases when the Quicken database is inconsistent, QuickBooks may not be able to convert the Quicken database.
 

"Microsoft Money stopped importing checks."

This problem has been encountered with Microsoft Money in cases where a closing has a check with more than five lines of "split detail". The workaround is to turn off (uncheck) Power Closer's site option to export the split detail, and re-export the checks. 
 

"What's the problem with Microsoft Money Plus?"

Microsoft Money Plus is being discontinued. After January 31, 2011, Microsoft will no longer let you activate Microsoft Money Plus on your computer. At that point, if your computer crashes, inability to reinstall the software on any computer could make your accounting data inaccessible. Therefore, we suggest that you not upgrade from Microsoft Money 2007 and older versions to Microsoft Money Plus.

This problem does not affect versions of Microsoft Money without the "Plus" and dated 2007 or earlier. 
 

Document Merge

"Microsoft Word stopped opening the data source file"

This can happen when a particular closing's data contains a merge field with a single quote in it. Microsoft Word asks you to set the Field and Record delimiters, but no setting will work because the single quote disrupts the data.

Find the single quote in Power Closer and remove it or replace it with paired quotes. Close Microsoft Word or end it using Task Manager or if necessary restart your computer. Re-export the Power Closer merge data and merge the document.

 

See also: Support Advisories, What's New
 


TECHNICAL SUPPORT | POWER CLOSER

RESOURCES | HOME