Article Details
Id:11277
Product:finPOWER Connect
Type:NEW
Version:2.00.00
Opened:03/07/2013
Closed:03/07/2013
Released:04/10/2013
Job: J011792

Account Processes; option added to update Overdue Days on Accounts

For performance reasons the Account table includes two denormalised columns, OverdueFromDate and OverdueCFromDate. These can be used to display the number of days the Account has been overdue, e.g. as used in the Task Manager.

However, every time a Transaction is posted to an Account this information becomes outdated, and therefore is nulled. When this occurs, the overdue days is calculated the long way, i.e. loading transactions and calculating which transactions are overdue. This is a lot slower.

Under Global Settings, Accounts, General page, Account Process Options block there is a new setting "Update Overdue days at the end of Account Processes?". When checked, at the end of Account Processes the OverdueFromDate and OverdueCFromDate columns are recalculated and updated on the database. Note, this is a reasonably slow process - but may be preferred over letting these values be calculated the slow way when loading the Task Manager.

In addition there is a new Business Layer function "AccountOverdueDaysUpdate" in finAccountFunctions. This does the same thing as Account Processes, but can be easily called from a script, for example.