Alpha Video Training
Results 1 to 4 of 4

Thread: Cash Activity report

  1. #1
    Member
    Real Name
    Gary Soltani
    Join Date
    Sep 2008
    Posts
    2

    Default Cash Activity report

    Hi, I’m a new user of QReport Builder, and I’m trying to create a cash register report that will print the individual bank account registers as well as a combined report that will show the total cash position. The report needs to prompt selection of account and date range for the period that the report need to run for. The summary of the key requirement of report is as following:

    • Account(s): a drop down widow with option of accounts to be selected, either by group or individually

    • Date range: From and Through

    • Beginning/Forward Balance: which should be the ending balance from the prior day of starting date range.

    • Line items: detail and /or summary of the transactions in group type with subtotals; such as deposits, checks, wires and transfers, adjustments/ JE’s.

    • Ending balance: which should be the ending balance of the register for the last day of selected date range.

    Any comments or directions as to how to approach in creating this report will be appreciated.

    Thanks
    Gary
    Last edited by GarySol; 09-04-2008 at 02:43 PM.

  2. #2
    "Certified" Alphaholic
    Real Name
    Mike Christensen
    Join Date
    Nov 2005
    Location
    Michigan U.P.
    Posts
    5,937

    Default Re: Cash Activity report

    Hi Gary,
    Without specific questions I can only give general answers/help. One thing for certain is that this report is by no means a basic or simple one---but is definitely doable.

    • Account(s): a drop down widow with option of accounts to be selected, either by group or individually

    • Date range: From and Through
    I'd use dialog boxes for both of these.

    • Beginning/Forward Balance: which should be the ending balance from the prior day of starting date range.
    • Ending balance: which should be the ending balance of the register for the last day of selected date range.
    Using the variables generated from the date range dialog box that is created, these values can be obtained--one likely way to use these values then in the report would be to use subreports as then a separate filter could be used from the rest of the report.

    • Line items: detail and /or summary of the transactions in group type with subtotals; such as deposits, checks, wires and transfers, adjustments/ JE’s.
    Just have to determine what tables have the data you desire, create a set, if need be, for multiple tables. The genie can create most of the totals for any grouping wanted, subtotals, grand totals, whathave you.



    Note: If a "ton" of records are being refreshed from Quickbooks then a bit more advanced techniques can be used by only bringing over the records and columns that are needed from Quickbooks. This is done usually if a report is to be generated several times during the course of a day and / or the use of "live" data is needed.
    Last edited by MikeC; 09-04-2008 at 09:55 PM.
    Mike
    __________________________________________
    It is only when we forget all our learning that we begin to know.
    It's not what you look at that matters, it's what you see.
    Henry David Thoreau
    __________________________________________




  3. #3
    Member
    Real Name
    Gary Soltani
    Join Date
    Sep 2008
    Posts
    2

    Default Re: Cash Activity report

    Hi Mike,
    Thank you for your comments. I was able to create the date dialog box. However, I’m having difficulty finding the right expression to prompt the account selection. I have tried the following three expressions but none of them are valid.

    Account range expression:
    • Accountreffullname = "INVESTMENT INCOME:CNB-Interest Income"
    • Accountreffullname = Var->askC_Account
    • "INVESTMENT INCOME:CNB-Interest Income"

    How would I go about creating the drop down account selection?
    Gary

  4. #4
    "Certified" Alphaholic
    Real Name
    Mike Christensen
    Join Date
    Nov 2005
    Location
    Michigan U.P.
    Posts
    5,937

    Default Re: Cash Activity report

    Gary,
    I don't know how you attempted to create the xdialog box so am at a loss. I just created one on a test database using the "Multi-select List Box", set it to populate via a chosen table, filtered it by specific criteria (accounts containing the word "Labor") and ordered it. I then ran the script, selected two of the choices, and clicked OK. I then went into the interactive editor and put in my variable that was created when first creating the xdialog box with a question mark as prefix and hit the Enter key which will show what the variable contains. In my case it created the crlf list with the two choices I selected.

    ? vMulti_List
    =IS Labor
    FO Labor

    As I stated before, this is not the easiest first report, but with learning and diligence it can be done.

    If you have more specific questions I can most likely be of more help.
    Mike
    __________________________________________
    It is only when we forget all our learning that we begin to know.
    It's not what you look at that matters, it's what you see.
    Henry David Thoreau
    __________________________________________




Similar Threads

  1. When using netmailer, any activity hangs PC
    By imaddison in forum Alpha Five Version 7
    Replies: 4
    Last Post: 02-27-2009, 02:48 PM
  2. Cash flow report??
    By KathM in forum QReportBuilder
    Replies: 7
    Last Post: 08-18-2008, 10:28 PM
  3. Activity Record
    By Rob C in forum Alpha Five Version 5
    Replies: 5
    Last Post: 01-31-2004, 11:08 AM
  4. Mouse Wheel, Trap activity
    By russ Boehle in forum Alpha Five Version 5
    Replies: 2
    Last Post: 06-19-2003, 06:34 PM
  5. Strange Activity
    By Robert Adler in forum Alpha Five Version 5
    Replies: 4
    Last Post: 10-27-2002, 07:20 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •