Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

2019-02-23 Thread Wm via gnucash-devel
On 10/02/2019 19:46, Alex Aycinena wrote: It is possible that Wm is noting a problem in gnucash that I'm trying to address with my 'Book Currency' enhancement (unfortunately, a bit delayed). I'm not antagonistic to your idea, Alex, just not sure I understand it. For most users who deal in a

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

2019-02-11 Thread Wm via gnucash-devel
On 11/02/2019 17:30, Adrien Monteleone wrote: Please tell me the intent is to *add* the book currency value, not replace the actual currency value. Our USA friends are still thinking about what a TB is for. I would hope that the actual currency transaction data would still be available. >

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

2019-02-11 Thread Adrien Monteleone
Please tell me the intent is to *add* the book currency value, not replace the actual currency value. I would hope that the actual currency transaction data would still be available. If you have to reconcile against statements or receipts (or suffer an audit) with foreign amounts sans their

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

2019-02-11 Thread Wm via gnucash-devel
On 11/02/2019 04:03, David Carlson wrote: Wm, before you run off at the mouth with all your innuendos, look at facts. I'm hoping you get a message from Liz If you don't there is something rotten in this list's administration. Did you try running a test on one of your backups from around

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

2019-02-11 Thread Wm via gnucash-devel
On 09/02/2019 13:03, D via gnucash-devel wrote: That sounds to me like it's using a different exchange rate from one day to another, and I'd agree with your assessment in that case. I would have thought that the exchange rate in the transaction would be used. You are correct. I have an

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

2019-02-11 Thread Wm via gnucash-devel
On 10/02/2019 22:52, David Carlson wrote: Wm, Where does unrealized income fall into tb if there is no price in the database on the closing date for one or more security or currency accounts because it was not sold? Essentially it doesn't occur, it is just a number of something if you aren't

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

2019-02-10 Thread Wm via gnucash-devel
On 10/02/2019 12:40, David Carlson wrote: Lets all step back a second and consider what the report is supposed to show before deciding whether it is always correct. I think the report is conceptually broken. The report is supposed to cover all of the assets and liabilities that were selected

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

2019-02-10 Thread Wm via gnucash-devel
On 10/02/2019 16:54, John Ralls wrote: The "Average Cost" price source creates a price based on the actual transaction prices and is designed for the TB report, see the thread beginning with https://lists.gnucash.org/pipermail/gnucash-devel/2008-July/023297.html. I broke it for 2.6.13-2.6.21,

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

2019-02-10 Thread Wm via gnucash-devel
On 10/02/2019 09:14, Geert Janssens wrote: Op zondag 10 februari 2019 09:56:51 CET schreef Adrien Monteleone: I’m in agreement on that note. I understand why someone who doesn’t close books would like a report that shows a current position. But the Trial Balance report is really only useful for

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

2019-02-10 Thread Alex Aycinena
> > > -- Forwarded message -- > From: John Ralls > To: Adrien Monteleone > Cc: "gnucash-de...@lists.gnucash.org" > Bcc: > Date: Sun, 10 Feb 2019 08:54:03 -0800 > Subject: Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I > th

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

2019-02-10 Thread David Carlson
Lets all step back a second and consider what the report is supposed to show before deciding whether it is always correct. The report is supposed to cover all of the assets and liabilities that were selected when configured only over time interval which was also selected during the configuration.

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

2019-02-10 Thread Geert Janssens
Op zondag 10 februari 2019 09:56:51 CET schreef Adrien Monteleone: > I’m in agreement on that note. I understand why someone who doesn’t close > books would like a report that shows a current position. But the Trial > Balance report is really only useful for the close books crowd. It should > only

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

2019-02-10 Thread Adrien Monteleone
I’m in agreement on that note. I understand why someone who doesn’t close books would like a report that shows a current position. But the Trial Balance report is really only useful for the close books crowd. It should only reflect actual transactions in the various registers. In the case of

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

2019-02-10 Thread D via gnucash-devel
Ok. I'll preface my comments with the note that every time I try to understand how the trial balance report works, someone on the list points out how misguided my understanding is That being said, I don't understand how a trial balance of completed transactional history could change value

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

2019-02-09 Thread David Carlson
Following up on my last email, in version 2.6.17 the Trial Balance report does default to nearest in time as the default valuation procedure. I don't know what happens in 3.4. David Carlson On Sat, Feb 9, 2019 at 9:05 AM David Carlson wrote: > Now if there is an exchange rate entry for 12-19

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

2019-02-09 Thread David Carlson
Now if there is an exchange rate entry for 12-19 and 12-16 but not for 12-18 or 12-17-2017 and the report is using nearest in time, that could cause what you are seeing. On Sat, Feb 9, 2019 at 7:04 AM D via gnucash-devel < gnucash-devel@gnucash.org> wrote: > That sounds to me like it's using a

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

2019-02-09 Thread D via gnucash-devel
That sounds to me like it's using a different exchange rate from one day to another, and I'd agree with your assessment in that case. I would have thought that the exchange rate in the transaction would be used. Mind you, I can't wrap my head around the subtleties that seem to apply on this

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

2019-02-09 Thread Wm via gnucash-devel
On 09/02/2019 07:00, Wm via gnucash-devel wrote: Background: My gnc TB has been wrong for years.  This hasn't been a problem for me because I can do my own TB in sql and satisfy myself all is relatively well with my accounts.  Over the last week or so I decided to try again and I think the gnc

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

2019-02-09 Thread Wm via gnucash-devel
On 09/02/2019 07:00, Wm via gnucash-devel wrote: Background: My gnc TB has been wrong for years.  This hasn't been a problem for me because I can do my own TB in sql and satisfy myself all is relatively well with my accounts.  Over the last week or so I decided to try again and I think the gnc

[GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

2019-02-08 Thread Wm via gnucash-devel
Background: My gnc TB has been wrong for years. This hasn't been a problem for me because I can do my own TB in sql and satisfy myself all is relatively well with my accounts. Over the last week or so I decided to try again and I think the gnc TB report is b0rked. Looking at the bug list,