ES237 (Unbalance 13.2)
I've had several questions about a common unbalance issue on the printed ES237 reports--The total on Chart 13.2 line 13 is a bit higher than the totals on page one. It takes a bit of sleuthing, but can usually be solved with some good detective work.
Normally what’s happened is you have some folks marked as members, clovers, or special who have one club membership, and that club is marked as “not a youth group unit”. Many times I find that these are “special” category, and they’re people who should be marked as “other”.
When I go through county files looking for that error, the first thing I do is note which club numbers are “not a youth group unit” from the club codes screen. Then I go to Member query and do a filter on category=S and look to see if any of them belong to one of those clubs. That finds the problem about 75% of the time.
If that doesn’t do it, then I do a filter in Member query on clubID= (each of the “not a youth group unit” numbers) and look for people who are members of those clubs and are marked as members, clovers, and specials. That catches most of the rest of them.
The other thing I do is to go to the ES237 report, and instead of doing the complete/combined, I do Test Member/Leader by Club, previewing each club report. At least that way I can narrow down which club(s) are causing the unbalance issue, and can look at their members to find the problem.
If you find that you have this unbalance issue, try these suggestions to find the culprit. If you absolutely cannot find the problem, send me a brand new backup and tell me what's happening, and then I can find it for you!!