I have a couple of custom modules, which were build using the standard “Account” module template, and other than renaming some of the field labels, are as is. When I enable the modules to search in the Outlook plugin, I get “The remote server returned error: 500…”
the Suitecrm.log files shows this:
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name ‘billing_address_street_2’.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name ‘billing_address_street_3’.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name ‘billing_address_street_4’.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name ‘shipping_address_street_2’.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name ‘shipping_address_street_3’.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name ‘shipping_address_street_4’.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name ‘email1’.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name ‘email_addresses_non_primary’.
I don’t have this issue for other custom modules which are based on the “contact” template, only custom modules using the Account Template.
Any pointers here?
Thanks!!