We have a 2500 member organization that is moving to online dues payment. Because they haven't had it in the past most members are sending in checks and aren't used to going online and clicking the button to say pay offline. This creates a problem because I need one field in my database for tracking how much a member has paid for dues.
Since those that don't pay online don't get added to the payment tables I would like to create a SQL action to populate payment information for those that pay online into a field in the jos_comprofiler table that everyone has a record in.
I'm not sure if this makes sense or not... I can try to map it out if it doesn't.