• Article Type: General
• Product: Aleph
• Product Version: 17.01

Description:
We have had a change in fines ceiling from $20 to $1. We have changed tab31 to reflect this, however, only when the record in updated in the GUI is the new fine applied. Is there a way to apply this change globally?

Resolution:
You can update the z305 records in SQL:

1. Make a backup of the z305 file using p_file_03 (Circulation - Services - Manage Database Tables), so that you can restore the table if there's a problem with your SQL
2. Run a command in sql like the following:

update z305
set Z305_CASH_LIMIT='0000000100';
Follwed by this command:
commit;

This will change the limit for ALL your local patron records. If you need to limit it to specific patron statuses you should add the following line after the 1st line:

where Z305_BOR_STATUS=nn

(nn is the patron status number concerned)

I would also recommend doing this on the test server before you do it on the production server.