- Forum
- T24 Technical Discussions
- T24 Development & Customization
- I NEED A EXAMPLE ROUTINE (USE CALL EB.GET.ACCT.BAL
×
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
-
Less
More
- Posts: 7
- Thank you received: 0
13 years 8 months ago #8744
by tuongnd
I NEED A EXAMPLE ROUTINE (USE CALL EB.GET.ACCT.BAL was created 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"?
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
-
Less
More
- Posts: 7
- Thank you received: 0
13 years 8 months ago #8746
by tuongnd
Replied by tuongnd on topic Re: I NEED A EXAMPLE ROUTINE (USE CALL EB.GET.ACCT.BAL
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
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
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
13 years 8 months ago #8750
by jpb
Replied by jpb on topic Re: I NEED A EXAMPLE ROUTINE (USE CALL EB.GET.ACCT.BAL
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 ???
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.
- Forum
- T24 Technical Discussions
- T24 Development & Customization
- I NEED A EXAMPLE ROUTINE (USE CALL EB.GET.ACCT.BAL
Time to create page: 0.053 seconds