#沈阳同城会的会员应该另加一个群，共同学习1 #沈阳同城会的会员应该另加一个群，共同学习1[]

有道理

想调宽一点，不懂在哪里调？ 想调宽一点，不懂在哪里调？

您好，请问您是哪里想调宽呢
@畅捷服务吴娟:摘要
@柠檬树啦啦啦:您好，软件中摘要的宽度是固定的，无法进行调整。
@畅捷服务吴娟:打印的时候，也无法修改吗？
@柠檬树啦啦啦:可以改的啦，这个要调凭证打印的模版，是一个rep的文件
@柠檬树啦啦啦:您好，软件中打印和填写摘要宽都是固定的，无法在T3软件中进行更改。如果您一定要更改，请联系下您的服务商帮您到后台中改凭证的模板

用友U8 先进先出法出库成本错误用友U8 先进先出法出库成本错误 问题原因:数据错误 解决方法:备份数据，恢复单据记帐，在IA_valuationAss表中滤出成本错误的存货,发现入库单价字段值异常,根据对应的采购入库单修改为正确的单价,再记所有入库类型单据,再记所有出库类型单据,取成本正确。
解决方案：
问题原因:数据错误 解决方法:备份数据，恢复单据记帐，在IA_valuationAss表中滤出成本错误的存货,发现入库单价字段值异常,根据对应的采购入库单修改为正确的单价,再记所有入库类型单据,再记所有出库类型单据,取成本正确。

www.kuaiji66.com 天龙瑞德

用友U8 销售系统发货结算勾对表查出有很多负数未结算，但在开销售发票时参照不到这些未结算的发货单。用友U8 销售系统发货结算勾对表查出有很多负数未结算，但在开销售发票时参照不到这些未结算的发货单。 问题原因:发货结算勾对表错，当红字发货单（即退货单）已关闭时，在发货结算勾对表中还是显示未结算数量，而兰字发货单已关闭时则未结算数量为零，导致发货结算勾对表中有很多负数未结算，而开票时参照发货单时已关闭的发货单不显示，故两处显示结果不一致。 解决方法:修改存储过程SA_MoveOutIncome，在判断发货单是否已关闭的条件前加上abs，使判断条件考虑红、兰两种发货单后两处显示结果一致。存储过程SA_MoveOutIncome：/* 当有退补业务时发货结算勾对表查询无数据 江苏省药材公司 2003.06.27 当发货单关闭时发货结算勾对表未结数量为0 而当退货单关闭时发货结算勾对表未结数量为退货数量 江苏省中医药科技发展总公司 2003.07.18 南京用友维护部 丁德安*/IF EXISTS(SELECT * FROM sysobjects WHERE name='Sa_MoveOutIncome' and type='P')DROP PROCEDURE Sa_MoveOutIncomeGOCREATE PROCEDURE Sa_MoveOutIncome( -- 取得发货发货明细账存储过程 作者：刘小东 --@chrtable varchar(200) = null , --保存发货结算勾兑明细临时表--@chrWhere1 varchar(255) =null , --查询条件名称--@chrOutDate varchar(100) = null ,-- 发货日期 --@chrSaleDate varchar(100) = null, -- 开票日期 --@chrVouchType varchar(100) = null -- 单据类型 --) ASdeclare @chrSQL varchar(8000)declare @chrCost varchar(50)declare @chrWhere varchar(1000) declare @chrstartDate varchar(50)declare @chrstartDate1 varchar(50)declare @chrstartdate2 varchar(50)if ltrim(rtrim(@chrwhere1 )) = 'newReport_ParameterFromTempTable' begin --条件参数通过临时表传递 --set @chrwhere = (select name from tempdb..newReportParameter )end else --条件参数直接传递 --begin set @chrwhere = rtrim(ltrim(@chrwhere1))end -- 取销售系统启用日期 --set @chrStartDate = (select isnull(cValue,'1900-01-01') from accinformation where cSysid='Sa' and cName='dStartDate' ) if @chrstartdate <> '' begin if len(ltrim(rtrim(@chrstartdate))) <= 8 set @chrstartdate = convert(varchar(10),convert(smalldatetime,@chrstartdate,2),121) set @chrstartDate1 = ' Dispatchlist.dDate>=''' + @chrstartdate + ''''set @chrstartDate2 = ' and SalebillVouch.dDate>=''' + @chrstartdate + ''''end if exists(select * from tempdb..sysobjects where name ='po_DispatchFirst ') drop table tempdb..po_DispatchFirst print '发货'--取得发货单内容 -- --2003.06.27 增加两字段iTB,TBQuantityset @chrsql = 'Select Dispatchlist.DLID as DLID ,Dispatchlist.cDLCode AS cDLCode,Dispatchlist.cSTCode AS cSTCode ,Dispatchlist.ddate AS ddate ,Dispatchlist.cDepCode as cDepCode,Dispatchlist.cPersonCode as cPersonCode , Dispatchlist.cCusCode as cCusCode, Dispatchlist.iExchRate as iExchRate , Dispatchlist.bFirst as bFirst , Dispatchlist.cVerifier as cVerifier, Dispatchlist.cMaker as cMaker, Dispatchlists.iDlsid as iDlsid, Dispatchlists.cWhCode as cWHCode , Dispatchlists.cInvCode as cInvCode , Dispatchlists.iQuantity as iQuantity , Dispatchlists.iNum as iNum , Dispatchlists.iTaxUnitPrice as iTaxUnitPrice , Dispatchlists.iMoney as iMoney , Dispatchlists.iTax as iTax , Dispatchlists.iSum as iSum , Dispatchlists.iDisCount as iDisCount , Dispatchlists.iNatUnitPrice as iNatUnitPrice, Dispatchlists.iNatMoney as iNatMoney , Dispatchlists.iNatTax as iNatTax , Dispatchlists.iNatSum as iNatSum , Dispatchlists.iNatDisCount as iNatDisCount , Dispatchlists.cBatch as cBatch , Dispatchlists.cFree1 as cFree1, Dispatchlists.cFree2 as cFree2 , Dispatchlists.iTaxRate as iTaxRate , Dispatchlists.cDefine22 as cDefine22 , Dispatchlists.cDefine23 as cDefine23, Dispatchlists.cDefine24 as cDefine24, Dispatchlists.cDefine25 as cDefine25, Dispatchlists.cDefine26 as cDefine26 , Dispatchlists.cDefine27 as cDefine27 ,Dispatchlist.cVouchtype as cVouchtype,Dispatchlist.cDefine1 as cDefine1 , Dispatchlist.cDefine2 as cDefine2 ,Dispatchlist.cDefine3 as cDefine3 ,Dispatchlist.cDefine4 as cDefine4 ,Dispatchlist.cDefine5 as cDefine5 ,Dispatchlist.cDefine6 as cDefine6 ,Dispatchlist.cDefine7 as cDefine7 ,Dispatchlist.cDefine8 as cDefine8 ,Dispatchlist.cDefine9 as cDefine9 ,Dispatchlist.cDefine10 as cDefine10 ,Dispatchlists.bSettleall as bsettleall , Dispatchlists.iSettleQuantity as iSettleQuantity , Dispatchlists.iSettleNum as iSettlenum ,Dispatchlists.iTB as iTB ,Dispatchlists.TBQuantity as TBQuantity ,Dispatchlists.iUnitPrice INTO tempdb..po_DispatchFirst From Dispatchlists inner join Dispatchlist On DispatchLists.DLID = Dispatchlist.DLID WHERE ( Dispatchlist.bFirst=1 or ' + @chrstartdate1 + ' ) '--追加单据类型条件 if not (@chrVouchtype is null ) and ltrim(rtrim(@chrVouchType)) <> '' set @chrsql = @chrsql + ' and ' + @chrVouchtype if not (@chrOutDate is null ) and ltrim(rtrim(@chrOutDate)) <> '' set @chrsql = @chrsql + ' and ' + @chrOutDate if not (@chrwhere is null ) and ltrim(rtrim(@chrwhere)) <> '' set @chrsql = @chrsql + ' and ' + @chrWhere exec (@chrsql )--取得发票内容，发票按发货单子表ID汇总 --print '开票'if exists(select * from tempdb..sysobjects where name ='po_SaleBillFirst ') drop table tempdb..po_salebillfirst set @chrsql = 'Select SaleBillVouchs.iDLSID as iDLSID ,SaleBillVouchs.iQuantity as iQuantity , SaleBillVouchs.iNum as iNum , SaleBillVouchs.iMoney as iMoney , SaleBillVouchs.iSum as iSum , SaleBillVouchs.iTax as iTax , SaleBillVouchs.iNatMoney as iNatMoney , SaleBillVouchs.iNatSum as iNatSum , SaleBillVouchs.iNatTax as iNatTax INTO tempdb..po_SaleBillfirst From SaleBillVouchs inner join SaleBillVouch On SalebillVouchs.SBVID = SalebillVouch.SBVID inner join tempdb..po_dispatchfirst on tempdb..po_dispatchfirst.idlsid = Salebillvouchs.idlsidWhere Salebillvouchs.idlsid <> 0 and Salebillvouchs.idlsid is not null and isnull(Salebillvouch.cInvalider,'''')=''''and isnull(Salebillvouch.cSTCode,'''') <> '''' ' + @chrstartdate2 --作废发票不能计算在内,开票日期必须大于系统起用日期 --if not (@chrSaleDate is null ) and ltrim(rtrim(@chrSaleDate)) <> '' set @chrsql = @chrsql + ' and ' + @chrSaleDate --不要其它条件 --if not (@chrwhere is null ) and ltrim(rtrim(@chrwhere)) <> '' set @chrsql = @chrsql + ' and ' + @chrwhere exec( @chrsql )-- 发票内容按发货单子表ID号合计--if exists(select * from tempdb..sysobjects where name ='po_SaleBill') Drop Table tempdb..po_salebill Select iDlsid ,Sum( iQuantity ) as js_iQuantity,Sum( iNum) as js_iNum , Sum( iMoney ) as js_iMoney , Sum( iSum ) as js_iSum , Sum( iTax ) as js_iTax, Sum( iNatMoney ) as js_iNatMoney, Sum( iNatSum ) as js_iNatSum ,Sum( iNatTax ) as js_iNatTaxINTO tempdb..po_SaleBill from tempdb..po_salebillfirst Group by Idlsid if exists( select * from tempdb..sysobjects where name='po_DispSale')Drop table tempdb..po_DispSale -- 关联发货单和结算单 -- -- ye_iNatSum,ye_iNatTax 考虑退补问题 -- 2003.06.27 -- 退货单关闭时问题， -- case when a.bsettleall = 1 and ( a.iQuantity -a.iSettleQuantity ) > 0 then -- 改成 case when a.bsettleall = 1 and abs( a.iQuantity -a.iSettleQuantity ) > 0 then -- 2003.07.18set @chrsql = 'Select a.DLID as DLID ,a.cDLCode AS cDLCode,a.cSTCode AS cSTCode ,a.ddate AS ddate ,a.cDepCode as cDepCode,a.cPersonCode as cPersonCode , a.cCusCode as cCusCode, a.iExchRate as iExchRate , a.bFirst as bFirst , a.cVerifier as cVerifier, a.cMaker as cMaker, a.cWhCode as cWHCode , a.cInvCode as cInvCode , a.iQuantity as iQuantity , a.iNum as iNum , a.iTaxUnitPrice as iTaxUnitPrice , a.iMoney as iMoney , a.iTax as iTax , a.iSum as iSum , a.iDisCount as iDisCount , a.iNatUnitPrice as iNatUnitPrice, a.iNatMoney as iNatMoney , a.iNatTax as iNatTax , a.iNatSum as iNatSum , a.iNatDisCount as iNatDisCount , a.cBatch as cBatch , a.cFree1 as cFree1, a.cFree2 as cFree2 , a.iTaxRate as iTaxRate , a.cDefine22 as cDefine22 , a.cDefine23 as cDefine23, a.cDefine24 as cDefine24, a.cDefine25 as cDefine25, a.cDefine26 as cDefine26 , a.cDefine27 as cDefine27 , a.cVouchtype as cVouchtype , tempdb..po_SaleBill.js_iQuantity as js_iQuantity,tempdb..po_SaleBill.js_iNum as js_iNum , tempdb..po_SaleBill.js_iMoney as js_iMoney , tempdb..po_SaleBill.js_iSum as js_iSum , tempdb..po_SaleBill.js_iTax as js_iTax, tempdb..po_SaleBill.js_iNatMoney as js_iNatMoney, tempdb..po_SaleBill.js_iNatSum as js_iNatSum ,tempdb..po_SaleBill.js_iNatTax as js_iNatTax ,case when a.bsettleall = 1 and abs( a.iQuantity -a.iSettleQuantity ) > 0 then a.iSettleQuantity - isnull(tempdb..po_salebill.js_iQuantity,0)else a.iQuantity - isnull(tempdb..po_salebill.js_iQuantity,0)end as ye_iQuantity,case when a.bSettleall =1 and abs( a.iQuantity -a.iSettleQuantity ) > 0 then a.iSettleNum - isnull(tempdb..po_salebill.js_inum,0)else a.iNum - isnull(tempdb..po_salebill.js_inum,0 )end as ye_iNum , case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then iUnitPrice * a.iSettleQuantity - isnull( tempdb..po_salebill.js_iMoney,0 )else a.iMoney - isnull(tempdb..po_salebill.js_iMoney, 0 ) end as ye_iMoney , case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then a.iTaxUnitPrice * a.iSettleQuantity - isnull( tempdb..po_salebill.js_isum , 0 )else a.isum - isnull(tempdb..po_salebill.js_isum , 0 )end as ye_iSum , case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then ( a.iTaxUnitPrice - a.iUnitPrice) * a.iSettleQuantity - isnull (tempdb..po_salebill.js_itax, 0 )else a.iTax - isnull(tempdb..po_salebill.js_iTax,0 )end as ye_iTax, case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then a.iNatUnitPrice * a.iSettleQuantity - isnull( tempdb..po_salebill.js_iNatMoney,0 )else a.iNatMoney - isnull(tempdb..po_salebill.js_iNatMoney,0)end as ye_iNatMoney, case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then case when a.iTB=1 then(a.iNatSum / a.TBQuantity) * a.iSettleQuantity - isnull( tempdb..po_salebill.js_iNatSum,0 )else(a.iNatSum / a.iQuantity) * a.iSettleQuantity - isnull( tempdb..po_salebill.js_iNatSum,0 )endelse a.iNatSum - isnull(tempdb..po_salebill.js_iNatSum,0 )end as ye_iNatSum ,case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then case when a.iTB=1 then ((a.iNatSum - a.iNatMoney) / a.TBQuantity) * a.iSettleQuantity - isnull(tempdb..po_salebill.js_iNatTax, 0 )else ((a.iNatSum - a.iNatMoney) / a.iQuantity) * a.iSettleQuantity - isnull(tempdb..po_salebill.js_iNatTax, 0 )endelse a.iNatTax - isnull(tempdb..po_salebill.js_iNatTax, 0 )end as ye_iNatTax , a.cDefine1 ,a.cDefine2 ,a.cDefine3 ,a.cDefine4 ,a.cDefine5 ,a.cDefine6 ,a.cDefine7 ,a.cDefine8 ,a.cDefine9 ,a.cDefine10 into tempdb..po_DispSale from tempdb..po_dispatchfirst a left join tempdb..po_salebill On a.idlsid = tempdb..po_salebill.iDLSID ' exec (@chrsql )print '结果'-- 生成最终的明细账临时表 --if exists(select * from tempdb..sysobjects where name =@chrtable ) exec('drop table tempdb..' + @chrtable )set @chrsql = 'Select tempdb..po_DispSale.* , inventory.cInvName as cInvName , inventory.cInvStd as cInvStd , inventory.cInvM_Unit as cInvM_Unit , inventory.cinvCCode as cInvCCode , Customer.cCusName as cCusName , Customer.cCCCode as cCCCode , SaleType.cSTName as cSTName, Department.cDepName as cDepName , Person.cPersonName as cPersonname , WareHouse.cWHName as cWHName ,Customer.cCusAbbName as cCusAbbName ,Vouchtype.cVouchName as cVouchName into tempdb..'+ @chrtable + ' From tempdb..po_Dispsale left join inventory on tempdb..po_dispsale.cInvCode = inventory.cInvCode left join customer on tempdb..po_dispsale.cCusCode = Customer.cCusCode left join saletype on tempdb..po_dispsale.cSTCode = SaleType.cSTCode left join department on tempdb..po_dispsale.cDepCode = Department.cDepCode left join person on tempdb..po_dispsale.cPersonCode = person.cPersonCode left join warehouse on tempdb..po_dispsale.cWhCode = warehouse.cWhCodeleft join Vouchtype on tempdb..po_dispsale.cVouchtype = Vouchtype.cVouchtypeorder by tempdb..po_dispsale.ddate,tempdb..po_dispsale.dlid 'exec ( @chrsql )
解决方案：
问题原因:发货结算勾对表错，当红字发货单（即退货单）已关闭时，在发货结算勾对表中还是显示未结算数量，而兰字发货单已关闭时则未结算数量为零，导致发货结算勾对表中有很多负数未结算，而开票时参照发货单时已关闭的发货单不显示，故两处显示结果不一致。 解决方法:修改存储过程SA_MoveOutIncome，在判断发货单是否已关闭的条件前加上abs，使判断条件考虑红、兰两种发货单后两处显示结果一致。存储过程SA_MoveOutIncome：/* 当有退补业务时发货结算勾对表查询无数据 江苏省药材公司 2003.06.27 当发货单关闭时发货结算勾对表未结数量为0 而当退货单关闭时发货结算勾对表未结数量为退货数量 江苏省中医药科技发展总公司 2003.07.18 南京用友维护部 丁德安*/IF EXISTS(SELECT * FROM sysobjects WHERE name='Sa_MoveOutIncome' and type='P')DROP PROCEDURE Sa_MoveOutIncomeGOCREATE PROCEDURE Sa_MoveOutIncome( -- 取得发货发货明细账存储过程 作者：刘小东 --@chrtable varchar(200) = null , --保存发货结算勾兑明细临时表--@chrWhere1 varchar(255) =null , --查询条件名称--@chrOutDate varchar(100) = null ,-- 发货日期 --@chrSaleDate varchar(100) = null, -- 开票日期 --@chrVouchType varchar(100) = null -- 单据类型 --) ASdeclare @chrSQL varchar(8000)declare @chrCost varchar(50)declare @chrWhere varchar(1000) declare @chrstartDate varchar(50)declare @chrstartDate1 varchar(50)declare @chrstartdate2 varchar(50)if ltrim(rtrim(@chrwhere1 )) = 'newReport_ParameterFromTempTable' begin --条件参数通过临时表传递 --set @chrwhere = (select name from tempdb..newReportParameter )end else --条件参数直接传递 --begin set @chrwhere = rtrim(ltrim(@chrwhere1))end -- 取销售系统启用日期 --set @chrStartDate = (select isnull(cValue,'1900-01-01') from accinformation where cSysid='Sa' and cName='dStartDate' ) if @chrstartdate <> '' begin if len(ltrim(rtrim(@chrstartdate))) <= 8 set @chrstartdate = convert(varchar(10),convert(smalldatetime,@chrstartdate,2),121) set @chrstartDate1 = ' Dispatchlist.dDate>=''' + @chrstartdate + ''''set @chrstartDate2 = ' and SalebillVouch.dDate>=''' + @chrstartdate + ''''end if exists(select * from tempdb..sysobjects where name ='po_DispatchFirst ') drop table tempdb..po_DispatchFirst print '发货'--取得发货单内容 -- --2003.06.27 增加两字段iTB,TBQuantityset @chrsql = 'Select Dispatchlist.DLID as DLID ,Dispatchlist.cDLCode AS cDLCode,Dispatchlist.cSTCode AS cSTCode ,Dispatchlist.ddate AS ddate ,Dispatchlist.cDepCode as cDepCode,Dispatchlist.cPersonCode as cPersonCode , Dispatchlist.cCusCode as cCusCode, Dispatchlist.iExchRate as iExchRate , Dispatchlist.bFirst as bFirst , Dispatchlist.cVerifier as cVerifier, Dispatchlist.cMaker as cMaker, Dispatchlists.iDlsid as iDlsid, Dispatchlists.cWhCode as cWHCode , Dispatchlists.cInvCode as cInvCode , Dispatchlists.iQuantity as iQuantity , Dispatchlists.iNum as iNum , Dispatchlists.iTaxUnitPrice as iTaxUnitPrice , Dispatchlists.iMoney as iMoney , Dispatchlists.iTax as iTax , Dispatchlists.iSum as iSum , Dispatchlists.iDisCount as iDisCount , Dispatchlists.iNatUnitPrice as iNatUnitPrice, Dispatchlists.iNatMoney as iNatMoney , Dispatchlists.iNatTax as iNatTax , Dispatchlists.iNatSum as iNatSum , Dispatchlists.iNatDisCount as iNatDisCount , Dispatchlists.cBatch as cBatch , Dispatchlists.cFree1 as cFree1, Dispatchlists.cFree2 as cFree2 , Dispatchlists.iTaxRate as iTaxRate , Dispatchlists.cDefine22 as cDefine22 , Dispatchlists.cDefine23 as cDefine23, Dispatchlists.cDefine24 as cDefine24, Dispatchlists.cDefine25 as cDefine25, Dispatchlists.cDefine26 as cDefine26 , Dispatchlists.cDefine27 as cDefine27 ,Dispatchlist.cVouchtype as cVouchtype,Dispatchlist.cDefine1 as cDefine1 , Dispatchlist.cDefine2 as cDefine2 ,Dispatchlist.cDefine3 as cDefine3 ,Dispatchlist.cDefine4 as cDefine4 ,Dispatchlist.cDefine5 as cDefine5 ,Dispatchlist.cDefine6 as cDefine6 ,Dispatchlist.cDefine7 as cDefine7 ,Dispatchlist.cDefine8 as cDefine8 ,Dispatchlist.cDefine9 as cDefine9 ,Dispatchlist.cDefine10 as cDefine10 ,Dispatchlists.bSettleall as bsettleall , Dispatchlists.iSettleQuantity as iSettleQuantity , Dispatchlists.iSettleNum as iSettlenum ,Dispatchlists.iTB as iTB ,Dispatchlists.TBQuantity as TBQuantity ,Dispatchlists.iUnitPrice INTO tempdb..po_DispatchFirst From Dispatchlists inner join Dispatchlist On DispatchLists.DLID = Dispatchlist.DLID WHERE ( Dispatchlist.bFirst=1 or ' + @chrstartdate1 + ' ) '--追加单据类型条件 if not (@chrVouchtype is null ) and ltrim(rtrim(@chrVouchType)) <> '' set @chrsql = @chrsql + ' and ' + @chrVouchtype if not (@chrOutDate is null ) and ltrim(rtrim(@chrOutDate)) <> '' set @chrsql = @chrsql + ' and ' + @chrOutDate if not (@chrwhere is null ) and ltrim(rtrim(@chrwhere)) <> '' set @chrsql = @chrsql + ' and ' + @chrWhere exec (@chrsql )--取得发票内容，发票按发货单子表ID汇总 --print '开票'if exists(select * from tempdb..sysobjects where name ='po_SaleBillFirst ') drop table tempdb..po_salebillfirst set @chrsql = 'Select SaleBillVouchs.iDLSID as iDLSID ,SaleBillVouchs.iQuantity as iQuantity , SaleBillVouchs.iNum as iNum , SaleBillVouchs.iMoney as iMoney , SaleBillVouchs.iSum as iSum , SaleBillVouchs.iTax as iTax , SaleBillVouchs.iNatMoney as iNatMoney , SaleBillVouchs.iNatSum as iNatSum , SaleBillVouchs.iNatTax as iNatTax INTO tempdb..po_SaleBillfirst From SaleBillVouchs inner join SaleBillVouch On SalebillVouchs.SBVID = SalebillVouch.SBVID inner join tempdb..po_dispatchfirst on tempdb..po_dispatchfirst.idlsid = Salebillvouchs.idlsidWhere Salebillvouchs.idlsid <> 0 and Salebillvouchs.idlsid is not null and isnull(Salebillvouch.cInvalider,'''')=''''and isnull(Salebillvouch.cSTCode,'''') <> '''' ' + @chrstartdate2 --作废发票不能计算在内,开票日期必须大于系统起用日期 --if not (@chrSaleDate is null ) and ltrim(rtrim(@chrSaleDate)) <> '' set @chrsql = @chrsql + ' and ' + @chrSaleDate --不要其它条件 --if not (@chrwhere is null ) and ltrim(rtrim(@chrwhere)) <> '' set @chrsql = @chrsql + ' and ' + @chrwhere exec( @chrsql )-- 发票内容按发货单子表ID号合计--if exists(select * from tempdb..sysobjects where name ='po_SaleBill') Drop Table tempdb..po_salebill Select iDlsid ,Sum( iQuantity ) as js_iQuantity,Sum( iNum) as js_iNum , Sum( iMoney ) as js_iMoney , Sum( iSum ) as js_iSum , Sum( iTax ) as js_iTax, Sum( iNatMoney ) as js_iNatMoney, Sum( iNatSum ) as js_iNatSum ,Sum( iNatTax ) as js_iNatTaxINTO tempdb..po_SaleBill from tempdb..po_salebillfirst Group by Idlsid if exists( select * from tempdb..sysobjects where name='po_DispSale')Drop table tempdb..po_DispSale -- 关联发货单和结算单 -- -- ye_iNatSum,ye_iNatTax 考虑退补问题 -- 2003.06.27 -- 退货单关闭时问题， -- case when a.bsettleall = 1 and ( a.iQuantity -a.iSettleQuantity ) > 0 then -- 改成 case when a.bsettleall = 1 and abs( a.iQuantity -a.iSettleQuantity ) > 0 then -- 2003.07.18set @chrsql = 'Select a.DLID as DLID ,a.cDLCode AS cDLCode,a.cSTCode AS cSTCode ,a.ddate AS ddate ,a.cDepCode as cDepCode,a.cPersonCode as cPersonCode , a.cCusCode as cCusCode, a.iExchRate as iExchRate , a.bFirst as bFirst , a.cVerifier as cVerifier, a.cMaker as cMaker, a.cWhCode as cWHCode , a.cInvCode as cInvCode , a.iQuantity as iQuantity , a.iNum as iNum , a.iTaxUnitPrice as iTaxUnitPrice , a.iMoney as iMoney , a.iTax as iTax , a.iSum as iSum , a.iDisCount as iDisCount , a.iNatUnitPrice as iNatUnitPrice, a.iNatMoney as iNatMoney , a.iNatTax as iNatTax , a.iNatSum as iNatSum , a.iNatDisCount as iNatDisCount , a.cBatch as cBatch , a.cFree1 as cFree1, a.cFree2 as cFree2 , a.iTaxRate as iTaxRate , a.cDefine22 as cDefine22 , a.cDefine23 as cDefine23, a.cDefine24 as cDefine24, a.cDefine25 as cDefine25, a.cDefine26 as cDefine26 , a.cDefine27 as cDefine27 , a.cVouchtype as cVouchtype , tempdb..po_SaleBill.js_iQuantity as js_iQuantity,tempdb..po_SaleBill.js_iNum as js_iNum , tempdb..po_SaleBill.js_iMoney as js_iMoney , tempdb..po_SaleBill.js_iSum as js_iSum , tempdb..po_SaleBill.js_iTax as js_iTax, tempdb..po_SaleBill.js_iNatMoney as js_iNatMoney, tempdb..po_SaleBill.js_iNatSum as js_iNatSum ,tempdb..po_SaleBill.js_iNatTax as js_iNatTax ,case when a.bsettleall = 1 and abs( a.iQuantity -a.iSettleQuantity ) > 0 then a.iSettleQuantity - isnull(tempdb..po_salebill.js_iQuantity,0)else a.iQuantity - isnull(tempdb..po_salebill.js_iQuantity,0)end as ye_iQuantity,case when a.bSettleall =1 and abs( a.iQuantity -a.iSettleQuantity ) > 0 then a.iSettleNum - isnull(tempdb..po_salebill.js_inum,0)else a.iNum - isnull(tempdb..po_salebill.js_inum,0 )end as ye_iNum , case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then iUnitPrice * a.iSettleQuantity - isnull( tempdb..po_salebill.js_iMoney,0 )else a.iMoney - isnull(tempdb..po_salebill.js_iMoney, 0 ) end as ye_iMoney , case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then a.iTaxUnitPrice * a.iSettleQuantity - isnull( tempdb..po_salebill.js_isum , 0 )else a.isum - isnull(tempdb..po_salebill.js_isum , 0 )end as ye_iSum , case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then ( a.iTaxUnitPrice - a.iUnitPrice) * a.iSettleQuantity - isnull (tempdb..po_salebill.js_itax, 0 )else a.iTax - isnull(tempdb..po_salebill.js_iTax,0 )end as ye_iTax, case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then a.iNatUnitPrice * a.iSettleQuantity - isnull( tempdb..po_salebill.js_iNatMoney,0 )else a.iNatMoney - isnull(tempdb..po_salebill.js_iNatMoney,0)end as ye_iNatMoney, case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then case when a.iTB=1 then(a.iNatSum / a.TBQuantity) * a.iSettleQuantity - isnull( tempdb..po_salebill.js_iNatSum,0 )else(a.iNatSum / a.iQuantity) * a.iSettleQuantity - isnull( tempdb..po_salebill.js_iNatSum,0 )endelse a.iNatSum - isnull(tempdb..po_salebill.js_iNatSum,0 )end as ye_iNatSum ,case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then case when a.iTB=1 then ((a.iNatSum - a.iNatMoney) / a.TBQuantity) * a.iSettleQuantity - isnull(tempdb..po_salebill.js_iNatTax, 0 )else ((a.iNatSum - a.iNatMoney) / a.iQuantity) * a.iSettleQuantity - isnull(tempdb..po_salebill.js_iNatTax, 0 )endelse a.iNatTax - isnull(tempdb..po_salebill.js_iNatTax, 0 )end as ye_iNatTax , a.cDefine1 ,a.cDefine2 ,a.cDefine3 ,a.cDefine4 ,a.cDefine5 ,a.cDefine6 ,a.cDefine7 ,a.cDefine8 ,a.cDefine9 ,a.cDefine10 into tempdb..po_DispSale from tempdb..po_dispatchfirst a left join tempdb..po_salebill On a.idlsid = tempdb..po_salebill.iDLSID ' exec (@chrsql )print '结果'-- 生成最终的明细账临时表 --if exists(select * from tempdb..sysobjects where name =@chrtable ) exec('drop table tempdb..' + @chrtable )set @chrsql = 'Select tempdb..po_DispSale.* , inventory.cInvName as cInvName , inventory.cInvStd as cInvStd , inventory.cInvM_Unit as cInvM_Unit , inventory.cinvCCode as cInvCCode , Customer.cCusName as cCusName , Customer.cCCCode as cCCCode , SaleType.cSTName as cSTName, Department.cDepName as cDepName , Person.cPersonName as cPersonname , WareHouse.cWHName as cWHName ,Customer.cCusAbbName as cCusAbbName ,Vouchtype.cVouchName as cVouchName into tempdb..'+ @chrtable + ' From tempdb..po_Dispsale left join inventory on tempdb..po_dispsale.cInvCode = inventory.cInvCode left join customer on tempdb..po_dispsale.cCusCode = Customer.cCusCode left join saletype on tempdb..po_dispsale.cSTCode = SaleType.cSTCode left join department on tempdb..po_dispsale.cDepCode = Department.cDepCode left join person on tempdb..po_dispsale.cPersonCode = person.cPersonCode left join warehouse on tempdb..po_dispsale.cWhCode = warehouse.cWhCodeleft join Vouchtype on tempdb..po_dispsale.cVouchtype = Vouchtype.cVouchtypeorder by tempdb..po_dispsale.ddate,tempdb..po_dispsale.dlid 'exec ( @chrsql )

批量审核请购单 批量审核请购单

平仓盈亏（offset gain and loss） 平仓盈亏（offset gain and loss）

    与持仓盈亏相对。期货交易者在实际平仓时所发生的损益。分为即日平仓盈亏和延至平仓盈亏。即日平仓盈亏指当日开仓并平仓的盈亏，延至平仓盈亏指以前开仓当日平仓的盈亏。其计算公式如下：

　　即日平仓盈亏=（平仓价-开仓价）×平仓量
　　延至平仓盈仓=（平仓价-上日结算价）×平仓量

会计可以已经在上个月使用了并结了账，现在想要在这个科目下加3及科目提示被使用了，怎么解决这个问题呢？除了反到1月初替换凭证取消期间损益结转定义，删除期初的这个方法外有简单一点的方法吗 会计可以已经在上个月使用了并结了账，现在想要在这个科目下加3及科目提示被使用了，怎么解决这个问题呢？除了反到1月初替换凭证取消期间损益结转定义，删除期初的这个方法外有简单一点的方法吗[]

您可以直接点计是——下一步——是。就可正常添加三级科目，您的二级科目的金额会自动转到您的三级上。
已经使用的科目可以增加下级科目的，系统会提示是否要增加下级科目，点击下一步，确定，已使用的科目数据会复制到新增的第一个下级科目里。
使用过的科目也可以增加下级科目，提示已使用的，点击继续增加就可以
删除期初余额，修改反结账反记账到期初

短期借款的分类 短期借款的分类

　　企业用来维持正常的生产经营所需的资金或为抵偿项全力而向银行或其他金融机构等外单位借入的、还款期限在一年或超过一年的一个经营周期内的各种借款。

　　工商企业的短期借款主要有：经营周转借款、临时借款、结算借款、票据贴现借款、卖方信贷、预购定金借款和专项储备借款等。

　　（1）经营周转借款：亦称生产周转借款或商品周转借款。企业因流动资金不能满足正常生产经营需要，而向银行或其他金融机构取得的借款。办理该项借款时，企业应按有关规定向银行提出年度、季度借款计划，经银行核定后，在借款计划指人根据借款借据办理借款。

登陆时出现错误提示“SA口令错误或口令被修改过… 登陆时出现错误提示“SA口令错误或口令被修改过…

用友我暂时不想使用UTU，请问该怎么卸载呢？ 我暂时不想使用UTU，请问该怎么卸载呢？

? ?与安装过程相对应，UTU服务端在卸载U8时一同卸载，客户端可通过U8客户端的卸载过程一起卸载，也可通过独立安装包卸载。卸载UTU后,系统会保留当前客户端的聊天记录及用户配置文件,重新安装UTU后将自动关联聊天记录和用户配置信息，如果不需要，可在卸载后手动删除相关信息。

请问净资产负债率多少比较适合- 请问净资产负债率多少比较适合?[]

任何财务指标都没有确定的标准。不同行业、不同企业都有不同的标准。净资产负债率越大，说明你负债多，杠杆作用明显，但债权人风险越大
@财务经理学院杨增华:恩,没有个大概标准吗,比如资产负债率最好是在40%-60%
你可以去查查同行业标准。不同行业肯定差异很大

用友U8 采购入库单结算价为人民币,实际付款时用港币,请问如何进行付款单与采购发票核销-用友U8 采购入库单结算价为人民币,实际付款时用港币,请问如何进行付款单与采购发票核销? 问题原因:同解决方案 解决方法:您好：我们软件中异币种核销功能，从付款单录入功能里找到该付款单。然后点核销旁边的下拉黑三角。选异币种，就可以实现异币种核销功能。
解决方案：
问题原因:同解决方案 解决方法:您好：我们软件中异币种核销功能，从付款单录入功能里找到该付款单。然后点核销旁边的下拉黑三角。选异币种，就可以实现异币种核销功能。

在登录T3采购和销售模块的时候提示如图，然后就登录不进去了，提示登陆子系统失败，请问这是什么问题？ 在登录T3采购和销售模块的时候提示如图，然后就登录不进去了，提示登陆子系统失败，请问这是什么问题？

点击服务社区-更多-工具下载下载工具：工具名称：清除异常互斥记录：http://service.chanjet.com/tool，清除一下异常互斥记录再进行操作
注意重启一下服务器的产品服务

备份引入失败_0备份引入失败

项目成本12个成本责任区域是什么？ 项目成本12个成本责任区域是什么？''

在现金流量表附表中，定义计算项目...在现金流量表附表中，定义计算项目...

利润表(小企业) 利润表(小企业)

点击下载、查看利润表

您好老师 我们去年的时候让一个单位给做技术开发但是一开始是付的现金有10000 后来是银行存款有60000，但是现在才给开发票，发票金额是60000，原来一开始的10000是给这个单位的一个开发人员的，发票是不会给开了，我当时做帐做的预付款---单位，怎么处理这部分没有票的呢 谢谢老师！ 您好老师 我们去年的时候让一个单位给做技术开发但是一开始是付的现金有10000 后来是银行存款有60000，但是现在才给开发票，发票金额是60000，原来一开始的10000是给这个单位的一个开发人员的，发票是不会给开了，我当时做帐做的预付款-**单位，怎么处理这部分没有票的呢 谢谢老师！[]

这一万可以去税务局开劳务发票
@倪玲1457921978: 谢谢老师

总账-账簿打印-总账账簿打印-打印预览--我的上头6个字没有了，应该怎样设置- 总账\账簿打印\总账账簿打印\打印预览我的上头6个字没有了，应该怎样设置?

打印时候，这6个字没有
在总账-设置-选项-账簿页签中，打印位数宽度中的6个数值都调整大些，一般调为20-30，账簿表头可以显示。
@畅捷服务苏娜_:回复 我试了，还是不行
看下演示账套是否能调整正常。如果正常的话，做好账套备份，进入这个账套的数据库，把表gl_myoutput、gl_mybooktype、printex删除，从演示账套中把这三个表导入过来。如果您是客户，不要自行修改数据库，请联系服务商处理
@畅捷服务苏娜_:我试试，不能是需要升级吧
好的
@畅捷服务苏娜_:还是不行，是不是需要打补丁？
还有没有其他办法？
使用软件之前要打上补丁，导表的方式也不行的话只能看下他的数据了，先打上补丁，对账套执行补丁脚本，还是有问题的话，直接在支持网提交问题和账套，根据数据进一步处理吧。

u8自动备份目录

用友软件提供两种备份方式：手工备份和自动备份，下面我们讲解这两种方式的备份账套数据操作步骤（T6和U8与T3备份恢复方法相同，此处以T3为例）：

㈠、手工备份

1、先在硬盘上建立一个空文件夹

打开我的电脑（双击）D（或E、F）盘，（空白处右击右键）新建文件夹，把这个新建的文件夹，改名为如用友数据手工备份。（双击）打开用友数据手工备份，（右击）出现新建文件夹，把所新建的文件夹改名为当天的备份日期如2016-12-16后退出