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.

000331-a.png


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.

000331-b.png


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

000331-c.png


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')

000331-d.png


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'

000331-e.png


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

https://wiki.autocountsoft.com/wiki/Pos3/5/FNB:_After_deleted_POS_Posting_inquiry_shows_no_records%3F


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.

000331-f.png


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


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1


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