Troubleshooting: Year End Closing Error – DB concurrency violation: Difference between revisions
Troubleshooting: Year End Closing Error – DB concurrency violation (view source)
Revision as of 06:42, 9 January 2020
, 4 years agono edit summary
(Created page with "'''Question :''' When I perform year end closing, system prompts an error message "DB concurrency violation”. What should I do? File:Db concurrency1.png <u><b>Possibl...") |
No edit summary |
||
Line 22:
|-
| update APPayment set CBKey = null where docdate < '2016-01-01' and CBKey is not null<br/><br/>
update APRefund set CBKey = null where docdate < '2016-01-01' and CBKey is not null<br/><br/>
update ARPayment set CBKey = null where docdate < '2016-01-01' and CBKey is not null<br/><br/>
update ARRefund set CBKey = null where docdate < '2016-01-01' and CBKey is not null<br/><br/>
update ARAPContra set JEKey = null where docdate < '2016-01-01' and JEKey is not null<br/>
|