Report Problems

Problems Printing/Trying to Print Reports

Amorization Schedule

The maximum loan duration the program allows for is 40 years.

Balance Sheet

Every Account Description on the Balance Sheet says the same thing. But the Trial Balance prints fine.

Run Locate Setup Errors and look at the errors. Most likely they have an Account being consolidated to an invalid account. Correct any problems and the Balance Sheet should print fine.
The Payroll Liability figures do not match what the Payroll Summary says.

Run Trans Prep, they must have changed (1) or more payroll transactions since the last time Trans Prep was run for the period. As you know the Balance Sheet use the summary entries generated by Trans Prep, while the Payroll Summary totals the entries themselves.
If you get underlines going though the numbers, go to.

Setup -> Reporting -> Statement -> General -> Misc (Tab)

Check the Line spacing for statements/schedules figure. If the number is below "85" (the default) increase the number by increments of "5" till the problem goes away.

A number of "55" will most definitely cause the problem.

Bank Recon

Journal Codes - If more than (1) Cash Account is setup with the same Journal Codes you will experience the following problems:

Revenue Recon The transactions for the other Cash Accounts will show up on the report.

Bank Recon for Account 110
```
    1     5000.00     Sales
    2        0.00     DEP-1
    
```
Bank Recon for Account 120
```
    1        0.00     DEP 01-10
    2    2,500.00     Sales
    
```
Note: You if mark the "0.00" transaction as being cleared it will mark in cleared in the other Cash Account. But removing the "X" may or may not remove the "X" in the other Cash Account.
Cash Recon - The screens will look normal.

Bank Recon for Account 110
```
    1     5000.00     DEP 01-10
    
```
Bank Recon for Account 120
```
    2    2,500.00     DEP 1
    
```
Fixing the Problem - You cannot simply fix the problem by going into Cash Account Maintenance and changing the Journal Codes on one of the Cash Accounts. You must:
1. Change the Journal Code in Cash Account Maintenance
2. Transaction Utilities -> Modify a Group of Transactions
3. Click on the List GL Transactions button
4. On the next screen leave the default settings and click OK
5. Look for the transactions that have the wrong Jounral Code
  
  Write down the TRN #'s (Transaction Number).
6. Click Close
7. Now enter the Beginning and Ending TRN #'s
8. Click on the Journal Code checkbox
9. Type in the correct Journal Code and click OK
At this point you should be all set.

Bank Report

The Bank Report is missing transactions.

The Bank Report will only list transactions that have the proper Journal Code and Account Number. So check the transaction to make sure the Journal Code is the proper one.

The Journal Codes the system will use are the ones you entered in Setup -> Account -> Cash Accounts.

For example if you setup Cash Account 110 to use Journal Codes CD1 & CR1. But the transaction was posted to CD. This transaction will not show up on the Bank Report for account 110.

Journal Codes - If more than (1) Cash Account is setup with the same Journal Codes you will experience the following problems:

Detail Report - The transactions for the other Cash Accounts will show up on the report.

Bank Report for Account 110

    01/03/03     2      D  DEP-1
    440                    Sales                            2,500.00
    120                    DEP-1                           -2,500.00
                           DEP-1 Total                          0.00       0.00

    01/10/03     1      D  DEP 01-10
    440                    Sales                            5,000.00   5,000.00

Bank Report for Account 120

    01/03/03     2      D  DEP-1
    440                    Sales                            2,500.00   2,500.00
 
    01/10/03     1      D  DEP 01-10
    440                    Sales                            5,000.00   
    110                    DEP 01-10                       -5,000.00
                           DEP 01-10 Total                      0.00   2,500.00

Summary Report - The transactions for the other Cash Accounts will show up on the report.

Bank Report for Account 110

    01/03/03     2      D  DEP-1                                0.00       0.00
    01/10/03     1      D  DEP 01-10                        5,000.00   5,000.00

Bank Report for Account 120

    01/03/03     2      D  DEP-1                            2,500.00   2,500.00
    01/10/03     1      D  DEP 01-10                            0.00   2,500.00

Note: There should be a warning message at the bottom of the report telling you that the jounral codes are being used by another Cash Account.

Fixing the Problem - You cannot simply fix the problem by going into Cash Account Maintenance and changing the Journal Codes on one of the Cash Accounts. Follow the steps listed under the Bank Recon.

PLUS - After the doing the above steps the figures should be right on the report. But the descriptions may not show, because the system stores Receipts in a separate table and the report looks at both the GL table and Receipts table when generating the report. This isn't a problem. But if someone goes back into Receipts and corrects the Journal Code (pressing OK twice to actually record the change) the report can show the amount twice. You need to run Version Control and/or Repair Data so the figures on the report show only once.

* Changed Journal Code for 120
** Also ran modify transactions for 120 - The 01/03/03 deposit disappears from the the 110 report.
1. Detail Report - The transactions for the other Cash Accounts will show up on the report.
  
  Bank Report for Account 110
```
         01/03/03     2      D  DEP-1
         440                    Sales                        2,500.00
         120                    DEP-1                       -2,500.00
                                DEP-1 Total                      0.00       0.00

         01/10/03     1      D  DEP 01-10
         440                    Sales                        5,000.00   5,000.00
         
```
  * Bank Report for Account 120
```
         01/03/03     2      L              
         120                                                 2,500.00   2,500.00
         
```
  ** Bank Report for Account 120
```
         01/03/03     2      D              
         440                                                 2,500.00   2,500.00
         
```
2. Summary Report - The transactions for the other Cash Accounts will show up on the report.
  
  Bank Report for Account 110
```
         01/03/03     2      D  DEP-1                            0.00       0.00
         01/10/03     1      D  DEP 01-10                    5,000.00   5,000.00
         
```
  * Bank Report for Account 120
```
         01/03/03     2      L  DEP-1                        2,500.00   2,500.00
         
```
  ** Bank Report for Account 120
```
         01/03/03     2      D                               2,500.00   2,500.00
         
```

Disclaimer Letters

If you are having problems printing a certain Font try using the Alternate Print Method. This option is listed on the Special Options Menu on the top of the Disclaimer Letter Screen.

This option uses VSVIEW to print the letters instead on Microsofts Print Drivers.
Runtime Error 13: Type mismatch - The problem has to do with Fiscal Years. If this is a new client (setup this year) then add a Fiscal Year for the prior year. So if they were setup in 2004 add 2003 and the error should go away.

Note: This problem was fixed in v5.65.01.

General Ledger

The PYR / CKS (payroll transaction) figures do not match what the Payroll Summary says.

Run Trans Prep, they must have changed (1) or more payroll transactions since the last time Trans Prep was run for the period. As you know the General Ledger use the summary entries generated by Trans Prep, while the Payroll Summary totals the entries themselves.

Income Statement

When you ask for a 4 Column Last Year Comparative the ending date on the top of the report has 1899 as the year.
- Check the Initial Balance Date. You are maybe asking for a period prior to this date.
- Check the number of months in the (2) Fiscal Years. If they don't match, change (1) of the years so they do match. (ie: 4 - Quarterly & 12 - Monthly)

Laser 941

Error 3021 - I had one person get this error while trying to run the Laser 941 option. Repairing both the client data and system data didn't help. Neither did a Version Control. I had them send their data and it turned out that the Form941 table was damaged. It recreated the table and the error went away.
The Wages figure from line 2 does not match a Payroll Summary or Payroll Transaction Listing.
- Run a Payroll Reporting -> 940/941 Report. This report will match what is on the 941 and it also shows you how the system got the figure. (ie: FLGROS (121641.74) - CAF (749.45) = 120892.29)
- Check the dates being used to determine what payroll transactions are included on the report. The 941 is by Quarter, so make sure to include the entire quarter in the report. Otherwise you may exclude transactions on the report that are included in the wage figure on the 941.
The number of employees is a bogus figure. As we have no good way to be 100% accurate. (ie: A person gets paid bi-annually or annual, hired this quarter but wont get a check until next quarter) You can either go by the Hired and Terminated dates or by the number of employees receiving a check in the last month of the quarter (Mar, Jun, Sept and Dec).

Go to Setup -> Payroll -> Payroll Setup -> Unemployment Page 1 tab and either select Hire/Term Dates or Check Dates. It will be in the Count Employees for Unemp/941 section of the screen.

Last Year Comparative Report

The report has an Ending Date of 1899.

The most common causes of this are:
1. The Date Range on the report falls before the Initial Balance Date.
  
  Setup -> Account -> Initial Balances
2. The Number of Reporting Periods for the (2) years do not match (ie: 12 vs 6). The system needs for them to be the same.
  
  Setup -> Date -> Enter/Change Fiscal Years

Locate Setup Errors

Invalid Account - On FY1 transactions this means that the account listed in the Account to Close to at Fiscal Year End field for the account is invalid. Go into Chart of Accounts Maintenance -> Miscellaneous (Tab) to make sure the account number is valid or blank.

Payroll Check Register (Payroll Only)

The check appears under the wrong employee. But when you bring the check up on the payroll screen the check does have the correct employee ID.

They must have changed the employee ID on the check after it was written. So you will need them to go to Utilities -> Employee Utility and click on the Fix Payroll Transaction Employee Names. This will check all payroll transactions in the system and put the correct employee name on the check.

Payroll Check Register (Payables & Payroll)

The check appears under the wrong employee. But when you bring the check up on the payroll screen the check does have the correct employee ID.

They must have changed the employee ID on the check after it was written. So they will need to run Utilities -> Fix Credits to Cash.

Payroll Summary

Payroll item NCSTWH does not exist - Check to make sure the Payroll Item really does exist and is setup properly.

You can also get this message if the Exclude the State withholding column checkbox was checked and you remove it to run the report again. This problem was fixed is later versions. But in the mean time all you have to do is uncheck the box, [Close] the report screen and come back in.

Unemployment Quarterly Tax Report

The unemployment form background does not print. The data that goes on the form prints but the background doesn't.

They have selected the print Continuation Sheet Only option. Go back into the report and click on the Coninuation Sheet / Page 1 (radio button).

Note: On newer versions of the program the system will warn you that you have not selected the Coninuation Sheet / Page 1 option after clicking on the OK Button on the second page.

Texas

The background does not print. The data that goes on the form prints but the background doesn't.

You didn't enable the Print Form(s) checkbox under the Texas Extras Section on the first page.