由应收系统收款单汇总生成凭证可审核，但不能过账，提示:"名称或代码在系统中已被使用
错误代码:3604(E14H)
Source :Microsoft OLE DB Provider for SQL Server
Detail :在结果列的列表中多次出现列名 'F1'。"
跟踪其进程，显示结果如下：
SELECT v.FVoucherID,v.FYear,v.FPeriod,v.FDate,v.FGroupID,v.FNumber, v.FChecked,v.FCashierID,v.FApproveID,v.FPosted, TransferPL = CASE WHEN (ISNULL(v.FInternalInd,'#')='TransferPL') THEN 1 ELSE 0 END INTO #Voucher FROM t_Voucher v WHERE v.FVoucherID=427
SELECT TOP 0 v.FVoucherID,v.FDate,v.FGroupID,v.FNumber,FEntryID=0, FErrCode=0,FErrDescription=CONVERT(varchar(255),SPACE(0)) INTO #Report FROM #Voucher v
INSERT INTO #Report SELECT v.FVoucherID,v.FDate,v.FGroupID,v.FNumber,FEntryID=0,FErrCode=-2147204854,FErrDescription=SPACE(0) FROM #Voucher v WHERE FYear<>2007 OR FPeriod<>1


当用收款单按笔生成凭证时则可过账，请问是什么样的问题，如何解决？谢谢

修改时间：2007-7-25 11:17:00