首页 T+ 采购管理 进货单生成进货单(退货)提示:账号已被删除,不允许操作!账号的Id为1!请重新选择修改账号

进货单生成进货单(退货)提示:账号已被删除,不允许操作!账号的Id为1!请重新选择修改账号


【问题现象】:

进货单生成进货单(退货)提示:账号已被删除,不允许操作!账号的Id为1!请重新选择修改账号。

5810b50d63ae06b480fc1043a47917c【解决方案】:

您好,请备份好账套数据,执行脚本:

--账套库执行脚本,

SET IDENTITY_INSERT dbo.AA_BankAccount ON

IF NOT EXISTS(SELECT 1 FROM dbo.AA_BankAccount WHERE id = 1)

INSERT INTO dbo.AA_BankAccount(

id,code,name,bankNo,disabled,updatedBy,

isusingdeficitcontrol,isusingbankcheck,NewBalance_Abandon,VirtualPay,idcurrency,

iddepartment,idMarketingOrgan,balancedirection,bankName,bankNoType,

madeDate,updated,dateofusingbankcheck,createdTime,WeixinAppID,

WeixinPayKey,AlipayServiceNo,AlipayAppID,WeiXinMerchantNo,WeiXinServiceNo,

WeiXinServiceAPPID,AlipayPublicKey,MerchantPublicKey,MerchantPrivateKey,EncryptionMethod,

imageFile,AlipayServiceAppID)

VALUES(

1,'现金','现金','现金',0,NULL,

0,0,0,0,4,

NULL,1,NULL,NULL,309,

'2009-03-31 17:37:06.000','2009-03-31 17:37:06.000',NULL,'2009-03-31 17:37:06.000',NULL,

NULL,NULL,NULL,NULL,NULL,

NULL,NULL,NULL,NULL,NULL,

NULL,NULL)

IF NOT EXISTS(SELECT 1 FROM dbo.AA_BankAccount_Balance WHERE idBankAccount = 1)

INSERT INTO dbo.AA_BankAccount_Balance(

idBankAccount,NewBalance,updatedBy,updated,Creater,createdTime)

VALUES(

1,0,NULL,dbo.getdate(),NULL,dbo.getdate()

)

SET IDENTITY_INSERT dbo.AA_BankAccount OFF


作者:熊嘉颖 |  时间:2023年04月21日 11:58


对我有用 对我有用
没有帮助 没有帮助