解决Dynamics GP Bank Deposit Entry报错

本篇将介绍如何解决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’