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 is most often caused by a tax update being pointed to a specific company folder
  • User Account Control blocks access to the network data location
Resolution
[BCB:1:Backup warning:ECB]

Option 1: 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 prior to 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.

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

Option 2: Recreate the file when there is not a valid backup

Note: User-Maintained formulas will have to be recreated 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 does not 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