I assisted Lawrence Deogracias regarding the Cost of Sales Report error he was generating. I tried generating the same report to validate the concern and got the same output. I ran a select query in Mysql to check for crashed tables, and as a result, the sales fact table was marked as crashed. I repaired the table and ran a sales refresh for the whole month of September 2022 to get the most updated data in JDA. I will generate the report to validate if the report is working after repairing the table and will email the generated report to Lawrence for validation. This is now OK as per the confirmation of the accounting team who reported the concern.