Article Details
Id:10131
Product:finPOWER Connect
Type:FIX
Version:1.05.07
Opened:29/05/2012
Closed:08/06/2012
Released:15/06/2012
Job: J009714

Report Templates and Queries using the Account List may not show Interest Rate

Including the Interest Rate column from the Account List query in a Report Template may result in no interest rates printed.

If the Interest Rate column is added to a Report Template as a Type Number, ensure the 'Decimal Places' is set, i.e.; not zero.

Work Around: This is not an issue if any of the following columns are also included:

  • AccruedInterest
  • AllocatedFeeIB
  • AllocatedFeeNIB
  • AllocatedInterest
  • AllocatedPrincipalIB
  • AllocatedPrincipalNIB
  • AmountFinanced,ResidualValue
  • BalanceOverdueToday
  • BalanceReversed
  • BdmUserId
  • BdmUserPk
  • CreditLimit1
  • CreditLimit2
  • CreditLimit3
  • PendingWithdrawls
  • UnclearedFunds
  • AvailableCredit1
  • AvailableCredit2
  • AvailableCredit3
  • LastPaymentDate
  • LastPaymentValue
  • NetBalance
  • NextPaymentDate
  • NextPaymentValue
  • OverdueDays
  • PaymentBalloon
  • PaymentCycle
  • PaymentCycleDescription
  • CurrentInterestRate
  • ClosedToAccountId
  • CreatedFromAccountId