Advice for creating consolidated report from different modules

Currently, I’m working on ERPNext manufacturing project for an Oil manufacturing company. They’re requesting a single consolidated report of few modules like purchase, stock, sales, etc… I need the advice to consolidate all reports in a single report for management view.

Your balance sheet gives such report.