Pos5/FNB: Delete POS Posting error DB concurrency violation

From AutoCount Resource Center

Question :

I want to delete a POS Posting Transaction but system pop up an error.

DB concurrency violation.

Possible Reason :

POS Posting Transaction post to G/L Cash Book (CB), Journal (JV) or A/R Invoice. Their linked source was somehow gone or deleted by user.

Solution :

1. On Cash Sale tab, Journal Entry tab, Refund tab & Credit Sale tab, check recent documents that have linked to any CB, JV or A/R Invoice.

2. Make sure all CB, JV or A/R Invoice posted from POS Posting already deleted.

3. Open Autocount or POS 5.0 Management Studio > Tools > SQL Query > Yes

4.Enter the following query to delete posting detail

delete from PosPostingDtl where dockey in (select Dockey from PosPosting where docno = 'Doc No.')

My sample

delete from PosPostingDtl where dockey in (select Dockey from PosPosting where docno = 'PP-000097')

5.Then enter another query to delete the master

delete from PosPosting where docno = 'Doc No.'

My sample

delete from PosPosting where docno = 'PP-000097'

6. Next, follow below FAQ for the next step to reset your True False trigger.


To prevent this problem from happening, pls untick this function:

Login Accounting / POS 5.0 Backend > Tools > Option > Category A/R & A/P > Aging and Statement > don’t tick Allow Edit or Delete A/R and A/P Documents Posted From Other Source.

By: CK 20220512, Jacky 20220523, P220525 [000331]

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