专业版|采购发票序时簿单据点开显示错误,所选单据可能被删除
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这张表啊。麻烦大神有时间指点指点,我是不是漏了哪张表了。