During the migration process, the program may encounter problems in that might prevent writing a particular record to the SQL database.
If the problem is one that the migration program can fix, it changes the record, and then writes the updated record to the SQL database. For example:
- If a record contains a reference to a record that does not exist, the program creates the missing referenced record using the name or description "Unknown [record]," with any required fields, and the record is set to Inactive.
- If a record contains a defined error that has a prescribed solution, the program applies the solution as it creates the record in the SQL database.
The migration program applies solutions, as described, when it encounters these specific errors:
- Canadian-specific fields that include values in a United States company. These fields are cleared.
- Line tables that include Quantity and Price or Cost fields, where the Price/Cost is negative. The Price/Cost is written as a positive value and the Quantity is made negative.*
- Parts with negative values for Average Cost, Default Cost or Billing Amount. These fields are cleared.*
- Bid Items that are Item# 0 with no value for Item Type. The Item Type is assigned 1-Base Bid.
- Job Costs with no value for Billing Status. The Billing Status is assigned 2-Not Billable.
- Job Costs with no value (or an otherwise invalid value) for Cost Type. The Cost Type is assigned 5-Other.
- Payroll Calculations with negative value for Benefit. The Benefit is changed to 0.
- Purchase Order Lines with AR, AP or SR for the Account. The Account and Subaccount fields are cleared.
- Clients with no value for Part Billing Basis. The Billing Basis is assigned 3 (Billing Amount).
- Clients with no value for Status. The Status is assigned to a new Status record, which is created using the highest available number and description of Unknown Status.*
- Tasks with no value for Task Type. The Task Type is assigned to a new Task Type record, which is created using the highest available number and description of Unknown Type.*
- Service Work Orders/Invoices with no value for Priority (in either the header or Dispatch grid). The Priority is assigned to the default value (either 3 or the customer’s setting from F7).
- T&M Billing Setup with no value for Income Account. The Income Account is assigned to the default Income Account from the Job record. (If there is no default value on the Job, the SQL record is not created, and the error is reported in the migration log.)
- Parts with any value other than 0 or 1 for Required from Inventory. The field is assigned 0 (not selected).
- Dispatch Board Column Setup with no value for Record Type. The Record Type is assigned E (Employee).
- Service Areas with no value for Dispatch Color. The Dispatch Color is assigned Black.
- Any Yes/No field with any value other than Y, N, or blank. These fields are cleared.