If switching between screens on one record corrects the YTD field but
running the Replace All Find Fields script doesn't, then the fix for the
bug in that script (which you allude to) was improperly implemented.
This is because the Home script (or Home button which runs that script)
calls up the Replace Current Find Fields script which had a correct
calculation. Go back to the fix (I'll paste instructions below) and try
it again. You must do it carefully.
Carl
*************
Jack's Bug Fix:
Get into ebase using your master password. Once you're on the HOME
screen, select
File->Define->Fields. Double-click on the field named "SUM::Current
Fiscal
Year". You will see a "Specify Calculation" dialog box appear.
The correct calculation for this field is as follows:
If( Month(gToday) >= setup::Fiscal Year Number and setup::Fiscal Year
Number > 1, Year(gToday) + 1, Year(gToday))
If the calculation for your field reads differently, you should correct
it (copy and paste the calculation above). After doing so, you should
run the "Replace All Find Fields" script, leaving the date blank so that
it runs for your entire file.
**************
Eric Johnson wrote:
>
> I'd thought that updating the find fields (under the admin screen) would
> work for this, but am not so sure. Some time back a colleague noticed that
> YTD$ and Last Year $ values were incorrect in her implementation of 1.02.
> This apparently was due to a bug in 1.02. Unfortunately, after doing this
> fix there's still a problem with these fields. When she opens her ebase up
> and scrolls down to a record with some payments this year and last, YTD $
> (including only dues & contributions, not purchases) is still incorrect, and
> Last Year $ is as well. Oddly, the values in these field on the HOME screen
> change after one views the payments for that record and then returns HOME.
>
> I realize this is an unusual specific problem. Does anyone have any ongoing
> experience with the 1.02 fix for YTD $ & Last Year $ ??? I checked & double
> checked that I'd done the fix as listed, but the result is still off...
>
> Thanks if you can help.
>
> Eric Johnson
> Colo. Env. Coalition
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 14, 2001 1:34 PM
> To: TechRocks Support
> Subject: [support] YTD $
>
> I am operating with Ebase v 1.02 and need to update all of my records so
> that the YTD $ field is for this current year (2001). I cannot seem to
> find this script or command. I have been able to update individual records
> with the script "Update Status from Payments," but would prefer to update
> all 5000+ records with one command/script.
>
> Stacey Anderson
> Montanans for Choice
>
> ------------------
> Reminder to each recipient: To change your list account preferences, go to
> http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the
> email address you used to subscribe to the ebase support list::
> [EMAIL PROTECTED]
>
> To unsubscribe send a blank email to [EMAIL PROTECTED]
> ---------------------------------------------------------------------
> ebase - Relationship Management for Nonprofits, http://www.ebase.org
> ---------------------------------------------------------------------
>
> ------------------
> Reminder to each recipient: To change your list account preferences, go to
> http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email
>address you used to subscribe to the ebase support list:: [EMAIL PROTECTED]
>
> To unsubscribe send a blank email to [EMAIL PROTECTED]
> ---------------------------------------------------------------------
> ebase - Relationship Management for Nonprofits, http://www.ebase.org
> ---------------------------------------------------------------------
--
Carl Paulsen
New Hampshire Rivers Council
54 Portsmouth Street
Concord, NH 03301
603-228-6472
603-228-0423 Fax
[EMAIL PROTECTED]
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address
you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
