进货单生成进货单(退货)提示:账号已被删除,不允许操作!账号的Id为1!请重新选择修改账号
【问题现象】:
进货单生成进货单(退货)提示:账号已被删除,不允许操作!账号的Id为1!请重新选择修改账号。
【解决方案】:
您好,请备份好账套数据,执行脚本:
--账套库执行脚本,
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