General information
Category:
Reports & Report designer
Title:
How to calculate balance in balance column
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
Next
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