普及版，正常的年结步骤，为什么年结后没有总账期初余额

普及版，正常的年结步骤，为什么年结后没有总账期初余额[]

您好！正常年结之后，提示的信息是什么？是否报错了呢？
--有一个提示是报错为0，那不是就是没错吗，其他的就没有了
--备份账套，打上补丁，执行补丁脚本，然后重新年结总账，看是否正常；
--打过补丁之后
--无法启用
右击计算机（我的电脑）-管理-服务和应用程序，在服务里面找到T3产品服务或者用友通服务，点击重启服务，然后再登录软件；

t1财务增强包，报表和T3一样设置公式之后取不到数，公式也设置 为记账凭证可以取数了 凭证也正常审核记账过了。 有老师能远程协助看一下吗 t1财务增强包，报表和T3一样设置公式之后取不到数，公式也设置 为记账凭证可以取数了 凭证也正常审核记账过了。 有老师能远程协助看一下吗

很抱歉社区不能远程查看。首先看下报表公式中的科目编码和实际帐套中的损益科目编码是否一致，保持一致的话，再进入总账-明细账，看下这些损益类科目4月份的借方发生合计或贷方发生合计，费用类科目就看借方发生合计，收入类科目看贷方发生合计，如果为0，那么利润表就取不到数，

用友U8 1、产品结构录入与修改界面只显示父项名称与型号. 但有的单位是以编码为准的,可能名称都一样,这样在修改产品结构时就容易搞错.2、我们软件中产品结构排序是按存货编码(在树型结构查看中),但大多数客户如果以前做过BOM管理的都有自己的一套排序方法. 希望软件中添加可以自定义排序功能.比如在插位中手工输入序号,然后系统可以按此进行排序.用友U8 1、产品结构录入与修改界面只显示父项名称与型号. 但有的单位是以编码为准的,可能名称都一样,这样在修改产品结构时就容易搞错.2、我们软件中产品结构排序是按存货编码(在树型结构查看中),但大多数客户如果以前做过BOM管理的都有自己的一套排序方法. 希望软件中添加可以自定义排序功能.比如在插位中手工输入序号,然后系统可以按此进行排序. 问题原因:使用问题和对产品的理解问题，目前产品中均已有相应的控制和功能实现。 解决方法:1、产品结构录入时，首先参照选择父项信息，参照窗口上显示存货编码和存货名称信息； 产品结构修改时，首先需选择欲修改的父项信息，此时产品结构界面上显示的是父项编码； 所以说即使存在名称相同或相似的存货编码，也不会导致产品结构录入、修改操作的误操作。 2、目前产品结构显示界面上，可以对子项信息中任意一列，点击鼠标右键来选择排序（升序或降序）。
解决方案：
问题原因:使用问题和对产品的理解问题，目前产品中均已有相应的控制和功能实现。 解决方法:1、产品结构录入时，首先参照选择父项信息，参照窗口上显示存货编码和存货名称信息； 产品结构修改时，首先需选择欲修改的父项信息，此时产品结构界面上显示的是父项编码； 所以说即使存在名称相同或相似的存货编码，也不会导致产品结构录入、修改操作的误操作。 2、目前产品结构显示界面上，可以对子项信息中任意一列，点击鼠标右键来选择排序（升序或降序）。

用友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 )

批量打印卡片 _0批量打印卡片

凭证界面一晃而过，无法置凭证 凭证界面一晃而过，无法置凭证

对未实行福利企业税收优惠政策试点改革的征管如何应对 对未实行福利企业税收优惠政策试点改革的征管如何应对

　　日前，经国务院批准，国家税务总局、财政部、民政部和中国残疾人联合会联合发布了调整完善现行福利企业税收优惠政策试点的通知，从7月1日起，在广东等七个省市试点。根据《财政部、国家税务总局关于调整完善现行福利企业税收优惠政策试点工作的通知》（财税2006111号）和《国家税务总局、财政部、民政部中国残疾人联合会关于调整完善现行福利企业税收优惠政策试点实施办法的通知》（国税发〔2006〕112号）两个配套文件的精神。笔者认为，试点工作实施以后，会很快在全国推广，因此，如何应对今后福利企业税收优惠政策改革，切实加强税收征管，提出几点粗浅看法。

房地产企业低值易耗品的摊销方法 房地产企业低值易耗品的摊销方法

　　房地产企业低值易耗品的摊销有两种方法：一次摊销法和五五摊销法，中华网校小编整理了该行业两种摊销方法的特点，如下所示：

　　为了核算低值易耗品成本和摊销情况，企业要设置“周转材料——低值易耗品”账户，该账户借方登记入库低值易耗品的实际成本，其贷方登记发出或摊销的低值易耗品的成本。其借方余额表示在库和在用的低值易耗品的实际成本。

电梯公司缴纳增值税还是营业税 电梯公司缴纳增值税还是营业税

　　【问题】

　　我公司是一家小规模电梯公司，以电梯的保养、安装及维修为主营业务，同时也代理销售电梯设备，我公司现保养、维修及销售都缴纳，可是客户要求我们提供服务业保养发票，我公司能否就保养及维修业务申领服务业发票？

　　【解答】

　　根据《国家总局关于电梯保养、维修收入征税问题》（国税函[1998]390号）的规定：“电梯属于增值税应税货物的范围，但安装运行之后，则与建筑物一道形成不动产。因此，对企业销售电梯（自产或购进的）并负责安装及保养、维修取得的收入，一并征收增值税；对不从事电梯生产、销售，只从事电梯保养和维修的专业公司对安装运行后的电梯进行的保养、维修取得的收入，征收营业税。”问题所述情形，您应缴纳增值税，并开具增值税发票，不能申领开具服务业发票。

用友外币明细账合计双倍外币明细账合计双倍

用友T3用友通该存货不存在或您没有权限 用友T3用友通该存货不存在或您没有权限

现在有个存货编码是1020的存货，在填调拨单的时候提示“该存货不存在或您没有权限”，换成帐套主管也不行，提示一样的。但是这个存货的现存量还有102个，足够调拨的，不知道是什么原因，做其他的单据是可以的！就这一个存货有问题，别的存货是没有问题的！你把1020拆的存货名称改了，只要别和存货档案中的所有存货编码一样就行，因为我们输入存货编码的时候，他会同检查存货编码和存货名称两项。如有其它问题，请联系在线客服咨询。用友云基地

用友U8 更改扣零设置工资表数据不正确用友U8 更改扣零设置工资表数据不正确 问题原因:操作使用问题 解决方法:更改扣零设置后，需重建工资表。否则工资表出错。
解决方案：
问题原因:操作使用问题 解决方法:更改扣零设置后，需重建工资表。否则工资表出错。

www.kuaiji66.com 天龙瑞德

委外入库单只有材料费没有加工费，生成凭证时已经勾选“已结算采购入库单自动选择全部结算单上单据(...)”这个选项，但是加工费还是为零，这是什么原因？ 委外入库单只有材料费没有加工费，生成凭证时已经勾选“已结算采购入库单自动选择全部结算单上单据(...)”这个选项，但是加工费还是为零，这是什么原因？

@畅捷服务丁红萍
您的关于加工费发票审核了吗

我发现之前有个成本（采购入库单）录错了，发票也已经生成了。这时我想做一张入库调整单把单价调一下，请问在入库调整单里的被调整单据号是入库单呢？还是发票呢？ 我发现之前有个成本（采购入库单）录错了，发票也已经生成了。这时我想做一张入库调整单把单价调一下，请问在入库调整单里的被调整单据号是入库单呢？还是发票呢？[]

只能调整结存金额的；要么就只能做红字冲，然后重做
调整结存金额的话，我的出入库的成本会变成正确的吗、
@以马内利yiu:不能调整，只能调整之后的结存成本的
那调整单上的被调整单据号的作用是什么
@以马内利yiu:那个作用不大，一般不用

企业官网域名注册需要什么资料？ 企业官网域名注册需要什么资料？''

会计继续教育，课件不计时怎么办 会计继续教育，课件不计时怎么办''

请教一下，应付票据与其他货币资金的区别，我单位自己在银行办理的承兑汇票是记到其他货币资金还是应付票据呢 请教一下，应付票据与其他货币资金的区别，我单位自己在银行办理的承兑汇票是记到其他货币资金还是应付票据呢[]

应付票据
1.银行存入银承保证金
借:其它货币资金
贷:银行存款
2.银承支付货款
借:应付账款
贷:应付票据
3.到期保证金转回
借:银行存款
贷:其它货币资金
借:应付票据
贷:银行存款

我前天抄税了，还能开这个月的收购票吗 我前天抄税了，还能开这个月的收购票吗[]

现在是月底，你就抄税了啊， 可以开
我这个月收购票没开够，又给点错了，抄税了
@大圣归来2016:大圣，用这个名字多长时间了？
@人生豪迈:一直啊

委外发票结算系统自动生成的出库调整单，记账时提示会造成负结存，不允许记账要怎么处理 委外发票结算系统自动生成的出库调整单，记账时提示会造成负结存，不允许记账要怎么处理[]

打开存货核算的明细账看一下结存金额还有多少了，若结存金额小于调整单上的金额就不能记账的。需要先把入库单记账，再记出库调整单。
是委外结算系统自动生成的入库调整单，这个是否可以不记账，并且手工删除
@服务社区赖海芳:是委外结算系统自动生成的入库调整单，这个是否可以不记账，并且手工删除
@夜凉如水1432531261:不能
@服务社区赖海芳:经过查找后发现是因为该调整单的仓库为半成品库，可是被调整存货的结存在临时借用库，可是该单据不允许修改仓库。要怎么修改
@服务社区赖海芳:是否可以把该单据删除后重新生成正确的调整单
@夜凉如水1432531261:可以对半成品库做一张入库调整单，入库调整单先记账出库调整单再记账。临时借用库的可以做出库调整单出掉，这样相当于调到半成品库了
@服务社区赖海芳:你看我理解的对不对，我需要把一部分金额从临时借用库调到半成品库，让系统的这张入库调整单能够记帐。金额从临时借用库调到半成品库的操作是：临时借用库入库调整单（负数），半成品库入库调整单（正数）。
@夜凉如水1432531261:对的
@服务社区赖海芳:明白了 谢谢您。
@夜凉如水1432531261:[/微笑]

用友在进行公式复制时经常性地出错并退出在进行公式复制时经常性地出错并退出