Hello all,
I've got a question that pertains to either support list:
Our database has had several revisions to the member levels assigned
through the Setup Wizard. Now, when I print a Giving Level report, I
get printouts for the old levels which have since been deleted. It
appears that the member level is stored in the Level field in the
Payments file, which is calculated from the Level Calc field (which in
turn draws it's values from the setup file based on the member levels at
the time the payment is recorded and updated). The Names file merely
references this field in its Find Mbr Level field.
Thus, when you change the values in the member level list, you end up
with a growing list of levels in the Level field covering a wide range
of dollar values which all print in the Giving Level report (at least
the levels for the payments being reported on). It seems that if you go
back into payments entered under old member levels and run the Update
Level button, the values get corrected to the new levels.
This is a cumbersome way to get old payments to update to the new
levels. Is there an easier way to do this? It seems like this
"feature" should include a routine by which all payment levels can be
updated to the new member levels through a routine similar to the
"Replace All Find Fields" routine (which doesn't update the member
level, even though it is a calculated field). Users could opt to run
the routine based on a Start Date or leave the old payment levels alone.
The Update Level script - which reads: Set Field ("Level", "Level
Calc") - merely replaces the values in the Level field with the
calculated results from the Level Calc field.
I think we've settled on a member level in ebase that suits our needs -
for now - but need to make sure all payments entered so far are in sync
with these levels. Also, we will probably change these levels in the
future, and may want old payments to reflect these new catagories.
Can someone explain how the member level works and how I might update
all old payments to fit our new levels?
Carl
--
Carl Paulsen
New Hampshire Rivers Council
54 Portsmouth Street
Concord, NH 03301
603-228-6472
603-228-0423 Fax
[EMAIL PROTECTED]
