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

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

通过采购发票或者现金系统生成的付款单下推应付退款单时报以下错误，付款单已经反核销。如果手工做的付款单则可以下推应付退款单。联系电话：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 FRemainAmount

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

相关阅读

栏目

最新发布

热门标签