goPOS/daily-clearance-run-before-all-transactions-processed.md

+## 起因  
+daily clearance json 過早處理  
+![image](uploads/81042f62dde54233cd626ed7661748bb/image.png)
+
+transaction 未搬晒去 transactionArchive，pre processing 就做咗  
+![image](uploads/5e2658afe83432409f851d9e89097417/image.png)
+
+而引起嘅錯數  
+![WhatsApp_Image_2023-05-18_at_09.04.24](uploads/ffe0d376be89af172aeb2c1c5857210a/WhatsApp_Image_2023-05-18_at_09.04.24.jpg)
+![image](uploads/5d0cb33326008e88b634e2d5eee1ba54/image.png)
+
+
+## 解決方法
+直接駁 cloud report db  
+用以下嘅 SQL statement
+http://gitlab.web-on.com/-/snippets/39  
+替換其中嘅 shop code
+
+再 remote 去 cloud report VM  
+用以下 command 行多次 pre processing  
+![image](uploads/2e92fcc93ab239f524b7cc19f4e223eb/image.png)
+
+就可以解決呢個問題  
+![image](uploads/0b3acb1bda7c80ab5b48111e38920ed2/image.png)
\ No newline at end of file