≪ View Page

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
autocount_pos:possqlquery [2025/04/02 06:58] – created junautocount_pos:possqlquery [2025/04/02 06:59] (current) – jun
Line 1: Line 1:
 ===POS SQL Query=== ===POS SQL Query===
 select submiteinvoice,createdtime ,* from pos where createdtime >='20250101' and SubmitEInvoice='F' select submiteinvoice,createdtime ,* from pos where createdtime >='20250101' and SubmitEInvoice='F'
- //+\\
 update pos set SubmitEInvoice ='T' where createdtime >='20250101' and SubmitEInvoice='F' update pos set SubmitEInvoice ='T' where createdtime >='20250101' and SubmitEInvoice='F'