Author Topic: Changing the Dues Amount  (Read 4740 times)

aktaylor

  • Jr. Member
  • **
  • Posts: 12
Changing the Dues Amount
« on: September 19, 2011, 01:03:51 AM »
Note: This post only applies to the Legacy database!

At the beginning of the year i set the dues for the year at $26.00, but on the first night of club we changed it to $28.00. Is there any way for the database to change the fees for each family by itself?

Thanks for your help ;D
« Last Edit: March 24, 2022, 11:36:54 AM by Annette »
Anchorage Grace Church Awana Club Database Admin

dave4him

  • Global Moderator
  • Full Member
  • *****
  • Posts: 48
  • I love this job!
    • First Baptist Church Awana Clubs
Re: Changing the Dues Amount
« Reply #1 on: September 19, 2011, 03:01:12 AM »
Under Admins > Club Setup > change your Weekly Dues in each club to reflect the Annual Dues increase.
« Last Edit: February 16, 2022, 09:07:54 AM by Annette »
David Barnes
Awana Commander
First Baptist Church
Branford, FL
N.Fl. Awana Ministry Team

Rick Leffler

  • Guest
Re: Changing the Dues Amount
« Reply #2 on: September 19, 2011, 08:38:49 AM »
Dave is right about making the correction under Admin > Club Setup > Club Names, Logos, Dues and Points.  However, this will not automatically change any existing Fee records. You will need to open each Fee record and typeover the Amount to change it from $26 to $28, tab out of the Amount field, then Save And Close.

Or AFTER RUNNING THE BACKUP UTILITY:
you could run an SQL statement like:

update Fee set Amount = 28 where Amount = 26 and Club_Year = '2011-2012' and For_Dues=True

this will mess up the Balance Due on each affected Fee record though, so you will have to run the OPTIMIZE procedure (under Admin > Database Utilities) and select the Checkbox to "Recalculate the Balance Due on all Fees"

Just to be safe... do a screen print of the main Ledger > Fees grid BEFORE you try this. Then, when you're done, compare the results with the screen print to be sure the results are exactly what you expected.
« Last Edit: February 16, 2022, 09:08:02 AM by Annette »

aktaylor

  • Jr. Member
  • **
  • Posts: 12
Re: Changing the Dues Amount
« Reply #3 on: September 19, 2011, 12:14:16 PM »
Thanks for the advice guys I'll give it a shot.


David Taylor

« Last Edit: February 16, 2022, 09:08:09 AM by Annette »
Anchorage Grace Church Awana Club Database Admin

aktaylor

  • Jr. Member
  • **
  • Posts: 12
Re: Changing the Dues Amount
« Reply #4 on: September 19, 2011, 06:11:45 PM »
Thanks Rick for the SQL statement, and thanks Dave, for the other advice. :D My dues fees are fixed!!! ;D ;D ;D ;D ;D
« Last Edit: February 16, 2022, 09:08:15 AM by Annette »
Anchorage Grace Church Awana Club Database Admin