How to get start balances a account number?

  • tuongnd
  • Topic Author
  • Offline
  • New Member
  • New Member
More
14 years 6 months ago #7712 by tuongnd
Please show me
Can I select in ACCT.ACTIVITY?

Please Log in or Create an account to join the conversation.

  • tuongnd
  • Topic Author
  • Offline
  • New Member
  • New Member
More
14 years 6 months ago #7713 by tuongnd
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

Please Log in or Create an account to join the conversation.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • retired . . . ¯\_(ツ)_/¯
More
14 years 6 months ago #7720 by jpb
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