Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers

Improvements to Statement Print Locking

Datafile Software

Improvements to Statement Print Locking

If an account statement is set to flag back to the account record – to update last statement date, statement page number or Credit Control flag – then the system requires exclusive access to the sales accounts file when doing a statement run.


This new option allows the ability to use record locking rather than file locking for statement production. This allows the system to process a statement for all required accounts but skipping any that are exclusively locked by another operator and reports at the end of the procedure if any accounts not processed. Missed accounts can be reprocessed later by running the statement on a selective basis (perhaps using the statement date not equal to ‘today’).

Installation

Document Design Manager

A new parameter has been added to the statement design to omit file locks for the statement print.To update the Document Design select Installation from the main menu followed by the Application Manager option and then Document Design Manager. Select the Sales Ledger application and the Statements document type.Select the document to be updated and then, once the document mask is displayed, select the Parameters option on the main toolbar – the new option is available on the first parameter screen.


Omit File Locks – set to omit exclusive file locks when the statement definition is run but to apply record locks to the accounts.

File / Record Locking

In processing a statement the system applies U-usage locks to the accounts and transaction files. As each account is processed the system applies a U lock on the account record and, for the update, places a W-wait lock on the transaction file whilst updating the account record before releasing the W lock and then releasing the U lock on the account record. The system then repeats this process for each account to be processed. Only accounts which are exclusively locked by another process will be omitted.

Custom Fields
  • Release ID: 6.6
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Increased Number of Entries in Allocations
Viewed 2564 times since Fri, Jun 8, 2012
Fuel Scale Charge Posting
Viewed 5745 times since Fri, Oct 12, 2018
Automatic Generation of Payments (P/L only)
Viewed 2332 times since Wed, Jun 13, 2012
Inserting New Items - Document Design Manager
Viewed 2902 times since Mon, Jul 2, 2012
Account Optional 3 - Database Profiles
Viewed 3034 times since Mon, Jul 2, 2012
Validate Invoice Entry against Job Budgets (P/L only)
Viewed 2659 times since Wed, Jun 13, 2012
Credit Control Manager - Selection Criteria for Accounts
Viewed 3076 times since Fri, Jun 8, 2012
Aged Analysis of Debtors / Creditors
Viewed 4048 times since Mon, Jul 2, 2012
Nominal Asset Account Validation
Viewed 2933 times since Wed, Jun 13, 2012
Account and Transaction Pick Lists
Viewed 2932 times since Mon, Jun 11, 2012