Check the total quantity and total sales from JDA and from the HiPOS per date per transaction and I notice that there is data duplication. I'd check the Poll05 query then I see that the cause of duplicate data is from the table hipos_customer_info. This need to create a subquery to distinct the data