Pos3/5/FNB: After deleted POS Posting inquiry shows no records?
I wish to redo POS posting and after I deleted the POS posting, click on inquiry there is no record. Why?
Possible Reason :
The status of those transaction may somehow still marked as posted status in AutoCount, that is why when inquiry could not see any transaction after deleted POS posting.
PS: Backup your data before performing this as it may lead to data corrupt or mismatch. Please call for support if have any question.
1. Go to Windows Start > AutoCount POS 5.0 > AutoCount POS 5.0 Management Studio
2. After login > Tools > SQL Query
3. Click on Yes
4. Enter the 1st statement > Highlight it > Execute
Sample A: From Doc to Doc
Update POS set Posted = 'F' where Docno >= 'xxx' and Docno <= 'xxx'
Update POS set Posted = 'F' where Docno >= 'T05-000001' and Docno <= 'T05-000010'
Sample B: From Time to Time
Update POS set Posted = 'F' where Createdtime >= 'xxx' and Createdtime <= 'xxx'
Update POS set Posted = 'F' where Createdtime >= '2019-01-01 00:00:00' and Createdtime <= '2019-12-31 23:59:59'
5. Enter the 2nd statement > Highlight it > Execute
Update POSPayment set Posted = 'F' where Dockey in (select dockey from POS where Posted = 'F')
6. Go back to POS Posting screen and clock on Inquiry again.
By: CK 20201125, Jacky 20201221, P201228 
|AutoCount Accounting 2.0
|AutoCount Accounting 1.8 / 1.9
|AutoCount On The Go
|AutoCount Accounting Plug-In Documentations