Visa Balancing Program

[CeeEssGee]

I'm working on a program for our office to make balancing the Visa a bit easier. Its fairly simple, and doesn't need many protections from user error, although I guess in the future a reliable annual report would be nice.

This is what I have so far, but the one thing I am having trouble with is providing subtotals (For GST, Post, and Total) for each "category", being the account names. The post amount is the amount we need to pay, the GST is the tax (that we don't have to pay; it's the 8% PST tax that we do have to pay). Any ideas how I can get this to work, easily? I don't want to have to flip between three different windows just to put in an account name (like my "Law Office Database"), but to be able to just put it in on a quick drop down list.

BalanceVisa.zip

[Reed]

What you want are filtered portals.... I created a duplicate of your layout and a few fields and added a global field to with a popup list to control which accounts are displayed.

If you want to see all the charges with subtotals for each account on one page, I would suggest creating a report with subsummary parts using the expenses table

BalanceVisa.fp7.zip

[CeeEssGee]

Ah, that helps, thanks! Whenever I make the summary reports though, it doesn't register the account names at all. Its in preview mode, the values and descriptions are all there, but there is a spot for account names and nothing there (this is from expenses). Also, how would I be able to filter this preview to only preview for that specific monthly report?

[Reed]

I don't get why your account names don't show, but as far as showing reports for a specific month, just script a find that will result in only records for the desired month being in the found set.

[CeeEssGee]

Bleh, this is really annoying. I can't figure out why these account names won't show on the grouped report..

[CeeEssGee]

Anyone? Nothing seems to work.