Pos3/5/FNB: After deleted POS Posting inquiry shows no records?

From AutoCount Resource Center

Question :

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.

Solution :

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 [000138]

Go to menu

AutoCount Accounting 2.0 & 2.1

AutoCount Accounting 1.8 / 1.9
AutoCount Payroll
AutoCount POS

AutoCount On The Go
AutoCount Accounting Plug-In Documentations