Fwd: New transaction report - consolidates / creates composite if same description, has find capability and can convert annual data to daily amounts
Pedro Albuquerque
palbuquerque73 at gmail.com
Tue Mar 21 11:02:49 EDT 2017
Many thanks for this tool
Pedro
A Ter, 21-03-2017 às 10:31 -0400, Cindy Doughty escreveu:
> Dear Gnucash-Users
>
> It brings me great pleasure to present an updated and beefed up
> transaction.scm
>
> In addition to advanced date, transaction and account filtering
> capabilities, and the scaling multiplier features already presented,
> it now
> has a novel multi-column view to separate transactions into splits as
> a
> multicolumn view.
>
> This will be useful in multiple ways. For example
> 1) report your bank account, and filter by expenses, visualise the
> monies
> leaving your bank into various accounts
> 2) report from your GST/VAT accounts, and visualise the various
> incomes and
> expenses, with quarterly totals. Use figures to determine your
> GST/VAT
> obligations.
> 3) cut from multicolumn, and paste into spreadsheet for more advanced
> data
> analytics
>
> See attached sample reports for illustration.I will be happy for this
> report to be submitted to the standard reports.
> Thanks to help from Chris Lam, this report is nearly mature - just
> needs
> some adjustments to UI and settings.
>
> Doug Doughty
> ---
>
>
> On 21 March 2017 at 11:33, Cindy Doughty <dbdoughty at gmail.com> wrote:
>
> Yes, it would be good if you can help with the announcement. I've
> attached
> >
> > one finalversion - added to the find command so you can search for
> > text in
> > the date, reconciled date, and check number fields. And changed so
> > we can
> > replace the current transaction.scm with it. (can't do it yet since
> > this
> > version uses the extra file gnctimeperiods-utilities.) I agree
> > about
> > removing old running balance but was worried my version may not
> > work under
> > all conditions. We could change the default to not use the old
> > version.
> > Could also change the sign conversion default to none ( just a
> > question of
> > changing from true #f to #f on running balance menu item and
> > changing the
> > entry to 'none on the style menu option. If you look in the code
> > you'll
> > see where I added some code to turn off the menu choice for running
> > balance
> > and amount when optname-account-as-cols? is true. Could do this
> > for the
> > other menu items I listed in the e-mail settings but not sure if I
> > should.
> >
> >
> > On Mon, Mar 20, 2017 at 11:00 PM, Christopher Lam <
> > christopher.lck at gmail.com> wrote:
> >
> > I think it is ready for general release & feedback on UI :)
> > >
> > > My vote: Remove sign reversal, Remove old running balance
> > > If you wish I can help with announcement and illus on new
> > > functionality
> > > especially for quarterly tax obligations
> > > And incorporate Multicolumn option as the 4th option for 'Amount'
> > > display.
> > >
> > > \o/ We are not worthy \o/
> > >
> > >
> > >
> > > On 21 March 2017 at 01:37, Cindy Doughty <dbdoughty at gmail.com>
> > > wrote:
> > >
> > > try settings:
> > > >
> > > > display tab - check multi-column and only show transaction
> > > > once
> > > > sign reverses - none
> > > > uncheck totals uncheck consolidate
> > > > transactions
> > > > general - style single
> > > > sorting - primary key date primary subtotal -
> > > > none
> > > > secondary key none
> > > >
> > > >
> > > > On Sun, Mar 19, 2017 at 3:59 PM, Cindy Doughty
> > > > .com>
> > > > wrote:
> > > >
> > > > I figured out how to easily only have a transaction entered
> > > > once -
> > > > >
> > > > > should I, should it be a menu choice, and if it is a menu
> > > > > choice, where
> > > > > and how should it be worded. Also, is there a better menu
> > > > > choice/
> > > > > description than account names as columns.
> > > > >
> > > > >
> > > > > I watched four or five you tube tutorials on scheme, then
> > > > > googled guile
> > > > > scheme. Looked at http://web-artanis.com/scheme.html, looked
> > > > > at
> > > > > https://pingus.seul.org/~grumbel/tmp/guile-1.6.0/guile-tut_3.
> > > > > html and
> > > > > have been using the guile manual https://www.gnu.org/softwar
> > > > > e/g
> > > > > uile/manual/html_node/index.html#SEC_Contents. I make a
> > > > > backup copy
> > > > > of the file write only 1or two lines of code and then run
> > > > > it. If it
> > > > > doesn't work I use a diff program to compare the backup and
> > > > > the current
> > > > > version. If it works I make another backup and
> > > > > continue. The back ups
> > > > > have the current day and time in the name so I have multiple
> > > > > versions. I
> > > > > look at the existing programs when I am ready to add a new
> > > > > feature and try
> > > > > to copy over the existing code as a starting point for what I
> > > > > am trying to
> > > > > write. The biggest problem I found is the parenthesis ,
> > > > > getting the right
> > > > > number and right location for them. The editor I am using
> > > > > highlights where
> > > > > the opening or closing paren is when you click on the
> > > > > opposite one. The
> > > > > word let needs to be entere as (let ( and then the variables
> > > > > such as (let
> > > > > ( (var1 "testt") (var2 "test2") ) <--- note the closing
> > > > > paren then
> > > > > the code where you do other things besides creating a
> > > > > temporary variable
> > > > > and then another closing paren ")" to end the entire
> > > > > let. If you are
> > > > > using the variable as part of te definition of another
> > > > > variable the let
> > > > > needs an asterisk (let* ( code needs to be
> > > > > grouped so after
> > > > > (define
> > > > > (name_of_sub_routine input_variable1 input_variable2)
> > > > > ( you
> > > > > can only have one set of code. If you are going to have
> > > > > multipe statements
> > > > > they need to be inside a (let ( or (begin ( the
> > > > > other problem I
> > > > > have at times is it appears you can only put (define in
> > > > > certain locations
> > > > > (I am not sure about this) so sometimes it works if I just
> > > > > move the code
> > > > > to a new location.
> > > > >
> > > > >
> > > > > On Sun, Mar 19, 2017 at 12:10 PM, Christopher Lam <
> > > > > christopher.lck at gmail.com> wrote:
> > > > >
> > > > > You've fixed (2) and (3) currency! :)
> > > > > >
> > > > > > (5) is already fixed.
> > > > > > I must ask you which resources are useful to learn scheme
> > > > > > this way?
> > > > > > I've been trying to fix the commodities table.
> > > > > >
> > > > > >
> > > > > >
> > > > > > On 19 March 2017 at 23:59, Cindy Doughty
> > > > > > om> wrote:
> > > > > >
> > > > > > try this version with your list of items to check. For
> > > > > > item 1 I could
> > > > > > >
> > > > > > > look at transaction guid and filter so I only have 1 copy
> > > > > > > of each
> > > > > > > transaction but if you print sorted by expense account
> > > > > > > name, only one of
> > > > > > > the expense categories would have a listing such as
> > > > > > >
> > > > > > > groceries checking
> > > > > > > groceries pet supplies cd's/dvd's
> > > > > > > A&P -100
> > > > > > > 85 5 10
> > > > > > >
> > > > > > > pet supplies
> > > > > > > (no entries)
> > > > > > > cd's/dvds
> > > > > > > (no entries)
> > > > > > >
> > > > > > >
> > > > > > > On Sun, Mar 19, 2017 at 11:48 AM, Christopher Lam <
> > > > > > > christopher.lck at gmail.com> wrote:
> > > > > > >
> > > > > > > Addendum
> > > > > > > >
> > > > > > > > I think item (1) is currently unsolvable. If there are
> > > > > > > > multiple
> > > > > > > > splits to same account, they *have* to be duplicated
> > > > > > > > unless major
> > > > > > > > structural changes made to main loop.
> > > > > > > > Otherwise the other items are mostly cosmetic. I tried
> > > > > > > > hacking
> > > > > > > > scheme from your changes to fix the currency/commodity
> > > > > > > > and still failed.
> > > > > > > > Very grateful for work!
> > > > > > > > C
> > > > > > > >
> > > > > > > >
> > > > > > > > On 19 March 2017 at 12:06, Cindy Doughty
> > > > > > > > il.com>
> > > > > > > > wrote:
> > > > > > > >
> > > > > > > > item 2 - currency
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > On Sat, Mar 18, 2017 at 11:31 PM, Christopher Lam <
> > > > > > > > > christopher.lck at gmail.com> wrote:
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > The original transaction program doesn't have a
> > > > > > > > > > menu choice for
> > > > > > > > > > turning on or off the amount column, should it
> > > > > > > > > > automatically be hidden or
> > > > > > > > > > should it be a menu choice?
> > > > > > > > > > I'd think if we choose 'accounts-as-columns' it
> > > > > > > > > > should omit
> > > > > > > > > > printing the original Amount column. I figure it
> > > > > > > > > > should also disable
> > > > > > > > > > 'Running Total'.
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > I can easily sum up the column but I haven't
> > > > > > > > > > > figured out how to
> > > > > > > > > > handle multiple currencies in the same account.
> > > > > > > > > > You mean multiple currencies in same split. I guess
> > > > > > > > > > we'd add each
> > > > > > > > > > 'account-as-column' currency amount.
> > > > > > > > > > Alternatively we could 'overload' the original
> > > > > > > > > > 'Amount' display to
> > > > > > > > > > show each amount-as-column, and inherit its ability
> > > > > > > > > > to display currencies,
> > > > > > > > > > running totals, subtotals... but I guess this cause
> > > > > > > > > > major breakage...
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > On 19 March 2017 at 11:21, Cindy Doughty
> > > > > > > > > > @gmail.com>
> > > > > > > > > > wrote:
> > > > > > > > > >
> > > > > > > > > > Hi, check what setting you have for options display
> > > > > > > > > > sign reversal
> > > > > > > > > > >
> > > > > > > > > > > - should be none, I may need to change the
> > > > > > > > > > > default to none. Also, I am
> > > > > > > > > > > summing up all of the entries to the same
> > > > > > > > > > > account for a split so I thought
> > > > > > > > > > > I had item 1 taken care of. Good catch on your
> > > > > > > > > > > part, I'll have to look at
> > > > > > > > > > > it. Adding the currency sign should be easy. I
> > > > > > > > > > > haven't figured out how to
> > > > > > > > > > > print a total. I can easily sum up the column
> > > > > > > > > > > but I haven't figured out
> > > > > > > > > > > how to handle multiple currencies in the same
> > > > > > > > > > > account. The original
> > > > > > > > > > > transaction program doesn't have a menu choice
> > > > > > > > > > > for turning on or off the
> > > > > > > > > > > amount column, should it automatically be hidden
> > > > > > > > > > > or should it be a menu
> > > > > > > > > > > choice?
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > On Sat, Mar 18, 2017 at 10:55 PM, Christopher Lam
> > > > > > > > > > > <
> > > > > > > > > > > christopher.lck at gmail.com> wrote:
> > > > > > > > > > >
> > > > > > > > > > > This.is.beautiful... I respectfully deny your
> > > > > > > > > > > claim to be a
> > > > > > > > > > > >
> > > > > > > > > > > > scheme beginner. I feel guilty about using your
> > > > > > > > > > > > skills. Herewith my
> > > > > > > > > > > > thoughts. The report is nearly mature.
> > > > > > > > > > > >
> > > > > > > > > > > > 1) With this new development there'll be a
> > > > > > > > > > > > snag: If the same
> > > > > > > > > > > > transaction contains multiple splits to the
> > > > > > > > > > > > same account, there will be
> > > > > > > > > > > > duplication of data. Illustration:
> > > > > > > > > > > >
> > > > > > > > > > > > 01/01/2017 "Deposit Cheques into bank"
> > > > > > > > > > > > Income:Sales $-500 Cheque 1 - for work
> > > > > > > > > > > > done in November
> > > > > > > > > > > > Income:Sales $-800 Cheque 2 - for work
> > > > > > > > > > > > done in December
> > > > > > > > > > > > Assets:Bank $1300 Deposits into Bank
> > > > > > > > > > > >
> > > > > > > > > > > > If I now select "Income:Sales" as report
> > > > > > > > > > > > account, it will show
> > > > > > > > > > > > Date Desc
> > > > > > > > > > > > Acct Amount Bank Income
> > > > > > > > > > > > 01/01/17 "Deposit cheques into Bank"
> > > > > > > > > > > > Split-transaction $800 1,300 1,300
> > > > > > > > > > > > 01/01/17 "Deposit cheques into
> > > > > > > > > > > > Bank" Split-transaction
> > > > > > > > > > > > $1,300 1,300 1,300
> > > > > > > > > > > >
> > > > > > > > > > > > I dealt with this in my .py report in the
> > > > > > > > > > > > main loop by looping
> > > > > > > > > > > > through transactions rather than splits.
> > > > > > > > > > > > I'm not sure how easy it will be to modify
> > > > > > > > > > > > scm.
> > > > > > > > > > > >
> > > > > > > > > > > > 2) For some reason the accounts-in-columns are
> > > > > > > > > > > > printed as
> > > > > > > > > > > > numbers without currencies?
> > > > > > > > > > > > 3) Ideally if accounts-as-columns is selected,
> > > > > > > > > > > > we will omit
> > > > > > > > > > > > printing the split amount ($800 and $1300) as
> > > > > > > > > > > > above because it's now
> > > > > > > > > > > > redundant?
> > > > > > > > > > > > 4) How difficult to add totals for each
> > > > > > > > > > > > amounts-as-columns?
> > > > > > > > > > > > 5) The amounts-as-columns don't seem to have
> > > > > > > > > > > > consistent
> > > > > > > > > > > > negativity rules. If, for example, they used
> > > > > > > > > > > > the raw gnucash amount they
> > > > > > > > > > > > will always be consistent (+ve amounts usually
> > > > > > > > > > > > in assets/expenses, -ve in
> > > > > > > > > > > > income/liability/equity) so that each row, when
> > > > > > > > > > > > summed, will equal zero.
> > > > > > > > > > > >
> > > > > > > > > > > > I admit my .py didn't handle currencies at all.
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > On 19 March 2017 at 10:08, Cindy Doughty
> > > > > > > > > > > > ghty at gmail.com>
> > > > > > > > > > > > wrote:
> > > > > > > > > > > >
> > > > > > > > > > > > try this one
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > On Fri, Mar 17, 2017 at 10:20 PM, Cindy
> > > > > > > > > > > > > Doughty <
> > > > > > > > > > > > > dbdoughty at gmail.com> wrote:
> > > > > > > > > > > > >
> > > > > > > > > > > > > ok, I found a split transaction- it doesn't
> > > > > > > > > > > > > print as any type
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > of account, I'll need to try and figure out
> > > > > > > > > > > > > > what variable has the account
> > > > > > > > > > > > > > info
> > > > > > > > > > > > > >
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > On Fri, Mar 17, 2017 at 10:05 PM, Cindy
> > > > > > > > > > > > > > Doughty <
> > > > > > > > > > > > > > dbdoughty at gmail.com> wrote:
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > try the transactionpayee.scm version I
> > > > > > > > > > > > > > sent, think it does
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > this but it prints on multiple lines (the
> > > > > > > > > > > > > > > first of the two files send today)
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > On Fri, Mar 17, 2017 at 7:49 PM,
> > > > > > > > > > > > > > > Christopher Lam <
> > > > > > > > > > > > > > > christopher.lck at gmail.com> wrote:
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > Hi, thank you... can't determine
> > > > > > > > > > > > > > > difference between the last
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > two reports.
> > > > > > > > > > > > > > > > The execution is slowly matching the
> > > > > > > > > > > > > > > > idea. I'm sure the
> > > > > > > > > > > > > > > > rteam will be keen to incorporate it.
> > > > > > > > > > > > > > > > Right now the 'account cols' are
> > > > > > > > > > > > > > > > matching the last leaf of
> > > > > > > > > > > > > > > > the 'originating account'
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > Instead, the idea is to match the
> > > > > > > > > > > > > > > > 'fullname' of the 'Other
> > > > > > > > > > > > > > > > account' for the transaction splits.
> > > > > > > > > > > > > > > > Not sure if this is easily done. I've
> > > > > > > > > > > > > > > > made suitable
> > > > > > > > > > > > > > > > screenshots showing the idea.
> > > > > > > > > > > > > > > > Notice in the 2nd shot, all amounts
> > > > > > > > > > > > > > > > will sum to $0 (because
> > > > > > > > > > > > > > > > each txn is balanced)
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > Current Report
> > > > > > > > > > > > > > > > [image: Inline images 1]
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > Desired Report
> > > > > > > > > > > > > > > > [image: Inline images 3]
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > On 18 March 2017 at 05:28, Cindy
> > > > > > > > > > > > > > > > Doughty <
> > > > > > > > > > > > > > > > dbdoughty at gmail.com> wrote:
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > This is the version I had earlier,
> > > > > > > > > > > > > > > > seems like it fits better
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > with your note
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > On Fri, Mar 17, 2017 at 5:20 PM,
> > > > > > > > > > > > > > > > > Cindy Doughty <
> > > > > > > > > > > > > > > > > dbdoughty at gmail.com> wrote:
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > try this version - see third item on
> > > > > > > > > > > > > > > > > display page, I
> > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > originally set it up for accounts
> > > > > > > > > > > > > > > > > > instead of other accounts. If it
> > > > > > > > > > > > > > > > > > looks
> > > > > > > > > > > > > > > > > > okay I'll work on creating
> > > > > > > > > > > > > > > > > > totals. Works best when accounts
> > > > > > > > > > > > > > > > > > that are open
> > > > > > > > > > > > > > > > > > are liabilities. Is this the
> > > > > > > > > > > > > > > > > > format you need r do you need
> > > > > > > > > > > > > > > > > > accounts
> > > > > > > > > > > > > > > > > > instead of other accounts
> > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > On Thu, Mar 16, 2017 at 10:52 PM,
> > > > > > > > > > > > > > > > > > Christopher Lam <
> > > > > > > > > > > > > > > > > > christopher.lck at gmail.com> wrote:
> > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > PS My multicolumn report is for
> > > > > > > > > > > > > > > > > > transactional data rather
> > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > than (eg) quarterly summaries. It
> > > > > > > > > > > > > > > > > > > converts from the following to
> > > > > > > > > > > > > > > > > > > the sample
> > > > > > > > > > > > > > > > > > > output later. I don't know why
> > > > > > > > > > > > > > > > > > > the standard reports offer
> > > > > > > > > > > > > > > > > > > nothing like this.
> > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > 01/01/17 Paycheck
> > > > > > > > > > > > > > > > > > > Income:Paid $-1000
> > > > > > > > > > > > > > > > > > > Expense:TaxWithheld $-300
> > > > > > > > > > > > > > > > > > > Assets:Bank $700
> > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > 01/02/17 Paycheck
> > > > > > > > > > > > > > > > > > > Income:Paid $-2000
> > > > > > > > > > > > > > > > > > > Expense:TaxWithheld $-600
> > > > > > > > > > > > > > > > > > > Assets:Bank $1400
> > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > *Outputs*
> > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > Date, Income:Paid,
> > > > > > > > > > > > > > > > > > > Expense:TaxWithheld, Assets:Bank,
> > > > > > > > > > > > > > > > > > > Description
> > > > > > > > > > > > > > > > > > > 01/01/17, -1000, -300, 700,
> > > > > > > > > > > > > > > > > > > Paycheck
> > > > > > > > > > > > > > > > > > > 01/02/17, -2000, -600, 1400,
> > > > > > > > > > > > > > > > > > > Paycheck
> > > > > > > > > > > > > > > > > > > Totals, -3000, -900, 2100
> > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > This is for later spreadsheet
> > > > > > > > > > > > > > > > > > > processing
> > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > On 17 March 2017 at 10:46,
> > > > > > > > > > > > > > > > > > > Christopher Lam <
> > > > > > > > > > > > > > > > > > > christopher.lck at gmail.com> wrote:
> > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > Thank you, looks fine to me! C
> > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > On 16 March 2017 at 21:14,
> > > > > > > > > > > > > > > > > > > > Cindy Doughty <
> > > > > > > > > > > > > > > > > > > > dbdoughty at gmail.com> wrote:
> > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > I forgot to change the income
> > > > > > > > > > > > > > > > > > > > statement report last
> > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > night - here is the orphan
> > > > > > > > > > > > > > > > > > > > > version
> > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > On Wed, Mar 15, 2017 at 11:19
> > > > > > > > > > > > > > > > > > > > > PM, Cindy Doughty <
> > > > > > > > > > > > > > > > > > > > > dbdoughty at gmail.com> wrote:
> > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > Sorry I forgot to mention
> > > > > > > > > > > > > > > > > > > > > only change on income
> > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > statement is the general
> > > > > > > > > > > > > > > > > > > > > > section - same choices for
> > > > > > > > > > > > > > > > > > > > > > dates as on transaction
> > > > > > > > > > > > > > > > > > > > > > report.
> > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > I finally played with the
> > > > > > > > > > > > > > > > > > > > > > custom multi-column report
> > > > > > > > > > > > > > > > > > > > > > today, I put 4 copies of
> > > > > > > > > > > > > > > > > > > > > > profit / loss next to each
> > > > > > > > > > > > > > > > > > > > > > other and used new date
> > > > > > > > > > > > > > > > > > > > > > feature to set each report
> > > > > > > > > > > > > > > > > > > > > > to a different quarter, got
> > > > > > > > > > > > > > > > > > > > > > me to thinking about
> > > > > > > > > > > > > > > > > > > > > > multi column reports, so
> > > > > > > > > > > > > > > > > > > > > > your python program looks
> > > > > > > > > > > > > > > > > > > > > > interesting.
> > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > On Wed, Mar 15, 2017 at
> > > > > > > > > > > > > > > > > > > > > > 11:03 PM, Cindy Doughty <
> > > > > > > > > > > > > > > > > > > > > > dbdoughty at gmail.com> wrote:
> > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > thanks for the comments,
> > > > > > > > > > > > > > > > > > > > > > > I'm still learning scheme
> > > > > > > > > > > > > > > > > > > > > > > ,
> > > > > > > > > > > > > > > > > > > > > > > I'll take a look at your
> > > > > > > > > > > > > > > > > > > > > > > report. Try this one for
> > > > > > > > > > > > > > > > > > > > > > > imbalance / orphan
> > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > On Wed, Mar 15, 2017 at
> > > > > > > > > > > > > > > > > > > > > > > 9:20 PM, Christopher Lam
> > > > > > > > > > > > > > > > > > > > > > > <
> > > > > > > > > > > > > > > > > > > > > > > christopher.lck at gmail.com
> > > > > > > > > > > > > > > > > > > > > > > > wrote:
> > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > Hi Doug, this looks
> > > > > > > > > > > > > > > > > > > > > > > > good. I'd hope the
> > > > > > > > > > > > > > > > > > > > > > > > wizards agree
> > > > > > > > > > > > > > > > > > > > > > > > to upgrade the reports.
> > > > > > > > > > > > > > > > > > > > > > > > I like special handling
> > > > > > > > > > > > > > > > > > > > > > > > for Imbalance-XXX. I
> > > > > > > > > > > > > > > > > > > > > > > > wonder
> > > > > > > > > > > > > > > > > > > > > > > > if it would be
> > > > > > > > > > > > > > > > > > > > > > > > worthwhile also
> > > > > > > > > > > > > > > > > > > > > > > > handling Orphan-XXX
> > > > > > > > > > > > > > > > > > > > > > > > accounts?
> > > > > > > > > > > > > > > > > > > > > > > > I think they have very
> > > > > > > > > > > > > > > > > > > > > > > > similar purposes. (see
> > > > > > > > > > > > > > > > > > > > > > > > http://lists.gnucash.or
> > > > > > > > > > > > > > > > > > > > > > > > g/piper
> > > > > > > > > > > > > > > > > > > > > > > > mail/gnucash-user/2011-
> > > > > > > > > > > > > > > > > > > > > > > > September/041127.html
> > > > > > > > > > > > > > > > > > > > > > > > from
> > > > > > > > > > > > > > > > > > > > > > > > Derek)
> > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > I wish I understood
> > > > > > > > > > > > > > > > > > > > > > > > Scheme - I created a
> > > > > > > > > > > > > > > > > > > > > > > > multicolumn
> > > > > > > > > > > > > > > > > > > > > > > > report to help me with
> > > > > > > > > > > > > > > > > > > > > > > > quarterly tax
> > > > > > > > > > > > > > > > > > > > > > > > obligations but they
> > > > > > > > > > > > > > > > > > > > > > > > will never accept
> > > > > > > > > > > > > > > > > > > > > > > > .py into standard
> > > > > > > > > > > > > > > > > > > > > > > > reports -- from a
> > > > > > > > > > > > > > > > > > > > > > > > transaction list, it
> > > > > > > > > > > > > > > > > > > > > > > > will separate out
> > > > > > > > > > > > > > > > > > > > > > > > splits into different
> > > > > > > > > > > > > > > > > > > > > > > > columns. eg
> > > > > > > > > > > > > > > > > > > > > > > > "Income:Sales"
> > > > > > > > > > > > > > > > > > > > > > > > transactions on rows,
> > > > > > > > > > > > > > > > > > > > > > > > "Sales (tax-free)",
> > > > > > > > > > > > > > > > > > > > > > > > "Tax received" etc on
> > > > > > > > > > > > > > > > > > > > > > > > columns.
> > > > > > > > > > > > > > > > > > > > > > > > https://github.com/chri
> > > > > > > > > > > > > > > > > > > > > > > > stopherlam/gnucashxml/t
> > > > > > > > > > > > > > > > > > > > > > > > ree/m
> > > > > > > > > > > > > > > > > > > > > > > > aster/reports -- if you
> > > > > > > > > > > > > > > > > > > > > > > > can convert this to
> > > > > > > > > > > > > > > > > > > > > > > > .scm
> > > > > > > > > > > > > > > > > > > > > > > > you'll be my hero :)
> > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > On 15 March 2017 at
> > > > > > > > > > > > > > > > > > > > > > > > 23:08, Cindy Doughty <
> > > > > > > > > > > > > > > > > > > > > > > > dbdoughty at gmail.com>
> > > > > > > > > > > > > > > > > > > > > > > > wrote:
> > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > Christopher,
> > > > > > > > > > > > > > > > > > > > > > > > > I made a few small
> > > > > > > > > > > > > > > > > > > > > > > > > changes to the
> > > > > > > > > > > > > > > > > > > > > > > > > display tab
> > > > > > > > > > > > > > > > > > > > > > > > > choices and added a
> > > > > > > > > > > > > > > > > > > > > > > > > few more choices on
> > > > > > > > > > > > > > > > > > > > > > > > > the general tab under
> > > > > > > > > > > > > > > > > > > > > > > > > specified
> > > > > > > > > > > > > > > > > > > > > > > > > period and specified
> > > > > > > > > > > > > > > > > > > > > > > > > last - figured this
> > > > > > > > > > > > > > > > > > > > > > > > > was my last
> > > > > > > > > > > > > > > > > > > > > > > > > opportunity to easily
> > > > > > > > > > > > > > > > > > > > > > > > > change. Once I
> > > > > > > > > > > > > > > > > > > > > > > > > submit it changes
> > > > > > > > > > > > > > > > > > > > > > > > > will have to be done
> > > > > > > > > > > > > > > > > > > > > > > > > thru the normal bug
> > > > > > > > > > > > > > > > > > > > > > > > > reports. If you
> > > > > > > > > > > > > > > > > > > > > > > > > don't mind, please
> > > > > > > > > > > > > > > > > > > > > > > > > test it. Also I
> > > > > > > > > > > > > > > > > > > > > > > > > added an optional
> > > > > > > > > > > > > > > > > > > > > > > > > imbalance flag to
> > > > > > > > > > > > > > > > > > > > > > > > > both reports. The
> > > > > > > > > > > > > > > > > > > > > > > > > settings default is
> > > > > > > > > > > > > > > > > > > > > > > > > to turn the
> > > > > > > > > > > > > > > > > > > > > > > > > imbalance check
> > > > > > > > > > > > > > > > > > > > > > > > > on. If the program
> > > > > > > > > > > > > > > > > > > > > > > > > checked for an
> > > > > > > > > > > > > > > > > > > > > > > > > imbalance it prints a
> > > > > > > > > > > > > > > > > > > > > > > > > dash "-" at the
> > > > > > > > > > > > > > > > > > > > > > > > > bottom of the report.
> > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > The new income-
> > > > > > > > > > > > > > > > > > > > > > > > > expense-
> > > > > > > > > > > > > > > > > > > > > > > > > statement will show
> > > > > > > > > > > > > > > > > > > > > > > > > up on
> > > > > > > > > > > > > > > > > > > > > > > > > the
> > > > > > > > > > > > > > > > > > > > > > > > > report - income
> > > > > > > > > > > > > > > > > > > > > > > > > and expense menu
> > > > > > > > > > > > > > > > > > > > > > > > > as a duplicate income
> > > > > > > > > > > > > > > > > > > > > > > > > statement and
> > > > > > > > > > > > > > > > > > > > > > > > > duplicate profit &
> > > > > > > > > > > > > > > > > > > > > > > > > loss. I am hoping
> > > > > > > > > > > > > > > > > > > > > > > > > they will replace the
> > > > > > > > > > > > > > > > > > > > > > > > > current versions with
> > > > > > > > > > > > > > > > > > > > > > > > > the new one. Thanks
> > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > Doug
> > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > On Sat, Mar 11, 2017
> > > > > > > > > > > > > > > > > > > > > > > > > at 10:10 PM,
> > > > > > > > > > > > > > > > > > > > > > > > > Christopher Lam <
> > > > > > > > > > > > > > > > > > > > > > > > > christopher.lck at gmail
> > > > > > > > > > > > > > > > > > > > > > > > > .com> wrote:
> > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > This latest report
> > > > > > > > > > > > > > > > > > > > > > > > > > now seems to work.
> > > > > > > > > > > > > > > > > > > > > > > > > > Tried
> > > > > > > > > > > > > > > > > > > > > > > > > > various
> > > > > > > > > > > > > > > > > > > > > > > > > > Consolidate/Common
> > > > > > > > > > > > > > > > > > > > > > > > > > Currency
> > > > > > > > > > > > > > > > > > > > > > > > > > combinations as
> > > > > > > > > > > > > > > > > > > > > > > > > > well as the newer
> > > > > > > > > > > > > > > > > > > > > > > > > > options, and they
> > > > > > > > > > > > > > > > > > > > > > > > > > all seem fine!
> > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > Dunno if it can be
> > > > > > > > > > > > > > > > > > > > > > > > > > considered a bug,
> > > > > > > > > > > > > > > > > > > > > > > > > > but I
> > > > > > > > > > > > > > > > > > > > > > > > > > tick/untick "Find
> > > > > > > > > > > > > > > > > > > > > > > > > > Text" which is
> > > > > > > > > > > > > > > > > > > > > > > > > > nicely programmed
> > > > > > > > > > > > > > > > > > > > > > > > > > to enable/disable
> > > > > > > > > > > > > > > > > > > > > > > > > > the
> > > > > > > > > > > > > > > > > > > > > > > > > > subsequent fields.
> > > > > > > > > > > > > > > > > > > > > > > > > > This occasionally
> > > > > > > > > > > > > > > > > > > > > > > > > > does not trigger.
> > > > > > > > > > > > > > > > > > > > > > > > > > But I can't
> > > > > > > > > > > > > > > > > > > > > > > > > > reproduce this
> > > > > > > > > > > > > > > > > > > > > > > > > > behavior. I think
> > > > > > > > > > > > > > > > > > > > > > > > > > I've seen it in
> > > > > > > > > > > > > > > > > > > > > > > > > > Standard Reports so
> > > > > > > > > > > > > > > > > > > > > > > > > > it may
> > > > > > > > > > > > > > > > > > > > > > > > > > be a Gnome issue.
> > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > In any case, thank
> > > > > > > > > > > > > > > > > > > > > > > > > > you again! If only
> > > > > > > > > > > > > > > > > > > > > > > > > > I understood
> > > > > > > > > > > > > > > > > > > > > > > > > > scheme...
> > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > On 12 March 2017 at
> > > > > > > > > > > > > > > > > > > > > > > > > > 09:44, Cindy
> > > > > > > > > > > > > > > > > > > > > > > > > > Doughty <
> > > > > > > > > > > > > > > > > > > > > > > > > > dbdoughty at gmail.com
> > > > > > > > > > > > > > > > > > > > > > > > > > > wrote:
> > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > Sorry to keep
> > > > > > > > > > > > > > > > > > > > > > > > > > > bothering you - I
> > > > > > > > > > > > > > > > > > > > > > > > > > > found a problem
> > > > > > > > > > > > > > > > > > > > > > > > > > > with multiple
> > > > > > > > > > > > > > > > > > > > > > > > > > > currencies in the
> > > > > > > > > > > > > > > > > > > > > > > > > > > running
> > > > > > > > > > > > > > > > > > > > > > > > > > > balance. I think
> > > > > > > > > > > > > > > > > > > > > > > > > > > the attached file
> > > > > > > > > > > > > > > > > > > > > > > > > > > fixes it
> > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > On Sat, Mar 11,
> > > > > > > > > > > > > > > > > > > > > > > > > > > 2017 at 2:37 PM,
> > > > > > > > > > > > > > > > > > > > > > > > > > > Cindy Doughty <
> > > > > > > > > > > > > > > > > > > > > > > > > > > dbdoughty at gmail.c
> > > > > > > > > > > > > > > > > > > > > > > > > > > om> wrote:
> > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > I missed a
> > > > > > > > > > > > > > > > > > > > > > > > > > > > spot, try this
> > > > > > > > > > > > > > > > > > > > > > > > > > > > one
> > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > On Sat, Mar 11,
> > > > > > > > > > > > > > > > > > > > > > > > > > > > 2017 at 9:25
> > > > > > > > > > > > > > > > > > > > > > > > > > > > AM, Christopher
> > > > > > > > > > > > > > > > > > > > > > > > > > > > Lam
> > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > k at gmail.com>
> > > > > > > > > > > > > > > > > > > > > > > > > > > > wrote:
> > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > From my
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > tests. My
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > datafile main
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > currency is
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > MUR, also has
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > transactions
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > in EUR AUD.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > Untick
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > Consolidate,
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > untick common
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > currency -
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > seems fine -
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > each currency
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > has its own
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > running
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > total.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > Untick
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > Consolidate,
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > tick common
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > currency to
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > be
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > MUR - seems
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > fine - each
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > amount gets
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > forex-
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > converted
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > appropriately
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > , and
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > there's 1
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > correctly-
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > calculated
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > total amount
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > in MUR. Let's
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > call this
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > "GrandTotal-
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > MUR"
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > Tick
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > Consolidate,
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > Untick Common
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > Currency -
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > seems fine so
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > far - amounts
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > being added
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > as expected
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > even with
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > multiple
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > currencies.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > Each currency
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > will be given
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > its separate
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > line in the
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > Total
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > section.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > Tick
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > Consolidate,
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > Tick Common
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > Currency to
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > be
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > MUR ->
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > amounts are
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > being
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > converted via
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > MUR/XXX
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > exchange
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > rate.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > *Currency
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > symbols
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > however
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > remain as $ €
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > etc. Totals
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > still show
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > one lines per
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > currency.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > These
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > amounts,
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > wrongly-
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > labelled $
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > **€
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > and Rs, when
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > added
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > together
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > matches
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > GrandTotal-
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > MUR as
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > above.*
> > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > Overall
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > better
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > because it is
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > now no longer
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > converting to
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > the
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > Preferences >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > Accounts >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > Default
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > Currency.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > Definitely
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > going in the
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > right
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > direction.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > C
> > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > On 11 March
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > 2017 at
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > 22:02, Cindy
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > Doughty <
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > dbdoughty at gma
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > il.com>
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > wrote:
> > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Please try
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > this
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > version
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Fri, Mar
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 10, 2017 at
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 11:30 PM,
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Christopher
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Lam
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > opher.lck at g
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > mail.com>
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > wrote:
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > So
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > USD seems
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > to show
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > US$
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > AUD shows
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > $
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > CAD shows
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > C$
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > TBH I'd
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > store the
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > commodity
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > guid
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > rather
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > than
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > symbol.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On 11
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > March
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 2017 at
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 11:32,
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Christoph
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > er Lam <
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > christoph
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > er.lck at gm
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ail.com>
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > wrote:
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Dollar
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Symbols
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > were
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > occasio
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > nally $
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > or US$
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > I think
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > better
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > use
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > commodi
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ty guid
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > to
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > disting
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > uish?
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Cannot
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > remembe
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > r what
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > does
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > what.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > I'll
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > test
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > when I
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > get
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > back
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > home! C
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On 11
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Mar
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 2017
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 11:13,
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > "Cindy
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Doughty
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > " <
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > dbdough
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ty at gmai
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > l.com>
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > wrote:
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > do
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > you
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > know
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > if
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > AUD
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > and
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > USD
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > print
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > the
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > same
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > symbo
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > l -
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > tryin
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > g to
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > see
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > if I
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > can
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > use
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > the
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > symbo
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > l to
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > diffe
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > renti
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ate
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > curre
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ncies
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Fri,
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Mar
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 10,
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 2017
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > at
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 9:43
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > PM,
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Chris
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > tophe
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > r Lam
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > stoph
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > er.lc
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > k at gma
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > il.co
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > m>
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > wrote
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > :
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Scaling seems fine. Multiple currencies
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > being handled well.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On 11 March 2017 at 10:41, Cindy Doughty <
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > dbdoughty at gmail.com> wrote:
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > does the scaling work correctly for the
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > multiple currencies -if you select one month and multiply by 12 are values
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > correct?
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Fri, Mar 10, 2017 at 9:34 PM, Cindy
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Doughty <dbdoughty at gmail.com> wrote:
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Currently for consolidating I only store
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > the items checked on the display page and the primary and secondary sort
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > items. If you select no items on the display page and set primary and
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > secondary to none the entire thing gets consolidated into one amount. Guess
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > I need to always store the type of currency so if three currencies are
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > used then three entries are shown. I'll try and send you a file to test in
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > the next couple of days
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Fri, Mar 10, 2017 at 9:10 PM,
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Christopher Lam <
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > christopher.lck at gmail.com> wrote:
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Further details.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > In my datafile I have accounts in
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > multiple currencies.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > If I untick consolidate it seems fine.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Multiple currencies working well, filtering is perfect.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > If I tick consolidate, as explained
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > before, the datafile currency is being ignored, and the default currency is
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > being used. Moreover, and perhaps more critically, EUR GBP USD raw values
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > being added together, and the final meaningless values are being labelled
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > with the default currency.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > HTH
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On 11 March 2017 at 10:01, Cindy
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Doughty <dbdoughty at gmail.com> wrote:
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > looking at the code the unconsolidated
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > stores seems to store a pointer to the account name with each transaction
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > and each account name can have its own type of currency. I currently store
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > the account GUID with each transaction so you can click on the account name
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > if it is displayed and open up the account. Guess I could use the
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > accountguid as a variable name and store in it each accounts type of
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > currency.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Fri, Mar 10, 2017 at 8:53 PM,
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Christopher Lam <
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > christopher.lck at gmail.com> wrote:
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > You mean Report Options > General Tab
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Report's Currency?
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > I understand it should be disabled if
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 'Common Currency' is unticked, however I have seen it being inadvertently
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > active - in which case it does nothing.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > My Common Currency > Report's
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Currency is AUD.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On 11 March 2017 at 09:40, Cindy
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Doughty <dbdoughty at gmail.com> wrote:
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > What is the setting you have under
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > options general report currency?
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Fri, Mar 10, 2017 at 7:28 PM,
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Christopher Lam <
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > christopher.lck at gmail.com>
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > wrote:Functionality is *perfect* Thank you for deploying your scheme skills
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > :-OStill has currency display issue - not a major bug. But it can confuse
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > future generations.Let's say the datafile is in AUD, but for some reason
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > the Edit>Preferences default currency is GBP (because I occasionally do
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > books for relatives)Untick Consolidate, untick 'Common Currency' = amounts
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > are fine, currency will show Australian '$' correctlyTick Consolidate,
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > untick 'Common Currency' = report will calculate amounts (correctly
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > summed), but will show £ prior to amount.Tick Consolidate, tick 'Common
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Currency' for AUD = amounts ok, currency okUntick Consolidate, tick 'Common
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Currency' for AUD = fine as wellHTHOn 11 March 2017 at 03:22, 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.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
> _______________________________________________
> 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.
More information about the gnucash-user
mailing list