Create a report variabled called rnBalance. Mark it to reset on a data group that matches up with your Code field. Set the Intial Value to party.balance (or whatever the opening balance field is called). Set the value to store to (Debit - Credit). Mark it as sum.
This should start the variable with the beginning balance, and then add the debits and subtract the credits for each detail record it processes.
Cathy
>I want to generate a report. I got a table for it. The Table contains the following fields:
>
>1. Reference
>2. Date
>3. Description
>4. Debit
>5. Credit
>
>The Report should be as follows:
>
>Code: CA001 ABC International Ltd.
> P.O. Box 1295, Dubai, UAE
>___________________________________________________________________________
>Date----------Reference--------Description---------Debit--------Credit--------Balance
>___________________________________________________________________________
>
>01/01/2004--Opening Balance--------------------------------------------------5,000 DR
>10/01/2004--CR101244-------Received Cash-----------------2,000------3,000 DR
>15/01/2004--SI349072-------Sales Invoice-------1,500--------------------4,500 DR
>17/01/2004--BR320944-------Paid By Chq.No.---------------4,000--------500 DR
>
>**************************************************************************
>
>I just wanted to know, how can I calculate the balance column. Please note that the Opening balance comes from Party master file (Party.dbf) and the field name is obal.
>
>Please help !
>
>Thanks - Saif