[GNC] Balance Sheet - Currency Conversion

[Adrien Monteleone]

I would think the ‘Most Recent’ or ’Nearest in Time’ options would not look at the price db past the closing date of the report.

And if it does look past the date, Average/Weighted Average wouldn’t work either because transactions (and prices) entered post 6/30/19 shouldn’t be part of the report.

Running a Balance Sheet for a specified closing date should produce the same report no matter what day it is run on, without regards to any transactions or price data entered after 6/30/19. (assuming no historical transactions or prices were altered)

I should think it a bug if this is not the case.

Regards,
Adrien


> On Aug 3, 2019, at 3:52 AM, Christopher Lam <christopher.lck at gmail.com> wrote:
> 
> Simple answer, unfortunately no.
> Running balance sheet (or multicolumn balance sheet) on date 30/06/19 will
> try the nearest pricedb entry by default, which is dated 05/07/19.
> If you wish to run balance-sheet using prices dated 05/06/19, you will have
> to duplicate the 05/06/19 prices to the new date 30/06/19.
> HTH
> 
> On Sat, 3 Aug 2019 at 08:33, Danilo Freitas da Costa <danfcosta at gmail.com>
> wrote:
> 
>> Hi, @ll!
>> 
>> I'm facing a strange issue or misunderstanding, using different currencies.
>> 
>> For simplification, I have an account tree like this:
>> 
>> Asset
>> Asset : Account-1 (BRL)
>> Income
>> Income : Income-1 (USD)
>> 
>> My default currency is BRL.
>> 
>> Steps (example):
>> 
>> 1. Add an income on 07/Jun/2019 and provide the currency quotation on this
>> date.
>> 2. Generate Balance Sheet report until 30/06/2019
>> 
>> Until now, everything is OK. The conversion sounds good.
>> 
>> 3. Add a new income on 05/Jul/2019 and provide the currency quotation on
>> this date.
>> 4. Generate Balance Sheet report until 30/06/201.
>> 
>> Now, the report Balance Sheet uses the most recent quotation not the
>> quotation on 07/jun. As well, the total of "Assets" and "Liabilities and
>> Equity" doesn't match.
>> 
>> Is there any way to use this entries and provide a balance sheet with the
>> the correct value?
>> 
>> Regards,
>> 
>> *Danilo*