Balance sheet out - how do I fix?

[Carsten Rinke]

Hi,

in order to exclude a program bug:

Is it possible to reproduce this behaviour starting with a new file that 
has similar transactions for the Feb-Mar 2012 time frame?
Yes, this can be quite some work depending on your setup and on the 
amounts of transactions at that time.
But you can export the "empty" account tree and maybe it is enough to 
"only" enter the suspecious transactions and price info.

Kind regards,
/Carsten


On 04/09/2013 06:44 PM, bunk3m wrote:
> Not sure if this got through or if it's gotten lost.  So a resend.
>
> Still need some help to figure out why the balance sheet doesn't balance
> anymore.
>
> Thanks in advance.
>
> B.
>
> ---Original Send Apr. 5, 2013 13:21---
> I checked each account manually and there are no transactions on Mar 12
> or 13.  I also ran a transaction report selecting all accounts for Mar
> 2012. The report shows the closest transactions are Mar 4 and Mar 21.
> The price editor has price info on Feb 29 {xfer-dialog 1.022} and Mar 26
> {user:price-editor 0.9894}.  The balance sheet on Mar 13 should use the
> 1.022 exchange rate too. (??)
>
> So, I'm as sure as I can be that there are no transactions or price
> changes.
>
> I'm assuming there must be a corruption in the file or a bug in the
> program.  What do you suggest to try next?
>
> Just a wild thought here ... Mar 13 is exactly 1/2 way between Feb. 29
> and Mar 26.  Is it possible that the program is adjusting/averaging the
> difference in the dates to determine the currency rate even when I've
> selected "Nearest In Time" on the report?  If yes or no, the balance
> sheet should still balance.
>
> B.
>
> On 5.04.2013 12:23 , Derek Atkins wrote:
>> bunk3m <bunk3m at gmail.com> writes:
>>
>>> Further to my earlier email, I checked balance sheets back month by
>>> month until I found the dates between which the balance sheet got out of
>>> balance.
>>>
>>> March 12, 2012 balance sheet is OK.  CAD-USD xchg = 1.022 on report
>>> March 13, 2012 balance sheet is out by $0.32. CAD-USD xchg = 0.9894
>>>
>>> 1) Both reports use Commodity:Price Source:Nearest in Time.
>>> 2) All base currency (CAD) balances are identical in both reports.
>>> 3) The only differences between the two reports is the USD valuation
>>> calculation, which shouldn't be there because the price didn't change.
>>>
>>> There are no transactions on either date.  There is no currency price on
>>> either date in the Price Editor, so there should be no change in the
>>> currency on the report.
>>>
>>> What's going on?  What do I need to do to fix this?
>>>
>>> Is this a bug?
>>>
>>> Thanks in advance for your help and quick reply.
>> There must be SOME piece of data on March 12 or March 13 that is causing
>> this.  Are you SURE there's no transactions or PriceDB entries?
>>
>>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>