Re: [GNC] Exchange rate of income statement report

2020-10-15 Thread Christopher Lam
Found it. Both methods are acceptable: 1) reach foreign currency converted to local according to Forex on date. Transaction report will do this. 2) average rate is allowed under GAAP. Not doable easily unless price data is carefully scrutinised.

Re: [GNC] ASX quotes not working

2020-10-15 Thread John Bonnett
Hi Geoff, I am still not getting all my stocks retrieved inside GnuCash but I may have made some progress. I checked the stocks not working using gnc-fq-dump and they all retrieved except for one I still had that had been de-listed, so that is as expected, but does not explain why they

Re: [GNC] ASX quotes not working

2020-10-15 Thread John Bonnett
Hi Geoff, I seem to have partly solved my problem. Following up on a comment from Bill and your interest in the version of Perl I was running, I chased up a recent version of Strawberry Perl. I got v5.32.0 64bit and installed that. It still thought I had the older 32bit installed so I tried

Re: [GNC] Exchange rate of income statement report

2020-10-15 Thread Christopher Lam
As I understand, for personal tax most would offer the original currency income statements to the accountant; the latter would convert to local currency using an exchange rate from legislated sources. To achieve this using the formal reports you'd ensure there is price data USD/ILS on the report

Re: [GNC] Payment initiation; was: FreeBSD and GNUCash

2020-10-15 Thread Derek Atkins
On Thu, October 15, 2020 2:18 pm, Frank H. Ellenberger wrote: > the european protocolls EBICS and FinTS have the > ability to upload PAyment INitiation (PAIN). And BOY does it hurt!!! LOL. > Regards > Frank > Please remember to CC this list on all your replies. > You can do this by

[GNC] Payment initiation; was: FreeBSD and GNUCash

2020-10-15 Thread Frank H. Ellenberger
Hi Maf., I found this accidently while googling for another theme and think, I should correct you. Am 01.04.16 um 13:00 schrieb Maf. King: > GnuCash, AFAIK, can not initiate transactions with your banking institutions. > The mostly american used [direct]OFX can only download CAsh Management

Re: [GNC] Exchange rate of income statement report

2020-10-15 Thread Gal
Michael or Penny Novack wrote > Well, this was the P report, one of the uses being when filing out tax > forms (this is a case where the name usually used for the report depends > on the form of the entity for which the books being kept) > > So what do the tax codes of the US and

Re: [GNC] Exchange rate of income statement report

2020-10-15 Thread Michael or Penny Novack
On 10/15/2020 7:23 AM, Gal wrote: Michael or Penny Novack wrote Meanwhile, Gal,  please explain something to me. If you wanted dollar amounts converted to shekels as of the date of the initial transaction (frozen as of that date) why entered in dollars rather than shekels? Actually, I'm in the

Re: [GNC] Exchange rate of income statement report

2020-10-15 Thread Gal
Michael or Penny Novack wrote > Meanwhile, Gal,  please explain something to me. If you wanted dollar > amounts converted to shekels as of the date of the initial transaction > (frozen as of that date) why entered in dollars rather than shekels? Actually, I'm in the middle of my evaluation of

Re: [GNC] Exchange rate of income statement report

2020-10-15 Thread Michael or Penny Novack
On 10/15/2020 5:37 AM, Gal Bar Mashiah wrote: I have expense accounts in several currencies, for example: Expenses:Food:USD Expenses:Food:ILS I run the income statement report for 2013 for example, select only Expenses:Food account (and its sub accounts) and select ILS as the currency report.

Re: [GNC] Exchange rate of income statement report

2020-10-15 Thread Christopher Lam
The only report with ability to exchange currency amounts using price on posting date is the Transaction Report. On Thu, 15 Oct 2020, 5:40 pm Gal Bar Mashiah, wrote: > I have expense accounts in several currencies, for example: > Expenses:Food:USD > Expenses:Food:ILS > > I run the income

[GNC] Exchange rate of income statement report

2020-10-15 Thread Gal Bar Mashiah
I have expense accounts in several currencies, for example: Expenses:Food:USD Expenses:Food:ILS I run the income statement report for 2013 for example, select only Expenses:Food account (and its sub accounts) and select ILS as the currency report. The Price source chosen is Nearest in time.

Re: [GNC] ASX quotes not working

2020-10-15 Thread Peter West
-- Peter West p...@pbw.id.au “Woe to you lawyers also! For you load people with burdens hard to bear, and you yourselves do not touch the burdens with one of your fingers.” It’s not strange, because %decoded_json is the name of a hash, a structure of key=>value pairs. A single “value” is a

Re: [GNC] ASX quotes not working

2020-10-15 Thread dullege
Hi, Fyi the fixed ASX.pm is working here for me (Strawberry perl v5.32.0) PS C:\Program Files (x86)\gnucash\bin> perl gnc-fq-dump ASX BHP Finance::Quote fields Gnucash uses: symbol: BHP <=== required date: 10/15/2020 <=== recommended currency: AUD

Re: [GNC] ASX quotes not working

2020-10-15 Thread John Bonnett
Strawberry Perl 5.18.2.2-32bit On 15/10/2020 4:21 pm, Geoff wrote: Hmmm.  I can't reproduce your problem.  What version of perl are you running please John? > perl -v Thanks Geoff = On 15/10/2020 4:09 pm, John Bonnett wrote: Hi Geoff, I had an error in naming the file. I had a space