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

[Cindy Doughty]

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.
>>
>
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: transactionbypayee.scm
Type: application/octet-stream
Size: 146276 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20170311/b6af4783/attachment-0001.obj>