KSMS AP_Company settings
When adding the AP_Company view to KSMS, ensure that the following settings are applied. Without this configuration, the database lookup does not work as expected.
Setting |
Value |
---|---|
Connection Type |
Microsoft SQL Server |
Connection String |
Connection string for the APAgility database |
Relational database object |
CompanyAddressMaster |
Columns to Use |
Ensure that the following columns and only these columns are selected for Search.
Ensure that the following column and only this column is selected for Filtering.
|
Ignore case |
Selected |
Database active after import |
Selected |
Word separation characters |
,-; and Space is selected |