付款单下推应付退款单时报错

栏目：k3wise知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：1

付款单下推应付退款单时报错

通过采购发票或者现金系统生成的付款单下推应付退款单时报以下错误，付款单已经反核销。如果手工做的付款单则可以下推应付退款单。联系电话：18010511708 QQ：705375171通过SQL跟踪发现的问题：SELECT Distinct id_num,t_RP_NewReceiveBill.FSubSystemID,t_RP_NewReceiveBill.FMulCy,t_RP_NewReceiveBill.FObtainRateWay,t_RP_NewReceiveBill.FBillID,t_RP_NewReceiveBill.FBankAcctName,t_rp_ARBillOfSH.FClassID_SRC_Text,t_rp_ARBillOfSH.FPayBillNo,t_rp_NewReceiveBill.FPrintCount,t_rp_newreceivebill.FCheckStatus AS FBillStatus,t_rp_newreceivebill.FCheckStatus AS FBillStatus,t_RP_NewReceiveBill.FNumber,t_RP_NewReceiveBill.FYear,t_RP_NewReceiveBill.FPeriod,t_RP_NewReceiveBill.FDate,t_RP_NewReceiveBill.FFincDate,t_RP_NewReceiveBill.FItemClassID,t_ItemClass.FNumber AS FItemClassID_FNDName,t_ItemClass.FName AS FItemClassID_DSPName,t_RP_NewReceiveBill.FExchangeRateType,v_BASE_ExRateType.FNumber AS FExchangeRateType_FNDName,v_BASE_ExRateType.FName AS FExchangeRateType_DSPName,t_RP_NewReceiveBill.FCustomer,t_Item.FNumber AS FCustomer_FNDName,t_Item.FName AS FCustomer_DSPName,t_RP_NewReceiveBill.FRPBank AS FRPBank_Pay,t_RP_NewReceiveBill.FBankAcct AS FBankAcct_Pay,t_RP_NewReceiveBill.FDepartment,t_Department.FNumber AS FDepartment_FNDName,t_Department.FName AS FDepartment_DSPName,t_RP_NewReceiveBill.FEmployee,t_Emp.FNumber AS FEmployee_FNDName,t_Emp.FName AS FEmployee_DSPName,t_RP_NewReceiveBill.FBillType,t_rp_systemenum.FName AS FBillType_FNDName,t_rp_systemenum.FName AS FBillType_DSPName,t_RP_NewReceiveBill.FSettle,t_Settle.fnumber AS FSettle_FNDName,t_Settle.FName AS FSettle_DSPName,t_RP_NewReceiveBill.FSettle AS FSettleNumber,t_Settle.fnumber AS FSettleNumber_FNDName,t_Settle.FNumber AS FSettleNumber_DSPName,t_RP_NewReceiveBill.FSettleNo,t_RP_NewReceiveBill.FExplanation,t_RP_NewReceiveBill.faccountid,t_Account.FNumber AS faccountid_FNDName,t_Account.FName AS faccountid_DSPName,t_RP_NewReceiveBill.FRPBank_Pay AS FRPBank,t_RP_NewReceiveBill.FBankAcct_Pay AS FBankAcct,t_RP_NewReceiveBill.FContractNo,t_rp_ARBillOfSH.FReceiveCyID AS FReceiveCyID_3,t_RP_NewReceiveBill.FCurrencyID,t_Currency3.FNumber AS FCurrencyID_FNDName,t_Currency3.FScale AS FCurrencyID_Decimal,t_Currency3.FName AS FCurrencyID_DSPName,t_RP_NewReceiveBill.FExchangeRate,t_RP_NewReceiveBill.FAmountFor,t_RP_NewReceiveBill.FAmount,t_RP_NewReceiveBill.FPreAmountFor,t_RP_NewReceiveBill.FTaskID,vw_rp_PMTask.FNumber AS FTaskID_FNDName,vw_rp_PMTask.FName AS FTaskID_DSPName,t_RP_NewReceiveBill.FResourceID,vw_rp_PMResource.FNumber AS FResourceID_FNDName,vw_rp_PMResource.FName AS FResourceID_DSPName,t_RP_NewReceiveBill.FBudgetAmountFor,t_Rp_arbillofsh.FExchangeExpenseFor AS FExchangeExpenseFor3,t_RP_NewReceiveBill.FOrderID,vw_rp_PMOrder.FNumber AS FOrderID_FNDName,vw_rp_PMOrder.FName AS FOrderID_DSPName,t_RP_NewReceiveBill.FOrderID AS FOrderAmountFor,vw_rp_PMOrder.FAmountFor AS FOrderAmountFor_DSPName,t_RP_NewReceiveBill.FVoucherID,VWVoucherNumber.FVoucherNumber AS FVoucherID_FNDName,VWVoucherNumber.FVoucherNumber AS FVoucherID_DSPName,t_rp_newreceivebill.FCustomer AS FRegion,vw_rp_region.FNumber AS FRegion_FNDName,vw_rp_region.FName AS FRegion_DSPName,t_rp_arbillofsh.FExchangeExpense AS FExchangeExpense3,t_rp_NewReceiveBill.FCustomer AS FTrade,vw_rp_trade.FNumber AS FTrade_FNDName,vw_rp_trade.FName AS FTrade_DSPName,t_RP_NewReceiveBill.FPreparer,t_User2.FName AS FPreparer_FNDName,t_User2.FName AS FPreparer_DSPName,t_RP_NewReceiveBill.FChecker,t_User1.FName AS FChecker_FNDName,t_User1.FName AS FChecker_DSPName,t_RP_NewReceiveBill.FReceiveCyID,t_currency4.fnumber AS FReceiveCyID_FNDName,t_currency4.FScale AS FReceiveCyID_Decimal,t_currency4.fname AS FReceiveCyID_DSPName,t_RP_NewReceiveBill.FReceiveAmountFor,t_RP_NewReceiveBill.FReceiveAmount,t_RP_NewReceiveBill.FSettleCyID,t_currency5.fnumber AS FSettleCyID_FNDName,t_currency5.FScale AS FSettleCyID_Decimal,t_currency5.fname AS FSettleCyID_DSPName,t_RP_NewReceiveBill.FSettleAmountFor,t_RP_NewReceiveBill.FSettleAmount,t_RP_NewReceiveBill.FSettleDiscountFor,t_RP_NewReceiveBill.FSettleDiscount,t_RP_NewReceiveBill.FSource,t_RP_NewReceiveBill.FSourceID,t_RP_NewReceiveBill.FStatus,t_RP_NewReceiveBill.FOrderNo,t_RP_NewReceiveBill.FDiscountAmount,t_RP_NewReceiveBill.FDiscountAmountFor,t_RP_NewReceiveBill.FContractID,t_RP_NewReceiveBill.FRP,t_rp_arbillofsh.FClassID_SRC,ICClassType.FName_CHS AS FClassID_SRC_FNDName,ICClassType.FName_CHS AS FClassID_SRC_DSPName,t_rp_arbillofsh.FBillNo_SRC,t_rp_arbillofsh.FContractNo AS FEntryContractNo,t_RP_NewReceiveBill.FPre,t_rp_arbillofsh.FOrderNo AS FEntryOrderNo,t_rp_ARBillOfSH.FReceiveCyName,t_rp_ARBillOfSH.FReceiveAmountFor AS FReceiveAmountFor_3,t_RP_NewReceiveBill.FClassTypeID,t_rp_ARBillOfSH.FReceiveAmount AS FReceiveAmount_3,t_rp_ARBillOfSH.FReceiveExchangeRate,t_rp_ARBillOfSH.FSettleCyName,t_rp_ARBillOfSH.FSettleQuantity,t_rp_ARBillOfSH.FSettleAmountFor AS FSettleAmountFor_3,t_rp_arbillofsh.FAmountFor_Entry,t_rp_arbillofsh.FBackAmountFor_Relative,t_rp_arbillofsh.FRemainAmountFor AS FRemainAmountForEntry,t_rp_arbillofsh.Famount_Entry,t_rp_arbillofsh.FBackAmount_Relative,t_rp_arbillofsh.FRemainAmount AS FRemainAmountEntry,t_rp_arbillofsh.FRemainQty,t_rp_ARBillOfSH.FSettleAmount AS FSettleAmount_3,t_rp_ARBillOfSH.FDiscountFor AS FDiscountFor_3,t_rp_ARBillOfSH.FDiscount,t_rp_ARBillOfSH.FEntryID AS FEntryID3,t_rp_arbillofsh.FEntryID_SRC,t_rp_ARBillOfSH.FBillID AS FBillID3,t_rp_ARBillOfSH.FIndex AS FIndex3,t_rp_ARBillOfSH.FSettleExchangeRate,t_rp_ARBillOfSH.FAccountID AS FEntryAccountID,t_Account1.FNumber AS FEntryAccountID_FNDName,t_Account1.FName AS FEntryAccountID_DSPName,t_rp_ARBillOfSH.FItemID,t_ICItem.FNumber AS FItemID_FNDName,t_ICItem.FTrack AS FItemID_Track,t_ICItem.FBatchManager AS FItemID_BatchNoManage,t_ICItem.FQtyDecimal AS FItemID_FQtyDecimal,t_ICItem.FPriceDecimal AS FItemID_FPriceDecimal,t_ICItem.FUnitGroupID AS FItemID_UnitGroupID,t_ICItem.FISKFPeriod AS FItemID_FISKFPeriod,t_ICItem.FNumber AS FItemID_DSPName,t_rp_ARBillOfSH.FItemID AS FBaseProperty,t_ICItem.FName AS FBaseProperty_DSPName,t_rp_ARBillOfSH.FItemID AS FBaseProperty1,t_ICItem.FModel AS FBaseProperty1_DSPName,t_rp_arbillofsh.FLinkCheckQty,t_rp_ARBillOfSH.FID_SRC,t_rp_arbillofsh.FLinkCheckAmountFor,t_rp_ARBillOfSH.FSettleCyID AS FSettleCyID_3,t_rp_arbillofsh.FLinkCheckAmount,t_rp_ARBillOfSH.FRemainAmountFor AS FRemainAmountFor3,t_rp_ARBillOfSH.FRemainAmountFor_SRC,t_rp_ARBillOfSH.FRemainAmount AS FRemainAmount3,t_rp_ARBillOfSH.FRemainAmount_SRC,t_rp_ARBillOfSH.FPayEntryID,t_rp_ARBillOfSH.FOrderEntryID,t_rp_ARBillOfSH.FPayBillID,t_rp_ARBillOfSH.FContractEntryID,t_rp_ARBillOfSH.FAuxPropID,t_AuxItem.FNumber AS FAuxPropID_FNDName,t_AuxItem.FName AS FAuxPropID_DSPName,t_rp_ARBillOfSH.funitid AS FBase2,t_Measureunit.FNumber AS FBase2_FNDName,t_Measureunit.FName AS FBase2_DSPName,t_rp_ARBillOfSH.FQuantity,t_rp_ARBillOfSH.FTaxPrice,t_rp_ARBillOfSH.FAmountFor_SRC,t_rp_ARBillOfSH.Famount_SRC,t_rp_newreceivebill.FAdjustExchangeRate,t_rp_newreceivebill.FAdjustAmount,t_rp_arbillofsh.FCheckAmountFor,t_rp_arbillofsh.FCheckAmount,t_rp_arbillofsh.FOrderInterID,t_rp_ARBillOfSH.FOrderType,t_rp_arbillofsh.FFeeObjID,t_Base_BudgetItem.FNumber AS FFeeObjID_FNDName,t_Base_BudgetItem.FNumber AS FFeeObjID_DSPName,t_RP_NewReceiveBill.FPaySettNo,t_rp_arbillofsh.FFeeObjID AS FFeeObjName,t_Base_BudgetItem.FName AS FFeeObjName_DSPName FROM t_RP_NewReceiveBill LEFT JOIN t_rp_ARBillOfSH ON t_RP_NewReceiveBill.FBillID=t_rp_ARBillOfSH.FBillID LEFT JOIN t_ItemClass ON t_RP_NewReceiveBill.FItemClassID=t_ItemClass.FItemClassID AND t_ItemClass.FItemClassID<>0 LEFT JOIN t_Item ON t_RP_NewReceiveBill.FCustomer=t_Item.FItemID AND t_Item.FItemID<>0 LEFT JOIN t_Settle ON t_RP_NewReceiveBill.FSettle=t_Settle.FItemID AND t_Settle.FItemID<>0 LEFT JOIN t_rp_systemenum ON t_RP_NewReceiveBill.FBillType=t_rp_systemenum.FItemID LEFT JOIN t_Account ON t_RP_NewReceiveBill.faccountid=t_Account.FAccountID AND t_Account.FAccountID<>0 LEFT JOIN v_BASE_ExRateType ON t_RP_NewReceiveBill.FExchangeRateType=v_BASE_ExRateType.FID LEFT JOIN t_currency t_Currency3 ON t_RP_NewReceiveBill.FCurrencyID=t_Currency3.FCurrencyID AND t_Currency3.FCurrencyID<>0 LEFT JOIN t_User t_User1 ON t_RP_NewReceiveBill.FChecker=t_User1.FUserID AND t_User1.FUserID<>0 LEFT JOIN t_User t_User2 ON t_RP_NewReceiveBill.FPreparer=t_User2.FUserID AND t_User2.FUserID<>0 LEFT JOIN t_Department ON t_RP_NewReceiveBill.FDepartment=t_Department.FItemID AND t_Department.FItemID<>0 LEFT JOIN t_Emp ON t_RP_NewReceiveBill.FEmployee=t_Emp.FItemID AND t_Emp.FItemID<>0 LEFT JOIN vw_rp_PMOrder ON t_RP_NewReceiveBill.FOrderID=vw_rp_PMOrder.FID LEFT JOIN vw_rp_PMTask ON t_RP_NewReceiveBill.FTaskID=vw_rp_PMTask.FID LEFT JOIN t_currency t_currency4 ON t_RP_NewReceiveBill.FReceiveCyID=t_currency4.fcurrencyid AND t_currency4.fcurrencyid<>0 LEFT JOIN VWVoucherNumber VWVoucherNumber ON t_RP_NewReceiveBill.FVoucherID=VWVoucherNumber.FVoucherID AND VWVoucherNumber.FVoucherID<>0 LEFT JOIN vw_rp_PMResource ON t_RP_NewReceiveBill.FResourceID=vw_rp_PMResource.FID LEFT JOIN t_currency t_currency5 ON t_RP_NewReceiveBill.FSettleCyID=t_currency5.fcurrencyid AND t_currency5.fcurrencyid<>0 LEFT JOIN vw_rp_region ON t_rp_newreceivebill.FCustomer=vw_rp_region.FItemID LEFT JOIN vw_rp_trade ON t_rp_NewReceiveBill.FCustomer=vw_rp_trade.FItemID LEFT JOIN ICClassType ON ABS(t_rp_arbillofsh.FClassID_SRC)=ABS(ICClassType.FID) AND ICClassType.FID<>0 LEFT JOIN t_Account t_Account1 ON t_rp_ARBillOfSH.FAccountID=t_Account1.FAccountID AND t_Account1.FAccountID<>0 LEFT JOIN t_ICItem ON t_rp_ARBillOfSH.FItemID=t_ICItem.FItemID AND t_ICItem.FItemID<>0 LEFT JOIN t_AuxItem ON t_rp_ARBillOfSH.FAuxPropID=t_AuxItem.FItemID AND t_AuxItem.FItemID<>0 LEFT JOIN t_Measureunit ON t_rp_ARBillOfSH.funitid=t_Measureunit.FItemID AND t_Measureunit.FItemID<>0 LEFT JOIN t_Base_BudgetItem ON t_rp_arbillofsh.FFeeObjID=t_Base_BudgetItem.FItemID AND t_Base_BudgetItem.FItemID<>0 INNER JOIN #tmpID ON #tmpID.FEntryID = t_rp_ARBillOfSH.FEntryID WHERE FCheckStatus<>1 and t_rp_newreceivebill.fchecker>0 and t_rp_arbillofsh.fAmountfor_entry>0 and t_rp_arbillofsh.fclassid_src not in (1000003,1000004,1000022,1000502,1000503,1000521) and (abs(t_rp_arbillofsh.FRemainAmountfor)-abs(t_rp_arbillofsh.FBackAmountFor_Relative)+abs(t_rp_arbillofsh.FLinkCheckAmountFor))>0 And (t_rp_newreceivebill.FItemClassID<>8 Or (t_rp_newreceivebill.FItemClassID=8 And t_rp_newreceivebill.FCustomer Not In(Select FItemID From t_Supplier Where IsNull(FAPFrozenFlag,0)=1))) ORDER BY id_num排除了fclassid_src是1000003,1000004,1000022,1000502,1000503,1000521的.但根据应付发票生成的付款单fclassid_src是1000003,根据现金系统传递过来的付款单fclassid_src是1000503.导致无法下推生成应付退款单.