Trying the attachment again ...
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "No Thirst Software User Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/no-thirst-software?hl=en -~----------~----~----~----~------~----~------~--~---
-- Script to output "Cleared/Reconciled" account balance (excludes "Open" and "Pending" transactions) -- Note: assumes you have no split transactions in "Open" status select sum(zt.zamount) from ztransaction as zt,zaccount as za where zt.zaccount = za.z_pk and za.zname = "Checking" and zt.zdate >= (select zdatein from zrollover where zisinitialrollover = 1) and (zt.ziscleared = 1 or zt.zisreconciled = 1 or zt.zissplitchild =1) and zt.zispending = 0; .exit
