Hey Matt, This is pretty slick! Since I had a lot of manipulation I wanted to do for email purposes I lazily put most of the logic inside my Perl script, but this pushes most of the logic into the SQL itself, which is much more portable.
Regarding the pending transactions, if you typically hide all future transactions, you can ignore them as you have done here to match the GUI. However, if you show future transactions, any ones that will occur in the current month will count against your bucket balances, which is why I do a separate query and use the last day of the current month in order to match the GUI when you pick "Show Future Pending Transactions". I like to see both numbers since the current amounts can be misleading. Good idea on grabbing the cash flow info from the ZROLLOVER table. I think I'll update my script to do this as well so I don't have to hardcode these numbers in. -Lance --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
