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

+## 起因  
+daily clearance json 過早處理 
+![image](uploads/083e76ee8f064f460c8f29885b08e4fb/image.png)
+
+transaction 未搬晒去 transactionArchive，pre processing 就做咗  
+
+而引起嘅錯數  
+![WhatsApp_Image_2023-05-24_at_10.42.46](uploads/a1fb63497c66574be975992295b3d74f/WhatsApp_Image_2023-05-24_at_10.42.46.jpg)
+
+![WhatsApp_Image_2023-05-24_at_10.42.55](uploads/05feca6bc6783c86bd06e2961e050408/WhatsApp_Image_2023-05-24_at_10.42.55.jpg)
+
+
+## 解決方法
+直接駁 cloud report db  
+用以下嘅 SQL statement
+http://gitlab.web-on.com/-/snippets/41  
+替換其中嘅 `shopCode`, `archiveStaff`, `archiveDate`, `startDate`, `endDate`
+
+再 remote 去 cloud report VM  
+用以下 command 行多次 pre processing  
+![image](uploads/c20236e4b99e76fa1ad2dfeb04f8fa54/image.png)
+
+就可以解決呢個問題  
+![image](uploads/59edcb888714917621dba00448f6af53/image.png)
\ No newline at end of file