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

000138-a.png


2. After login > Tools > SQL Query

000138-b.png


3. Click on Yes

000138-c.png


4. Enter the 1st statement > Highlight it > Execute

000138-d.png


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

000138-e.png

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