I was wondering if anyone has had any experience with adding custom column's to GP tables? I have the need to add a Created By field that would have a default value and be for reporting only (not shown in the GP UI). I would imagine it makes the upgrade process a bit hairier, but outside of that?
Not, not, not recommended. Get Extender from eOne. You can add as many custom fields as you want tied to whatever standard GP window you want without mucking up the standard GP tables and being on an unsupported system.
** Please, if this answers your question, mark it as 'Answered' so others experiencing the same will know it resolved your issue. **
Frank E. Hamelly, MCP-GP, MCP-AX, MCITP, MCT, MVP
I agree with Richard. If you change our tables you are going to run into issues. It may work fine in the application but when you do a upgrade and that table is change it will 100% cause issues during the upgrade.
Or create custom table and dump data there and retrieve when it require.