Subject: matching the "Stock Receipt" Qty against "Portfolio" Qty
13.1. Should exclude the "Undue Qty" (i.e. beyond valid date qty).
The SB "Transaction Date" & "Settlement
Date" is stored in
SBSYSFL.DBF :-
TR_DATE Date 8 Current Tran Date
ST_DATE Date 8 Current Settlement Date
The "Undue Trades" of SB are kept in a separate data file
MGNUNSTL.DBF :-
MACCT
Character 7
Client A/C No
MTDATE Date
8
Transaction Date
MSDATE Date
8
Settlement Date
MREF
Character 8
B/S Note No
MNAMT
Numeric 12
2 B/S Note Amount
MSTK
Character 15
Stock No
MSTKNO
Character 4 Stock Code
MQTY
Numeric
9 B/S Qty
to calculate "Undue" Qty from this file, exclude those trades
where: MSDATE>SBSYSFL->TR_DATE !
The Client Stock Position can be calculated from PFMAST.DBF
FQTYBF+FQTYTT
13.2. On calculate "Stock Receipt" Qty, present the "Undue
Qty" in a
separate column. Use the "Net Qty on Hand" to
check against the
"Net Qty on Hand" in Portfolio.
Stock Client Receipt Un-Due Net Qty Portfolio
No & Code A/C No & Name Qty
Qty
On Hand Net
Qty Variance
xxx xxxxx xxxxx xxxxxxxx (A)
(B)
(C)
(D) (E)
=(A)-(B) =(C)-(D)
For Variance > 0, means Client sold stock, but not presenting "Stock
Receipt"
to company for settlement.
For Variance < 0, means something wrong with either the "Stock
Receipt" Qty or
the "Portfolio" Qty.
It is because the Client Portfolio Qty has insufficient "Stock
Receipt" quantity
for reconcilation.
Or may be user forget to extract the SRTRAN.DBF from SB.
13.3. NOTE: Do not run the "Stock Receipt Matching" program in the
period "Update
Portfolio" but
before "System End" ! It is because the Current Date
PFMAST.DBF is updated,
but the MGNUNSTL.DBF is not yet updated.
| 主頁 | 公司簡介 | 產品系列 | 意見箱 | 常見問題解答 | 軟件下傳 | 最新消息 |
|
|||||||||||||||||
Copyright ©
1998, POP ELECTRONIC PRODUCTS LTD. All rights reserved.