| Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers |
Improvements to Statement Print Locking |
|
Article Number: 1905 | Rating: Unrated | Last Updated: Mon, Jun 19, 2023 at 3:23 PM
|
|
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’). InstallationDocument Design ManagerA 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. |
Attachments
There are no attachments for this article.
|
Discount and Supplier Matrix Prevent Sale of Items to Selected Customers
Viewed 3326 times since Fri, May 20, 2016
Account Currency Turnover - Database Profiles
Viewed 2746 times since Mon, Jul 2, 2012
Customers / Suppliers
Viewed 2477 times since Fri, Jun 29, 2012
Cheque Printing (Purchase Ledger) - Application User Facilities
Viewed 2558 times since Mon, Jul 2, 2012
Sub-Contractor Accessory - Multiple Job Analysis
Viewed 2369 times since Mon, Jul 2, 2012
Edit System Status Display
Viewed 2125 times since Mon, Jul 2, 2012
Extra File Scans
Viewed 2650 times since Mon, Jul 2, 2012
Customer Profitability (Sales Ledger)
Viewed 2682 times since Mon, Jul 2, 2012
Group Account Credit Limit Checking Sales Ledger Only
Viewed 7202 times since Mon, Mar 2, 2020
Statements
Viewed 2545 times since Mon, Jul 2, 2012
|



