T3标准版10.81总账系统升级升级T+标准版12.0提示这个是啥意思？没有存货却提示存货不存在- T3标准版10.81总账系统升级升级T+标准版12.0提示这个是啥意思？没有存货却提示存货不存在?

优先升级到 10.8plus2 版本 升级
12.0也需要更新补丁。
最好全选复制或截图报错内容，展示问题详细。
@畅捷支持侯椿寳:原来账套有项目核算，提示的就是项目问题，难道有项目核算不能直接升级？
项目核算不支持升级。
T3的项目 跟T+的项目结构不相同。
@畅捷支持侯椿寳:不支持项目升级？[/衰]
是的。

请问易代账是怎么用的，我增加凭证时只能只借贷的其中一方输入金额，求指教 请问易代账是怎么用的，我增加凭证时只能只借贷的其中一方输入金额，求指教[]

截个图看看？
@二休哥:只能够在一方输入，输入另一方时已经输入的会变成零
@二休哥:师兄请帮我看下谢谢
你是手机记的吧？
这一栏块，就相当于是电脑网页上使用易代账时的一行分录，同一行分录借贷方肯定只能填一个
我以一个提现200举例，截图给你，你看看
第一个科目选择借方或贷方，下一个科目选择贷方或借方。手机要一个科目一个科目的输入

用友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 天龙瑞德

用友U8 插上加密盒后系统不能重新启动。联想启天M4700电脑.用友U8 插上加密盒后系统不能重新启动。联想启天M4700电脑. 问题原因:硬件兼容问题 解决方法:经过和联想总部的工程师联系,该问题估计是和硬件兼容性相关.先进行BIOS恢复默认设置,看一下加密狗是否好用。如果不好用就和联想的工程师联系，看是否有新的BIOS程序可以更新。如果更新bios后还是不行，就没有什么办法了。
解决方案：
问题原因:硬件兼容问题 解决方法:经过和联想总部的工程师联系,该问题估计是和硬件兼容性相关.先进行BIOS恢复默认设置,看一下加密狗是否好用。如果不好用就和联想的工程师联系，看是否有新的BIOS程序可以更新。如果更新bios后还是不行，就没有什么办法了。

www.kuaiji66.com 天龙瑞德

期初数据对帐不平 期初数据对帐不平

批次问题 _0批次问题

每次退出T1时间特别长要10分钟左右，有时还未响应，什么原因？ 每次退出T1时间特别长要10分钟左右，有时还未响应，什么原因？[]

将系统配置中软件退出自动进行备份选项取消试下时间是否会减短
@畅捷服务左美清:不自动备份秒退。。。但是还想开启退出自动备份
检查软件安装路径盘及C盘是否有足够的空间，或者帐套数据比较大，导致内存运行不过来
@畅捷服务左美清:系统工具里的系统整理是干什么呢？可以做么？
数据减压的，可以试下，一般这个减压不大

昨天杀过一次毒以后 现在不能打印单据 昨天杀过一次毒以后 现在不能打印单据[]

不能打印单据具体问题现象是什么呢？提示报错还是无反应呢？
没有反应
@钰彤山庄_風満樓:点击调研后倒三角，报表样式选择基本样式再打印看下是否正常呢
@服务社区李珊:也没反应
@钰彤山庄_風満樓:所有单据都是无反应吗？
@服务社区李珊: 是的
@钰彤山庄_風満樓:所有单据都不行的话，那么是您的程序问题了
您是否还有其他电脑安装了软件，有的话，将其他电脑上的安装路劲下客户端程序文件夹下的 rep report.ini和pos.ini复制到这台电脑上，也放在 安装路劲下客户端程序文件夹下。会提示您是否覆盖，您点击是。覆盖之后再重新运行软件看下
是在哪个文件里
@钰彤山庄_風満樓:上面我说的3个文件都需要复制到您的不正常电脑上去的。里面都是您的打印模板及模板设置信息的
rep 这个文件是空的啊 其他文件都有数据
@服务社区李珊:rep 这个文件是空的啊 其他文件都有数据
@钰彤山庄_風満樓:您现在电脑打印都不行，说明这个文件夹就是有问题的
所以您需要去可以正常打印的电脑上，将这些文件复制到这台不正常电脑上才可以的
@服务社区李珊: 我是从服务器主机上复制过来的
@钰彤山庄_風満樓:服务器可以正常打印的吗？不正常的复制过来是无效的

其他应收款的账务处理 其他应收款的账务处理

　　一、本科目核算企业除存出保证金、买入返售资产、应收票据、应收账款、预付账款、应收股利、应收利息、应收代位追偿款、应收分保账款、应收分保合同准备金、长期应收款等以外的其他各种应收及暂付款项。

　　二、本科目可按对方单位（或个人）进行明细核算。

　　三、采用售后回购方式融出资金的，应按实际支付的金额，借记本科目，贷记“存款”科目。销售价格与原购买价格之间的差额，应在售后回购期间内按期计提利息费用，借记本科目，贷记“财务费用”科目。按合同约定返售商品时，应按实际收到的金额，借记“银行存款”科目，贷记本科目。

用友数据输出到EXCEL后,其数据还是为字符型数据输出到EXCEL后,其数据还是为字符型

用友U8 进行年度结转时提示错误“结转上年出现错误，请检查上年数据无误后再执行本功能- 使用检查工具提示F_7有问题，但删除后再结转也不行，跟踪数据库没有找到是那条语句出错，检查了数据库中的相关的表没有发现其他问题用友U8 进行年度结转时提示错误“结转上年出现错误，请检查上年数据无误后再执行本功能" 使用检查工具提示F_7有问题，但删除后再结转也不行，跟踪数据库没有找到是那条语句出错，检查了数据库中的相关的表没有发现其他问题 问题原因:为数据错误。表wa_gztblset中缺少了id为7的记录，表wa_gzdata中多了列名为“F_8”的列。 解决方法:修改数据库（修改前请务必做好数据备份） 1、删除2006年度帐； 2、为2005年度帐的表wa_gztblset增加iGZItem_id为7的记录，属性参考演示帐套（需先取消主键索引，修改后再添上）； 3、为2005年度帐的表wa_gzdata删除列名为“F_8”的列； 4、重新新建2006年度帐，重新结转即可。 步骤2和3也可以在查询分析器中执行以下脚本（选择2005年度帐库）：set Identity_insert wa_GZtblset on INSERT INTO WA_GZtblset([iGZItem_id], [cSetGZItemName], [iSetGZItemStyle], [iSetGZItemLenth], [iDecimal], [iSetGZItemProp], [iGZNum]) VALUES(7, '计件工资', 0,10, 2, 0, 7) set Identity_insert wa_GZtblset off ALTER TABLE wa_GZDATA drop CONSTRAINT DF__wa_GZDATA__F_8__0D1C71D8 alter Table wa_GZDATA drop COLUMN F_8
解决方案：
问题原因:为数据错误。表wa_gztblset中缺少了id为7的记录，表wa_gzdata中多了列名为“F_8”的列。 解决方法:修改数据库（修改前请务必做好数据备份） 1、删除2006年度帐； 2、为2005年度帐的表wa_gztblset增加iGZItem_id为7的记录，属性参考演示帐套（需先取消主键索引，修改后再添上）； 3、为2005年度帐的表wa_gzdata删除列名为“F_8”的列； 4、重新新建2006年度帐，重新结转即可。 步骤2和3也可以在查询分析器中执行以下脚本（选择2005年度帐库）：set Identity_insert wa_GZtblset on INSERT INTO WA_GZtblset([iGZItem_id], [cSetGZItemName], [iSetGZItemStyle], [iSetGZItemLenth], [iDecimal], [iSetGZItemProp], [iGZNum]) VALUES(7, '计件工资', 0,10, 2, 0, 7) set Identity_insert wa_GZtblset off ALTER TABLE wa_GZDATA drop CONSTRAINT DF__wa_GZDATA__F_8__0D1C71D8 alter Table wa_GZDATA drop COLUMN F_8

单据中录入数量提示超出系统要求范围？ 单据中录入数量提示超出系统要求范围？

网购先赔打开后下订单没有保单？ 网购先赔打开后下订单没有保单？明明打开了360网购先赔也是使用的360浏览器，却没有任何保单显示，是为什么？

一般都是在后台默认的

这个是没有期限的啊，是从始至终不是客户下单到收到客户的好评这个时间段。也就是说如果一定订单产生以后系统都是默认您是完美订单，一但这个订单发生了以上那些加分扣分的情况，此订单才会相应的加分和扣分。

数据同步 报错如下图 怎么办？ _0数据同步 报错如下图 怎么办？

您到服务器上打上产品最新补丁，点击服务器电脑的开始菜单—所有程序—Ｔ＋—工具箱—T+服务管理器，打开之后全选服务重新启动。
然后清除缓存后重新登录。
@服务社区刘佳佳:好的，谢谢

四方财务软件中核算项目指什么 四方财务软件中核算项目指什么''

如何查国际注册内部审计师答案 如何查国际注册内部审计师答案''

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

小微型建筑安装公司，现在购买一批材料（电表箱）直接用到工程项目中，我手上已经有材料款的发票和银行付款单了，请问一下会计分录要怎么做呢？是不是：工程施工——材料费 贷：银行存款？ 还需要做其他分录么？ 我刚入行，新手 请教一下QAQ 小微型建筑安装公司，现在购买一批材料（电表箱）直接用到工程项目中，我手上已经有材料款的发票和银行付款单了，请问一下会计分录要怎么做呢？是不是：工程施工——材料费 贷：银行存款？ 还需要做其他分录么？ 我刚入行，新手 请教一下QAQ[]

不需要了，按照你写的就可以了，到月底再结转成本就可以了。

无法查询去年的单据，一点开去年的单据就提示“系统繁忙”是怎么回事？ 无法查询去年的单据，一点开去年的单据就提示“系统繁忙”是怎么回事？

您好，留下邮箱，我给您对应脚本您备份好数据之后，通过维护中心下的查询执行器执行下在查询看下
@服务社区李珊:[email protected]
@黄Nzi:邮件已发送，请查收！
@服务社区李珊:请问一下必须要在服务器上执行吗，在客户端上执行是否效果一样啊？
@黄Nzi:是的，一定要在数据库上执行才可以的。
@服务社区李珊:你好，执行了你发给我的脚本之后，虽然2015年的销售明细表能查到了，但是我2015年很多其它数据都查不到了，请问是怎么回事？
@黄Nzi:开始日期和结束日期分别输入 1999-01-01和 9999-01-01查询看下，其他条件君不要输入
@服务社区李珊:一样，还是没有任何数据显示，比如说“销售成本表”等，在执行脚本之前是可以查到相应数据的
@黄Nzi:好的，建议您联系经销商，将您执行脚本之前的备份数据再支持网 http://support.chanjet.com提交，有数据工程师帮您进一步检测修复下。

手工帐总帐年结图片

一、操作流程：
1、先做数据备份
2、新建年度帐
3、结转上年数据

二、具体步骤：
1、数据备份：
系统管理→系统→注册→用户名admin 密码为空→确定→账套→备份→选择要备份的账套→确定→选择备份路径→完成备份
2、新建年度帐（以2016年结转到2017年为例）：
系统管理-系统-注册-用户名是您自己的名字如demo密码demo-选择帐套001-年度2016-确定-年度帐-建立-2017年年度帐-确定-关闭系统管理
3、结转上年数据：
系统管理-系统-注册-用户名是您自己的名字如demo密码demo-选择帐套-年度2017-确定-年度帐--结转上年数据-总账系统结转-选择结转方式-明细方式-错误结转科目为0说明结转成功