[GNC] Commodities in Balance Sheet Report Missing Prices

[John Ralls]

> On Nov 10, 2025, at 08:34, David Carlson <david.carlson.417 at gmail.com> wrote:
> 
> I am currently using the Windows Nightly Build 5.13 dated November 10, 2025.
> When I run a Balance Sheet Report or a custom report based on that report,
> Commodities that do not have a price dated on or before the report date
> that is visible in the Price Database are not given a value in the report.
> I use the Last up through report date price source because I am comparing
> the report with my broker's report.
> While the  Price Database has recent entries generated by purchase and sale
> transactions, for some reason sale and purchase prices before November 30,
> 2022 for some securities do not exist, even though I have been tracking
> those securities in GnuCash for over 10 years.
> 
> I believe that in the past either this price source selection method picked
> up prices from transaction history and did not need them to be duplicated
> in the Price Database, which may have prices purged accidentally or
> intentionally from time to time or perhaps the prices were always
> duplicated in the.Price Database and updated if a transaction was edited.
> 
> Do I need to file a bug report?

No, you need to put historical prices in your price database.

Report pricing is and has always been either price database (nearest in time, nearest in time before, latest) or transaction-based (average cost, weighted average cost). Transaction have written a price into the database since sometime around the v2.6. release. That’s probably what you’re thinking of. 

I think the only way to delete prices from the price database is to use the RemoveOlld button in the Price Database window. That opens another dialog that provides pretty fine-grained control over what prices to remove, so it would be hard to do it inadvertently. Might you have done that?

Regards,
John Ralls