Data Check

Check Menu: Setup->System Maintenance->Data Check

Data Check is standalone program that will repair some common problems with data files. When run, it will show a set of checkboxes to select what data repair options to use. All users should be out of the program when using Data Check.

Data files...Location of the ProfitSystem data files. This should be filled in automatically. Check primary keys?...Compares the next primary key versus the actual highest key used for certain tables and adjusts the next primary key as needed. Checks customer, event, poitem, pomast, tickitem, tickmast, prospect, resvmast, ship, todo, fitmast, szctmast, szcnmast, and invmast. Used if the program is generated new ID's that duplicate existing ID's Fix missing default user?...If the default user is accidentally removed, this will replace it. Used if a 'DEFAULT' user not found error occurs at program startup. Clean bad chars from styles?...Scans the vendor styles and vendor number and remove prohibited characters, such as '[] '. Used if errors occur on inventory reports and printing tags. Remove blank records?...Checks for blank records in important files and removes them. Checks customer, event, prospect, invclass, acctclas, tickmast, tickitem, sinvmast, sinvsize, sinvstor, pomast, poitem, pickinv. Used if 'duplicate key value' messages appear when adding new records to tables. Remove bad adj and tax details?...Checks the ticket line item file for records where an unknown adjustment appears, or bad tax details appear. Used if errors occur when running Customers with Balances report for past dates.