T24: Account Balances on Dates Range

[gabalian]

Hi,

I am looking for any routine/function which can return account balances on dates range. I used EB.GET.ACCT.BALANCE(ACCT.ID,R.ACCT,'BOOKING',Y.DATE,'',ACCT.BAL,CR.MVMT,DB.MVMT,ERR.MSG) but it provides account balance on a particular date not on the range of dates.
I would really appreciate any help.

--
Imran Khan
T24 Technical Consultant

[Srinivas]

Hi,

Make use of EB.ACCT.ENTRY.LIST with the necessary parameters passed.

 

EB.ACCT.ENTRY.LIST (ACCOUNT.NUMBER,FROM.DATE,END.DATE,ID.LIST,OPENING.BAL,ER)

ID.LIST gives the statement entries .By this you can achieve your requirement.

 

2009/12/11 gabalian <gaba...@gmail.com>

--
Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines
 
IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24
 
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

--
SrinivasYadav. G
Mobile No: 00966 - 564991072

[Igor Micev]

Hi,

I have used EB.ACCT.ENTRY.LIST() recently. Be careful, it gives you the balance on the start date (FROM.DATE). So to have the balance in a Dates range, you have to LOOP all the STMT.ERTNY ids (ID.LIST) and sum the amounts (Credit or Debit, depends what you need).

Igor Micev

[gabalian]

Thank you very much Srinivas for ur help and support. Can u tell me if "OPENING.BAL" provides the opening balance of the
"END.DATE" or it provides the average balance???

+92 334 3545114

[Ram shankar]

OPENING.BAL return parameter will have opening balance on start date.

 

Many Regards, Ram

[VK]

Hi,
I believe you can also use ACCT.ACTIVITY application

Happy NY!

VK

On Dec 13, 9:54 am, Ram shankar <ram.r.shan...@gmail.com> wrote:
> OPENING.BAL return parameter will have opening balance on start date.
>
> Many Regards, Ram
>

> On Sat, Dec 12, 2009 at 9:57 AM, gabalian <gabal...@gmail.com> wrote:
> > Thank you very much Srinivas for ur help and support. Can u tell me if "*
> > OPENING.BAL*" provides the opening balance of the *
> > "END.DATE"* or it provides the average balance???

>
> >  On Fri, Dec 11, 2009 at 9:35 PM, Srinivas <srinivasyada...@gmail.com>wrote:
>
> >>  Hi,
> >> Make use of EB.ACCT.ENTRY.LIST with the necessary parameters passed.
>

> >> EB.ACCT.ENTRY.LIST (*
> >> ACCOUNT.NUMBER,FROM.DATE,END.DATE,ID.LIST,OPENING.BAL,ER)*

> >> ID.LIST gives the statement entries .By this you can achieve your
> >> requirement.
>

> >> 2009/12/11 gabalian <gabal...@gmail.com>

>
> >>> Hi,
>
> >>> I am looking for any routine/function which can return account balances

> >>> on dates range. I used *EB.GET.ACCT.BALANCE(ACCT.ID <http://acct.id/>
> >>> ,R.ACCT,'BOOKING',Y.DATE,'',ACCT.BAL,CR.MVMT,DB.MVMT,ERR.MSG)* but it