Re: [GNC] Charts with Multiple Currency

[Christopher Lam]

Most reports are designed to convert to one particular currency.

There are only a few only reports which do not necessitate a target
currency . Try the multi column balance sheet in the experimental reports
menu?

On Sat, 12 Oct 2019, 08:54 risokei,  wrote:

> Hello,
>
> Thanks for your help.
>
> I inputted 1,000,000 JPY as cash and 55 facebook(it worth almost
> 10,000USD, this mean it worth almost 1,000,000 JPY)
>
> So my expectation is asset chart shows the total value is 2,000,000 JPY,
> but actually it shows 1,000,000 JPY as cash and 100,000 JPY as asset
> On 2019/10/06 14:14, Christopher Lam wrote:
>
> Hello, nice to hear users using multiple currencies in reports. Most
> reports were designed to run converting all currencies into a "target"
> currency. It would be useful to know exactly what report options you are
> using, and exactly what you're trying to achieve.
>
> On Sun, 6 Oct 2019, 12:56 risokei,  wrote:
>
>> Hello,
>>
>> I'm using Gnucash with Japanese Yen and USD
>> Some charts show the data by graph.
>> But the graph is wrong. It seems all data is treated as Japanese Yen in
>> the graph.
>>
>> For example, Networth line chart
>>
>> I have 100 JPY and US asset which worth 1 USD(1USD is almost 100 JPY),
>> Gnucash draw the graph as 100 for currency and 1 for foreign asset value.
>> I think JPY and USD asset should have same volume in the graph in this
>> example.
>>
>> I guess gnucash don't have the feature to draw a graph with multi
>> currency .
>>
>> Is there any workaround or fix for this?
>>
>> Thanks in advance.
>>
>> Risok
>>
>> ___
>> 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] Gnucash on MacOs Catalina

[John Ralls]

Cool it with the wild speculation.

FYI I've been running GnuCash 3.5, 3.6, and 3.7 on Catalina since the first 
developer beta in early June with no issues at all.

I suspect from the error messages that the OP is trying to run GnuCash 2.6.x. 
Those were built as 32-bit apps to support MacOS 10.5 and 10.6. Catalina won't 
run 32-bit apps. That's why I asked the OP what version of GnuCash they're 
trying to run.

Regards,
John Ralls

> On Oct 10, 2019, at 7:48 PM, GWB  wrote:
> 
> Chronosync is another app that needed some work to integrate smoothly
> with Catalina.  This excerpt from their email to users explains:
> 
> <<
> The Catalina Split
> Catalina introduces a new APFS feature called ‘Volume Groups’. Under
> Catalina, Apple takes advantage of this ability and splits the boot
> volume into two components: System and Data. The System volume is
> read-only and contains all the operating system files that should
> never change during use of the computer. The Data volume contains
> everything else, including the user’s home folders. Through a new
> Apple feature known as firmlinks, the two volumes are linked together
> to appear as one volume to the user, so you will only see one drive on
> your Mac. However, there really are two distinct boot volumes mounted.
> You can see the two volumes using Disk Utility or by mounting the
> drive on an older macOS. If running a bootable backup, we strongly
> recommend starting fresh with a new backup volume and not to copy over
> your old bootable backup volume. Read the ChronoSync Catalina Tech
> Note for all the details.
>>> 
> 
> This may have no relevance at all, but if your version of GnuCash
> "needs" to alter a specific file in the System folder (which is
> doubtful, but possible) Catalina may be using a "hard link" instead of
> the underlying file.  The devs would know.
> 
> I'm not sure, but it looks like Apple is re-inventing the old LVM and
> calling it something different.  It's usually good to separate boot OS
> from data (Unix welcomes Apple to 1998!), but this might not be the
> way to do it.  Better to just mount them in separate LVM
> containers/volumes, and snapshot them.
> 
> What type of CPU does system information report on your mac?  The
> error message "Bad CPU type in executable" might be Catalina seeing a
> CPU call from GnuCash (amd64 bit i7, usually) as something else.
> 
> Gordon
> 
> On Wed, Oct 9, 2019 at 10:19 PM John Ralls  wrote:
>> 
>> 
>> 
>>> On Oct 9, 2019, at 1:09 PM, gnuc...@pelchar.no-ip.org wrote:
>>> 
>>> Hi,
>>> 
>>> I'm having trouble starting gnucash on Catalina. Here's the message I get
>>> from the command line:
>>> 
>>> /Volumes/Macintosh HD/Applications/Gnucash.app/Contents/MacOS/Gnucash: line
>>> 95: /Volumes/Macintosh
>>> HD/Applications/Gnucash.app/Contents/MacOS/Gnucash-bin: Bad CPU type in
>>> executable
>>> /Volumes/Macintosh HD/Applications/Gnucash.app/Contents/MacOS/Gnucash: line
>>> 95: /Volumes/Macintosh
>>> HD/Applications/Gnucash.app/Contents/MacOS/Gnucash-bin: Undefined error: 0
>>> 
>>> Anybody has a clue?
>> 
>> What version of GnuCash?
>> 
>> 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.

___
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] How to find transactions where any split in register has a memo containing xxxx

[Adrien Monteleone]

I too have discovered that ‘Find’ will only match memos where the account for 
that split matches the current register account.

If you want to see all splits with a certain memo, then you need to run ‘Find’ 
from the CoA tab, however, this will search all accounts.

You could add a criteria based on account to narrow (refine) this down. (but 
this might produce the same result, not sure)

Possibly (I haven’t tried) a transaction report run with a similar filter and 
limited to only the desired account(s) might also provide what you want.

I can certainly see the utility of a search to find all transactions you paid 
cash for (register) that happened to match a certain memo description, (but 
where that memo description was detailed say, on the expense split, not the 
payment split) and where the actual ‘Description’ may vary.

Regards,
Adrien

> On Oct 11, 2019 w41d284, at 8:18 PM, Chris Good  wrote:
> 
> Hi,
> 
> 
> 
> From a register, I want to find (Control-F) all transactions in the current
> register that have a split with a memo containing say ''.
> 
> GnuCash seems it only looks in splits for the register account?
> 
> I would expect it to look in splits for all accounts in the register.
> 
> 
> 
> I have tried the 'Account' and 'All Accounts' options but no joy.
> 
> 
> 
> GnuCash 3.6 on Windows.
> 
> 
> 
> I cannot find any fixed 3.6 or 3.7 bugs that seem to be relevant.
> 
> 
> 
> Regards,
> 
> Chris Good


___
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] How to find transactions where any split in register has a memo containing xxxx

[Chris Good]

Hi,

 

>From a register, I want to find (Control-F) all transactions in the current
register that have a split with a memo containing say ''.

GnuCash seems it only looks in splits for the register account?

I would expect it to look in splits for all accounts in the register.

 

I have tried the 'Account' and 'All Accounts' options but no joy.

 

GnuCash 3.6 on Windows.

 

I cannot find any fixed 3.6 or 3.7 bugs that seem to be relevant.

 

Regards,

Chris Good

 

___
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] Importing a CSV with transactions in another currency

[David Cousens]

There is really no way GnuCash can do that at least at the moment. The
easiest way to achieve it would be to use the multiline multisplit import
mode and prior to import into GnuCash import the data into a spreadsheet and
add the additional information in a Rate/Price column for each split.  

If you export a typical transaction of the currency conversion type you want
to import from GnuCash and don't choose the Simple Layout option you will
get a CSV file which will give you the format you need for import. You can
use the copy command to change the rate/price for the splits to the expense
accounts to the desired conversion rate.  One problem is that GnuCash
exports  currency conversion rates in a "3+ 144456/238798" format and my
experience is that it does not parse this correctly on import in some
circumstances.  I haven't confirmed yet that if you convert the rational
rate to a decimal number that it always imports correctly but I suspect it
might.

This is probably easier than duplicating the expense accounts.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] Importing a CSV with transactions in another currency

[Frederico Zica]

Hello!

I have been using gnucash with more than one currency, but recently I got
puzzled about how to proceed with a CSV import.

In that CSV there are USD transactions while my main Gnucash currency is
not USD, and the majority of my accounts don't have USD as their currency.

I'm importing those transactions to a 'Bank' type account that is USD, but
the majority of the counterpart accounts for these transactions are
expenses accounts. These expense accounts are not in USD, so Gnucash
imports them, without issuing any warning, and assumes a 1:1 exchange rate.
Here comes the problem: I could go through all of them and set an exchange
rate, but that would consume a lot of time.

The ideal solution for me would be Gnucash asking me what would be the
conversion rate that I expected for ALL the imported transactions only one
time, or simply assuming the current conversion rate.

I see right now a couple solutions to this:

   1. Duplicating all the expenses account I have in my main currency as
   USD accounts - that would work but would unnecessarily create a lot of
   additional accounts
   2. Setting the exchange rate each time I do it - would be really
   time-consuming


Are there better ways of doing this?


Thanks!
--
___
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] Gnucash on MacOs Catalina

[GWB]

Chronosync is another app that needed some work to integrate smoothly
with Catalina.  This excerpt from their email to users explains:

<<
The Catalina Split
Catalina introduces a new APFS feature called ‘Volume Groups’. Under
Catalina, Apple takes advantage of this ability and splits the boot
volume into two components: System and Data. The System volume is
read-only and contains all the operating system files that should
never change during use of the computer. The Data volume contains
everything else, including the user’s home folders. Through a new
Apple feature known as firmlinks, the two volumes are linked together
to appear as one volume to the user, so you will only see one drive on
your Mac. However, there really are two distinct boot volumes mounted.
You can see the two volumes using Disk Utility or by mounting the
drive on an older macOS. If running a bootable backup, we strongly
recommend starting fresh with a new backup volume and not to copy over
your old bootable backup volume. Read the ChronoSync Catalina Tech
Note for all the details.
>>

This may have no relevance at all, but if your version of GnuCash
"needs" to alter a specific file in the System folder (which is
doubtful, but possible) Catalina may be using a "hard link" instead of
the underlying file.  The devs would know.

I'm not sure, but it looks like Apple is re-inventing the old LVM and
calling it something different.  It's usually good to separate boot OS
from data (Unix welcomes Apple to 1998!), but this might not be the
way to do it.  Better to just mount them in separate LVM
containers/volumes, and snapshot them.

What type of CPU does system information report on your mac?  The
error message "Bad CPU type in executable" might be Catalina seeing a
CPU call from GnuCash (amd64 bit i7, usually) as something else.

Gordon

On Wed, Oct 9, 2019 at 10:19 PM John Ralls  wrote:
>
>
>
> > On Oct 9, 2019, at 1:09 PM, gnuc...@pelchar.no-ip.org wrote:
> >
> > Hi,
> >
> > I'm having trouble starting gnucash on Catalina. Here's the message I get
> > from the command line:
> >
> > /Volumes/Macintosh HD/Applications/Gnucash.app/Contents/MacOS/Gnucash: line
> > 95: /Volumes/Macintosh
> > HD/Applications/Gnucash.app/Contents/MacOS/Gnucash-bin: Bad CPU type in
> > executable
> > /Volumes/Macintosh HD/Applications/Gnucash.app/Contents/MacOS/Gnucash: line
> > 95: /Volumes/Macintosh
> > HD/Applications/Gnucash.app/Contents/MacOS/Gnucash-bin: Undefined error: 0
> >
> > Anybody has a clue?
>
> What version of GnuCash?
>
> 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.
___
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] [MAINT] network outage affecting code.gnucash.org

[Derek Atkins]

Hi,

There was a network outage that took out code.gnucash.org for the past
30-ish hours.  The cablemodem in front of the network got reset in a way
that it blocked the router sitting behind it.  I have reset the CM
configuration and packets are now flowing.  There's a tech scheduled to
come in the next 30 minutes and I'll make sure he doesn't break it.

This affected the Wiki, Email, IRC Logger, Git, and all other services
run off code.gnucash.org.  At this point messages should be flowing
again, so while there will be a delay I don't expect anything to be lost.

Sorry for the inconvenience.

Long term, the systems will be moving to more permanent digs which have
better networking.  I expect that move to happen before the end of the
year, hopefully sooner rather than later.

Please let me know if you have more issues.

Thanks,

-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.

[GNC] Search UI in v3.7

[aegross]

Haven't seen anything posted on this so maybe this is a problem with my
setup?  I also checked the bugs on https://www.gnucash.org/news.phtml.  

When using the search function, just one of the requested parameters is
visible, although there is a good amount of white space in the dialogue box. 
Anyone else seeing this?

OS: Mac 10.12.6 (last version this Mac will support)

Thanks,
Andrew


 




--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.