我国实行税收国民待遇的现状 我国实行税收国民待遇的现状

　　从我国目前情况来看，是非税收国民待遇与超税收国民待遇并存。一方面进口产品和外资企业享受了许多国内企业所不能享受的税收优惠，另一方面，由于内外资企业所得税没有统一，外资企业享有优惠待遇的同时，也面临一些非国民待遇，如适用于内资企业的某些优惠政策外资企业却不能享受。 

　　(一)对外资企业和外籍个人的税收优惠政策 

　　改革开放以来，为了引进资金和先进技术，我国对外资企业和外籍个人实行了比内资企业和本国人要优惠很多的税收政策，实际上是一种超税收国民待遇。主要表现在如下几个方面： 

单位的车违章罚款怎么做帐？做营业外支出吧？ 单位的车违章罚款怎么做帐？做营业外支出吧？[]

是

用友U8 u8服务不能启动用友U8 u8服务不能启动 问题原因:客户操作系统是server2003，以前正常打上sp1补丁后出现问题 解决方法:852可能与server2003的sp1补丁存在冲突，导致服务不能启动。重新安装软件解决！
解决方案：
问题原因:客户操作系统是server2003，以前正常打上sp1补丁后出现问题 解决方法:852可能与server2003的sp1补丁存在冲突，导致服务不能启动。重新安装软件解决！

www.kuaiji66.com 天龙瑞德

用友U8 U821在数据精度定义中设置存货数量小数位为6位，销售系统中的委托代销统计表统计出来的发货数量、结算数量、结存数量虽显示为6位小数但全被四舍五入为4位有效位数，并且当选择了起始日期、结束日期与未选择时查询出来的结果不一致。用友U8 U821在数据精度定义中设置存货数量小数位为6位，销售系统中的委托代销统计表统计出来的发货数量、结算数量、结存数量虽显示为6位小数但全被四舍五入为4位有效位数，并且当选择了起始日期、结束日期与未选择时查询出来的结果不一致。 问题原因:Sa_MoveTrustDetail存储过程未考虑小数位数的问题，当查询条件不同时发货数量、结算数量、结存数量的字段有时被定义为Money型，有时被定义为Float型，当被定义为Money型时则查询结果的有效位数为4位，故有上述结果。 解决方法:修改Sa_MoveTrustDetail存储过程如下，即可解决问题：IF EXISTS (SELECT * FROM sysobjects WHERE name='Sa_MoveTrustDetail' and type='P')DROP PROCEDURE Sa_MoveTrustDetailGO/* 改正当数据精度设置中存货数量小数位大于4位时委托代销统计表 发货数量、结算数量、结存数量只显示4位的问题 2003.06.13 南京用友维护部 丁德安 */CREATE PROCEDURE Sa_MoveTrustDetail @chrTableName varchar(255) = null,@chrWhere1 varchar(255) = null,@chrStartDate varchar(30) = null,@chrEndDate varchar(30) = nullASdeclare @chrSQL varchar(4000)declare @chrWhere varchar(4000)/*取得超长参数方法*/if ltrim(rtrim(@chrWhere1)) = 'newReport_ParameterFromTempTable' begin--从临时表中取得超长参数 为了解决SQL SERVER 7.0 中的问题set @chrWhere = (select name from tempdb..newReportParameter )endelsebeginset @chrWhere = @chrWhere1 end/*取得需要处理的最小数据集合*//*取委托代销发货数据 */if exists(select name from tempdb..sysobjects where name='tmp_saletrust') drop table tempdb..tmp_saletrustset @chrSQL = 'Select ddate, autoid, iQuantity, iNum, iMoney, iTax, iSum, iDisCount,iNatMoney, iNatTax, iNatSum, iNatDisCountinto tempdb..tmp_saletrustfrom Endispatchs Inner join EndispatchOn EnDispatchs.EDID = Endispatch.EDID 'if ltrim(rtrim(@chrWhere)) = '' or @chrWhere is nullbegin/*设置日期条件 */if rtrim(ltrim(@chrEndDate)) <> '' and not (@chrEndDate is null)set @chrSQL = @chrSQL + 'Where ddate <= ''' + @chrEndDate + ''''endelse/* 设置其他条件 */beginset @chrSQL = @chrSQL + 'Where ' + @chrWhere/*设置日期条件 */if rtrim(ltrim(@chrEndDate)) <> '' and not (@chrEndDate is null)set @chrSQL = @chrSQL + ' and ddate <= ''' + @chrEndDate + ''''endexec (@chrSQL)/*取得委托结算数据*/if exists(select name from tempdb..sysobjects where name = 'tmp_resulttrust') drop table tempdb..tmp_resulttrustset @chrSQL = 'Select dDate, iCorID as autoid, iQuantity, iNum,iMoney, iTax, iSum, iDisCount,iNatMoney, iNatTax, iNatSum, iNatDisCountinto tempdb..tmp_resulttrustfrom Dispatchlistsinner join dispatchlist on Dispatchlists.dlid = Dispatchlist.dlidWhere Dispatchlist.cVouchtype = ''07'''if ltrim(rtrim(@chrWhere)) <> '' and not (@chrWhere is null)set @chrSQL = @chrSQL + ' and ' + @chrWhereif rtrim(ltrim(@chrEndDate)) <> '' and not (@chrEndDate is null)set @chrSQL = @chrSQL + ' and ddate <= ''' + @chrEndDate + ''''exec (@chrSQL)/*分析出委托代销期初，本期发货，本期结算和结存数据 *//*从临时表 tempdb..tmp_saletrust 取委托发货数据，从 tempdb..tmp_resulttrust 取结算数据*/if exists(select name from tempdb..sysobjects where name='tmp_trustDetail') drop table tempdb..tmp_trustDetail/*计算期初*/if ltrim(rtrim(@chrStartDate)) <> '' and not (@chrStartDate is null)begin/* 期初发货 */Select autoid, dDate,iQuantity as qc_iQuantity, iNum as qc_iNum, iMoney as qc_iMoney, iTax as qc_iTax,iSum as qc_iSum, iDiscount as qc_iDiscount, iNatMoney as qc_iNatMoney,iNatTax as qc_iNatTax, iNatSum as qc_iNatSum, iNatDiscount as qc_iNatDiscount,iQuantity - iQuantity as fh_iQuantity , iNum - iNum as fh_iNum, iMoney - iMoney as fh_iMoney, iTax - iTax as fh_iTax, iSum - iSum as fh_iSum, iDiscount - iDiscount as fh_iDiscount, iNatMoney - iNatMoney as fh_iNatMoney,iNatTax - iNatTax as fh_iNatTax, iNatSum - iNatSum as fh_iNatSum, iNatDiscount - iNatDiscount as fh_iNatDiscount,iQuantity - iQuantity as js_iQuantity, iNum - iNum as js_iNum , iMoney - iMoney as js_iMoney, iTax - iTax as js_iTax, iSum - iSum as js_iSum, iDiscount - iDiscount as js_iDiscount, iNatMoney - iNatMoney as js_iNatMoney,iNatTax - iNatTax as js_iNatTax, iNatSum - iNatSum as js_iNatSum, iNatDiscount - iNatDiscount as js_iNatDiscount,iQuantity - iQuantity as wj_iQuantity, iNum - iNum as wj_iNum, iMoney - iMoney as wj_iMoney, iTax - iTax as wj_iTax, iSum - iSum as wj_iSum, iDiscount - iDiscount as wj_iDiscount, iNatMoney - iNatMoney as wj_iNatMoney,iNatTax - iNatTax as wj_iNatTax, iNatSum - iNatSum as wj_iNatSum, iNatDiscount - iNatDiscount as wj_iNatDiscountinto tempdb..tmp_trustDetailfrom tempdb..tmp_saletrust where dDate < @chrStartDate/* 期初结算 */insert into tempdb..tmp_trustDetailSelect autoid, dDate,- iQuantity as qc_iQuantity, - iNum as qc_iNum, - iMoney as qc_iMoney, - iTax as qc_iTax, - iSum as qc_iSum, - iDiscount as qc_iDiscount, - iNatMoney as qc_iNatMoney,- iNatTax as qc_iNatTax, - iNatSum as qc_iNatSum, - iNatDiscount as qc_iNatDiscount,0 as fh_iQuantity, 0 as fh_iNum , 0 as fh_iMoney, 0 as fh_iTax, 0 as fh_iSum, 0 as fh_iDiscount , 0 as fh_iNatMoney,0 as fh_iNatTax, 0 as fh_iNatSum, 0 as fh_iNatDiscount,0 as js_iQuantity, 0 as js_iNum, 0 as js_iMoney, 0 as js_iTax, 0 as js_iSum, 0 as js_iDiscount, 0 as js_iNatMoney,0 as js_iNatTax, 0 as js_iNatSum, 0 as js_iNatDiscount,0 as wj_iQuantity, 0 as wj_iNum, 0 as wj_iMoney, 0 as wj_iTax, 0 as wj_iSum, 0 as wj_iDiscount, 0 as wj_iNatMoney,0 as wj_iNatTax, 0 as wj_iNatSum, 0 as wj_iNatDiscountfrom tempdb..tmp_resulttrust where dDate < @chrStartDateend /*计算本期发货 */ if ltrim(rtrim(@chrStartDate)) = '' or @chrStartDate is nullbegin/* 没有输入期初日期的情况 */Select autoid, dDate,iQuantity - iQuantity as qc_iQuantity, iNum - iNum as qc_iNum, iMoney - iMoney as qc_iMoney, iTax - iTax as qc_iTax,iSum - iSum as qc_iSum, iDiscount - iDiscount as qc_iDiscount, iNatMoney - iNatMoney as qc_iNatMoney,iNatTax - iNatTax as qc_iNatTax, iNatSum - iNatSum as qc_iNatSum, iNatDiscount - iNatDiscount as qc_iNatDiscount,iQuantity as fh_iQuantity, iNum as fh_iNum, iMoney as fh_iMoney, iTax as fh_iTax,iSum as fh_iSum, iDiscount as fh_iDiscount, iNatMoney as fh_iNatMoney,iNatTax as fh_iNatTax , iNatSum as fh_iNatSum , iNatDiscount as fh_iNatDiscount,iQuantity - iQuantity as js_iQuantity, iNum - iNum as js_iNum, iMoney - iMoney as js_iMoney, iTax - iTax as js_iTax,iSum - iSum as js_iSum, iDiscount - iDiscount as js_iDiscount, iNatMoney - iNatMoney as js_iNatMoney,iNatTax - iNatTax as js_iNatTax, iNatSum - iNatSum as js_iNatSum, iNatDiscount - iNatDiscount as js_iNatDiscount,iQuantity - iQuantity as wj_iQuantity, iNum - iNum as wj_iNum, iMoney - iMoney as wj_iMoney, iTax - iTax as wj_iTax,iSum - iSum as wj_iSum, iDiscount - iDiscount as wj_iDiscount, iNatMoney - iNatMoney as wj_iNatMoney,iNatTax - iNatTax as wj_iNatTax, iNatSum - iNatSum as wj_iNatSum, iNatDiscount - iNatDiscount as wj_iNatDiscountinto tempdb..tmp_trustDetail from tempdb..tmp_saletrustendelse begin/*有期初日期的情况 */insert into tempdb..tmp_trustDetailSelect autoid, dDate,0 as qc_iQuantity, 0 as qc_iNum, 0 as qc_iMoney, 0 as qc_iTax,0 as qc_iSum, 0 as qc_iDiscount, 0 as qc_iNatMoney,0 as qc_iNatTax, 0 as qc_iNatSum, 0 as qc_iNatDiscount,iQuantity as fh_iQuantity, iNum as fh_iNum, iMoney as fh_iMoney, iTax as fh_iTax,iSum as fh_iSum, iDiscount as fh_iDiscount, iNatMoney as fh_iNatMoney,iNatTax as fh_iNatTax, iNatSum as fh_iNatSum, iNatDiscount as fh_iNatDiscount,0 as js_iQuantity, 0 as js_iNum, 0 as js_iMoney, 0 as js_iTax,0 as js_iSum, 0 as js_iDiscount, 0 as js_iNatMoney,0 as js_iNatTax, 0 as js_iNatSum, 0 as js_iNatDiscount,0 as wj_iQuantity, 0 as wj_iNum, 0 as wj_iMoney, 0 as wj_iTax,0 as wj_iSum, 0 as wj_iDiscount, 0 as wj_iNatMoney,0 as wj_iNatTax, 0 as wj_iNatSum, 0 as wj_iNatDiscountfrom tempdb..tmp_saletrust where dDate >= @chrStartDateend /*计算本期结算 */if rtrim(ltrim(@chrStartDate)) = '' or @chrStartDate is nullbegin/*没有输入期初日期的情况 */insert into tempdb..tmp_trustDetailSelect autoid, dDate,0 as qc_iQuantity, 0 as qc_iNum, 0 as qc_iMoney, 0 as qc_iTax,0 as qc_iSum, 0 as qc_iDiscount, 0 as qc_iNatMoney,0 as qc_iNatTax, 0 as qc_iNatSum, 0 as qc_iNatDiscount,0 as fh_iQuantity, 0 as fh_iNum, 0 as fh_iMoney, 0 as fh_iTax,0 as fh_iSum, 0 as fh_iDiscount , 0 as fh_iNatMoney,0 as fh_iNatTax, 0 as fh_iNatSum, 0 as fh_iNatDiscount,iQuantity as js_iQuantity, iNum as js_iNum, iMoney as js_iMoney, iTax as js_iTax,iSum as js_iSum, iDiscount as js_iDiscount, iNatMoney as js_iNatMoney,iNatTax as js_iNatTax, iNatSum as js_iNatSum, iNatDiscount as js_iNatDiscount,0 as wj_iQuantity, 0 as wj_iNum, 0 as wj_iMoney, 0 as wj_iTax,0 as wj_iSum, 0 as wj_iDiscount, 0 as wj_iNatMoney,0 as wj_iNatTax, 0 as wj_iNatSum, 0 as wj_iNatDiscountfrom tempdb..tmp_resulttrustendelse/*输入期初日期的情况 */begininsert into tempdb..tmp_trustDetailSelect autoid, dDate,0 as qc_iQuantity, 0 as qc_iNum, 0 as qc_iMoney, 0 as qc_iTax,0 as qc_iSum, 0 as qc_iDiscount, 0 as qc_iNatMoney,0 as qc_iNatTax, 0 as qc_iNatSum, 0 as qc_iNatDiscount,0 as fh_iQuantity, 0 as fh_iNum, 0 as fh_iMoney, 0 as fh_iTax,0 as fh_iSum, 0 as fh_iDiscount, 0 as fh_iNatMoney,0 as fh_iNatTax, 0 as fh_iNatSum, 0 as fh_iNatDiscount,iQuantity as js_iQuantity, iNum as js_iNum, iMoney as js_iMoney, iTax as js_iTax,iSum as js_iSum, iDiscount as js_iDiscount, iNatMoney as js_iNatMoney,iNatTax as js_iNatTax, iNatSum as js_iNatSum, iNatDiscount as js_iNatDiscount,0 as wj_iQuantity, 0 as wj_iNum, 0 as wj_iMoney, 0 as wj_iTax,0 as wj_iSum, 0 as wj_iDiscount, 0 as wj_iNatMoney,0 as wj_iNatTax, 0 as wj_iNatSum, 0 as wj_iNatDiscountfrom tempdb..tmp_resulttrust where ddate >= @chrStartDateend/*组织最后的数据源临时表 *//*初始化临时表 */if exists(select name from tempdb..sysobjects where name = @chrTableName ) exec ('drop table tempdb..'+ @chrTableName)/*生成临时表 *//*数据源输出列：仓库， 销售类型， 部门，业务员，客户名称，存货名称，规格型号，主计量单位， 辅助计量单位，存货供应商，币种，客户自定义项（1-3），存货自定义项（1-3）单据体自定义项（1-6），单据头自定义项（1-10），期初（数量，件数，金额，税额，价税合计，折扣，本币金额，本币税额，本币价税合计，本币折扣）本期发货（数量，件数，金额，税额，价税合计，折扣，本币金额，本币税额，本币价税合计，本币折扣），本期结算（数量，件数，金额，税额，价税合计，折扣，本币金额，本币税额，本币价税合计，本币折扣），期末结存 （数量，件数，金额，税额，价税合计，折扣，本币金额，本币税额，本币价税合计，本币折扣）*/set @chrSQL = 'Select a.*, warehouse.cwhname,saletype.cstname, department.cDepname,person.cPersonname, customer.cCusname,customer.cCusDefine1, customer.cCusDefine2,customer.cCusDefine3, inventory.cinvName,inventory.cinvstd, inventory.cInvM_Unit,inventory.cInvA_Unit, vendor.cVenName,inventory.cInvDefine1, inventory.cInvDefine2,inventory.cInvDefine3, c.cexch_name,c.cDefine1, c.cDefine2, c.cDefine3, c.cDefine4, c.cDefine5,c.cDefine6, c.cDefine7, c.cDefine8, c.cDefine9, c.cDefine10,b.cDefine22, b.cDefine23, b.cDefine24,b.cDefine25, b.cDefine26, b.cDefine27into tempdb..'+ @chrTableName +'from tempdb..tmp_trustdetail ainner join endispatchs b on a.autoid = b.autoidinner join endispatch c on b.EDID = c.EDIDleft join inventory on b.cInvCode = inventory.cInvCodeleft join warehouse on b.cWhCode = warehouse.cWhcodeleft join department on c.cDepCode = department.cDepcodeleft join person on c.cPersoncode = person.cpersoncodeleft join customer on c.cCuscode = customer.cCuscodeleft join vendor on inventory.cVencode = vendor.cVencodeleft join saletype on c.cstcode = saletype.cstcode'exec (@chrSQL)GO
解决方案：
问题原因:Sa_MoveTrustDetail存储过程未考虑小数位数的问题，当查询条件不同时发货数量、结算数量、结存数量的字段有时被定义为Money型，有时被定义为Float型，当被定义为Money型时则查询结果的有效位数为4位，故有上述结果。 解决方法:修改Sa_MoveTrustDetail存储过程如下，即可解决问题：IF EXISTS (SELECT * FROM sysobjects WHERE name='Sa_MoveTrustDetail' and type='P')DROP PROCEDURE Sa_MoveTrustDetailGO/* 改正当数据精度设置中存货数量小数位大于4位时委托代销统计表 发货数量、结算数量、结存数量只显示4位的问题 2003.06.13 南京用友维护部 丁德安 */CREATE PROCEDURE Sa_MoveTrustDetail @chrTableName varchar(255) = null,@chrWhere1 varchar(255) = null,@chrStartDate varchar(30) = null,@chrEndDate varchar(30) = nullASdeclare @chrSQL varchar(4000)declare @chrWhere varchar(4000)/*取得超长参数方法*/if ltrim(rtrim(@chrWhere1)) = 'newReport_ParameterFromTempTable' begin--从临时表中取得超长参数 为了解决SQL SERVER 7.0 中的问题set @chrWhere = (select name from tempdb..newReportParameter )endelsebeginset @chrWhere = @chrWhere1 end/*取得需要处理的最小数据集合*//*取委托代销发货数据 */if exists(select name from tempdb..sysobjects where name='tmp_saletrust') drop table tempdb..tmp_saletrustset @chrSQL = 'Select ddate, autoid, iQuantity, iNum, iMoney, iTax, iSum, iDisCount,iNatMoney, iNatTax, iNatSum, iNatDisCountinto tempdb..tmp_saletrustfrom Endispatchs Inner join EndispatchOn EnDispatchs.EDID = Endispatch.EDID 'if ltrim(rtrim(@chrWhere)) = '' or @chrWhere is nullbegin/*设置日期条件 */if rtrim(ltrim(@chrEndDate)) <> '' and not (@chrEndDate is null)set @chrSQL = @chrSQL + 'Where ddate <= ''' + @chrEndDate + ''''endelse/* 设置其他条件 */beginset @chrSQL = @chrSQL + 'Where ' + @chrWhere/*设置日期条件 */if rtrim(ltrim(@chrEndDate)) <> '' and not (@chrEndDate is null)set @chrSQL = @chrSQL + ' and ddate <= ''' + @chrEndDate + ''''endexec (@chrSQL)/*取得委托结算数据*/if exists(select name from tempdb..sysobjects where name = 'tmp_resulttrust') drop table tempdb..tmp_resulttrustset @chrSQL = 'Select dDate, iCorID as autoid, iQuantity, iNum,iMoney, iTax, iSum, iDisCount,iNatMoney, iNatTax, iNatSum, iNatDisCountinto tempdb..tmp_resulttrustfrom Dispatchlistsinner join dispatchlist on Dispatchlists.dlid = Dispatchlist.dlidWhere Dispatchlist.cVouchtype = ''07'''if ltrim(rtrim(@chrWhere)) <> '' and not (@chrWhere is null)set @chrSQL = @chrSQL + ' and ' + @chrWhereif rtrim(ltrim(@chrEndDate)) <> '' and not (@chrEndDate is null)set @chrSQL = @chrSQL + ' and ddate <= ''' + @chrEndDate + ''''exec (@chrSQL)/*分析出委托代销期初，本期发货，本期结算和结存数据 *//*从临时表 tempdb..tmp_saletrust 取委托发货数据，从 tempdb..tmp_resulttrust 取结算数据*/if exists(select name from tempdb..sysobjects where name='tmp_trustDetail') drop table tempdb..tmp_trustDetail/*计算期初*/if ltrim(rtrim(@chrStartDate)) <> '' and not (@chrStartDate is null)begin/* 期初发货 */Select autoid, dDate,iQuantity as qc_iQuantity, iNum as qc_iNum, iMoney as qc_iMoney, iTax as qc_iTax,iSum as qc_iSum, iDiscount as qc_iDiscount, iNatMoney as qc_iNatMoney,iNatTax as qc_iNatTax, iNatSum as qc_iNatSum, iNatDiscount as qc_iNatDiscount,iQuantity - iQuantity as fh_iQuantity , iNum - iNum as fh_iNum, iMoney - iMoney as fh_iMoney, iTax - iTax as fh_iTax, iSum - iSum as fh_iSum, iDiscount - iDiscount as fh_iDiscount, iNatMoney - iNatMoney as fh_iNatMoney,iNatTax - iNatTax as fh_iNatTax, iNatSum - iNatSum as fh_iNatSum, iNatDiscount - iNatDiscount as fh_iNatDiscount,iQuantity - iQuantity as js_iQuantity, iNum - iNum as js_iNum , iMoney - iMoney as js_iMoney, iTax - iTax as js_iTax, iSum - iSum as js_iSum, iDiscount - iDiscount as js_iDiscount, iNatMoney - iNatMoney as js_iNatMoney,iNatTax - iNatTax as js_iNatTax, iNatSum - iNatSum as js_iNatSum, iNatDiscount - iNatDiscount as js_iNatDiscount,iQuantity - iQuantity as wj_iQuantity, iNum - iNum as wj_iNum, iMoney - iMoney as wj_iMoney, iTax - iTax as wj_iTax, iSum - iSum as wj_iSum, iDiscount - iDiscount as wj_iDiscount, iNatMoney - iNatMoney as wj_iNatMoney,iNatTax - iNatTax as wj_iNatTax, iNatSum - iNatSum as wj_iNatSum, iNatDiscount - iNatDiscount as wj_iNatDiscountinto tempdb..tmp_trustDetailfrom tempdb..tmp_saletrust where dDate < @chrStartDate/* 期初结算 */insert into tempdb..tmp_trustDetailSelect autoid, dDate,- iQuantity as qc_iQuantity, - iNum as qc_iNum, - iMoney as qc_iMoney, - iTax as qc_iTax, - iSum as qc_iSum, - iDiscount as qc_iDiscount, - iNatMoney as qc_iNatMoney,- iNatTax as qc_iNatTax, - iNatSum as qc_iNatSum, - iNatDiscount as qc_iNatDiscount,0 as fh_iQuantity, 0 as fh_iNum , 0 as fh_iMoney, 0 as fh_iTax, 0 as fh_iSum, 0 as fh_iDiscount , 0 as fh_iNatMoney,0 as fh_iNatTax, 0 as fh_iNatSum, 0 as fh_iNatDiscount,0 as js_iQuantity, 0 as js_iNum, 0 as js_iMoney, 0 as js_iTax, 0 as js_iSum, 0 as js_iDiscount, 0 as js_iNatMoney,0 as js_iNatTax, 0 as js_iNatSum, 0 as js_iNatDiscount,0 as wj_iQuantity, 0 as wj_iNum, 0 as wj_iMoney, 0 as wj_iTax, 0 as wj_iSum, 0 as wj_iDiscount, 0 as wj_iNatMoney,0 as wj_iNatTax, 0 as wj_iNatSum, 0 as wj_iNatDiscountfrom tempdb..tmp_resulttrust where dDate < @chrStartDateend /*计算本期发货 */ if ltrim(rtrim(@chrStartDate)) = '' or @chrStartDate is nullbegin/* 没有输入期初日期的情况 */Select autoid, dDate,iQuantity - iQuantity as qc_iQuantity, iNum - iNum as qc_iNum, iMoney - iMoney as qc_iMoney, iTax - iTax as qc_iTax,iSum - iSum as qc_iSum, iDiscount - iDiscount as qc_iDiscount, iNatMoney - iNatMoney as qc_iNatMoney,iNatTax - iNatTax as qc_iNatTax, iNatSum - iNatSum as qc_iNatSum, iNatDiscount - iNatDiscount as qc_iNatDiscount,iQuantity as fh_iQuantity, iNum as fh_iNum, iMoney as fh_iMoney, iTax as fh_iTax,iSum as fh_iSum, iDiscount as fh_iDiscount, iNatMoney as fh_iNatMoney,iNatTax as fh_iNatTax , iNatSum as fh_iNatSum , iNatDiscount as fh_iNatDiscount,iQuantity - iQuantity as js_iQuantity, iNum - iNum as js_iNum, iMoney - iMoney as js_iMoney, iTax - iTax as js_iTax,iSum - iSum as js_iSum, iDiscount - iDiscount as js_iDiscount, iNatMoney - iNatMoney as js_iNatMoney,iNatTax - iNatTax as js_iNatTax, iNatSum - iNatSum as js_iNatSum, iNatDiscount - iNatDiscount as js_iNatDiscount,iQuantity - iQuantity as wj_iQuantity, iNum - iNum as wj_iNum, iMoney - iMoney as wj_iMoney, iTax - iTax as wj_iTax,iSum - iSum as wj_iSum, iDiscount - iDiscount as wj_iDiscount, iNatMoney - iNatMoney as wj_iNatMoney,iNatTax - iNatTax as wj_iNatTax, iNatSum - iNatSum as wj_iNatSum, iNatDiscount - iNatDiscount as wj_iNatDiscountinto tempdb..tmp_trustDetail from tempdb..tmp_saletrustendelse begin/*有期初日期的情况 */insert into tempdb..tmp_trustDetailSelect autoid, dDate,0 as qc_iQuantity, 0 as qc_iNum, 0 as qc_iMoney, 0 as qc_iTax,0 as qc_iSum, 0 as qc_iDiscount, 0 as qc_iNatMoney,0 as qc_iNatTax, 0 as qc_iNatSum, 0 as qc_iNatDiscount,iQuantity as fh_iQuantity, iNum as fh_iNum, iMoney as fh_iMoney, iTax as fh_iTax,iSum as fh_iSum, iDiscount as fh_iDiscount, iNatMoney as fh_iNatMoney,iNatTax as fh_iNatTax, iNatSum as fh_iNatSum, iNatDiscount as fh_iNatDiscount,0 as js_iQuantity, 0 as js_iNum, 0 as js_iMoney, 0 as js_iTax,0 as js_iSum, 0 as js_iDiscount, 0 as js_iNatMoney,0 as js_iNatTax, 0 as js_iNatSum, 0 as js_iNatDiscount,0 as wj_iQuantity, 0 as wj_iNum, 0 as wj_iMoney, 0 as wj_iTax,0 as wj_iSum, 0 as wj_iDiscount, 0 as wj_iNatMoney,0 as wj_iNatTax, 0 as wj_iNatSum, 0 as wj_iNatDiscountfrom tempdb..tmp_saletrust where dDate >= @chrStartDateend /*计算本期结算 */if rtrim(ltrim(@chrStartDate)) = '' or @chrStartDate is nullbegin/*没有输入期初日期的情况 */insert into tempdb..tmp_trustDetailSelect autoid, dDate,0 as qc_iQuantity, 0 as qc_iNum, 0 as qc_iMoney, 0 as qc_iTax,0 as qc_iSum, 0 as qc_iDiscount, 0 as qc_iNatMoney,0 as qc_iNatTax, 0 as qc_iNatSum, 0 as qc_iNatDiscount,0 as fh_iQuantity, 0 as fh_iNum, 0 as fh_iMoney, 0 as fh_iTax,0 as fh_iSum, 0 as fh_iDiscount , 0 as fh_iNatMoney,0 as fh_iNatTax, 0 as fh_iNatSum, 0 as fh_iNatDiscount,iQuantity as js_iQuantity, iNum as js_iNum, iMoney as js_iMoney, iTax as js_iTax,iSum as js_iSum, iDiscount as js_iDiscount, iNatMoney as js_iNatMoney,iNatTax as js_iNatTax, iNatSum as js_iNatSum, iNatDiscount as js_iNatDiscount,0 as wj_iQuantity, 0 as wj_iNum, 0 as wj_iMoney, 0 as wj_iTax,0 as wj_iSum, 0 as wj_iDiscount, 0 as wj_iNatMoney,0 as wj_iNatTax, 0 as wj_iNatSum, 0 as wj_iNatDiscountfrom tempdb..tmp_resulttrustendelse/*输入期初日期的情况 */begininsert into tempdb..tmp_trustDetailSelect autoid, dDate,0 as qc_iQuantity, 0 as qc_iNum, 0 as qc_iMoney, 0 as qc_iTax,0 as qc_iSum, 0 as qc_iDiscount, 0 as qc_iNatMoney,0 as qc_iNatTax, 0 as qc_iNatSum, 0 as qc_iNatDiscount,0 as fh_iQuantity, 0 as fh_iNum, 0 as fh_iMoney, 0 as fh_iTax,0 as fh_iSum, 0 as fh_iDiscount, 0 as fh_iNatMoney,0 as fh_iNatTax, 0 as fh_iNatSum, 0 as fh_iNatDiscount,iQuantity as js_iQuantity, iNum as js_iNum, iMoney as js_iMoney, iTax as js_iTax,iSum as js_iSum, iDiscount as js_iDiscount, iNatMoney as js_iNatMoney,iNatTax as js_iNatTax, iNatSum as js_iNatSum, iNatDiscount as js_iNatDiscount,0 as wj_iQuantity, 0 as wj_iNum, 0 as wj_iMoney, 0 as wj_iTax,0 as wj_iSum, 0 as wj_iDiscount, 0 as wj_iNatMoney,0 as wj_iNatTax, 0 as wj_iNatSum, 0 as wj_iNatDiscountfrom tempdb..tmp_resulttrust where ddate >= @chrStartDateend/*组织最后的数据源临时表 *//*初始化临时表 */if exists(select name from tempdb..sysobjects where name = @chrTableName ) exec ('drop table tempdb..'+ @chrTableName)/*生成临时表 *//*数据源输出列：仓库， 销售类型， 部门，业务员，客户名称，存货名称，规格型号，主计量单位， 辅助计量单位，存货供应商，币种，客户自定义项（1-3），存货自定义项（1-3）单据体自定义项（1-6），单据头自定义项（1-10），期初（数量，件数，金额，税额，价税合计，折扣，本币金额，本币税额，本币价税合计，本币折扣）本期发货（数量，件数，金额，税额，价税合计，折扣，本币金额，本币税额，本币价税合计，本币折扣），本期结算（数量，件数，金额，税额，价税合计，折扣，本币金额，本币税额，本币价税合计，本币折扣），期末结存 （数量，件数，金额，税额，价税合计，折扣，本币金额，本币税额，本币价税合计，本币折扣）*/set @chrSQL = 'Select a.*, warehouse.cwhname,saletype.cstname, department.cDepname,person.cPersonname, customer.cCusname,customer.cCusDefine1, customer.cCusDefine2,customer.cCusDefine3, inventory.cinvName,inventory.cinvstd, inventory.cInvM_Unit,inventory.cInvA_Unit, vendor.cVenName,inventory.cInvDefine1, inventory.cInvDefine2,inventory.cInvDefine3, c.cexch_name,c.cDefine1, c.cDefine2, c.cDefine3, c.cDefine4, c.cDefine5,c.cDefine6, c.cDefine7, c.cDefine8, c.cDefine9, c.cDefine10,b.cDefine22, b.cDefine23, b.cDefine24,b.cDefine25, b.cDefine26, b.cDefine27into tempdb..'+ @chrTableName +'from tempdb..tmp_trustdetail ainner join endispatchs b on a.autoid = b.autoidinner join endispatch c on b.EDID = c.EDIDleft join inventory on b.cInvCode = inventory.cInvCodeleft join warehouse on b.cWhCode = warehouse.cWhcodeleft join department on c.cDepCode = department.cDepcodeleft join person on c.cPersoncode = person.cpersoncodeleft join customer on c.cCuscode = customer.cCuscodeleft join vendor on inventory.cVencode = vendor.cVencodeleft join saletype on c.cstcode = saletype.cstcode'exec (@chrSQL)GO

www.kuaiji66.com 天龙瑞德

办理首套房商业贷款买房贷款需多长时间？我是今年1月8号办理的贷款，农行的，说是要等银行电话。这对吗？ 办理首套房商业贷款买房贷款需多长时间？我是今年1月8号办理的贷款，农行的，说是要等银行电话。这对吗？

期初同步 _0期初同步

调整库存数，根据发货单生成的发票不能弃审 调整库存数，根据发货单生成的发票不能弃审

分支机构注销增值税留抵额能否扣除 分支机构注销增值税留抵额能否扣除

　　【问题】

　　分支机构注销，其留抵额能否税前扣除？

　　【解答】

　　《部 国家总局关于增值税若干政策的通知》（财税〔2005〕165号）第六条规定，一般人注销或被取消辅导期一般纳税人资格，转为小规模纳税人时，存货不作进项税额转出处理，其留抵税额也不予退税。

企业出售旧房如何计算土地增值税 企业出售旧房如何计算土地增值税

　　例：某工业企业转让一幢90年代建造的厂房，当时造价100万元，无偿取得土地使用权。如果按现行市场价的材料、人工费计算，建造同样的房子需600万元，该房子为7成新，按500万元出售，支付有关税费计27.5万元。计算企业转让旧房应缴纳的土地增值税额。

　　（1）评估价格＝600×70％＝420（万元）

　　（2）允许扣除的税金27.5万元

　　（3）扣除项目金额合计＝420＋27.5＝447.5（万元）

发出商品记账成本不对 发出商品记账成本不对

用友U8 821产品，增加各种出入库单据，单据表体最下面的合计栏目没有，合计两个字也没有，数据也没有。是不是有哪个模版出了问题？用友U8 821产品，增加各种出入库单据，单据表体最下面的合计栏目没有，合计两个字也没有，数据也没有。是不是有哪个模版出了问题？ 问题原因:应是InvoiceItem_库存单据项目定义表有错误。解决方法:对比演示帐套或以前正确帐套的备份的InvoiceItem_表进行修改。
解决方案：
问题原因:应是InvoiceItem_库存单据项目定义表有错误。解决方法:对比演示帐套或以前正确帐套的备份的InvoiceItem_表进行修改。

www.kuaiji66.com 天龙瑞德

单位将公有住房出售给职工是否缴纳营业税 单位将公有住房出售给职工是否缴纳营业税

问：我们是北京市一家中型国有企业，今年底单位计划将公有住房向本企业职工出售，请问取得的收入是否需要缴纳营业税？有无相关文件规定？

　　答：根据《北京市财政局 北京市地方税务局转发财政部、国家税务总局关于调整房地产市场税收政策的通知》（京财税[1999]1201号），和《北京市地方税务局关于进一步加强北京市房地产市场营业税优惠政策执行管理工作的通知》（京地税营[2002]311号）规定：为支持住房制度的改革，对企业、行政事业单位按房改成本价、标准价出售住房的收入，暂免征收营业税。

T+和T6安装在同一台机器里，win7旗舰版32位的，要打什么补丁才可以？ T+和T6安装在同一台机器里，win7旗舰版32位的，要打什么补丁才可以？[]

亲，可以装在一台电脑上，打上软件的最新补丁
@畅捷服务张小翠:T6-企业管理软件V6.5补丁包、、、、是这个吗？是先安装T+还是先按T6？还是都可以、、、、、、
都可以！亲
打完补丁还是提醒要打数据库补丁SP2
那你数据库要打补丁
就是不知道怎么打数据库补丁？？？求助[/流泪]
装好数据库后就打数据库补丁！然后装软件，装软件前有个环境检测

mrp运算没有结果mrp运算没有结果

浪潮云服务目前已取得哪些资格认证？ 浪潮云服务目前已取得哪些资格认证？''

万能会员卡消费管理系统能怎样用啊 万能会员卡消费管理系统能怎样用啊''

保存的报表模版打不开？ 保存的报表模版打不开？

咨询大家一个问题，建安现在在国税办外经证，在国税开票，那是不是工程项目完之后还得在国税报验，还是每个月要去公司所在地的国税报验， 咨询大家一个问题，建安现在在国税办外经证，在国税开票，那是不是工程项目完之后还得在国税报验，还是每个月要去公司所在地的国税报验，[]

现在可以自开票，在劳务发生地预缴税款，回机构所在地申报纳税，不需要报验了
@风之幽灵:我们是小规模的，在劳务发生地交了国地税，

T1中的函数sum，参数怎么设置的，代表什么含义 T1中的函数sum，参数怎么设置的，代表什么含义

上面不知道怎么填写
您好，先测试下，稍后给您答复。
我开始打了你们服务电话，说可能是识别码过期了，我不知道怎么弄。
您好，此公式是合计值，软件中计算合计可以直接通过合计进行计算，您具体是要计算什么字段相加，我们将公式设计好的公式给您发送过去。
麻烦可以快的吗，软件打不开，生意无法做了。谢谢
@宋先生a2i:若是软件打不开，具体是提示什么报错呢？
点下一步时跳出：服务器连接失败，请重新确认
@宋先生a2i:插了加密狗的服务器电脑是否可以正常登录进去呢？
点确定以后又跳出：网络连接不稳定，请重新登录软件
@宋先生a2i:请先回复我：插了加密狗的服务器电脑是否可以正常登录进去呢？
加密狗尝试插了几次还不行
软件一直打不开
@宋先生a2i:您先看下您电脑右下角是否有套接字服务器，如下图，有的话，双击打开看下左上角的端口号是不是211，除了211还有其他的吗？
您也可以参考知识库的服务器连接失败的解决方法：http://service.chanjet.com/zhi ... 7b4d1
没有
是211，没有别的
@宋先生a2i:若是电脑右下角有该图标，端口也没有问题的话，您注册下软件安装路径下客户端程序文件夹中的空间 midas.dll。注册方法是：开始--运行--regsvr32空格+文件具体路径，例如：regsvr32 D:\用友T1-商贸宝批发零售版\客户端程序\midas.dl
@服务社区李珊:你把那个公式给我编一个我自己看看
@通友公司技术9:请稍等
不知道怎么操作
@宋先生a2i:您具体是哪里不知道怎么操作呢？
@服务社区李珊:公式给我随便编个，比如数量合计的的，我自己研究
@服务社区李珊:公式编没有啊，我提的问题，怎么在这里发的都是其他的
@通友公司技术9:还在测试中，请稍等下。[/微笑]

残疾人就业保障金和水利建设基金 计提和支付怎么账务处理？ 残疾人就业保障金和水利建设基金 计提和支付怎么账务处理？[]

1、残疾人保障金不用预先计提，在实际支付时
借：应付职工薪酬-残疾人保障金
贷：银行存款
计提
借：管理费用-残疾人保障金
贷：应付职工薪酬-残疾人保障金
2、执行《小企业会计准则》计提水利建设基金时
借：营业税金及附加- 水利建设基金
贷：应交税费-应交水利建设基金
缴纳水利建设基金时：
借：应交税费-应交水利建设基金
贷：银行存款
@清茶:残疾人保障金和残疾人就业保障金是一回事吗，不需要通过应交税费吗
@木头NZj:是一回事，这个不属于税费，不需要通过应交税费科目
@清茶:谢谢 可以直接在支付的时候借管理费用贷银行存款吗
@木头NZj:准则要求通过应付职工薪酬支付
@清茶:好的
@清茶:为啥我们的残疾人就业保障金直接记的营业外支出。。。。。
@清茶:清茶，请问残疾人就业保障金通过应付职工薪酬 有文件查吗 因为刚刚你们同事说通过应交税费 谢谢
@木头NZj:我们这里缴纳残疾人保障金、欠薪保障金都是通过社会保障缴费专户扣款的，所以我们一直是把它归类于社会保障缴费的，所以是通过应付职工薪酬科目的。
@清茶:我们这是地税管的
@木头NZj:说明各地有差异
@清茶:恩恩好的