General Ledger Export; review and try to lessen impact of database locking

The General Ledger Export has been updated to lessen the impact of database locking.

Note, the General Ledger Export operates as two phases:

1. Create the General Ledger Export Batch Header record and link relevant Account Transactions (Journals), Accounting Ledgers, Bank Transactions and Bank Suspense Items to this.
2. Export the General Ledger Batch created in the first phase.

On large databases the first phase can cause database locks to stall other processes, especially when processing Bank Transactions.

Currently Database Transactions are used for each major process, i.e. Account Transactions (Journals), Accounting Ledgers, Bank Transactions and Bank Suspense Items.

Now, for Bank Transactions, a Database Transaction is no longer used for the entire process, rather only for each Bank Transactions and related Account Transactions - therefore minimising the effect of database locking.

In addition, the Audit Log now records number of:

• Accounting Ledgers Processed
• Bank Transactions Processed
• Bank Suspense Items Processed
• Journals Processed