While working in Malawi I've noticed that f.e. in materialized view stock_status_and_consumption there is a lot of duplication of line items. It's affect on performance and correct of data. In this ticket we should check if the same issue exist in Core and take care of it.
There is no duplication of records in any of reporting tables or views.