Error: "A managed exception was caught..." opening User-Maintained tax tables
Description
Cause
  • The TAXTABLE.DAT file contained in your individual company directory has become damaged.
  • This happens when a tax update is pointed to a specific company folder instead of the data path.
  • User Account Control can block access to the network data location.
Resolution
[BCB:1:Backup warning:ECB]

Extract TAXTABLE.DAT file from a Backup (.PTB) File

  1. Make a backup of your company.
  2. Find your company location and make a note of the directory.
  3. Close Sage 50 on all computers.
  4. Open File Explorer and browse to the company directory noted in step 2.
  5. Right-click TAXTABLE.DAT and select Rename.
  6. Rename the file to OLDTAXTABLE.DAT.
  7. Find a backup file (.PTB) created before the error occurring.
  8. Right-click and Copy the file. Then go to the Desktop.
  9. Right-click a blank area of the Desktop and select Paste.
  10. Right-click the backup file and select Rename. Change the PTB extension to ZIP.
  11. Right-click the .ZIP file and choose Extract All.
  12. Open the extracted folder, right-click TAXTABLE.DAT, and select Copy.
  13. Open File Explorer and browse to the individual company directory.
  14. Right-click and Paste.
  15. Open Sage 50.
  16. Verify that User-Maintained Payroll Formulas can open without error and that payroll calculates.

If the backup that contains the good TAXTABLE.DAT is old, then any missing User-Maintained formulas may need to be recreated manually. Follow How to update User-Maintained formulas for further details.

Recreate the file when there isn’t a valid backup

NOTE:

You'll need to recreate User-Maintained formulas when using this method.

  1. Make a backup of your company.
  2. Find your company location and make a note of the directory.
  3. Close Sage 50 on all computers.
  4. Open File Explorer and browse to the individual company directory.
  5. Right-click TAXTABLE.DAT and select Rename. Rename the file to OLDTAXTABLE.DAT.
  6. Open the company and answer Yes when prompted to create a new TAXTABLE.DAT file.
  7. Go to File, Payroll Formulas, User-Maintained and verify the error doesn’t occur.
  8. Create a new company.
  9. Select Maintain, Payroll, Payroll Setup Wizard.
  10. Click Next, and then click Next again.
  11. Answer the questions as they relate to your company on the following screens to recreate the needed formulas.
  12. Click Finish.
  13. Go to Maintain, Company Information and make a note of the directory.
  14. Browse to the directory noted above.
  15. Right-click TAXTABLE.DAT and select Copy.
  16. Browse to the directory noted in step 2.
  17. Right-click TAXTABLE.DAT in that directory and select Rename.
  18. Rename the file OLD2TAXTABLE.DAT.
  19. Right-click in a blank area and select Paste.
  20. Close all screens and open Sage 50.
  21. Select File, Payroll Formulas, User-Maintained and verify the formulas are now in your original company.
[BCB:161:Chat 50 US:ECB]



Steps to duplicate
Related Solutions