Check the query of Sales and Inventory Summary Report and find the cause of generation error, I try to run the query per transaction and it was fine. I try to change the Union to Union All then try to test the Report