电脑桌面
添加蚂蚁七词文库到电脑桌面
安装后可以在桌面快捷访问

收付款类单据删除报错:Original Record has been deleted?

来源:金蝶云社区作者:金蝶2024-09-2216

收付款类单据删除报错:Original Record has been deleted?

【问题描述】

收款单,付款单,预收单,预付单等收付款单删除报错:Original Record has been deleted(如下图所示),且如果操作审核这张单据会提示:往来表中不存在对应的单据记录!


【原因分析】

单据往来表t_rp_contact缺失记录。


【解决方案】

1、执行以下语句查出异常单据的单据内码(XSKD000619对应异常单据编号):

select FBillID from t_RP_NewReceiveBill where FNumber in ('XSKD000619')


2、再执行以下语句补上往来表(XSKD000619对应异常单据编号,3030对应异常单据内码):

insert into t_rp_contact(FID,FYear,FPeriod,FRP,FType,FDate,FFincDate,FNumber,FCustomer,FDepartment,

FEmployee,FCurrencyID,FExchangeRate,FAmount,FAmountFor,FRemainAmount,FRemainAmountFor,

FContractNo,FInvoiceID,FRPBillID,FBillID,FBegID,FExpenseID,FBussinessDiscount,FCashDiscount,

FRPDate,FSuperDays,FDirectSale,FSaleBackAmount,FSaleBackAmountFor,FDue,FIsBad,FBadReason,

FVoucherID,FGrou

收付款类单据删除报错:Original Record has been deleted?

【问题描述】收款单,付款单,预收单,预付单等收付款单删除报错:Original Record has been deleted(如下图所示),且如果操作审核这...
点击下载文档文档为doc格式

声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。

确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息
QQ群
  • 答案:my7c点击这里加入QQ群
支持邮箱
微信
  • 微信