Im Getting a “type mismatch” error in Define Balance Sheet/Income Statement, Why?
There is a record in the tables with a null value and the query for building the report is failing. If receiving error in the balance sheet: From the Main Menu go to System Utilities and Tools/Tools/Table Maintenance. Choose the table named “tblGLBalanceSheetCategories.” Look through the table and make sure the all fields are populated for each line, except for the “notes” column. You may have a zero in some of the columns, and that is acceptable, however the only column which may contain nothing, is the “notes” column.If receiving the error in the If receiving error in the Income Statement: From the Main Menu go to System Utilities and Tools/Tools/Table Maintenance. Choose the table named “tblGLIncomeStmtCategories.” Look through the table and make sure the all fields are populated for each line, except for the “notes” column. You may have a zero in some of the columns, and that is acceptable, however the only column which may contain nothing, is the “notes” column. In either instance
