× Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...

I NEED A EXAMPLE ROUTINE (USE CALL EB.GET.ACCT.BAL

  • tuongnd
  • Topic Author
  • Offline
  • New Member
  • New Member
More
13 years 8 months ago #8744 by tuongnd
CALL EB.GET.ACCT.BALANCE

Description: This routine will return an account balance of a given type on a given date and can return the balance as at a requested system date too (ie. Without adjustments).

The routine obtains the balances by using the correct ACCT.ACTIVITY
record for the date requested.

If a BOOKING.DATE balance is requested for a date less than or equal to the BK.BAL.START.DATE from the DATES file, the routine will return the booking dated balance for the BK.BAL.START.DATE. Since the routine returns the opening balance for a date one calendar day must be added to the requested date to pass into the routine so that the closing balance is returned:




Arguments: ACCT.ID, ACCT.REC, BALANCE.TYPE, BALANCE.DATE, SYSTEM.DATE, BALANCE, CREDIT.MVMT, CREDIT.MVMT, DEBIT.MVMT, ERR.MSG




Incoming:


ACCT.ID Account Number

ACCT.REC Account record

BALANCE.TYPE ‘VALUE’, ‘TRADE’ or ‘BOOKING’

BALANCE.DATE Date balance is required for (YYYYMMDD), will default to Today if left blank

SYSTEM.DATE Optional date as of system date

what is "ACCT.ID Account Number"?
what is "ACCT.REC Account record"?

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

  • tuongnd
  • Topic Author
  • Offline
  • New Member
  • New Member
More
13 years 8 months ago #8746 by tuongnd
I USE SAME FUNCTION
ACCOUNT.NUMBER = 'VND1000100010001'
FROM.DATE = '20101230'
END.DATE = '20101230'
ID.LIST = ''
OPENING.BAL = ''
CALL EB.ACCT.ENTRY.LIST(ACCOUNT.NUMBER,FROM.DATE,END.DATE,ID.LIST,OPENING.BAL,ER)
CRT OPENING.BAL

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

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • retired . . . ¯\_(ツ)_/¯
More
13 years 8 months ago #8750 by jpb
ACCT.ID is the account number
ACCT.REC is the actual read record from ACCOUNT for ACCT.ID (must be read before calling)

Search for EB.GET.ACCT.BALANCE.TEST in PROGRAM.FILE, set it to TYPE = M and try out in classic.


What about the second post ???

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

Time to create page: 0.053 seconds