This note gives a guide line on relation between "Client Balance" and "Principal Balance"

12.1. When a Margin Client buy/sell a stock, the transaction amount will be updated
      to the "Client Balance" at transaction date, and the trans will be added to a
      separate file called "Portfolio Unsettled Tran File"

12.2. When SB calculates interest of a Margin Client, it reads the "Client Balance"
      from "Client Master" (LBALBF + LBALMTD).Then it reads the"Portfolio Unsettled
      Tran File" to find out any UN-DUE trades.

The "Principal Balance" can be determined by :- "Client Balance" - "UN-DUE Balance"

12.3. The "No of Interest Days" is derived from:- The date before "Next Trade Day"
      - Current Transaction date + 1

12.4. For AFH Case, please check the SB data files for exceptions

12.4.1. Since the SB system is set the trans date as:

Transaction Date: 01/01/95
Next Trade Date: 03/01/95
Settlement Date: 04/01/95
It is assumed that on running daily updating, the SB will calcuate the interest for 01/01/95 to 02/01/95 (2 days)

12.4.2. Check the Client Master, the "Balance B/F" should store the "Balance C/F"
        + "December Interest" from old BOS system.

You can edit the "Balance B/F" in the "Repair Client Master" screen (Option "1"
of "Data File Repair" menu)

12.4.3. Make sure that the client a/c no should be globally changed from "A"
        account to "P" account. Make sure the "Interest Rate Table" is setup
        properly. Make sure the "Interest Code" in "Client Master" is setup
        properly (i.e. it relates with a valid interest rate in "Interest Rate
        Table")

You may use the FOXPLUS command to globally set the interest code in "Client Master":-
CD \SB
FOXPLUS
USE CLMAST
REPL ALL LICODE WITH '01' FOR LACCT='P'
REPL ALL LICODE WITH '02' FOR LACCT='M'
(note: the '01' & '02' are interest codes for example)
QUIT

12.4.4. Next check the Client Master Interest date, it should be empty or 31/12/94.
        You can get this value on the "Repair Client Master" screen. If this value
        is not equal to either one, please change it by using FOXPLUS:-

CD \SB
FOXPLUS
(at the "DOT" prompt, key in)
USE CLMAST
REPL ALL LIDATE WITH CTOD(' / / ')
QUIT

12.4.5. Next check the "Portfolio Unsettled Tran File" (option "M" of "Data File
        Repair" menu) to see if it contains the B/S transactions of:-

Transaction Settlement
Date     Date
29/12/94 03/01/95
30/12/94 04/01/95

Pay attention to t "Client A/C No", this should be changed from "A" account to
"P" account.

12.4.6. Make a backup to floppy disk.

12.4.7. There should be no daily transactions: B/S/P/R. Run the Daily
        Transaction/Report/Update cycle.

Then the SB should be able to calculate the 01-02/01/95 interest

Copyright © 1998, POP ELECTRONIC PRODUCTS LTD. All rights reserved.