Interest calculator / report for designated NOM accounts

This is a 3 part process:

NOM

IBR

INTNOM

IBR:

Interest rates need to be maintained for a Currency/Name/Date combination and any changes to the rate for a Currency/Name need to be maintained .

Example

Use a Name of LLOYDS for currency GBP and setup the opening date/rate for that combination;

GBP – LLOYDS - 01/03/2014 rate = 2.5

GBP – LLOYDS - 10/05/2014 rate = 2.75

NOM:

For any account that requires Interest Calculator, maintain the Interest Name cell on the grid with the IBR Name to be used e.g. LLOYDS, this entry will be validated with content of IBR (but not checking what currency is being used)

INTNOM:

There are 2 modes of report; Detail and Summary. The user selects date range and can optionally apply standard NOM filter.

The process will build  balances for each Document date for each combination of Currency/NOM accounts where the NOM Interest Name has been setup AND there are IBR associated rates available. The calculator/report can be run any time for any date range i.e. the data used is the content of NLIST = detail transactions. 

NOTE , this does mean that if back dated transactions are entered they will be included in the next report run.