Open topic with Search, TOC, and Index

Comparing and Configuring Schema Differences

Sage recommends comparing the database schema in Sage SalesLogix with your accounting application schema to ensure data integrity. You can compare data for various resources to determine if differences in string lengths exist between systems.

This feature compares the schema for the selected resource in the two integrated systems and returns any differences in string lengths.

Tell me more about how Sage SalesLogix manages schema differences...

MaxLength - If data is synchronized to Sage SalesLogix that exceeds the MaxLength of a field, the entire row will be rejected.

FractionalDigits - If data is synchronized to Sage SalesLogix that exceeds the number of decimal points, the value will be rounded to the maximum digits allowed after the decimal point. For example, if a currency field is defined as 17.4, then a value of 123.12348 is saved as 123.1235 and a value of 123.12343 is saved as 123.1234.

To compare

1. On the Administration menu, click Integration Setup.
2. On the Accounting Systems tab, click Edit for the enabled accounting system.
3. In the Setup Accounting Integration dialog box, use the Schema Differences section to find differences between systems.

1. In the Filter By Resource box, select the resource type.
2. Click Execute.
3. Review the differences in the grid.
4. Note any information that may cause data integrity issues. For example, an accounting system field may only accept three characters when the same field in Sage SalesLogix accepts free text.
5. Repeat step 3 for all resource types.

4. Click OK.
5. Use the Database Manager or other application to modify the schema in one of the systems.