Hi everyone,
I’m trying to create a custom version of the Stock Balance report that shows only quantities (no values) and includes minimal filters.
I’ve set it up as a Query Report, but I’m running into an issue — the Opening Qty and Closing Qty are not calculated correctly whenever there’s a Stock Reconciliation entry.
Has anyone implemented a similar report or figured out the correct way to handle stock reconciliation adjustments in custom stock reports?Any pointers on which backend logic or functions (from stock_ledger.py or elsewhere) should be referenced to get accurate quantities would be really helpful.
Thanks!