00195198 — "Invalid Column Name" error when adding a row in a custom table
Fixed: cannot add a row in custom effective-dated tables if the pick list field references a non-effective-dated system table like the Payee table.
1. Add a table
a. From the Table type drop-down list, select 'Custom'.
b. Select the Effective dated checkbox.
c. Type a name for the primary key field and select 'Text' from the column type list.
d. Click Add a column to add another field to the table. Select 'Pick list' as the type and use the Payee table as the source.
2. Try to add another row by clicking the pick list field.
Result: error occurs. The error message is, "Invalid column name 'Effective_Start'. Invalid column name 'EffEnd_'. Invalid column name 'Effective_End'."