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

From AutoCount Resource Center
Jump to navigation Jump to search

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

IconAcc20.PNG AutoCount Accounting 2.0

IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS

Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations