Balance sheet out - how do I fix?

[bunk3m]

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