This report checks records for content problems and
reports based on the options you select. It can check records in
either the Active or Storage file.
Some of the options may not be available in your system. For
example, the "not in list" options are available only for
those items where you have established a list. Check the options
that you want included in this report and the file to process. Then
select OK to continue. Selecting Cancel
aborts the report.
The "not in list" Options
Tally-Up maintains many lists that make data entry easier and
reduce errors. There are several Record Rule Check options to
check your data against your lists
Transfer Category not in list
Tally-Up! allows you to define "Transfer Categories" and
set specific tax and Grossup rules for each category. This option
reports any records that have a Transfer Category value that is not
in your defined Transfer Category list.
User field values not in edit lists
You may define "edits" for any of your character type user
defined fields. This option reports any character type user fields
with values not in your edit lists. The option is not available if
you have not defined any edit lists.
Regular User-Def expense types not in list
Reports any regular user-defined expense types that are not in your
user-defined expense type list.
3rd Pty User-Def expense types not in list
Reports any 3rd Party user-defined expense types that are not in
your user-defined expense type list.
Budget Center values not in list
This option reports any Budget Center fields with values not in your
lists.
Vouchers values not in list
This option reports any Voucher fields with values not in your
lists. Note that if the term "Voucher" has been redefined
in Company Options, the term "Voucher" in this option will
be replaced with your Company Options term.
Payees not in list
This option reports any Payee fields with values not in your lists.
Local Codes not in list
It is unusual for there to be a local code entered in a record that
is not in your local code list. However, it can happen if a
local code is removed after it has been entered in a record. At any
rate, a local code that is not in your local code list is an error.
This option will show any of these errors.
Selecting any of these "not in list" options will allow
you to add any of the reported values at the end of the report.
Record settings differ from Trans Cat defaults
Tally-Up! allows you to define "Transfer Categories" and
set specific withholding and Grossup rules for each category. This
option reports any records which have settings that differ from your
defined defaults. This condition may not be an error, because most
of these defaults can be changed in the Edit Pages. Further, a
change in Transfer Category rules does not automatically update
existing records. Why? Because sometimes companies
change rules, but want the changes to be applicable to new
transferees, but not to affect existing transferees.
User field value format errors
When a User-defined field is created, a field type (numeric,
character or date) is determined. This option reports on any
user-defined field with contents that do not match the definition.
Local Default State different from Local ASB
Tally-Up! allows (but does not require) you to specify a default
state for local taxing authorities. Since most local taxing
authorities use their parent state as the source for income figures
(the Amount Subject Base, or ASB), defining the default state can be
a good idea. It ensures that the localities selected in the Edit
Pages are correctly associated with their parent state. This
option will report any localities with a defined default state where
there is no state code that matches the locality.
Questionable 3P Expense Payee Names
Tally-Up! uses the "paid-to" name to determine whether to
treat an expense as paid to the employee. Sometimes, a payee
that is intended to be the employee is misinterpreted by Tally-Up!
because of a typo or spelling error when the payee name is entered.
These errors can be avoided by entering * as the payee name, or
selecting the employee from the payee pick list. This report
section attempts to find such errors. If you select this
option, you will be asked if you want to correct questionable payee
names. If you choose to do so, Tally-Up! will pause
after each record that has questionable payee names, and allow you
to select any that you want to be changed to the employee name.
Questionable Empl Expense Payee Names
This option causes Tally-Up! to report any expense paid to an
employee that has a Payee name other than the employee. This
condition is quite rare, but has been known to happen when an error
occurs while an expense is being saved to the file.
Non-Standard User-defined expense codes
Tally-Up! uses a standard set of expense codes to associate
user-defined expenses with "regular" expenses. For
example, the "A1" code indicates the expense is a transit
expense. You may use non-standard codes if you wish. This option
reports any user-defined expenses that have codes that are not
recognized by Tally-Up!
Expense Flag 2 formatting errors
This option reports any expense in the Tally-Up! database which has
a Flag 2 value that is not a date. It is enabled only if your
Company Option is set to use Flag 2 as a date. If this option is
selected, you will be asked whether to erase bad Flag 2 values.
Expenses changed since closing
When the Withholding Amounts report is run, each processed expense
becomes "closed," and ordinarily, the expense can no
longer be edited or deleted. However, there is a Company
Option "Make no check on closed expenses." As a
general rule, this Company Option is not recommended, because it
allows you to change expense values that have already been processed
for payroll. This report option displays any expenses that
have been changed since they were processed by Withholding Amounts.
Expense Dates that cross Fiscal Range
There are four dates associated with each Tally-Up! expense; the
Expense Date entered by the user, the Posting Date, which is usually
the later of the Expense Date or the actual date the expense was
saved, the Payroll Date, which is the date the expense was processed
by the Withholding Amounts report, and the AP Date, which is the
date the expense was processed by an Accounts Payable report. This
report option displays any expenses that have at least one date
within your company's fiscal range and another date that is outside
the fiscal range.
Payroll Base/History values Mismatch
The Withholding Amounts report stores some of its results in the
base (main) transferee record and some in the Payroll History file.
If there is a network or disk write error during processing, there
is a possibility that one file may not be saved correctly. This
report option displays details of any record where such a
"mismatch" has occurred, and gives you the option to
correct the error.
Email formatting errors
This option reports any transferee that has an incorrectly formatted
email address.
Unused Frequent Payee
This option reports any payees in your Frequent Payee List that are
not used by any records in your database.
Unused Regular User-Def Expense Types
This option reports any Regular User-Defined expenses in your list
that are not used by any records in your database.
Unused 3rd Pty User-Def Expense Types
This option reports any Third Party User-Defined expenses in your
list that are not used by any records in your database.
|