本篇将介绍如何解决Dynamics GP Bank Deposit Entry报错.
如果你在添加一个新的Bank Deposit Entry时,发现以下报错:
A deposit for this chequebook already has been started.
If the process was interrupted, use the Check Links windows to check links for the CM logical files.
你需要按照以下方法来解决:
1. 首先你需要备份CM00100和CM20300,并且确保所有的GP用户都在GP上注销。
2. 运行以下命令,CHEKBKID NUMBER就是你在GP界面上得到报错CHECK ID NUMBER。
SELECT Deposit_In_Progress, * FROM CM00100 WHERE CHEKBKID=’CHEKBKID NUMBER’
记住Deposit_In_Progress的数字。
3. 运行以下命令:
UPDATE FROM CM00100
SET Deposit_In_Progress=”
WHERE CHEKBKID=’CHEKBKID NUMBER’
4. 找到那个出错的那个Deposit number,xxxxxx就是你在第一步记下的数字
SELECT DEPOSITED, RCPTNMBR, * FROM CM20300 WHERE depositnumber=’xxxxxx’
5. 更改statement
UPDATE CM20300
SET DEPOSITED=0, depositnumber=”
WHERE depositnumber=’xxxxxx’