Re: [GNC] Transcation Search & Replace

2020-07-02 Thread Edward Doolittle
I think there is also a general accounting philosophical issue (and in some
jurisdictions, potentially a legal issue) in cases like this. Changing
transactions is something that is discouraged in some accounting contexts.
When I first learned accounting in 1980 or so, I was taught never to erase
a mistake, but instead to cross it out and make a note of it. The gc
equivalent would be to create a "reversing transaction" for the incorrect
transaction, on the same date as the erroneous transaction, with an
appropriate note, and then add the corrected transaction. For those who
don't know, a reversing transaction is a mirror image of the original, with
all the debits changed to credits and vice versa. The net effect of any
transaction and its reversing transaction is null on all subaccounts.

On the other hand, since my books are for no one's use but my own, and
because I generally have only a few transactions to correct if I make a
mistake, I feel no need to follow the above advice. When I find I have made
mistakes or poor treatments, I go back and correct them, of necessity one
transaction at a time. However, the authors of gc have no idea how it might
be used; if it is important for someone to maintain books in a way that
does not permit changing transactions, then giving a way to bulk edit
transactions would be allowing users to shoot themselves in the foot. I
would say that such a feature is a low priority.

With all that said, here is a way to modify existing transactions in bulk:
1) Use the scheduled transaction editor to produce a set of reversing
transactions. You can set the scheduled transaction to start at the
appropriate time in the past, with the appropriate frequency, then close
the editor and go to "Since last run...". When you're finished, the
appropriate transactions should all be available in the book. 2) Use the
scheduled transaction editor to produce the set of correct transactions in
the same manner as the previous step. 3) (optional) Delete corresponding
pairs of incorrect transactions and their reversing transactions if you
don't like your book too cluttered, and if it's allowed by your accounting
rules. This part would have to be done manually, but should go faster than
manually entering transactions, particularly if there's a nice search key
that will only find the erroneous transactions and their corresponding
reversing transactions.

On Thu, 2 Jul 2020 at 14:40, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> The best and safest one has already been mentioned.
>
> 1. Conduct a ‘Find’ as appropriate to build a working list of transactions.
> 2. Trudge through them one by one making the desired changes.
>
> That sounds daunting, but it depends on the info being changed.
>
> If you just want to change the name of an account, then edit the account.
> (not the transactions)
>
> If you want to move *all* transactions from one account to another
> existing account, and leave *no* other transactions behind afterwards, then
> simply delete the undesired account. GnuCash will prompt you for where to
> move the transactions.
>
> If you only want to move *some* transactions from one account to another,
> then best to do a Find which will generate a Search Results tab. You’ll
> have to do them one-by-one, but as you re-assign them, they’ll disappear
> from the search results, and when it is empty, you are done. This can be
> quite tedious if you have hundreds or thousands of such transactions.
> However, with even a few dozen, the work isn’t too bad, and now that you
> can direct-search when entering an account, it will go much faster than
> with previous versions. (direct-search is available in 4.0)
>
> If you are changing Description/Notes, there’s no easy fix other than
> steps 1 & 2 above. And this time, you don’t get a reducing list. You’ll
> have to keep track of which ones are done or not.
>
>
> Regards,
> Adrien
>
>
>
> > On Jul 2, 2020 w27d184, at 2:57 PM, listsub3 <
> lists...@liberator-systems.co.uk> wrote:
> >
> > Typically bulk search replace changes would be for things like
> transaction category/account, changes in names in description/notes. etc.
> >
> > My GC data folder is currently 46mb (I have quite a lot of histrorical
> stuff).
> >
> > Seems like quite a functional omission in GC to me - it must be quite a
> common user task - I don't have an old Quicken on this machine but I know
> it used to be a breeze with that.
> >
> > Searching this list I found an an old response to the same question
> which indicated that this functionality would only be considered once GC
> had moved to a databese strcuture?
> >
> > What are the workaraounds?
> >
> > Thanks
> >
> > John
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 

Re: [GNC] Cost Basis Report on Transaction

2020-07-02 Thread Christopher Lam
No such report exists. It'll be useful to illustrate a sample list of stock
transactions and the desired report.

On Fri, 3 Jul 2020, 6:59 am ,  wrote:

> I'm evaluating gnuCash for tracking investments.  For my taxes I need a
> report of all stock sales during the year, showing the cost basis.  Perhaps
> even a report of the lots used in a sale.  I cannot find any of these on
> Standard Reports.  Am I missing it somewhere?  Are these reports called
> something different?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Price Quotes

2020-07-02 Thread Les

Thanks David. That works.


On 7/2/20 8:13 PM, David H wrote:

Les,

If you're asking where to enter your Alpha Vantage API Key go to 
Preferences >> Online Quotes and add it.


Cheers David H.


On Fri, 3 Jul 2020 at 10:48, Les > wrote:


An update:  I discovered that Flatpak has upgraded GC to the 4.0
version.  I assume this is the issue.

Would someone point me to the instructions for installing
AlphaVantage
on Linux Mint?

Thanks,

Les

On 7/2/20 4:59 PM, Les wrote:
> I have been using Yahoo as JSON for well over a year and now,
today,
> when I tried to download quotes, I received an error indicating 
that
> AlphaVantage needed to be installed for quotes. It is true that
I had
> the SSD crash about three weeks ago and reinstalled Linux Mint 19.3
> along with GC. via Flatpak.  Since then the only problem I had
> downloading prices was HKD.
>
> So, what has changed since yesterday?
>
> Although I have an AlphaVantage API, I haven't used it for a long
> time.  I think it was when the API was limiting the number of
prices.
>
> Any assistance with this issue would be greatly appreciated.
>
> Thanks,
>
> Les
>
___
gnucash-user mailing list
gnucash-user@gnucash.org 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Price Quotes

2020-07-02 Thread David H
Les,

If you're asking where to enter your Alpha Vantage API Key go to
Preferences >> Online Quotes and add it.

Cheers David H.


On Fri, 3 Jul 2020 at 10:48, Les  wrote:

> An update:  I discovered that Flatpak has upgraded GC to the 4.0
> version.  I assume this is the issue.
>
> Would someone point me to the instructions for installing AlphaVantage
> on Linux Mint?
>
> Thanks,
>
> Les
>
> On 7/2/20 4:59 PM, Les wrote:
> > I have been using Yahoo as JSON for well over a year and now, today,
> > when I tried to download quotes, I received an error indicating  that
> > AlphaVantage needed to be installed for quotes. It is true that I had
> > the SSD crash about three weeks ago and reinstalled Linux Mint 19.3
> > along with GC. via Flatpak.  Since then the only problem I had
> > downloading prices was HKD.
> >
> > So, what has changed since yesterday?
> >
> > Although I have an AlphaVantage API, I haven't used it for a long
> > time.  I think it was when the API was limiting the number of prices.
> >
> > Any assistance with this issue would be greatly appreciated.
> >
> > Thanks,
> >
> > Les
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Split transaction on invoices in foreign currencies

2020-07-02 Thread Jim DeLaHunt

On 2020-07-02 10:24, Antonio Roberts wrote:


…Yes, I think I confused you a bit with my description. Just so we're
on the same page I'll try.

I've transferred (as an example) €200 to my GBP account and it's now
£177. I had a £10 bank charge and so I'm trying to split the £177 but
when I do this it's asking me to do a currency conversion.

I guess 'cause the transaction I'm splitting originated from a EUR
transaction it's asking for a conversion.…


Antonio:

I feel your pain. I do multi-currency transactions frequently, and it 
took me a while to understand GnuCash's model of a "transaction 
currency", determined by the currency of the account from which you 
create the transaction, but not displayed in the UI. I think you 
understand it now.


I created bug 797664 - /Per-split exchange rates confusing, and UI 
doesn't explain well/  
- as a place to describe what is confusing about the present design, and 
to gather ideas for what improved design might make multi-currency 
transactions easier. If you are interested in participating in bug 
reports, you might want to read that, and add your thoughts.


In the meantime, congratulations on being able to issue an invoice. 
Those are a bit too rare in these pandemic times.


Best regards,
 —Jim DeLaHunt, software engineer, Vancouver, Canada


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Price Quotes

2020-07-02 Thread Les
An update:  I discovered that Flatpak has upgraded GC to the 4.0 
version.  I assume this is the issue.


Would someone point me to the instructions for installing AlphaVantage 
on Linux Mint?


Thanks,

Les

On 7/2/20 4:59 PM, Les wrote:
I have been using Yahoo as JSON for well over a year and now, today, 
when I tried to download quotes, I received an error indicating  that 
AlphaVantage needed to be installed for quotes. It is true that I had 
the SSD crash about three weeks ago and reinstalled Linux Mint 19.3 
along with GC. via Flatpak.  Since then the only problem I had 
downloading prices was HKD.


So, what has changed since yesterday?

Although I have an AlphaVantage API, I haven't used it for a long 
time.  I think it was when the API was limiting the number of prices.


Any assistance with this issue would be greatly appreciated.

Thanks,

Les


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Cost Basis Report on Transaction

2020-07-02 Thread D via gnucash-user
Well, if you track your gains, it's simple to track using a transaction report.

On Jul 2, 2020, 18:59, at 18:59, gnuc...@runbox.com wrote:
>I'm evaluating gnuCash for tracking investments.  For my taxes I need a
>report of all stock sales during the year, showing the cost basis. 
>Perhaps even a report of the lots used in a sale.  I cannot find any of
>these on Standard Reports.  Am I missing it somewhere?  Are these
>reports called something different?
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>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@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Accessing online currency rates

2020-07-02 Thread John Ralls
Did you remember to run Install Online Price Retrieval for GnuCash from the 
GnuCash group in the Start Menu?

Regards,
John Ralls


> On Jul 2, 2020, at 4:29 AM, Samantha Payn  
> wrote:
> 
>   I have had to change computers and have installed my existing Gnucash
>   set-up (in which I could access online currency rates using the "fetch
>   rate" button) on my new computer but I cannot now access online
>   currency rates.
> 
>   I have installed Strawberry Perl, and added my API key at the right
>   place but I cannot get the currencies to update.
> 
>   Sorry to be a dunce: what am I missing?
> 
>   Many thanks for any assistance.
> 
>   Samantha
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Accessing online currency rates

2020-07-02 Thread Samantha Payn
   I have had to change computers and have installed my existing Gnucash
   set-up (in which I could access online currency rates using the "fetch
   rate" button) on my new computer but I cannot now access online
   currency rates.

   I have installed Strawberry Perl, and added my API key at the right
   place but I cannot get the currencies to update.

   Sorry to be a dunce: what am I missing?

   Many thanks for any assistance.

   Samantha
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Cost Basis Report on Transaction

2020-07-02 Thread gnucash
I'm evaluating gnuCash for tracking investments.  For my taxes I need a report 
of all stock sales during the year, showing the cost basis.  Perhaps even a 
report of the lots used in a sale.  I cannot find any of these on Standard 
Reports.  Am I missing it somewhere?  Are these reports called something 
different?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Price Quotes

2020-07-02 Thread Les
I have been using Yahoo as JSON for well over a year and now, today, 
when I tried to download quotes, I received an error indicating  that 
AlphaVantage needed to be installed for quotes. It is true that I had 
the SSD crash about three weeks ago and reinstalled Linux Mint 19.3 
along with GC. via Flatpak.  Since then the only problem I had 
downloading prices was HKD.


So, what has changed since yesterday?

Although I have an AlphaVantage API, I haven't used it for a long time.  
I think it was when the API was limiting the number of prices.


Any assistance with this issue would be greatly appreciated.

Thanks,

Les

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Transcation Search & Replace

2020-07-02 Thread Adrien Monteleone
The best and safest one has already been mentioned.

1. Conduct a ‘Find’ as appropriate to build a working list of transactions.
2. Trudge through them one by one making the desired changes.

That sounds daunting, but it depends on the info being changed.

If you just want to change the name of an account, then edit the account. (not 
the transactions)

If you want to move *all* transactions from one account to another existing 
account, and leave *no* other transactions behind afterwards, then simply 
delete the undesired account. GnuCash will prompt you for where to move the 
transactions.

If you only want to move *some* transactions from one account to another, then 
best to do a Find which will generate a Search Results tab. You’ll have to do 
them one-by-one, but as you re-assign them, they’ll disappear from the search 
results, and when it is empty, you are done. This can be quite tedious if you 
have hundreds or thousands of such transactions. However, with even a few 
dozen, the work isn’t too bad, and now that you can direct-search when entering 
an account, it will go much faster than with previous versions. (direct-search 
is available in 4.0)

If you are changing Description/Notes, there’s no easy fix other than steps 1 & 
2 above. And this time, you don’t get a reducing list. You’ll have to keep 
track of which ones are done or not.


Regards,
Adrien



> On Jul 2, 2020 w27d184, at 2:57 PM, listsub3 
>  wrote:
> 
> Typically bulk search replace changes would be for things like transaction 
> category/account, changes in names in description/notes. etc.
> 
> My GC data folder is currently 46mb (I have quite a lot of histrorical stuff).
> 
> Seems like quite a functional omission in GC to me - it must be quite a 
> common user task - I don't have an old Quicken on this machine but I know it 
> used to be a breeze with that.
> 
> Searching this list I found an an old response to the same question which 
> indicated that this functionality would only be considered once GC had moved 
> to a databese strcuture?
> 
> What are the workaraounds?
> 
> Thanks
> 
> John

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Transcation Search & Replace

2020-07-02 Thread listsub3
Typically bulk search replace changes would be for things like 
transaction category/account, changes in names in description/notes. etc.


My GC data folder is currently 46mb (I have quite a lot of histrorical 
stuff).


Seems like quite a functional omission in GC to me - it must be quite a 
common user task - I don't have an old Quicken on this machine but I 
know it used to be a breeze with that.


Searching this list I found an an old response to the same question 
which indicated that this functionality would only be considered once GC 
had moved to a databese strcuture?


What are the workaraounds?

Thanks

John


On 02/07/2020 14:51, Adrien Monteleone wrote:

There are ways to accomplish what you want, but no, there is no built-in ‘Find 
& Replace All’ feature.

I would ask, what are you trying to accomplish? What problem are you trying to 
solve?

and

How many transactions are we talking about?

Regards,
Adrien


On Jul 1, 2020 w27d183, at 2:57 PM, listsub3  
wrote:

Is there any functionality to do bulk search & replace on transactions?  My old 
2002 Quicken had this feature and it was really useful to do bulk 
changes/corrections.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Split transaction on invoices in foreign currencies

2020-07-02 Thread D. via gnucash-user
Antonio, 

Your original description of the situation was clear, and the scenario John and 
Frank and I outlined was accurate. 

The point is this: if you enter the transaction from the GBP account, you can 
add the bank fee split without invoking the second exchange rate dialog. 


 Original Message 
From: Antonio Roberts 
Sent: Thu Jul 02 13:24:00 EDT 2020
To: "D." 
Cc: Adrien Monteleone , Vinayak Vatsal via 
gnucash-user 
Subject: Re: [GNC] Split transaction on invoices in foreign currencies

Hi David,

Yes, I think I confused you a bit with my description. Just so we're
on the same page I'll try.

I've transferred (as an example) €200 to my GBP account and it's now
£177. I had a £10 bank charge and so I'm trying to split the £177 but
when I do this it's asking me to do a currency conversion.

I guess 'cause the transaction I'm splitting originated from a EUR
transaction it's asking for a conversion.

On Thu, 2 Jul 2020 at 18:11, D.  wrote:
>
> Antonio,
>
> I think the point that John and Frank were making is that if you *entered* 
> the transaction in the EUR account, then it will have EUR as its currency, 
> and you will be asked to provide an exchange rate for every GBP split that is 
> subsequently entered, regardless of your current register. When I read your 
> original post, it looks like you created the transaction while in the EUR 
> account (you stated "transferred the EUR into my GBP Bank", which strongly 
> implies this). If this is in fact what you did, then you can either enter the 
> same exchange rate as John suggested, or enter the transaction from the GBP 
> account and avoid the subsequent request.
>
> David
>
>
>  Original Message 
> From: Antonio Roberts 
> Sent: Thu Jul 02 12:44:26 EDT 2020
> To: Adrien Monteleone 
> Cc: GnuCash Users 
> Subject: Re: [GNC] Split transaction on invoices in foreign currencies
>
> > Unless I read the original post wrong, and the OP could clarify, but it 
> > looks like they were entering this split in a GBP based account (the GBP 
> > bank account) and adding a GBP split for the bank charge.
>
> Yes, that is correct. I transferred the funds from EUR to GBP account
> and in that transaction line in the GBP account I'm attempting to do a
> split and it's prompting me about currency conversion.
>
> As suggested above I could just do a separate line in the GBP Bank
> Charges expense account but my preference is to split as it shows
> where the charge is inherited from.
>
> Kind regards,
>
> Antonio
>
> On Thu, 2 Jul 2020 at 17:40, Adrien Monteleone
>  wrote:
> >
> > Unless I read the original post wrong, and the OP could clarify, but it 
> > looks like they were entering this split in a GBP based account (the GBP 
> > bank account) and adding a GBP split for the bank charge.
> >
> > Regards,
> > Adrien
> >
> >
> >
> >
> > > On Jul 2, 2020 w27d184, at 11:34 AM, John Ralls  
> > > wrote:
> > >
> > >
> > >
> > >> On Jul 2, 2020, at 9:08 AM, Antonio Roberts  
> > >> wrote:
> > >>
> > >> I'm in the UK doing most of my accounting in GBP (£) but in this case
> > >> I invoiced someone in EUR (€). Following the advice from here I sent
> > >> up a Bank in EUR, invoiced them in EUR and then transferred the EUR
> > >> into my GBP Bank with the current exchange rate (my bank supplies the
> > >> rate at the time of transaction).
> > >>
> > >> However, this conversion incurred a bank charge in GBP. In GNUcash
> > >> I've gone to my GBP Bank balance to the transaction line to split it
> > >> to deduct the bank transfer. When I do this it's asking me to do a
> > >> currency conversion from EUR to GBP.
> > >>
> > >> The funds are already in the GBP bank so why am I being asked to do
> > >> conversion again? Is there something I've done wrong?
> > >
> > > No, you haven't done anything wrong. Every transaction has a transaction 
> > > currency that's used to balance the transaction. That currency is 
> > > determined by the account from which the transaction is created, and in 
> > > this case it's EUR, so GnuCash needs to know the value in EUR of the bank 
> > > charge. Just use the same exchange rate that you used to convert the EUR 
> > > payment to GBP.
> > >
> > > Regards,
> > > John Ralls
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
>
>
> --
> 
> anto...@hellocatfood.com
> http://www.hellocatfood.com
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences 

Re: [GNC] Split transaction on invoices in foreign currencies

2020-07-02 Thread John Ralls


> On Jul 2, 2020, at 10:24 AM, Antonio Roberts  wrote:
> 
> Hi David,
> 
> Yes, I think I confused you a bit with my description. Just so we're
> on the same page I'll try.
> 
> I've transferred (as an example) €200 to my GBP account and it's now
> £177. I had a £10 bank charge and so I'm trying to split the £177 but
> when I do this it's asking me to do a currency conversion.
> 
> I guess 'cause the transaction I'm splitting originated from a EUR
> transaction it's asking for a conversion.

Yes, exactly. The important point for you to understand is what made it an EUR 
transaction: It was that you created it in an EUR register or if you used the 
Transfer Dialog it was that of the From Account (the one on the left unless 
you're have "use formal accounting labels" in which case it's the one on the 
right).

Regards,
John Ralls

> 
> On Thu, 2 Jul 2020 at 18:11, D.  wrote:
>> 
>> Antonio,
>> 
>> I think the point that John and Frank were making is that if you *entered* 
>> the transaction in the EUR account, then it will have EUR as its currency, 
>> and you will be asked to provide an exchange rate for every GBP split that 
>> is subsequently entered, regardless of your current register. When I read 
>> your original post, it looks like you created the transaction while in the 
>> EUR account (you stated "transferred the EUR into my GBP Bank", which 
>> strongly implies this). If this is in fact what you did, then you can either 
>> enter the same exchange rate as John suggested, or enter the transaction 
>> from the GBP account and avoid the subsequent request.
>> 
>> David
>> 
>> 
>>  Original Message 
>> From: Antonio Roberts 
>> Sent: Thu Jul 02 12:44:26 EDT 2020
>> To: Adrien Monteleone 
>> Cc: GnuCash Users 
>> Subject: Re: [GNC] Split transaction on invoices in foreign currencies
>> 
>>> Unless I read the original post wrong, and the OP could clarify, but it 
>>> looks like they were entering this split in a GBP based account (the GBP 
>>> bank account) and adding a GBP split for the bank charge.
>> 
>> Yes, that is correct. I transferred the funds from EUR to GBP account
>> and in that transaction line in the GBP account I'm attempting to do a
>> split and it's prompting me about currency conversion.
>> 
>> As suggested above I could just do a separate line in the GBP Bank
>> Charges expense account but my preference is to split as it shows
>> where the charge is inherited from.
>> 
>> Kind regards,
>> 
>> Antonio
>> 
>> On Thu, 2 Jul 2020 at 17:40, Adrien Monteleone
>>  wrote:
>>> 
>>> Unless I read the original post wrong, and the OP could clarify, but it 
>>> looks like they were entering this split in a GBP based account (the GBP 
>>> bank account) and adding a GBP split for the bank charge.
>>> 
>>> Regards,
>>> Adrien
>>> 
>>> 
>>> 
>>> 
 On Jul 2, 2020 w27d184, at 11:34 AM, John Ralls  wrote:
 
 
 
> On Jul 2, 2020, at 9:08 AM, Antonio Roberts  
> wrote:
> 
> I'm in the UK doing most of my accounting in GBP (£) but in this case
> I invoiced someone in EUR (€). Following the advice from here I sent
> up a Bank in EUR, invoiced them in EUR and then transferred the EUR
> into my GBP Bank with the current exchange rate (my bank supplies the
> rate at the time of transaction).
> 
> However, this conversion incurred a bank charge in GBP. In GNUcash
> I've gone to my GBP Bank balance to the transaction line to split it
> to deduct the bank transfer. When I do this it's asking me to do a
> currency conversion from EUR to GBP.
> 
> The funds are already in the GBP bank so why am I being asked to do
> conversion again? Is there something I've done wrong?
 
 No, you haven't done anything wrong. Every transaction has a transaction 
 currency that's used to balance the transaction. That currency is 
 determined by the account from which the transaction is created, and in 
 this case it's EUR, so GnuCash needs to know the value in EUR of the bank 
 charge. Just use the same exchange rate that you used to convert the EUR 
 payment to GBP.
 
 Regards,
 John Ralls
>>> 
>>> 
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see 
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> 
>> 
>> 
>> --
>> 
>> anto...@hellocatfood.com
>> http://www.hellocatfood.com
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> 

Re: [GNC] Split transaction on invoices in foreign currencies

2020-07-02 Thread Adrien Monteleone
Got it, thanks.

Regards,
Adrien

> On Jul 2, 2020 w27d184, at 12:13 PM, John Ralls  wrote:
> 
> 
> Read it again: "That currency is determined by the account from which the 
> TRANSACTION IS CREATED." Once the transaction is created its currency is 
> immutable. It matters not a whit in what account one modifies it from.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Split transaction on invoices in foreign currencies

2020-07-02 Thread Antonio Roberts
Hi David,

Yes, I think I confused you a bit with my description. Just so we're
on the same page I'll try.

I've transferred (as an example) €200 to my GBP account and it's now
£177. I had a £10 bank charge and so I'm trying to split the £177 but
when I do this it's asking me to do a currency conversion.

I guess 'cause the transaction I'm splitting originated from a EUR
transaction it's asking for a conversion.

On Thu, 2 Jul 2020 at 18:11, D.  wrote:
>
> Antonio,
>
> I think the point that John and Frank were making is that if you *entered* 
> the transaction in the EUR account, then it will have EUR as its currency, 
> and you will be asked to provide an exchange rate for every GBP split that is 
> subsequently entered, regardless of your current register. When I read your 
> original post, it looks like you created the transaction while in the EUR 
> account (you stated "transferred the EUR into my GBP Bank", which strongly 
> implies this). If this is in fact what you did, then you can either enter the 
> same exchange rate as John suggested, or enter the transaction from the GBP 
> account and avoid the subsequent request.
>
> David
>
>
>  Original Message 
> From: Antonio Roberts 
> Sent: Thu Jul 02 12:44:26 EDT 2020
> To: Adrien Monteleone 
> Cc: GnuCash Users 
> Subject: Re: [GNC] Split transaction on invoices in foreign currencies
>
> > Unless I read the original post wrong, and the OP could clarify, but it 
> > looks like they were entering this split in a GBP based account (the GBP 
> > bank account) and adding a GBP split for the bank charge.
>
> Yes, that is correct. I transferred the funds from EUR to GBP account
> and in that transaction line in the GBP account I'm attempting to do a
> split and it's prompting me about currency conversion.
>
> As suggested above I could just do a separate line in the GBP Bank
> Charges expense account but my preference is to split as it shows
> where the charge is inherited from.
>
> Kind regards,
>
> Antonio
>
> On Thu, 2 Jul 2020 at 17:40, Adrien Monteleone
>  wrote:
> >
> > Unless I read the original post wrong, and the OP could clarify, but it 
> > looks like they were entering this split in a GBP based account (the GBP 
> > bank account) and adding a GBP split for the bank charge.
> >
> > Regards,
> > Adrien
> >
> >
> >
> >
> > > On Jul 2, 2020 w27d184, at 11:34 AM, John Ralls  
> > > wrote:
> > >
> > >
> > >
> > >> On Jul 2, 2020, at 9:08 AM, Antonio Roberts  
> > >> wrote:
> > >>
> > >> I'm in the UK doing most of my accounting in GBP (£) but in this case
> > >> I invoiced someone in EUR (€). Following the advice from here I sent
> > >> up a Bank in EUR, invoiced them in EUR and then transferred the EUR
> > >> into my GBP Bank with the current exchange rate (my bank supplies the
> > >> rate at the time of transaction).
> > >>
> > >> However, this conversion incurred a bank charge in GBP. In GNUcash
> > >> I've gone to my GBP Bank balance to the transaction line to split it
> > >> to deduct the bank transfer. When I do this it's asking me to do a
> > >> currency conversion from EUR to GBP.
> > >>
> > >> The funds are already in the GBP bank so why am I being asked to do
> > >> conversion again? Is there something I've done wrong?
> > >
> > > No, you haven't done anything wrong. Every transaction has a transaction 
> > > currency that's used to balance the transaction. That currency is 
> > > determined by the account from which the transaction is created, and in 
> > > this case it's EUR, so GnuCash needs to know the value in EUR of the bank 
> > > charge. Just use the same exchange rate that you used to convert the EUR 
> > > payment to GBP.
> > >
> > > Regards,
> > > John Ralls
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
>
>
> --
> 
> anto...@hellocatfood.com
> http://www.hellocatfood.com
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 

anto...@hellocatfood.com
http://www.hellocatfood.com

___
gnucash-user mailing list

Re: [GNC] Split transaction on invoices in foreign currencies

2020-07-02 Thread John Ralls
Read 

> On Jul 2, 2020, at 9:39 AM, Adrien Monteleone 
>  wrote:
> 
> Unless I read the original post wrong, and the OP could clarify, but it looks 
> like they were entering this split in a GBP based account (the GBP bank 
> account) and adding a GBP split for the bank charge.
> 
> Regards,
> Adrien
> 
> 
> 
> 
>> On Jul 2, 2020 w27d184, at 11:34 AM, John Ralls  wrote:
>> 
>> 
>> 
>>> On Jul 2, 2020, at 9:08 AM, Antonio Roberts  
>>> wrote:
>>> 
>>> I'm in the UK doing most of my accounting in GBP (£) but in this case
>>> I invoiced someone in EUR (€). Following the advice from here I sent
>>> up a Bank in EUR, invoiced them in EUR and then transferred the EUR
>>> into my GBP Bank with the current exchange rate (my bank supplies the
>>> rate at the time of transaction).
>>> 
>>> However, this conversion incurred a bank charge in GBP. In GNUcash
>>> I've gone to my GBP Bank balance to the transaction line to split it
>>> to deduct the bank transfer. When I do this it's asking me to do a
>>> currency conversion from EUR to GBP.
>>> 
>>> The funds are already in the GBP bank so why am I being asked to do
>>> conversion again? Is there something I've done wrong?
>> 
>> No, you haven't done anything wrong. Every transaction has a transaction 
>> currency that's used to balance the transaction. That currency is determined 
>> by the account from which the transaction is created, and in this case it's 
>> EUR, so GnuCash needs to know the value in EUR of the bank charge. Just use 
>> the same exchange rate that you used to convert the EUR payment to GBP.


Read it again: "That currency is determined by the account from which the 
TRANSACTION IS CREATED." Once the transaction is created its currency is 
immutable. It matters not a whit in what account one modifies it from.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Split transaction on invoices in foreign currencies

2020-07-02 Thread D. via gnucash-user
Antonio, 

I think the point that John and Frank were making is that if you *entered* the 
transaction in the EUR account, then it will have EUR as its currency, and you 
will be asked to provide an exchange rate for every GBP split that is 
subsequently entered, regardless of your current register. When I read your 
original post, it looks like you created the transaction while in the EUR 
account (you stated "transferred the EUR into my GBP Bank", which strongly 
implies this). If this is in fact what you did, then you can either enter the 
same exchange rate as John suggested, or enter the transaction from the GBP 
account and avoid the subsequent request.

David


 Original Message 
From: Antonio Roberts 
Sent: Thu Jul 02 12:44:26 EDT 2020
To: Adrien Monteleone 
Cc: GnuCash Users 
Subject: Re: [GNC] Split transaction on invoices in foreign currencies

> Unless I read the original post wrong, and the OP could clarify, but it looks 
> like they were entering this split in a GBP based account (the GBP bank 
> account) and adding a GBP split for the bank charge.

Yes, that is correct. I transferred the funds from EUR to GBP account
and in that transaction line in the GBP account I'm attempting to do a
split and it's prompting me about currency conversion.

As suggested above I could just do a separate line in the GBP Bank
Charges expense account but my preference is to split as it shows
where the charge is inherited from.

Kind regards,

Antonio

On Thu, 2 Jul 2020 at 17:40, Adrien Monteleone
 wrote:
>
> Unless I read the original post wrong, and the OP could clarify, but it looks 
> like they were entering this split in a GBP based account (the GBP bank 
> account) and adding a GBP split for the bank charge.
>
> Regards,
> Adrien
>
>
>
>
> > On Jul 2, 2020 w27d184, at 11:34 AM, John Ralls  wrote:
> >
> >
> >
> >> On Jul 2, 2020, at 9:08 AM, Antonio Roberts  
> >> wrote:
> >>
> >> I'm in the UK doing most of my accounting in GBP (£) but in this case
> >> I invoiced someone in EUR (€). Following the advice from here I sent
> >> up a Bank in EUR, invoiced them in EUR and then transferred the EUR
> >> into my GBP Bank with the current exchange rate (my bank supplies the
> >> rate at the time of transaction).
> >>
> >> However, this conversion incurred a bank charge in GBP. In GNUcash
> >> I've gone to my GBP Bank balance to the transaction line to split it
> >> to deduct the bank transfer. When I do this it's asking me to do a
> >> currency conversion from EUR to GBP.
> >>
> >> The funds are already in the GBP bank so why am I being asked to do
> >> conversion again? Is there something I've done wrong?
> >
> > No, you haven't done anything wrong. Every transaction has a transaction 
> > currency that's used to balance the transaction. That currency is 
> > determined by the account from which the transaction is created, and in 
> > this case it's EUR, so GnuCash needs to know the value in EUR of the bank 
> > charge. Just use the same exchange rate that you used to convert the EUR 
> > payment to GBP.
> >
> > Regards,
> > John Ralls
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



-- 

anto...@hellocatfood.com
http://www.hellocatfood.com

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Split transaction on invoices in foreign currencies

2020-07-02 Thread Antonio Roberts
> Unless I read the original post wrong, and the OP could clarify, but it looks 
> like they were entering this split in a GBP based account (the GBP bank 
> account) and adding a GBP split for the bank charge.

Yes, that is correct. I transferred the funds from EUR to GBP account
and in that transaction line in the GBP account I'm attempting to do a
split and it's prompting me about currency conversion.

As suggested above I could just do a separate line in the GBP Bank
Charges expense account but my preference is to split as it shows
where the charge is inherited from.

Kind regards,

Antonio

On Thu, 2 Jul 2020 at 17:40, Adrien Monteleone
 wrote:
>
> Unless I read the original post wrong, and the OP could clarify, but it looks 
> like they were entering this split in a GBP based account (the GBP bank 
> account) and adding a GBP split for the bank charge.
>
> Regards,
> Adrien
>
>
>
>
> > On Jul 2, 2020 w27d184, at 11:34 AM, John Ralls  wrote:
> >
> >
> >
> >> On Jul 2, 2020, at 9:08 AM, Antonio Roberts  
> >> wrote:
> >>
> >> I'm in the UK doing most of my accounting in GBP (£) but in this case
> >> I invoiced someone in EUR (€). Following the advice from here I sent
> >> up a Bank in EUR, invoiced them in EUR and then transferred the EUR
> >> into my GBP Bank with the current exchange rate (my bank supplies the
> >> rate at the time of transaction).
> >>
> >> However, this conversion incurred a bank charge in GBP. In GNUcash
> >> I've gone to my GBP Bank balance to the transaction line to split it
> >> to deduct the bank transfer. When I do this it's asking me to do a
> >> currency conversion from EUR to GBP.
> >>
> >> The funds are already in the GBP bank so why am I being asked to do
> >> conversion again? Is there something I've done wrong?
> >
> > No, you haven't done anything wrong. Every transaction has a transaction 
> > currency that's used to balance the transaction. That currency is 
> > determined by the account from which the transaction is created, and in 
> > this case it's EUR, so GnuCash needs to know the value in EUR of the bank 
> > charge. Just use the same exchange rate that you used to convert the EUR 
> > payment to GBP.
> >
> > Regards,
> > John Ralls
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



-- 

anto...@hellocatfood.com
http://www.hellocatfood.com

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Custom invoices don't work after upgrade

2020-07-02 Thread Geert Janssens
I'm sorry your distro pulled the rug from under you at this crucial moment. 
However if it's that 
crucial perhaps you should revert your system to a backup before the upgrade, 
do your invoice 
work and then when the pressure is off, look at upgrading again and what's 
needed to get 
your custom template compatible with gnucash 3.x.

Closer to your question then - you provide little detail on your custom 
template. However 
assuming it's based on an existing invoice template, perhaps you can start from 
the newer 
version of that template and reapply only your changes ?

Regards,

Geert

Op donderdag 2 juli 2020 18:04:37 CEST schreef lo...@clickworkorange.com:
> On Thu, 2020-07-02 at 17:37 +0200, Frank H. Ellenberger wrote:
> > Hi,
> > 
> > Am 02.07.20 um 17:01 schrieb
> > lo...@clickworkorange.com
> > 
> > > On Thu, 2020-07-02 at 13:32 +0100,
> > > lo...@clickworkorange.com
> > > 
> > >  wrote:
> > > > My custom invoice template that I've used for many years stopped
> > > > working after upgrading to 3.4 as part of a dist-upgrade. I had
> > > > to
> > > > remove a few things such as
> > 
> > also 3.4 is several years old. If you prefer to stay on a
> > distribution
> > shipping such old program versin, you should consider to use
> > https://wiki.gnucash.org/wiki/Flatpak
> > .
> > 
> > > I have compared this with the shipped reports (e.g. taxinvoice.scm)
> > > and
> > > it looks correct. So, a few hours killed, no progress. Any
> > > suggestions?
> > 
> > Yes, you should compare the shipped reports, but of a *recent*
> > GnuCash
> > version 3.11 or 4.0. ISTR they got several improvements in between.
> > 
> > Regards
> > Frank
> 
> Thanks Frank, but I really just need to get my invoice generated and
> sent out. I have no problem staying with the distro version, even if
> it's old, as long as my template works. It has bank details, address etc as
> well as a few other bells & whistles such as my logo and tax reg. info -
> all of which are important and tedious to replicate in e.g. LibreOffice
> Writer. In fact in desperation I tried to build an earlier version of
> GnuCash just to be able to do this, but found that my distro ships goffice
> 0.10.10 while GnuCash 2.6.19 would only build with goffice >= 0.7.0 and <
> 0.9.0. Can't be bothered to dig deeper so I'm just going to get drunk
> instead.
> 
> 
> 
> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. -
> 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@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Custom invoices don't work after upgrade

2020-07-02 Thread Frank H. Ellenberger
Am 02.07.20 um 18:29 schrieb John Ralls:
> you have two choices: Never upgrade or don't use custom reports.

IMHO there is always a third choice: Submit your customization as an
enhancement request. If the team agrees, probably after further
modification, you will have no issues with upgrades.

Regards
Frank
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Split transaction on invoices in foreign currencies

2020-07-02 Thread Adrien Monteleone
Unless I read the original post wrong, and the OP could clarify, but it looks 
like they were entering this split in a GBP based account (the GBP bank 
account) and adding a GBP split for the bank charge.

Regards,
Adrien




> On Jul 2, 2020 w27d184, at 11:34 AM, John Ralls  wrote:
> 
> 
> 
>> On Jul 2, 2020, at 9:08 AM, Antonio Roberts  wrote:
>> 
>> I'm in the UK doing most of my accounting in GBP (£) but in this case
>> I invoiced someone in EUR (€). Following the advice from here I sent
>> up a Bank in EUR, invoiced them in EUR and then transferred the EUR
>> into my GBP Bank with the current exchange rate (my bank supplies the
>> rate at the time of transaction).
>> 
>> However, this conversion incurred a bank charge in GBP. In GNUcash
>> I've gone to my GBP Bank balance to the transaction line to split it
>> to deduct the bank transfer. When I do this it's asking me to do a
>> currency conversion from EUR to GBP.
>> 
>> The funds are already in the GBP bank so why am I being asked to do
>> conversion again? Is there something I've done wrong?
> 
> No, you haven't done anything wrong. Every transaction has a transaction 
> currency that's used to balance the transaction. That currency is determined 
> by the account from which the transaction is created, and in this case it's 
> EUR, so GnuCash needs to know the value in EUR of the bank charge. Just use 
> the same exchange rate that you used to convert the EUR payment to GBP.
> 
> Regards,
> John Ralls


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Split transaction on invoices in foreign currencies

2020-07-02 Thread John Ralls


> On Jul 2, 2020, at 9:08 AM, Antonio Roberts  wrote:
> 
> I'm in the UK doing most of my accounting in GBP (£) but in this case
> I invoiced someone in EUR (€). Following the advice from here I sent
> up a Bank in EUR, invoiced them in EUR and then transferred the EUR
> into my GBP Bank with the current exchange rate (my bank supplies the
> rate at the time of transaction).
> 
> However, this conversion incurred a bank charge in GBP. In GNUcash
> I've gone to my GBP Bank balance to the transaction line to split it
> to deduct the bank transfer. When I do this it's asking me to do a
> currency conversion from EUR to GBP.
> 
> The funds are already in the GBP bank so why am I being asked to do
> conversion again? Is there something I've done wrong?

No, you haven't done anything wrong. Every transaction has a transaction 
currency that's used to balance the transaction. That currency is determined by 
the account from which the transaction is created, and in this case it's EUR, 
so GnuCash needs to know the value in EUR of the bank charge. Just use the same 
exchange rate that you used to convert the EUR payment to GBP.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Split transaction on invoices in foreign currencies

2020-07-02 Thread Frank H. Ellenberger
Hi,

Am 02.07.20 um 18:25 schrieb w...@theprescotts.com:
> I don't remember the circumstances, but it seems like I have had the same 
> issue on transactions that are half in one currency and half in the other. It 
> will sometimes ask for the exchange rate, when it doesn't need it.

Each transaction has a (base) currency, which is inherited from the
account, where you start to enter the transaction.

So, if you know you need to adjust the GBP part, enter the transaction
from one of the GBP accounts.

HTH
Frank
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Custom invoices don't work after upgrade

2020-07-02 Thread John Ralls



> On Jul 2, 2020, at 8:37 AM, Frank H. Ellenberger 
>  wrote:
> 
> Hi,
> 
> Am 02.07.20 um 17:01 schrieb lo...@clickworkorange.com:
>> On Thu, 2020-07-02 at 13:32 +0100, lo...@clickworkorange.com wrote:
>>> My custom invoice template that I've used for many years stopped
>>> working after upgrading to 3.4 as part of a dist-upgrade. I had to
>>> remove a few things such as 
> :
> 
> also 3.4 is several years old. If you prefer to stay on a distribution
> shipping such old program versin, you should consider to use
> https://wiki.gnucash.org/wiki/Flatpak.
> 
>> I have compared this with the shipped reports (e.g. taxinvoice.scm) and
>> it looks correct. So, a few hours killed, no progress. Any suggestions?
> 
> Yes, you should compare the shipped reports, but of a *recent* GnuCash
> version 3.11 or 4.0. ISTR they got several improvements in between.

Note, however that part of those improvements have come with API deprecated in 
3.x and removed outright from 4.0.

Report options are implemented as vectors. The second snippet of code that you 
commented out created an option, so I'd guess that the exception is from an 
attempt to use that no-longer existing option. 

For the previous issue about qof-book-get-slots, if you weren't calling that 
where did the slots argument to (coy-info) come from?

Yup, GnuCash's API changes. The release notes accompanying each release explain 
the changes and since 3.0 functions that are removed are first deprecated so 
that they emit warnings, but you have to check the trace file to see the 
warnings. If you don't want to keep up with GnuCash development you have two 
choices: Never upgrade or don't use custom reports.

Regards,
John Ralls



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Split transaction on invoices in foreign currencies

2020-07-02 Thread Adrien Monteleone
If you are adding another split to the same transaction that contains an EUR 
split, it will need to balance that bank charge split as well. It may be trying 
to balance all GBP splits with all EUR splits. That might be considered a bug, 
but you can work around it.

Either adjust the EUR split, add an EUR split for balancing, or make a separate 
transaction just for the bank charge. (probably the simplest approach, which 
would keep it all in GBP and not trigger the rate request)

Regards,
Adrien

> On Jul 2, 2020 w27d184, at 11:08 AM, Antonio Roberts 
>  wrote:
> 
> I'm in the UK doing most of my accounting in GBP (£) but in this case
> I invoiced someone in EUR (€). Following the advice from here I sent
> up a Bank in EUR, invoiced them in EUR and then transferred the EUR
> into my GBP Bank with the current exchange rate (my bank supplies the
> rate at the time of transaction).
> 
> However, this conversion incurred a bank charge in GBP. In GNUcash
> I've gone to my GBP Bank balance to the transaction line to split it
> to deduct the bank transfer. When I do this it's asking me to do a
> currency conversion from EUR to GBP.
> 
> The funds are already in the GBP bank so why am I being asked to do
> conversion again? Is there something I've done wrong?

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Split transaction on invoices in foreign currencies

2020-07-02 Thread w...@theprescotts.com
I do a lot of that since I live in Mexico and have bank accounts in both the US 
and Mexico.

I don't remember the circumstances, but it seems like I have had the same issue 
on transactions that are half in one currency and half in the other. It will 
sometimes ask for the exchange rate, when it doesn't need it. I think if you 
just give it the exchange rate (which it already has), it works fine. It is 
just that when you tab out of a field it wants the exchange rate even though it 
doesn't do anything with it.

Will

On 2020 Jul 2, at 07-02 11:08:50, Antonio Roberts  
wrote:

I'm in the UK doing most of my accounting in GBP (£) but in this case
I invoiced someone in EUR (€). Following the advice from here I sent
up a Bank in EUR, invoiced them in EUR and then transferred the EUR
into my GBP Bank with the current exchange rate (my bank supplies the
rate at the time of transaction).

However, this conversion incurred a bank charge in GBP. In GNUcash
I've gone to my GBP Bank balance to the transaction line to split it
to deduct the bank transfer. When I do this it's asking me to do a
currency conversion from EUR to GBP.

The funds are already in the GBP bank so why am I being asked to do
conversion again? Is there something I've done wrong?

-- 

anto...@hellocatfood.com
http://www.hellocatfood.com

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Australian System

2020-07-02 Thread elvis



On 2/7/20 4:08 pm, Mike Alsop wrote:

You have probably been asked a thousand times, but as we entered a new
financial year yesterday, I seriously need to look at doing my own
books. Bookkeeping fees are now over the moon!!

So, does this system comply with the Aussie GST and BAS reporting
system for the Australian Taxation Office??
  
Many thanks in advance for any info.



It's a very flexible system, you can make it do anything. I have used it 
since 2007 to do gst and bas.



I just used the plain reports with appropriate accounts selected. I did 
the June qtr bas in about 5 minutes last night.



You can use the business features, but it's pretty clunky and time 
consuming if you want to do a lot of entries, especially business 
consumables.



I also have a small program I run over my exported bank files to insert 
a gst split, otherwise it is business features or manual, neither of 
which appeal.






Mike
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--
Don't force it, get a larger hammer.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Split transaction on invoices in foreign currencies

2020-07-02 Thread Antonio Roberts
I'm in the UK doing most of my accounting in GBP (£) but in this case
I invoiced someone in EUR (€). Following the advice from here I sent
up a Bank in EUR, invoiced them in EUR and then transferred the EUR
into my GBP Bank with the current exchange rate (my bank supplies the
rate at the time of transaction).

However, this conversion incurred a bank charge in GBP. In GNUcash
I've gone to my GBP Bank balance to the transaction line to split it
to deduct the bank transfer. When I do this it's asking me to do a
currency conversion from EUR to GBP.

The funds are already in the GBP bank so why am I being asked to do
conversion again? Is there something I've done wrong?

-- 

anto...@hellocatfood.com
http://www.hellocatfood.com

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Custom invoices don't work after upgrade

2020-07-02 Thread lomax
On Thu, 2020-07-02 at 17:37 +0200, Frank H. Ellenberger wrote:
> Hi,
> 
> Am 02.07.20 um 17:01 schrieb 
> lo...@clickworkorange.com
> :
> > On Thu, 2020-07-02 at 13:32 +0100, 
> > lo...@clickworkorange.com
> >  wrote:
> > > My custom invoice template that I've used for many years stopped
> > > working after upgrading to 3.4 as part of a dist-upgrade. I had
> > > to
> > > remove a few things such as 
> 
> :
> 
> also 3.4 is several years old. If you prefer to stay on a
> distribution
> shipping such old program versin, you should consider to use
> https://wiki.gnucash.org/wiki/Flatpak
> .
> 
> > I have compared this with the shipped reports (e.g. taxinvoice.scm)
> > and
> > it looks correct. So, a few hours killed, no progress. Any
> > suggestions?
> 
> Yes, you should compare the shipped reports, but of a *recent*
> GnuCash
> version 3.11 or 4.0. ISTR they got several improvements in between.
> 
> Regards
> Frank

Thanks Frank, but I really just need to get my invoice generated and
sent out. I have no problem staying with the distro version, even if
it's old, as long as my template works. It has bank details, address etc as 
well as a few other bells & whistles such as my logo and tax reg. info - all of 
which are important and tedious to replicate in e.g. LibreOffice Writer. In 
fact in desperation I tried to build an earlier version of GnuCash just to be 
able to do this, but found that my distro ships goffice 0.10.10 while GnuCash 
2.6.19 would only build with goffice >= 0.7.0 and < 0.9.0. Can't be bothered to 
dig deeper so I'm just going to get drunk instead. 






___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Custom invoices don't work after upgrade

2020-07-02 Thread Frank H. Ellenberger
Hi,

Am 02.07.20 um 17:01 schrieb lo...@clickworkorange.com:
> On Thu, 2020-07-02 at 13:32 +0100, lo...@clickworkorange.com wrote:
>> My custom invoice template that I've used for many years stopped
>> working after upgrading to 3.4 as part of a dist-upgrade. I had to
>> remove a few things such as 
:

also 3.4 is several years old. If you prefer to stay on a distribution
shipping such old program versin, you should consider to use
https://wiki.gnucash.org/wiki/Flatpak.

> I have compared this with the shipped reports (e.g. taxinvoice.scm) and
> it looks correct. So, a few hours killed, no progress. Any suggestions?

Yes, you should compare the shipped reports, but of a *recent* GnuCash
version 3.11 or 4.0. ISTR they got several improvements in between.

Regards
Frank
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Custom invoices don't work after upgrade

2020-07-02 Thread lomax
My custom invoice template that I've used for many years stopped
working after upgrading to 3.4 as part of a dist-upgrade. I had to
remove a few things such as 

   (use-modules (gnucash gnc-module))
   (use-modules (gnucash printf))

in order for the template to compile, but I now get 

   Unbound variable: qof-book-get-slots
   In ice-9/boot-9.scm:
   829:9  4 (catch _ _ # _)
   In eguile-gnc.scm:
   187:6  3 (eval-input)
   187:6  2 (lp)
  191:13  1 (loop)
   In ice-9/eval.scm:
   619:8  0 (_ #(#(#(#(#) # …) …) …))

when opening it in gnucash. My template does not contain any use of
qof-book-get-slots. The closest I have is (define (coy-info slots key)
but removing this block of company info makes no difference. I'm a
little desperate as a client has just approved my fees for the first
job I've had since Covid-19 struck and really need to get my invoice
out today. It's a little frustrating that the templating API keeps
changing - I think this is the third time I've upgraded gnucash only to
find I have to spend lots of time "fixing" my invoice template. Please
help! 



 




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Custom invoices don't work after upgrade

2020-07-02 Thread lomax
On Thu, 2020-07-02 at 13:32 +0100, lo...@clickworkorange.com wrote:
> My custom invoice template that I've used for many years stopped
> working after upgrading to 3.4 as part of a dist-upgrade. I had to
> remove a few things such as 
> 
>(use-modules (gnucash gnc-module))
>(use-modules (gnucash printf))
> 
> in order for the template to compile, but I now get 
> 
>Unbound variable: qof-book-get-slots
>In ice-9/boot-9.scm:
>829:9  4 (catch _ _ # _)
>In eguile-gnc.scm:
>187:6  3 (eval-input)
>187:6  2 (lp)
>   191:13  1 (loop)
>In ice-9/eval.scm:
>619:8  0 (_ #(#(#(#(#) # …) …) …))
> 
> when opening it in gnucash. My template does not contain any use of
> qof-book-get-slots. The closest I have is (define (coy-info slots
> key)
> but removing this block of company info makes no difference. I'm a
> little desperate as a client has just approved my fees for the first
> job I've had since Covid-19 struck and really need to get my invoice
> out today. It's a little frustrating that the templating API keeps
> changing - I think this is the third time I've upgraded gnucash only
> to
> find I have to spend lots of time "fixing" my invoice template.
> Please
> help! 

I went through my template looking at every instance of "key", "qof",
"coy" and similar, and commented out the only bits I could find which
seemed even remotely relevant: 

   ; (define (coy-info slots key)
   ;   ;; Extract a value from the company info key-value pairs
   ;   (kvp-frame-get-slot-path-gslist
   ; slots 
   ; (append gnc:*kvp-option-path* (list gnc:*business-label*
   key


and

   ;  (add-option (gnc:make-text-option notespage optname-extra-css "b"
   ;(N_ "Embedded CSS.")  "h1.coyname { text-align:
   left;}"))

That got rid of the earlier error message, but I'm not sure if this
brought me closer to getting paid or not, because the report now
explodes with 

 16 (apply-smob/1 #)
   In c-interface.scm:
22:4 15 (gnc:call-with-error-handling _ _)
   In ice-9/boot-9.scm:
   829:9 14 (catch #t # # _)
   In c-interface.scm:
   29:29 13 (_)
   In unknown file:
 12 (eval-string "(gnc:report-run 2)" #)
   In ice-9/boot-9.scm:
  2312:4 11 (save-module-excursion #)
   In ice-9/eval-string.scm:
38:6 10 (read-and-eval # #:lang _)
   In report.scm:
   830:4  9 (gnc:report-run _)
   In c-interface.scm:
   70:23  8 (gnc:backtrace-if-exception _ . _)
22:4  7 (gnc:call-with-error-handling _ _)
   In ice-9/boot-9.scm:
   829:9  6 (catch #t # # _)
   In c-interface.scm:
   27:29  5 (_)
   In report.scm:
  834:24  4 (_)
  807:34  3 (gnc:report-render-html #< type:
   6e28a7d672124a8a854a668434f02c7 id: 2 options: # dirty?: #t needs-save?: #t editor-w…> …)
   In /home/me/.config/gnucash/my-invoice.scm:
  310:36  2 (report-renderer _)
   In options.scm:
  144:16  1 (gnc:option-value _)
   113:2  0 (gnc:option-getter _)
   In procedure vector-ref: Wrong type argument in position 1
   (expecting vector): #f

If possible an even more indecipherable exception "In procedure vector-
ref: Wrong type argument in position 1 (expecting vector): #f" I cannot
see a vector-ref anywhere in my template, but I do have this block at
the end: 

   (gnc:define-report
 'version 1
 'name (N_ "My Invoice")
 'report-guid "6e28a7d672124a8a854a668434f02c7"
 'menu-name (N_ "My Invoice")
 'menu-tip (N_ "Display a customer invoice in my style")
 'menu-path (list gnc:menuname-business-reports)
 'options-generator options-generator
 'renderer report-renderer)

I have compared this with the shipped reports (e.g. taxinvoice.scm) and
it looks correct. So, a few hours killed, no progress. Any suggestions?

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Custom invoices don't work after upgrade

2020-07-02 Thread lomax
My custom invoice template that I've used for many years stopped
working after upgrading to 3.4 as part of a dist-upgrade. I had to
remove a few things such as 

   (use-modules (gnucash gnc-module))
   (use-modules (gnucash printf))

in order for the template to compile, but I now get 

   Unbound variable: qof-book-get-slots
   In ice-9/boot-9.scm:
   829:9  4 (catch _ _ # _)
   In eguile-gnc.scm:
   187:6  3 (eval-input)
   187:6  2 (lp)
  191:13  1 (loop)
   In ice-9/eval.scm:
   619:8  0 (_ #(#(#(#(#) # …) …) …))

when opening it in gnucash. My template does not contain any use of
qof-book-get-slots. The closest I have is (define (coy-info slots key)
but removing this block of company info makes no difference. I'm a
little desperate as a client has just approved my fees for the first
job I've had since Covid-19 struck and really need to get my invoice
out today. It's a little frustrating that the templating API keeps
changing - I think this is the third time I've upgraded gnucash only to
find I have to spend lots of time "fixing" my invoice template. Please
help! 



 



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Transcation Search & Replace

2020-07-02 Thread Adrien Monteleone
There are ways to accomplish what you want, but no, there is no built-in ‘Find 
& Replace All’ feature.

I would ask, what are you trying to accomplish? What problem are you trying to 
solve?

and

How many transactions are we talking about?

Regards,
Adrien

> On Jul 1, 2020 w27d183, at 2:57 PM, listsub3 
>  wrote:
> 
> Is there any functionality to do bulk search & replace on transactions?  My 
> old 2002 Quicken had this feature and it was really useful to do bulk 
> changes/corrections.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Transcation Search & Replace

2020-07-02 Thread Derek Atkins
listsub3  writes:

> Is there any functionality to do bulk search & replace on
> transactions?  My old 2002 Quicken had this feature and it was really
> useful to do bulk changes/corrections.

There is a bulk search, but the replace must be done manually from the
resulting search results window.

Sorry.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Australian System

2020-07-02 Thread Christopher Lam
GnuCash is designed to be world-neutral. Record your transactions in any
currency. There is a report "Income and GST Statement" which will summarise
your BAS for you, assuming you have recorded them correctly.

On Thu, 2 Jul 2020 at 11:00, Mike Alsop  wrote:

> You have probably been asked a thousand times, but as we entered a new
> financial year yesterday, I seriously need to look at doing my own
> books. Bookkeeping fees are now over the moon!!
>
> So, does this system comply with the Aussie GST and BAS reporting
> system for the Australian Taxation Office??
>
> Many thanks in advance for any info.
>
> Mike
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Australian System

2020-07-02 Thread Liz
On Thu, 02 Jul 2020 15:38:38 +0930
Mike Alsop  wrote:

> You have probably been asked a thousand times, but as we entered a new
> financial year yesterday, I seriously need to look at doing my own
> books. Bookkeeping fees are now over the moon!!
> 
> So, does this system comply with the Aussie GST and BAS reporting
> system for the Australian Taxation Office??
> 
> Many thanks in advance for any info.
> 
> Mike

Mike
thanks for the question
Many of us are doing our business accounting in AU with Gnucash.

There isn't a way to automatically populate anything on the ATO website.

I am doing my IAS and BAS on paper ever since the ATO broke the system
for renewing certificates and I couldn't use the electronic system on
Linux. That would be about 13 years of quiet protest  ;)


Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Australian System

2020-07-02 Thread Mike Alsop
You have probably been asked a thousand times, but as we entered a new
financial year yesterday, I seriously need to look at doing my own
books. Bookkeeping fees are now over the moon!!

So, does this system comply with the Aussie GST and BAS reporting
system for the Australian Taxation Office??

Many thanks in advance for any info.

Mike
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.