专业版|采购发票序时簿单据点开显示错误,所选单据可能被删除

0

KIS专业版13.0:采购发票序时簿点开专票的时候提示报错,提示单据显示错误,所选单据可能被删除。然后普通发票是可以正常打开的,然后点上一张是可以查看专票,然后我在数据库查了下表ICPurchase(采购发票表头) 及ICPurchaseEntry(采购发票表体)发现没有问题,其中我把75,改为76(单据类型改为普通发票)都能正常打开。然后我跟踪了一下报错的位置, SELECT ICPurchaseEntry.FInterID,ICPurchaseEntry.FEntryID, ICPurchaseEntry.FEntryID, t002.FName as FBaseUnit, ICPurchaseEntry.FItemID, t003.FQtyDecimal, t003.FPriceDecimal, t003.FUnitGroupID, t003.FNumber as  FItemIDNumber, t003.FName as  FItemIDName, ICPurchaseEntry.FMapNumber, ICPurchaseEntry.FMapName, t003.Fname as FItemName, t003.Fmodel as FItemModel, ICPurchaseEntry.Famount, ICPurchaseEntry.FTaxRate, ICPurchaseEntry.FTaxAmount, ICPurchaseEntry.FAuxPropID, t012.FNumber as  FAuxPropIDNumber, t012.FName as  FAuxPropIDName, ICPurchaseEntry.FQty, ICPurchaseEntry.FUnitID, t014.FNumber as  FUnitIDNumber, t014.FName as  FUnitIDName, ICPurchaseEntry.Fauxqty, t016.FName as FSecUnitID, ICPurchaseEntry.FSecCoefficient, ICPurchaseEntry.Fauxprice, ICPurchaseEntry.FAuxTaxPrice, ICPurchaseEntry.FSecQty, ICPurchaseEntry.FDiscountRate, ICPurchaseEntry.FAuxPriceDiscount, ICPurchaseEntry.FStdAmount, ICPurchaseEntry.FAmtDiscount, ICPurchaseEntry.FStdAmtDiscount, ICPurchaseEntry.FStdTaxAmount, ICPurchaseEntry.FNote, ICPurchaseEntry.FAmountMust, ICPurchaseEntry.FNoMust, ICPurchaseEntry.FDeductTax, ICPurchaseEntry.FOrgBillEntryID, ICPurchaseEntry.FOrderPrice, ICPurchaseEntry.FAuxOrderPrice, ICPurchaseEntry.FSourceBillNo, ICPurchaseEntry.FSourceTranType, ICPurchaseEntry.FSourceInterId, ICPurchaseEntry.FSourceEntryID, ICPurchaseEntry.FOrderBillNo, ICPurchaseEntry.FOrderInterID, ICPurchaseEntry.FOrderEntryID, t003.FAuxClassID as FAuxPropCls, ICPurchaseEntry.FClassID_SRC, ICPurchaseEntry.FEntryID_SRC, ICPurchaseEntry.FContractBillNo, ICPurchaseEntry.FContractInterID, ICPurchaseEntry.FContractEntryID, ICPurchaseEntry.FAllHookQTY, ICPurchaseEntry.FAllHookAmount, ICPurchaseEntry.FCurrentHookQTY, ICPurchaseEntry.FCurrentHookAmount, ICPurchaseEntry.FBrNo
FROM ICPurchaseEntry left join t_MeasureUnit t002 on  t002.FItemID=t003.FUnitID  AND t002.FItemID<>0  left join t_AuxItem  t012 on t012.FItemID = ICPurchaseEntry.FAuxPropID AND t012.FItemID <>0  left join t_MeasureUnit  t014 on t014.FItemID = ICPurchaseEntry.FUnitID AND t014.FItemID <>0  left join t_MeasureUnit t016 on  t016.FItemID=t003.FSecUnitID  AND t016.FItemID<>0
WHERE ICPurchaseEntry.FInterID IN (2964)
ORDER BY ICPurchaseEntry.FEntryID,根本没有t003这张表啊。麻烦大神有时间指点指点,我是不是漏了哪张表了。采购发票序时簿单据点开显示错误,所选单据可能被删除采购发票序时簿单据点开显示错误,所选单据可能被删除采购发票序时簿单据点开显示错误,所选单据可能被删除