Hi,

The “Memory Error” occurs because the Dynamic General Ledger report tries to load all 5.7 million journal items into memory at once. While this may work on a local system with fewer records or more available RAM, the production server likely runs out of memory during processing. This is common when databases grow large and Odoo attempts to compute totals, filters, or PDF exports in memory instead of streaming results.

To fix this, start by optimizing your server resources — increase available RAM and, if possible, enable swap space to prevent crashes. Next, limit the data volume being processed at once: filter the report by smaller date ranges, journals, or accounts to reduce the load. You can also disable “load all entries” options if available in the report filters.

For a long-term solution, consider enabling PostgreSQL optimization (e.g., increasing work_mem and shared_buffers), and make sure your database has proper indexes on key fields like move_id, date, and account_id. If you are using Odoo Enterprise, you can schedule background reports or use spreadsheet-style reports to handle large data sets more efficiently.

In summary, this issue is caused by insufficient memory for such a large dataset. Filtering report ranges, improving server memory, and tuning PostgreSQL performance are the most effective ways to resolve it.

Hope it helps