How to get start balances a account number?
- tuongnd
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 7
- Thank you received: 0
14 years 6 months ago #7712
by tuongnd
How to get start balances a account number? was created by tuongnd
Please show me
Can I select in ACCT.ACTIVITY?
Can I select in ACCT.ACTIVITY?
Please Log in or Create an account to join the conversation.
- tuongnd
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 7
- Thank you received: 0
14 years 6 months ago #7713
by tuongnd
Replied by tuongnd on topic Re: How to get start balances a account number?
LIST FBNK.ACCT.ACTIVITY WITH @ID EQ ...
TURNOVER.CREDIT.... 3675869645 41518569 2130945000 26691300 39967264 7389000 27255350 8000000 165258609
5550000 12770000 5538555 42371964 14392650 23700000 656200000 12061333334 2425774600
27157690 60520000
TURNOVER.DEBIT..... -1927481500 -3276844265 -249249786 -288420302 -19474367 -30702087 -27995987 -5536196
-575330000 -102500000 -53000000 -7872075 -18388948 -414738712 -190436238 -713715767
-14241794891 -598486542 -213870093 -134828091 -14480442
BALANCE............ -5355988063 -4956962683 -5164693900 -3322169202 -3314952269 -3305687092 -3326294079
-3299038729 -3304574925 -3296574925 -3706646316 -3803596316 -3843826316 -3846159836
-3822176820 -4222522882 -4389259120 -4446774887 -6627236444 -4799948386 -5013818479
LIST FBNK.ACCT.ACTIVITY WITH @ID EQ VND1000100010001... BY @ID PAGE 7 04:44:09 19 MAY 2011
-5121488880 -5075449322
TRANSACT.CODE...... 1 51 213
NO.OF.TRANSACT..... 6 20 232
TRANSACT.AMT....... -10527205746 320918464 8559344523
VALUE.DAY..........
BOOKING.DATE.......
BOOK.TOVR.CR.......
BOOK.TOVR.DB.......
TRADE.DATE.........
TRADE.TOVR.CR......
TRADE.TOVR.DB......
BK.DAY.NO.......... 01 02 03 04 07 08 09 10 11 14 15 16 17 18 21 22 23 24 25 28 29
30 31
I can select get start balances depend on days by
BK.DAY.NO is day
BALANCE is get start
example
from 2010/10/10 to 2010/10/31 then start balance is -3296574925
TURNOVER.CREDIT.... 3675869645 41518569 2130945000 26691300 39967264 7389000 27255350 8000000 165258609
5550000 12770000 5538555 42371964 14392650 23700000 656200000 12061333334 2425774600
27157690 60520000
TURNOVER.DEBIT..... -1927481500 -3276844265 -249249786 -288420302 -19474367 -30702087 -27995987 -5536196
-575330000 -102500000 -53000000 -7872075 -18388948 -414738712 -190436238 -713715767
-14241794891 -598486542 -213870093 -134828091 -14480442
BALANCE............ -5355988063 -4956962683 -5164693900 -3322169202 -3314952269 -3305687092 -3326294079
-3299038729 -3304574925 -3296574925 -3706646316 -3803596316 -3843826316 -3846159836
-3822176820 -4222522882 -4389259120 -4446774887 -6627236444 -4799948386 -5013818479
LIST FBNK.ACCT.ACTIVITY WITH @ID EQ VND1000100010001... BY @ID PAGE 7 04:44:09 19 MAY 2011
-5121488880 -5075449322
TRANSACT.CODE...... 1 51 213
NO.OF.TRANSACT..... 6 20 232
TRANSACT.AMT....... -10527205746 320918464 8559344523
VALUE.DAY..........
BOOKING.DATE.......
BOOK.TOVR.CR.......
BOOK.TOVR.DB.......
TRADE.DATE.........
TRADE.TOVR.CR......
TRADE.TOVR.DB......
BK.DAY.NO.......... 01 02 03 04 07 08 09 10 11 14 15 16 17 18 21 22 23 24 25 28 29
30 31
I can select get start balances depend on days by
BK.DAY.NO is day
BALANCE is get start
example
from 2010/10/10 to 2010/10/31 then start balance is -3296574925
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2860
- Thank you received: 650
14 years 6 months ago #7720
by jpb
Replied by jpb on topic Re: How to get start balances a account number?
There is a core routine to get the balance for a specific date, something like GET.ACCT.BAL (have nor system access currently).
Please Log in or Create an account to join the conversation.
Time to create page: 0.026 seconds