Hello! I just tried adding a couple of custom plan elements (they are both currency/amount fields), and then seem to be functioning correctly in plans (as in, I can fill them in, and then save the plan with no issues, and pull them into the Plan Summary report), but when I try to pull a list using them as criteria, I get the following error message: "List generation has failed.: Error 8115, Severity 16, State 8, Procedure n/a, Line 1, Arithmetic overflow error converting varchar to data type numeric." What am I missing to make these work as list criteria?
I suspect this is part of a known bug with all custom fields (Plans, Orders, Contributions) and list elements, although my recollection was that it simply didn't generate criteria for them. I've had to create specific new list manager criteria for each custom element I wanted to use.
To add, all 10 custom fields in T_Plan are of varchar(255). I think you can use convert() in your list element design to actually turn them into money type. If not, keep them as strings and convert them in reporting.