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

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 2.0 What's New AutoCount Accounting 2.0 Help File AutoCount Accounting 2.0 FAQ (Application) AutoCount Accounting 2.0 FAQ (Troubleshoot) AutoCount Accounting 2.0 Others AutoCount Accounting 2.0 Release Note AutoCount Accounting 2.1 Release Note

AutoCount Accounting 1.8 / 1.9 AutoCount Accounting 1.8 FAQ (Application) AutoCount Accounting 1.8 FAQ (Troubleshoot) AutoCount Accounting 1.8 / 1.9 Release Note

AutoCount Payroll

AutoCount POS

AutoCount On The Go

AutoCount Accounting Plug-In Documentations