The purpose of the Financial Database Lock feature is to allow the operator to "lock" the finance portions of the database, up to a given date, to prevent any changes to the database which would affect financial totals prior to that date. Once locked, any actions which would affect the financial figures, such as adding/deleting/modifying invoices, applying credits notes (with dates prior to the lock), etc. will be blocked and an error message will be given.
Users with appropriate rights will be allowed to set the database lock date. Once set, the lock cannot be removed, and so caution should be exercised when setting the lock. A lock cannot be set for any date earlier than any previous lock, and cannot be set for a date later than "yesterday" - i.e. the new lock date must fall between any previous lock date and "yesterday's" date.
Only users who have rights to access the financial database lock will be able to update the lock date. Access to the lock date is controlled by a new "lock database" user right, set in the "users" tab - see Figure 1 below.
Figure 1. Lock database user right
When a user with the "lock database" right goes to the "invoices" tab, a new section called "Financial Database Lock" will appear below the "Financial Figures" section (see Figure 2 below). This section will not appear for users who do not have the "lock database" user right set.
Figure 2. Finance Database Lock settings
The new section indicates if the database is locked (1), and if so, who set the lock and up to what date it is locked. The lock date can be updated by selecting a new date from the calendar (3) and clicking the "Set Database Lock Date" button (2). A warning will be issued, and if OK is clicked the new database lock date will be set. An error message will be displayed if there are any problems with the new date - for example if you try to set a date earlier than any existing lock, or a date into the future.
Once the date has been set, any actions on or prior to that date will be blocked.
[An audit trail is maintained in the database, so changes to the lock date may be tracked]
First / Recurring Invoices
If a data base lock is set, and an attempt is made to generate a "first" or "recurring" invoice with a date prior to the lock date, the invoice will not be generated and an error message will be displayed for that particular invoice - see Figures 3-5 below.
Figure 5. Invoice not generated
If this error is displayed for a "first" invoice, you can return to the "First Invoices>>" page and adjust the "Start Date" to be a date later than the database lock date (see Figures 6-7 below).
Figure 6. The "First Invoices" button
For "recurring" invoices it would be necessary to add credit days to the customer's account in order to shift the next invoice date to be a date later than the database lock date (see Figures 8-11 below).
Figure 11. Update Customer after making changes
Figure 12. The "Create Custom Invoice" button
Figure 14. Custom/External invoice not generated
Credit notes may be used to credit out invoices prior to the database lock date. However, the credit note date must be after the lock date. If not, the credit note will not be generated and the following error will be displayed (see Figures 15.1 - 15.5 below).
The processing date for EFT / non-EFT payments and batch credit card payments is verified, and if it is prior to the database lock date, the batch file is not processed and the following error messages is generated (see Figures 17-18.2 below).
Figure 18.2 EFT/non-EFT payments
Modifications and deletions will not be allowed to lodgement details if the date of the lodgement is prior to the database lock date (see Figures 19-21 below) - the "Update Lodgement" button will be disabled, and the "Delete Lodgement" button is removed in this case.
The payment amounts and payment status of individual payments made under a lodgement may not be updated if the lodgement date is prior to the database lock date. This is done by disabling the "Process" buttons on the page - a warning note at the end of the pay will indicate why the "Process" button has been disabled (see Figures 21-23 below).
By default when loading a pre-payment against an invoice, the date of the lodgement will be set to the date that the pre-payment was created. If this date is prior to the database lock date, the lodgement will be prevented. The lodgement date can then be adjusted to be a date later than the lock date, and the pre-payment can then be re-applied. Figure 24 below shows a sample of where an attempt was made to lodge two prepayments - one was successful and the other was blocked as the date was not valid.
If a Credit or Pre-payment is dated before the the database lock date, the "Update" and "Delete" buttons on the modify page will be disabled to prevent changes to the credit/pre-payment (see Figures 25-27 below).
Likewise any attempt to change the date of a credit/pre-payment to be before the database lock date will result in the operation being blocked and an error message will be displayed (see Figures 28.1 - 28.4 below).
Figure 28.4 Modification of date blocked
Azotel | River House | Blackpool Park | Cork | Ireland