General information
Category:
Reports & Report designer
>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
You should create a variable in the report designer(Reports -> Variables) let say MBALANCE
initial value : party.obal
Value to store: debit-credit
calculate: Sum
The source in the balance column should be MBALANCE
Hope it helps
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only