T6单据新打印数据顺序错乱

iufida

T6单据新打印数据顺序错乱    魏雯
【问题现象】业务单据使用新打印，表体存货顺序错乱，见下图：

                               
登录/注册后可看大图

【问题分析】软件前台没有新打印顺序设置功能节点，一般新打印顺序是按照录入顺序，不会错乱，考虑是存储过程异常导致的。
【解决方案】备份好账套数据，使用事件跟踪器查询正常账套在新打印预览时的存储过程，在查询分析器中针对问题账套执行即可。以下以销售出库单新打印表体顺序错乱为例：
1.备份好账套数据，进入软件，打开销售出库单，点击打印-新设计，将新打印模板打开，使用事件跟踪器查询正常账套在打开新打印模板时的存储过程：

                               
登录/注册后可看大图

2. 进入查询分析器执行查看存储过程的命令：sp_helptext newprint_SaleOutVouch_body

                               
登录/注册后可看大图

3.在查询分析器中针对问题账套执行以下语句：
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
alter  PROCEDURE [dbo].[NewPrint_SaleOutVouch_Body]      
@parm varchar(100) ,@user varchar(100)  ,@cardnumber varchar(100), @cardsection varchar (100)   
AS   
begin   
declare @strname varchar(4000)  
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)  
exec('SELECT '+@strname+' from KCSaleOutB where id='''+@parm+'''' +'order by autoid')      
--select * from KCSaleOutB where id=@parm  order by AutoID  
end  
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

                               
登录/注册后可看大图

PS：语句中红色字体是需要自己在执行语句时加入的，“order by autoid”的意思是按照录入顺序自动排序，也可以根据自己的个性化要求进行排序，比如根据存货编码排序加“order by cInvCode”。
附件：以下附各单据的存储过程模块
单据
存储过程
采购
采购请购单
CREATE PROCEDURE [dbo].[NewPrint_PU_AppVouch_title]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from pu_AppHead with(nolock) where id='''+@parm+'''')
--select * from pu_AppHead where id=@parm

end
采购订单
采购订单存储过程
--采购订单
CREATE PROCEDURE [dbo].[NewPrint_PurOrder_body]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+',ginvpicture from zpurpotail with(nolock)
left join (select cinvcode as piccode,ginvpicture from InventoryPicture where cpictype is not null) as A on A.piccode=zpurpotail.cInvCode where poid='''+@parm+'''')
--SELECT * from zpurpotail where poid=@parm

end
采购到货单
采购到货单存储过程
CREATE PROCEDURE [dbo].[NewPrint_PU_ArrivalVouch_title]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from pu_ArrHead with(nolock) where id='''+@parm+'''')
--select * from pu_ArrHead where id=@parm

end

采购入库单
采购入库单存储过程
--采购入库单
CREATE PROCEDURE [dbo].[NewPrint_VoucherRD_Body]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+',ginvpicture from zpurRkdTail with(nolock)
left join (select cinvcode as gpiccode,ginvpicture from InventoryPicture where cpictype is not null) A on A.gpiccode=zpurRkdTail.cinvcode where id='''+@parm+'''' )

--SELECT * from zpurRkdTail where id=@parm
end

专用采购发票
CREATE PROCEDURE [dbo].[NewPrint_zhpurBillVouch_title]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from zhpurBillHead with(nolock) where pbvid='''+@parm+'''' )
--select * from zhpurBillHead where pbvid=@parm

end
红字专用采购发票
CREATE PROCEDURE [dbo].[NewPrint_zhpurBillVouch_title]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from zhpurBillHead with(nolock) where pbvid='''+@parm+'''' )
--select * from zhpurBillHead where pbvid=@parm

end
普通采购发票
CREATE PROCEDURE [dbo].[NewPrint_PpurBillVouch_title]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from PpurBillHead with(nolock) where pbvid='''+@parm+'''')
--select * from PpurBillHead where pbvid=@parm

end
红字普通采购发票
CREATE PROCEDURE [dbo].[NewPrint_PpurBillVouch_title]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from PpurBillHead with(nolock) where pbvid='''+@parm+'''')
--select * from PpurBillHead where pbvid=@parm

end
采购普通运费发票
CREATE PROCEDURE [dbo].[NewPrint_YpurBillVouch_title]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from YpurBillHead with(nolock) where pbvid='''+@parm+'''' )
--select * from YpurBillHead where pbvid=@parm

end
采购专用运费发票

Create PROCEDURE [dbo].[NewPrint_Z_YPurBillVouch_title]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from zypurBillhead with(nolock) where pbvid='''+@parm+'''' )


end
红字采购普通运费发票
CREATE PROCEDURE [dbo].[NewPrint_YpurBillVouch_title]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from YpurBillHead with(nolock) where pbvid='''+@parm+'''' )
--select * from YpurBillHead where pbvid=@parm

end
红字采购专用运费发票

Create PROCEDURE [dbo].[NewPrint_Z_YPurBillVouch_title]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from zypurBillhead with(nolock) where pbvid='''+@parm+'''' )


end
采购检验单
采购检验单存储过程
CREATE PROCEDURE [dbo].[NewPrint_QM_NCV10Vouch_title]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from QM_NCV10_H with(nolock) where id='''+@parm+'''')
--select * from QM_NCV10_H where id=@parm

end
销售
销售报价单
销售报价单
CREATE PROCEDURE [dbo].[NewPrint_SA_QuoVouch_title]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from SA_QuoHead with(nolock) where id='''+@parm+'''' )
--select * from SA_QuoHead where id=@parm

end
样品接单管理
样品接单管理
CREATE PROCEDURE [dbo].[NewPrint_SA_ManageSampleVouch_body]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from SA_ManageSample_V with(nolock) where iautoid='''+@parm+'''' )
--SELECT * from SA_ManageSample_V where iautoid=@parm

end
销售订单
销售订单存储过程
CREATE PROCEDURE [dbo].[NewPrint_SaleOrder_Title]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from SaleOrderQ with(nolock) where id='''+@parm+'''' )
--select * from SaleOrderQ where id=convert(int,@parm)
end
发货单
发货单存储过程
CREATE PROCEDURE [dbo].[NewPrint_Dispvch_Title]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from Sales_FHD_T with(nolock) where DLID='''+@parm+'''')
--select * from Sales_FHD_T where DLID=@parm
end

退货单
退货单存储过程
CREATE PROCEDURE [dbo].[newprint_ReDispatchList_title]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from Sales_FHD_T with(nolock) where dlid='''+@parm+'''' )
--select * from Sales_FHD_T where dlid=@parm

end
销售专用发票
销售专用发票存储过程
CREATE PROCEDURE [dbo].[NewPrint_SaleBillVouch_body]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from SaleBillVouchZW with(nolock) where sbvid='''+@parm+'''' )
--SELECT * from SaleBillVouchZW where sbvid=@parm

end
红字专用销售发票
CREATE PROCEDURE [dbo].[NewPrint_SaleBillVouch_title]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from SaleBillVouchZT with(nolock) where sbvid='''+@parm+'''' )
--select * from SaleBillVouchZT where sbvid=@parm

end

销售普通发票
销售普通发票存储过程
CREATE PROCEDURE [dbo].[NewPrint_SaleBillVouch_body]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from SaleBillVouchZW with(nolock) where sbvid='''+@parm+'''' )
--SELECT * from SaleBillVouchZW where sbvid=@parm

end
红字普通销售发票
CREATE PROCEDURE [dbo].[NewPrint_SaleBillVouch_title]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from SaleBillVouchZT with(nolock) where sbvid='''+@parm+'''' )
--select * from SaleBillVouchZT where sbvid=@parm

end

委托代销发货单
委托代销发货单
CREATE PROCEDURE [dbo].[NewPrint_Sales_DXFH_title]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from Sales_DXFH_T with(nolock) where dlid='''+@parm+'''' )
--select * from Sales_DXFH_T where dlid=@parm

end
委托代销发货退回单
委托代销发货退回单
CREATE PROCEDURE [dbo].[NewPrint_Sales_DXFH_title]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from Sales_DXFH_T with(nolock) where dlid='''+@parm+'''' )
--select * from Sales_DXFH_T where dlid=@parm

end

委托代销结算单
委托代销结算单
CREATE PROCEDURE [dbo].[NewPrint_Sales_DXJS_title]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from Sales_DXJS_T with(nolock) where id='''+@parm+'''' )
--select * from Sales_DXJS_T where id=@parm

end

委托代销结算退回单
CREATE PROCEDURE [dbo].[NewPrint_Sales_DXJS_title]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)
exec('SELECT '+@strname+' from Sales_DXJS_T with(nolock) where id='''+@parm+'''' )
--select * from Sales_DXJS_T where id=@parm

end

委托代销调整单
CREATE PROCEDURE [dbo].[NewPrint_Sales_DXFH_body]
@parm varchar(100) ,@user varchar(100) ,@cardnumber varchar(100), @cardsection varchar (100)
AS
begin
declare @strname varchar(4000)
set @strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsecti