Remove the condition product <> 1 that caused not to include all the product_id in the cost of sales report per UPC. Published the report and test if the sales report is tally in JDA. Advise Ian Latube of ISCI to test the report and this is now ok as per confirmation in hangouts.