Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to calculate balance in balance column
Message
From
14/12/2004 12:31:37
 
 
To
14/12/2004 12:14:23
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 7
OS:
Windows XP
Network:
Novell 4.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00969067
Message ID:
00969160
Views:
14
Cetin, Balance is a report variable. Initially I store these variable in balance:

balance = party.obal + drldgr.debit - drldgr.credit

(drldgr = Name of the Customer Ledger Account table )

It show correct result only when there is no opening balance of the party. If there is balance, it everytime sum in the above mentioned balance formula. What I want is only one time it should add in balance and then it should calculate like:

balance + drldgr.debit - drldgr.credit

(As in balance opening balance is already stored)

Any suggestion please.

Thanks/Regards - Saif
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform