[en] 00195198 — "Invalid Column Name" error when adding a row in a custom table
[en] 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.
[en] 1. Add a table
[en] a. From the Table type drop-down list, select 'Custom'.
[en] b. Select the Effective dated checkbox.
[en] c. Type a name for the primary key field and select 'Text' from the column type list.
[en] 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.
[en] 2. Try to add another row by clicking the pick list field.
[en] Result: error occurs. The error message is, "Invalid column name 'Effective_Start'. Invalid column name 'EffEnd_'. Invalid column name 'Effective_End'."