Check issue raised by Ms. Bea Abello regarding they weekly principal report from Dec 27 - Jan 2, 2021. There are variances between their internal sales and figures in Qliksense for the following location

                                         Qliksense	       Internal sales less tax 	 Discrepancy 
Central Square	        139,790.18	                           171,977.68	       (32,187.50)
Greenbelt 5	                261,341.52	                           605,955.36	     (344,613.84)
Newport	                        131,720.98	                           159,004.46	       (27,283.48)
Rockwell	                        221,245.54	                           341,691.96	     (120,446.43)
Rustans Cebu	                144,522.32	                           144,522.32	                       -  
Rustans Makati	          80,118.30	                           118,198.66	       (38,080.36)
Shangri-la	                220,977.68	                           364,593.75	     (143,616.07)

Steps:
1. Query CSHDET table for each location and based on checking sales in JDA except for Central Square tallies with the internal sales of Kate Spade.
2. Cascade issue to Jomar for checking, re-uploading in Qliksense
3. After the reloading, there are still discrepancies, so Jomar requested to extract the sales per date, per location and per SKU
4. Findings by Jomar showed that SKU 4850584 is not existing in INVMST table in QVD. 
5. Jomar to update the INVMST table
 	 	 	     




