收付款类单据删除报错: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格式
声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。
上一篇
已经是第一篇



