New transaction report - consolidates / creates composite if same description, has find capability and can convert annual data to daily amounts

[Pedro Albuquerque]

Thank all for your efforts.
Pedro
A Sáb, 11-03-2017 às 23:06 -0500, Cindy Doughty escreveu:
> Thanks to Christopher Lam for help testing with multiple currencies,
> Now
> have a revised version which should work with multiple currencies so,
> yet
> again please replace the old copy with this copy.
> 
> 
>   There is one known bug covered in the thread Report Generation.
> 
> > 
> >  You can reproduce the problem reliably in the following manner:
> > create
> > the
> > account Expenses:Test-Expenses. Create the account
> > Liabilities:Test-Liabilities. Create a transfer from
> > Liabilities:Test-Liabilities to Expenses:Test-Expenses of $100,
> > say. Since
> > everything balances, the net total of the two accounts should be
> > $0.
> > 
> > Run a transaction report including both accounts Expenses:Test-
> > Expenses
> > and
> > Liabilities:Test-Liabilities. If Options -> Display -> Sign
> > Reverses is
> > set
> > to None, the Grand Total on the report is $0, as expected. If
> > Options ->
> > Display -> Sign Reverses is set to Credit Accounts, the Grand Total
> > on the
> > report becomes $200, which is incorrect.
> > 
> > No other setting seems to have an effect on this: not the global
> > Preferences -> Account -> Reversed Balanced Accounts setting, not
> > any
> > other
> > setting in the old transaction report. It is all about that one
> > setting,
> > 
> > > 
> > > Sign Reverses in the transaction report.
> > 
> On Fri, Mar 10, 2017 at 2:22 PM, Cindy Doughty <dbdoughty at gmail.com>
> wrote:
> 
> > 
> > Attached is an updated version of the transactionsbypayee
> > file.  Please
> > replace the old version with this file.
> > This version should now display the correct currency for Euro and
> > other
> > currencies.  Also the search or find command has been changed.  You
> > can now
> > search account names, account codes, notes, and memo items in
> > addition to
> > transaction descriptions.  You can also add a second requirement to
> > the
> > search such as all items which start with MC but not
> > McDonald's.  Please
> > let me know if this fixes the currency problem and let me know if
> > the find
> > works correctly.
> > 
> > 
> > Doug Doughty
> > 
> > On Wed, Mar 8, 2017 at 11:57 AM, Cindy Doughty <dbdoughty at gmail.com
> > >
> > wrote:
> > 
> > > 
> > > I have modified the transaction report in four (4) ways.
> > > 
> > > 
> > > 
> > > 1. On the display tab you can select to consolidate transactions
> > > and the
> > > report will combine all similar transactions into one total
> > > entry.  By
> > > checking and unchecking entries on the display tab you can change
> > > how the
> > > numbers are combined - by description, memo, notes, account.  The
> > > date
> > > ranged which is combined is controlled based on the date range
> > > selected on
> > > the sorting tab.  You can combine for an entire year, by month,
> > > by week, or
> > > by quarter.
> > > 
> > > 
> > > 
> > > 2. You can use the find option on the sorting tab to limit the
> > > report to
> > > only descriptions containing specific text and you can limit the
> > > amount to
> > > a given range such as only amounts greater than 500.
> > > 
> > > 
> > > 
> > > 3. You can specify on the general tab you want all of the entries
> > > to be
> > > scaled.  By which I mean you can take the results for a full year
> > > and
> > > divide it by 365 to see what the amounts are on a daily
> > > basis.  You can
> > > also take the numbers for a quarter and multiply by 4 to see what
> > > they
> > > would look like on an annual basis.
> > > 
> > > 
> > > 
> > > 4. You can easily select a time period on the general tab.  Such
> > > as last
> > > quarter, 2nd half of the year, or the month of January.  I have
> > > also
> > > modified the Income statement in the "other" menu to provide this
> > > same
> > > capability.
> > > 
> > > 
> > > 
> > > There is also a check box on the display tab where you can change
> > > how the
> > > running balance is calculated.
> > > 
> > > 
> > > 
> > > To install, download the attached files and put them into your
> > > .gnucash
> > > folder.  In windows for me this is
> > > c:/users/UserName/.gnucash.  Warning if
> > > you already have a config.user file then first put into a
> > > different folder
> > > and then copy the entries in config.user into your existing
> > > config.user
> > > file.  The transaction  report will show up under reports, the
> > > income
> > > statement  in "Other".
> > > 
> > > 
> > > 
> > > Sorry, the last time I posted the income statement I failed to
> > > upload one
> > > of the files.
> > > 
> > > 
> > > 
> > >  Please post any potential improvements to either the menus shown
> > > or to
> > > the scheme programming code.
> > > 
> > 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.