服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务1T6单据新打印数据顺序错乱魏雯【问题现象】业务单据使用新打印，表体存货顺序错乱，见下图：【问题分析】软件前台没有新打印顺序设置功能节点，一般新打印顺序是按照录入顺序，不会错乱，考虑是存储过程异常导致的。【解决方案】备份好账套数据，使用事件跟踪器查询正常账套在新打印预览时的存储过程，在查询分析器中针对问题账套执行即可。以下以销售出库单新打印表体顺序错乱为例：1.备份好账套数据，进入软件，打开销售出库单，点击打印-新设计，将新打印模板打开，使服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务2用事件跟踪器查询正常账套在打开新打印模板时的存储过程：2.进入查询分析器执行查看存储过程的命令：sp_helptextnewprint_SaleOutVouch_body3.在查询分析器中针对问题账套执行以下语句：SETQUOTED_IDENTIFIERONGOSETANSI_NULLSONGOalterPROCEDURE[dbo].[NewPrint_SaleOutVouch_Body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务3ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromKCSaleOutBwhereid='''+@parm+''''+'orderbyautoid')--select*fromKCSaleOutBwhereid=@parmorderbyAutoIDendGOSETQUOTED_IDENTIFIEROFFGOSETANSI_NULLSONGO服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务4PS：语句中红色字体是需要自己在执行语句时加入的，“orderbyautoid”的意思是按照录入顺序自劢排序，也可以根据自己的个性化要求进行排序，比如根据存货编码排序加“orderbycInvCode”。附件：以下附各单据的存储过程模块单据存储过程采购采购请购单CREATEPROCEDURE[dbo].[NewPrint_PU_AppVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'frompu_AppHeadwith(nolock)whereid='''+@parm+'''')--select*frompu_AppHeadwhereid=@parmend采购订单采购订单存储过程--采购订单服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务5CREATEPROCEDURE[dbo].[NewPrint_PurOrder_body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+',ginvpicturefromzpurpotailwith(nolock)leftjoin(selectcinvcodeaspiccode,ginvpicturefromInventoryPicturewherecpictypeisnotnull)asAonA.piccode=zpurpotail.cInvCodewherepoid='''+@parm+'''')--SELECT*fromzpurpotailwherepoid=@parmend采购到货单采购到货单存储过程CREATEPROCEDURE[dbo].[NewPrint_PU_ArrivalVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)AS服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务6begindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'frompu_ArrHeadwith(nolock)whereid='''+@parm+'''')--select*frompu_ArrHeadwhereid=@parmend采购入库单采购入库单存储过程--采购入库单CREATEPROCEDURE[dbo].[NewPrint_VoucherRD_Body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+',ginvpicturefromzpurRkdTailwith(nolock)服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务7leftjoin(selectcinvcodeasgpiccode,ginvpicturefromInventoryPicturewherecpictypeisnotnull)AonA.gpiccode=zpurRkdTail.cinvcodewhereid='''+@parm+'''')--SELECT*fromzpurRkdTailwhereid=@parmend专用采购发票CREATEPROCEDURE[dbo].[NewPrint_zhpurBillVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromzhpurBillHeadwith(nolock)wherepbvid='''+@parm+'''')--select*fromzhpurBillHeadwherepbvid=@parmend红字专用采购发票CREATEPROCEDURE[dbo].[NewPrint_zhpurBillVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumber服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务8varchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromzhpurBillHeadwith(nolock)wherepbvid='''+@parm+'''')--select*fromzhpurBillHeadwherepbvid=@parmend普通采购发票CREATEPROCEDURE[dbo].[NewPrint_PpurBillVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromPpurBillHeadwith(nolock)wherepbvid='''+@parm+'''')--select*fromPpurBillHeadwherepbvid=@parm服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务9end红字普通采购发票CREATEPROCEDURE[dbo].[NewPrint_PpurBillVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromPpurBillHeadwith(nolock)wherepbvid='''+@parm+'''')--select*fromPpurBillHeadwherepbvid=@parmend采购普通运费发票CREATEPROCEDURE[dbo].[NewPrint_YpurBillVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务10@cardsection)exec('SELECT'+@strname+'fromYpurBillHeadwith(nolock)wherepbvid='''+@parm+'''')--select*fromYpurBillHeadwherepbvid=@parmend采购专用运费发票CreatePROCEDURE[dbo].[NewPrint_Z_YPurBillVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromzypurBillheadwith(nolock)wherepbvid='''+@parm+'''')end红字采购普通运费发票CREATEPROCEDURE[dbo].[NewPrint_YpurBillVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务11ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromYpurBillHeadwith(nolock)wherepbvid='''+@parm+'''')--select*fromYpurBillHeadwherepbvid=@parmend红字采购专用运费发票CreatePROCEDURE[dbo].[NewPrint_Z_YPurBillVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromzypurBillheadwith(nolock)wherepbvid='''+@parm+'''')服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务12end采购检验单采购检验单存储过程CREATEPROCEDURE[dbo].[NewPrint_QM_NCV10Vouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromQM_NCV10_Hwith(nolock)whereid='''+@parm+'''')--select*fromQM_NCV10_Hwhereid=@parmend销售销售报价单销售报价单CREATEPROCEDURE[dbo].[NewPrint_SA_QuoVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegin服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务13declare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromSA_QuoHeadwith(nolock)whereid='''+@parm+'''')--select*fromSA_QuoHeadwhereid=@parmend样品接单管理样品接单管理CREATEPROCEDURE[dbo].[NewPrint_SA_ManageSampleVouch_body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromSA_ManageSample_Vwith(nolock)whereiautoid='''+@parm+'''')--SELECT*fromSA_ManageSample_Vwhereiautoid=@parm服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务14end销售订单销售订单存储过程CREATEPROCEDURE[dbo].[NewPrint_SaleOrder_Title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromSaleOrderQwith(nolock)whereid='''+@parm+'''')--select*fromSaleOrderQwhereid=convert(int,@parm)end发货单发货单存储过程CREATEPROCEDURE[dbo].[NewPrint_Dispvch_Title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务15@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromSales_FHD_Twith(nolock)whereDLID='''+@parm+'''')--select*fromSales_FHD_TwhereDLID=@parmend退货单退货单存储过程CREATEPROCEDURE[dbo].[newprint_ReDispatchList_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromSales_FHD_Twith(nolock)wheredlid='''+@parm+'''')--select*fromSales_FHD_Twheredlid=@parmend销售专用发票销售专用发票存储过程CREATEPROCEDURE服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务16[dbo].[NewPrint_SaleBillVouch_body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromSaleBillVouchZWwith(nolock)wheresbvid='''+@parm+'''')--SELECT*fromSaleBillVouchZWwheresbvid=@parmend红字专用销售发票CREATEPROCEDURE[dbo].[NewPrint_SaleBillVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromSaleBillVouchZT服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务17with(nolock)wheresbvid='''+@parm+'''')--select*fromSaleBillVouchZTwheresbvid=@parmend销售普通发票销售普通发票存储过程CREATEPROCEDURE[dbo].[NewPrint_SaleBillVouch_body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromSaleBillVouchZWwith(nolock)wheresbvid='''+@parm+'''')--SELECT*fromSaleBillVouchZWwheresbvid=@parmend红字普通销售发票CREATEPROCEDURE[dbo].[NewPrint_SaleBillVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务18ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromSaleBillVouchZTwith(nolock)wheresbvid='''+@parm+'''')--select*fromSaleBillVouchZTwheresbvid=@parmend委托代销发货单委托代销发货单CREATEPROCEDURE[dbo].[NewPrint_Sales_DXFH_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromSales_DXFH_Twith(nolock)wheredlid='''+@parm+'''')服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务19--select*fromSales_DXFH_Twheredlid=@parmend委托代销发货退回单委托代销发货退回单CREATEPROCEDURE[dbo].[NewPrint_Sales_DXFH_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromSales_DXFH_Twith(nolock)wheredlid='''+@parm+'''')--select*fromSales_DXFH_Twheredlid=@parmend委托代销结算单委托代销结算单CREATEPROCEDURE[dbo].[NewPrint_Sales_DXJS_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)AS服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务20begindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromSales_DXJS_Twith(nolock)whereid='''+@parm+'''')--select*fromSales_DXJS_Twhereid=@parmend委托代销结算退回单CREATEPROCEDURE[dbo].[NewPrint_Sales_DXJS_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromSales_DXJS_Twith(nolock)whereid='''+@parm+'''')--select*fromSales_DXJS_Twhereid=@parm服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务21end委托代销调整单CREATEPROCEDURE[dbo].[NewPrint_Sales_DXFH_body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromSales_FHD_Wwith(nolock)wheredlid='''+@parm+'''')--SELECT*fromSales_FHD_Wwheredlid=@parmorderbyAutoIDend销售调拨单CREATEPROCEDURE[dbo].[NewPrint_SaleBillVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务22@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromSaleBillVouchZTwith(nolock)wheresbvid='''+@parm+'''')--select*fromSaleBillVouchZTwheresbvid=@parmend红字销售调拨单CREATEPROCEDURE[dbo].[NewPrint_SaleBillVouch_body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromSaleBillVouchZWwith(nolock)wheresbvid='''+@parm+'''')--SELECT*fromSaleBillVouchZWwheresbvid=@parmend服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务23代垫费用单CREATEPROCEDURE[dbo].[NewPrint_ExpenseVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromExpenseVouchTwith(nolock)whereid='''+@parm+'''')--select*fromExpenseVouchTwhereid=@parmend销售支出单CREATEPROCEDURE[dbo].[NewPrint_SalePayVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromSalePayVouchT服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务24with(nolock)whereid='''+@parm+'''')--select*fromSalePayVouchTwhereid=@parmend库存产成品入库单CREATEPROCEDURE[dbo].[NewPrint_RecordInVouch_Title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromRecordInQwith(nolock)whereid='''+@parm+'''')--select*fromRecordInQwhereid=@parmend其他入库单CREATEPROCEDURE[dbo].[NewPrint_OtherInVouch_Title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegin服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务25declare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromKCOtherInHwith(nolock)whereid='''+@parm+'''')--select*fromKCOtherInHwhereid=@parmend材料出库单材料出库单CREATEPROCEDURE[dbo].[NewPrint_RecordOutVouch_body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+',ginvpicturefromRecordOutSQwith(nolock)leftjoin(selectcinvcodeasgpiccode,ginvpicturefrom服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务26InventoryPicturewherecpictypeisnotnull)AonA.gpiccode=RecordOutSQ.cinvcodewhereid='''+@parm+'''')--SELECT*fromRecordOutSQwhereID=@parmend其它出库单CREATEPROCEDURE[dbo].[NewPrint_OtherOutVouch_Title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromKCOtherOutHwith(nolock)whereid='''+@parm+'''')--select*fromKCOtherOutHwhereid=@parmend调拨申请单CREATEPROCEDURE[dbo].[NewPrint_Transrep_Title]@parmvarchar(100),@uservarchar(100),@cardnumber服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务27varchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromTransVouchRepMwith(nolock)whereID='''+@parm+'''')end调拨单CREATEPROCEDURE[dbo].[NewPrint_TransVouch_Title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromTransMwith(nolock)whereid='''+@parm+'''')--select*fromTransMwhereid=@parmend服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务28盘点单CREATEPROCEDURE[dbo].[NewPrint_CheckVouch_Title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromCheckMwith(nolock)whereid='''+@parm+'''')--select*fromCheckMwhereid=@parmend限额领料单CREATEPROCEDURE[dbo].[NewPrint_MatchVouch_body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromMatchVouchD服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务29with(nolock)whereid='''+@parm+'''')--SELECT*fromMatchVouchDwhereid=@parmend不合格品记录单CREATEPROCEDURE[dbo].[NewPrint_KCScrapVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromKCScrapHeadwith(nolock)whereid='''+@parm+'''')--select*fromKCScrapHeadwhereid=@parmend假退料单材料出库单CREATEPROCEDURE[dbo].[NewPrint_RecordOutVouch_body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)AS服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务30begindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+',ginvpicturefromRecordOutSQwith(nolock)leftjoin(selectcinvcodeasgpiccode,ginvpicturefromInventoryPicturewherecpictypeisnotnull)AonA.gpiccode=RecordOutSQ.cinvcodewhereid='''+@parm+'''')--SELECT*fromRecordOutSQwhereID=@parmend核算入库调整单CREATEPROCEDURE[dbo].[NewPrint_JustInVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromJustInQwith(nolock)服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务31wherecjvcode='''+@parm+'''')--select*fromJustInQwherecjvcode=@parmend出库调整单CREATEPROCEDURE[dbo].[NewPrint_JustOutVouch_body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromJustOutSQwith(nolock)wherecjvcode='''+@parm+'''')--SELECT*fromJustOutSQwherecjvcode=@parmend报废单CREATEPROCEDURE[dbo].[NewPrint_qm_nbfv21_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)AS服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务32begindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromqm_nbfv21_hwith(nolock)whereid='''+@parm+'''')--select*fromqm_nbfv21_hwhereid=@parmend不合格品退回单CREATEPROCEDURE[dbo].[NewPrint_qm_nbhgthv22_body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromqm_nbhgthv22_bwith(nolock)whereid='''+@parm+'''')--SELECT*fromqm_nbhgthv22_bwhereid=@parm服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务33end生产预测单CREATEPROCEDURE[dbo].[NewPrint_pp_ycdVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'frompp_ycd_hwith(nolock)whereid='''+@parm+'''')--select*frompp_ycd_hwhereid=@parmendROP采购计划CREATEPROCEDURE[dbo].[NewPrint_roporderVouch_body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务34@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromroporderbodywith(nolock)wheremuid='''+@parm+'''')--SELECT*fromroporderbodywheremuid=@parmendSRP运算单CREATEPROCEDURE[dbo].[NewPrint_PP_SRPMainProduct_B_Body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromPP_SRPMainProduct_Bwith(nolock)whereid='''+@parm+'''')--select*frompp_m_operator_vwheremautoid=@parmend服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务35MRP生产计划CREATEPROCEDURE[dbo].[NewPrint_pp_scplanVouch_body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'frompp_scplan_bwith(nolock)whereid='''+@parm+'''')--SELECT*frompp_scplan_bwhereid=@parmendMRP委外计划CREATEPROCEDURE[dbo].[NewPrint_pp_wwplanVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务36@cardsection)exec('SELECT'+@strname+'frompp_wwplan_hwith(nolock)whereid='''+@parm+'''')--select*frompp_wwplan_hwhereid=@parmend采购计划CREATEPROCEDURE[dbo].[NewPrint_pp_cgplanVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'frompp_cgplan_hwith(nolock)whereid='''+@parm+'''')--select*frompp_cgplan_hwhereid=@parmend生产订单CREATEPROCEDURE[dbo].[NewPrint_pp_scdd_Title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务37ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'frompp_scdd_hwith(nolock)whereid='''+@parm+'''')--select*frompp_scdd_hwhereid=@parmend订单完工汇报单CREATEPROCEDURE[dbo].[NewPrint_pp_pp_porpt_Title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'frompp_q_porptmawith(nolock)whereporptid='''+@parm+'''')--select*frompp_q_porptmawhereporptid=@parmend服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务38生产检验单CREATEPROCEDURE[dbo].[NewPrint_QM_NCV14Vouch_body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromQM_NCV14_Bwith(nolock)whereid='''+@parm+'''')--SELECT*fromQM_NCV14_Bwhereid=@parmend派工单维护CREATEPROCEDURE[dbo].[NewPrint_pp_moorder_Body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务39exec('SELECT'+@strname+'frompp_q_moorderdewith(nolock)wheremoid='''+@parm+'''')--SELECT*FROMpp_q_moorderdewheremoid=@parmend生产进度汇报单CREATEPROCEDURE[dbo].[NewPrint_pp_moorderrpt_Title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'frompp_q_moorderrptmawith(nolock)whererptid='''+@parm+'''')--select*frompp_q_moorderrptmaWHERErptid=@parmend委外委外订单CREATEPROCEDURE[dbo].[NewPrint_OM_ProductPO_Title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)AS服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务40begindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromOM_ProductPO_Twith(nolock)whereid='''+@parm+'''')--select*fromOM_ProductPO_Twhereid=@parmend委外材料出库单CREATEPROCEDURE[dbo].[NewPrint_RdRecordc_Title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromRdRecord_Twith(nolock)whereid='''+@parm+'''')--select*fromRdRecord_Twhereid=@parmend服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务41委外产成品入库单委外产成品入库单CREATEPROCEDURE[dbo].[NewPrint_RdRecordr_Body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+',ginvpicturefromomrecordinsqwith(nolock)leftjoin(selectcinvcodeasgpiccode,ginvpicturefromInventoryPicturewherecpictypeisnotnull)AonA.gpiccode=omrecordinsq.cinvcodewhereid='''+@parm+'''')--select*fromomrecordinsqwhereid=@parmend委外检验单CREATEPROCEDURE[dbo].[NewPrint_QM_NCV16Vouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegin服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务42declare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromQM_NCV16_Hwith(nolock)whereid='''+@parm+'''')--select*fromQM_NCV16_HwhereID=@parmend委外普通发票CREATEPROCEDURE[dbo].[NewPrint_OM_PurBillVouch_body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromOM_PurBillVouchs_Vwith(nolock)wherepbvid='''+@parm+'''')--SELECT*fromOM_PurBillVouchs_Vwherepbvid=@parmend服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务43红字委外普通发票CREATEPROCEDURE[dbo].[NewPrint_OM_PurBillVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromOM_PurBillVouch_Twith(nolock)wherepbvid='''+@parm+'''')--select*fromOM_PurBillVouch_Twherepbvid=@parmend委外专用发票CREATEPROCEDURE[dbo].[NewPrint_Z_OM_PurBillVouch_body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务44@cardsection)exec('SELECT'+@strname+'fromOM_PurBillVouchs_Vwith(nolock)wherepbvid='''+@parm+'''')--SELECT*fromOM_PurBillVouchs_Vwherepbvid=@parmend红字委外专用发票CREATEPROCEDURE[dbo].[NewPrint_Z_OM_PurBillVouch_body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromOM_PurBillVouchs_Vwith(nolock)wherepbvid='''+@parm+'''')--SELECT*fromOM_PurBillVouchs_Vwherepbvid=@parmend委外普通运费发票CREATEPROCEDURE[dbo].[NewPrint_WWpurBillVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumber服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务45varchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromWWYpurBillHeadwith(nolock)wherepbvid='''+@parm+'''')--select*fromWWYpurBillHeadwherepbvid=@parmend红字委外普通运费发票CREATEPROCEDURE[dbo].[NewPrint_WWpurBillVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromWWYpurBillHeadwith(nolock)wherepbvid='''+@parm+'''')服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务46--select*fromWWYpurBillHeadwherepbvid=@parmend委外专用运费发票CreatePROCEDURE[dbo].[NewPrint_Z_WWpurBillVouch_body]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromwwzpurbilltailwith(nolock)wherepbvid='''+@parm+'''')end红字委外专用运费发票CreatePROCEDURE[dbo].[NewPrint_Z_WWpurBillVouch_title]@parmvarchar(100),@uservarchar(100),@cardnumbervarchar(100),@cardsectionvarchar(100)ASbegindeclare@strnamevarchar(4000)set服务热线：4006600566（客户）；010-62485766（伙伴）；服务社区：service.chanjet.com;微信服务号：畅捷服务47@strname=dbo.NPrint_GetFldName(@user,@cardnumber,@cardsection)exec('SELECT'+@strname+'fromZ_WWYpurBillHeadwith(nolock)wherepbvid='''+@parm+'''')end
