金蝶反核销失败问题

1. 查询原因是由于人工删除造成的

SELECT  FNAME
      , FDATETIME
      , BOL.FDESCRIPTION
FROM    T_BAS_OPERATELOGbk BOL
INNER JOIN T_SEC_USER SU ON BOL.FUSERID = SU.FUSERID
WHERE   BOL.FDESCRIPTION LIKE '%YFHXD00000549%'
UNION ALL
SELECT  FNAME
      , FDATETIME
      , BOL.FDESCRIPTION
FROM    T_BAS_OPERATELOG BOL
INNER JOIN T_SEC_USER SU ON BOL.FUSERID = SU.FUSERID
WHERE   BOL.FDESCRIPTION LIKE '%YFHXD00000549%'
ORDER BY FDATETIME ASC;

--单据编号为“YFHXD00000549”的应付核销单，删除成功！

2. 只能通过数据库修改

select * from T_AP_PAYMATCHLOGENTRY where FSRCBILLNO= 'YFHXD00000549'

select * from T_AP_PAYMATCHLOGENTRY where fid = 112455
select * from t_ap_paybill where FBILLNO = 'FKD00009492'
UPDATE t_ap_paybill SET FWRITTENOFFSTATUS ='A' where FBILLNO = 'FKD00009492'
 
select * from T_AP_PAYBILLENTRY where fid = 139624
update T_AP_PAYBILLENTRY set FWRITTENOFFSTATUS ='A',FWRITTENOFFAMOUNTFOR = 0,FREFUNDAMOUNT = 0 where fid = 139624

delete from T_AP_PAYMATCHLOGENTRY where fid = 112455
delete from T_AP_PAYMATCHLOG  where fid = 112455