用友U8 局域网,服务器server2000,在进入报表时,只能登陆到选择操作员界面,然后就一点反映也没有.在之前服务器没出问题时都正常,而且在客户端报表使用都正常.服务器是重做的系统.
2019-4-5 8:0:0 用友NC小编用友U8 局域网,服务器server2000,在进入报表时,只能登陆到选择操作员界面,然后就一点反映也没有.在之前服务器没出问题时都正常,而且在客户端报表使用都正常.服务器是重做的系统.
用友U8 局域网,服务器server2000,在进入报表时,只能登陆到选择操作员界面,然后就一点反映也没有.在之前服务器没出问题时都正常,而且在客户端报表使用都正常.服务器是重做的系统. 问题原因:环境问题 解决方法:1.请进行远程配置;2.删除服务器上的ufow.ini文件;3.控制面板-->区域选项-->短日期格式改为yyyy-mm-dd4.若有金山毒霸,请卸载,改用别的杀毒软件。解决方案:
问题原因:环境问题 解决方法:1.请进行远程配置;2.删除服务器上的ufow.ini文件;3.控制面板-->区域选项-->短日期格式改为yyyy-mm-dd4.若有金山毒霸,请卸载,改用别的杀毒软件。
www.kuaiji66.com 天龙瑞德
如果您的问题还没有解决,可以到 T+搜索>>上找一下
相关阅读
- 用友U8 客户客户端在考勤管理在设定休息日后,排班的时候不能跳过周六周日,同时客户设定的休息日无法在本月查询。同时无任何报错提示.只能通过 跨年度才能查询.2019-4-5 8:0:0
- 用友U8 存货期未处理时提示错误信息:类型不相符2019-4-5 8:0:0
- 用友U8 年中启用,录入期初发现没有累计借和累计贷2019-4-5 8:0:0
- 用友U8 库存期初从存货期初取数时提示与recorder约束冲突,取数失败2019-4-5 8:0:0
- 用友同一张UFO报表拷到另外一台机器上,打开后数据不同2019-4-5 8:0:0
- 用友填制凭证时报运行时错误“5”等错误2019-4-5 8:0:0
- 用友填制凭证时提示‘tempdb无效,未指定表名’2019-4-5 8:0:0
- 登录固定资产时提示“登录日期:2005-8-1不属于最新更改月份:2005.1月”2019-4-5 8:0:0
- 用友U8 安装了851软件后登陆软件看不到各种菜单,重装软件也不行2019-4-5 8:0:0
- 单据修改时,提示:单据保存失败,无法将CHAR值转换为MONEY2019-4-5 8:0:0
最新信息
- 你好老师,我这有个客户用的T3标准版10.8plus1,客户端安装好后,能连接到服务器,但是一点击核算管理,就提示子系统注册失败,请问是怎么回事
- 你好,我T+快速计提报错241,根据服务社区的文档改了之后点击固定资产就报错英文了,什么问题哦?
- 你好,我使用的是T+12.0的普及版,重装电脑系统后重装软件,登录帐套后查询应收总账提示如下图,打上最新补丁后还是提示这个错误,请问怎么解决,谢谢
- 老师,请问出现下面的重影现象怎么办?
- 老师:您好,T3登陆不进去,系统管理提示这个错误,咋解决呢
- 请问一下,现金银行统计累计数和明细合计累计数不一样,这个要怎么处理
- 我重做系统,重装了T3,win732位,现在打开T3,点总账系统,如图1,点一下,出图2,这是神么原因
- 登录 后提示这个是为什么?
- 241数据库错误,什么原因,数据库可以联通
- G3帐务管理系统 进入总帐系统时出现如下错误,怎么处理?
客户使用模块有销售和应收等,由于行业性质原因,客户想在软件上发货即开票形成虚拟应收账款,交纳税费想以收款为依据。(因为他们现在正常的流程在金税系统上开票即收款),前面软件上的虚拟发票不做为交税依据,请问这种情况有什么办法能够解决?一是要发货即生成销售发票,体现应收款,二是应收款不做交税依据,交税以收款为依据!! 直接在销售管理做完发货单就生成发票即可,交税和收款没有联系。@服务社区_郝瑞然_:做完发票生成应收,凭证为:借:应收账款 ;借应交税金,贷:主营业务收入,这个就体现要交税了啊
这个税就一直挂着不交,税务上也说不过去啊!想问的是怎么能形成应收账款的同时,税务体现也能说得过去@廖斌iUR: 你发货单生成发票之后在应收款管理审核下就形成应收账款,应收账款生成凭证的时候是带税的,需要你在应收管理中设置存货对方科目@服务社区_郝瑞然_:你的意思是用中转科目,然后收款的时候再形成交税,那主营业务收入这个科目,又用那个科目来代替呢?
- 用友U8 “机器考勤数据符合要求的格式:考勤卡号+分隔符号+刷卡日期+分隔符号+刷卡时间;分隔符号:空格;刷卡日期格式:YYYY-MM-DD ;刷卡时间格式:HH24-MM-SS”这句话是考勤管理帮助中的,我反复看也没看懂,请举个例子详细说明一下。现用户要求刷卡机的考勤数据导入考勤管理中。
- 用友U8 升级报日期错,显示日期格式不对!
- 用友U8 在增加发货单界面不能查询以前录入的单据,复制功能也不能使用
- 用友U8 在存货核算中,进行各种单据修改时,提示:单据保存失败,无法将CHAR值转换为MONEY,该CHAR值的语法有误,修改单据失败!该问题在所有的机器上都存在。
- 用友U8 安装了851软件后登陆软件看不到各种菜单,重装软件也不行
- 用友U8 年中启用,录入期初发现没有累计借和累计贷
- 用友U8 库存期初从存货期初取数时提示与recorder约束冲突,取数失败
- 用友U8 库存管理期初从存货中取数,在保存的时候报 datetime 错误,保存失败
- 用友U8 注册UFO时,提示-账套-年度错误-
- 用友U8 环境有问题
用友U8 U8销售系统发货结算勾对表当以不同的时段查询时,有时能查到数据,有时则不能。用友U8 U8销售系统发货结算勾对表当以不同的时段查询时,有时能查到数据,有时则不能。
问题原因:用户有退补业务,因退补业务不减实际库存,当退货单保存时,数量不写入DispatchLists的iQuantity字段而是写入TBQuantity字段,iQuantity字段值为0,查询发货结算勾对表时,当查询时段包含了退补业务时,Sa_MoveOutIncome存储过程产生除0错误而查询不到数据,当查询时段不包含退补业务时则正常。 解决方法:此为Sa_MoveOutIncome存储过程未考虑到退补业务的特殊性而产生的错误,修改Sa_MoveOutIncome如下即可解决问题:/* 版本:U821 当有退补业务时发货结算勾对表查询无数据 江苏省药材公司 2003.06.27 当发货单关闭时发货结算勾对表未结数量为0 而当退货单关闭时发货结算勾对表未结数量为退货数量 江苏省中医药科技发展总公司 2003.07.18 南京用友维护部 丁德安 与U821年结补丁: 821发货结算钩对表补丁(修改上年发货数据没有减问题).sql 相结合 2004.1.31 南京用友维护部 丁德安*/CREATE 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,TBQuantity --2003.09.03 再增加一字段TBNum --南京用友维护部 丁德安 --根据补丁增加字段ijcQuantityset @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.TBNum as TBNum ,Dispatchlists.iUnitPrice ,isnull(iquantity,0)-isnull(iquantity,0) as ijcQuantity 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 )-------------------------------------------------------------------------------------------------------------期初发货单去掉上年已经结算的数据 (补丁)set @chrsql ='update tempdb..po_DispatchFirst set ijcQuantity= isnull( iSettleQuantity,0)-isnull ( (select sum(iQuantity) from Salebillvouchs inner join salebillvouchon salebillvouchs.sbvid = salebillvouch.sbvid where salebillvouchs.idlsid =tempdb..po_DispatchFirst.idlsid and isnull(Salebillvouch.cInvalider,'''')='''' ) ,0) where tempdb..po_DispatchFirst.bfirst =1 ' exec(@chrsql)--by zzgset @chrsql ='update tempdb..po_DispatchFirst set ijcQuantity= iQuantity where iQuantity *( iQuantity - ijcQuantity)<0'-- 2004.3.5 -- 南京用友维护部 -- 南京蓝光燃气 -- 当期初发货单的结算数量>发货数量时数据不显示,故注释掉下行语句--exec(@chrsql)--by zzgset @chrsql ='update tempdb..po_DispatchFirst set iQuantity = iQuantity - ijcQuantity ,iNum = convert(decimal(20,2),iNum * (iQuantity - ijcQuantity ) / iQuantity) , iMoney = convert(decimal(20,2),iMoney * (iQuantity - ijcQuantity ) / iQuantity) , iTax = convert(decimal(20,2),iTax * (iQuantity - ijcQuantity ) / iQuantity) , iSum = convert(decimal(20,2),iMoney * (iQuantity - ijcQuantity ) / iQuantity)+convert(decimal(20,2),iTax * (iQuantity - ijcQuantity ) / iQuantity) , iDiscount = convert(decimal(20,2),iDiscount * (iQuantity - ijcQuantity ) / iQuantity) , iNatMoney = convert(decimal(20,2),iNatMoney * (iQuantity - ijcQuantity ) / iQuantity) , iNatTax = convert(decimal(20,2),iNatTax * (iQuantity - ijcQuantity ) / iQuantity) , iNatSum = convert(decimal(20,2),iNatMoney * (iQuantity - ijcQuantity ) / iQuantity)+convert(decimal(20,2),iNatTax * (iQuantity - ijcQuantity ) / iQuantity) , iNatDiscount = convert(decimal(20,2),iNatDiscount * (iQuantity - ijcQuantity ) / iQuantity) where ijcQuantity <> 0 and iQuantity <>0 'exec(@chrsql)set @chrsql='create index ix_idlsid on tempdb..po_dispatchfirst (idlsid)'exec(@chrsql)-------------------------------------------------------------------------------------------------------------取得发票内容,发票按发货单子表ID汇总 --print '开票'if exists(select * from tempdb..sysobjects where name ='po_SaleBillFirst ') drop table tempdb..po_salebillfirst --考虑退补问题 --2003.09.03 增加三字段iTB,TBQuantity,TBNum --南京用友维护部 丁德安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 ,SaleBillVouchs.TBQuantity as TBQuantity ,SaleBillVouchs.TBNum as TBNum, SaleBillVouchs.iTB as iTBINTO 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 -- 考虑退补问题 -- 增加三字段iTB,TBQuantity,TBNum -- 2003.09.03 -- 南京用友维护部 丁德安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_iNatTax, Sum( TBQuantity ) as js_TBQuantity, Sum( TBNum ) as js_TBNum, iTBINTO tempdb..po_SaleBill from tempdb..po_salebillfirst Group by iDLsID,iTB --加索引 (补丁)set @chrsql='create index ix_idlsid on tempdb..po_salebill (idlsid)'exec (@chrsql)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.18 -- ye_iQuantity,ye_iNum 考虑退补问题 -- 2003.09.03 -- 南京用友维护部 丁德安set @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 case when a.iTB=1 thena.iSettleQuantity - isnull(tempdb..po_salebill.js_TBQuantity,0) elsea.iSettleQuantity - isnull(tempdb..po_salebill.js_iQuantity,0) endelse 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 case when a.iTB=1 thena.iSettleNum - isnull(tempdb..po_salebill.js_TBnum,0) elsea.iSettleNum - isnull(tempdb..po_salebill.js_inum,0) endelse 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 )-------------------------------------------------------------------------------------------------------------by zzg (补丁)set @chrsql='update tempdb..po_DispSale set ye_iQuantity=0,ye_iNum=0,ye_iMoney=0,ye_iSum=0,ye_iTax=0,ye_iNatMoney=0,ye_iNatSum=0,ye_iNatTax=0 where isnull(tempdb..po_DispSale.iquantity,0)* isnull(tempdb..po_DispSale.ye_iQuantity,0)<0 or (iquantity=0 and isnull(tempdb..po_DispSale.iSum,0)* isnull(tempdb..po_DispSale.ye_iSum,0)<0)'exec (@chrsql )set @chrsql='update tempdb..po_DispSale set ye_iMoney=0,ye_iTax=0,ye_iNatMoney=0,ye_iNatSum=0,ye_iNatTax=0where isnull(ye_iSum,0)=0' 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 )
解决方案:
问题原因:用户有退补业务,因退补业务不减实际库存,当退货单保存时,数量不写入DispatchLists的iQuantity字段而是写入TBQuantity字段,iQuantity字段值为0,查询发货结算勾对表时,当查询时段包含了退补业务时,Sa_MoveOutIncome存储过程产生除0错误而查询不到数据,当查询时段不包含退补业务时则正常。 解决方法:此为Sa_MoveOutIncome存储过程未考虑到退补业务的特殊性而产生的错误,修改Sa_MoveOutIncome如下即可解决问题:/* 版本:U821 当有退补业务时发货结算勾对表查询无数据 江苏省药材公司 2003.06.27 当发货单关闭时发货结算勾对表未结数量为0 而当退货单关闭时发货结算勾对表未结数量为退货数量 江苏省中医药科技发展总公司 2003.07.18 南京用友维护部 丁德安 与U821年结补丁: 821发货结算钩对表补丁(修改上年发货数据没有减问题).sql 相结合 2004.1.31 南京用友维护部 丁德安*/CREATE 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,TBQuantity --2003.09.03 再增加一字段TBNum --南京用友维护部 丁德安 --根据补丁增加字段ijcQuantityset @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.TBNum as TBNum ,Dispatchlists.iUnitPrice ,isnull(iquantity,0)-isnull(iquantity,0) as ijcQuantity 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 )-------------------------------------------------------------------------------------------------------------期初发货单去掉上年已经结算的数据 (补丁)set @chrsql ='update tempdb..po_DispatchFirst set ijcQuantity= isnull( iSettleQuantity,0)-isnull ( (select sum(iQuantity) from Salebillvouchs inner join salebillvouchon salebillvouchs.sbvid = salebillvouch.sbvid where salebillvouchs.idlsid =tempdb..po_DispatchFirst.idlsid and isnull(Salebillvouch.cInvalider,'''')='''' ) ,0) where tempdb..po_DispatchFirst.bfirst =1 ' exec(@chrsql)--by zzgset @chrsql ='update tempdb..po_DispatchFirst set ijcQuantity= iQuantity where iQuantity *( iQuantity - ijcQuantity)<0'-- 2004.3.5 -- 南京用友维护部 -- 南京蓝光燃气 -- 当期初发货单的结算数量>发货数量时数据不显示,故注释掉下行语句--exec(@chrsql)--by zzgset @chrsql ='update tempdb..po_DispatchFirst set iQuantity = iQuantity - ijcQuantity ,iNum = convert(decimal(20,2),iNum * (iQuantity - ijcQuantity ) / iQuantity) , iMoney = convert(decimal(20,2),iMoney * (iQuantity - ijcQuantity ) / iQuantity) , iTax = convert(decimal(20,2),iTax * (iQuantity - ijcQuantity ) / iQuantity) , iSum = convert(decimal(20,2),iMoney * (iQuantity - ijcQuantity ) / iQuantity)+convert(decimal(20,2),iTax * (iQuantity - ijcQuantity ) / iQuantity) , iDiscount = convert(decimal(20,2),iDiscount * (iQuantity - ijcQuantity ) / iQuantity) , iNatMoney = convert(decimal(20,2),iNatMoney * (iQuantity - ijcQuantity ) / iQuantity) , iNatTax = convert(decimal(20,2),iNatTax * (iQuantity - ijcQuantity ) / iQuantity) , iNatSum = convert(decimal(20,2),iNatMoney * (iQuantity - ijcQuantity ) / iQuantity)+convert(decimal(20,2),iNatTax * (iQuantity - ijcQuantity ) / iQuantity) , iNatDiscount = convert(decimal(20,2),iNatDiscount * (iQuantity - ijcQuantity ) / iQuantity) where ijcQuantity <> 0 and iQuantity <>0 'exec(@chrsql)set @chrsql='create index ix_idlsid on tempdb..po_dispatchfirst (idlsid)'exec(@chrsql)-------------------------------------------------------------------------------------------------------------取得发票内容,发票按发货单子表ID汇总 --print '开票'if exists(select * from tempdb..sysobjects where name ='po_SaleBillFirst ') drop table tempdb..po_salebillfirst --考虑退补问题 --2003.09.03 增加三字段iTB,TBQuantity,TBNum --南京用友维护部 丁德安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 ,SaleBillVouchs.TBQuantity as TBQuantity ,SaleBillVouchs.TBNum as TBNum, SaleBillVouchs.iTB as iTBINTO 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 -- 考虑退补问题 -- 增加三字段iTB,TBQuantity,TBNum -- 2003.09.03 -- 南京用友维护部 丁德安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_iNatTax, Sum( TBQuantity ) as js_TBQuantity, Sum( TBNum ) as js_TBNum, iTBINTO tempdb..po_SaleBill from tempdb..po_salebillfirst Group by iDLsID,iTB --加索引 (补丁)set @chrsql='create index ix_idlsid on tempdb..po_salebill (idlsid)'exec (@chrsql)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.18 -- ye_iQuantity,ye_iNum 考虑退补问题 -- 2003.09.03 -- 南京用友维护部 丁德安set @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 case when a.iTB=1 thena.iSettleQuantity - isnull(tempdb..po_salebill.js_TBQuantity,0) elsea.iSettleQuantity - isnull(tempdb..po_salebill.js_iQuantity,0) endelse 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 case when a.iTB=1 thena.iSettleNum - isnull(tempdb..po_salebill.js_TBnum,0) elsea.iSettleNum - isnull(tempdb..po_salebill.js_inum,0) endelse 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 )-------------------------------------------------------------------------------------------------------------by zzg (补丁)set @chrsql='update tempdb..po_DispSale set ye_iQuantity=0,ye_iNum=0,ye_iMoney=0,ye_iSum=0,ye_iTax=0,ye_iNatMoney=0,ye_iNatSum=0,ye_iNatTax=0 where isnull(tempdb..po_DispSale.iquantity,0)* isnull(tempdb..po_DispSale.ye_iQuantity,0)<0 or (iquantity=0 and isnull(tempdb..po_DispSale.iSum,0)* isnull(tempdb..po_DispSale.ye_iSum,0)<0)'exec (@chrsql )set @chrsql='update tempdb..po_DispSale set ye_iMoney=0,ye_iTax=0,ye_iNatMoney=0,ye_iNatSum=0,ye_iNatTax=0where isnull(ye_iSum,0)=0' 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 )
www.kuaiji66.com 天龙瑞德
用友U8 总帐系统从7.21升级到8.52。7.21帐套的会计期间从2004.4.1到2005.3.31,但升级时设置成从2004.1.1到2004.12.31,导致在升级后查询4月份帐时查出来的是7月份的帐用友U8 总帐系统从7.21升级到8.52。7.21帐套的会计期间从2004.4.1到2005.3.31,但升级时设置成从2004.1.1到2004.12.31,导致在升级后查询4月份帐时查出来的是7月份的帐
问题原因:数据 解决方法:修改ua_period,修改第一个会计期间日期为2004.4.1开始,2004.4.30结束,如此依次修改至第12个会计期间
解决方案:
问题原因:数据 解决方法:修改ua_period,修改第一个会计期间日期为2004.4.1开始,2004.4.30结束,如此依次修改至第12个会计期间
www.kuaiji66.com 天龙瑞德
凭证中金额栏分隔线 _1凭证中金额栏分隔线
问题号: | 36488 |
---|---|
适用产品: | T3系列 |
软件版本: | T3-用友通标准版10.8plus1 |
软件模块: | 总账 |
问题名称: | 凭证中金额栏分隔线 |
问题现象: | 凭证中金额栏分隔线太多,怎么样才能去掉? |
问题原因: | 见问题答案。 |
关键字: | 金额栏分隔线 |
解决方案: | <P>软件预置的格式,可通过快捷键进行修改。</P> <P>在填制凭证界面按下ctrl+L可取消分隔线,再按下此快捷键可进行恢复。</P> |
行业: | 通用 |
补丁编号: | |
解决状态: | 临时解决方案 |
录入日期: | 2016-03-16 15:23:45 |
最后更新时间: |
- 凭证输现金流量后提示一下图示?怎么处理?
- 刚刚安装的T3标准版11.0软件 打开以后提示报错。演示数据同样错误。请帮忙给看看
- 启动服务的时候提示这个是怎么回事?已经重装一遍
- 在w10里面安装T311.0和10.9都是这个提示,普及版
- 在查询科目总账的时候,提示运行错误3021,这个要怎么操作,并不是选择所有的科目提示这个错误,是有一些出现这个错误的
- 新建年度帐时报错
- 新装打开系统管理提示运行时错误字符串之前有未闭合的引号,怎么处理
- 点击模块提示如下图
- 用友T3软件打开时出现:Automation 错误(-2147024770),然后点击确定,软件就关闭了,请问怎么解决
- 用友通精算普及版 核算模块无法打开 出现如图提示 原因为何 如何解决?
登陆软件时时间错乱 登陆软件时时间错乱
问题号: | 2695 |
---|---|
解决状态: | 临时解决方案 |
软件版本: | 8.50 |
软件模块: | 系统管理 |
行业: | 通用 |
关键字: | 会计期间 |
适用产品: | 所有 |
问题名称: | 登陆软件时时间错乱 |
问题现象: | 登陆时输入时间与会计期间不符 |
问题原因: | 因客户有多个年度帐,以系统管理的身份登陆系统管理修改帐套信息后造成。 |
解决方案: | 修改ufsystem中的ua_period中的错乱数据。 |
补丁编号: | |
录入日期: | 2016-03-16 15:23:45 |
最后更新时间: |
- 银行对账单导入的时候,提示时间错误-
- 单据记账之后不能恢复记账。
- 用友U8 在增加发货单界面不能查询以前录入的单据,复制功能也不能使用
- 用友U8 在存货核算中,进行各种单据修改时,提示:单据保存失败,无法将CHAR值转换为MONEY,该CHAR值的语法有误,修改单据失败!该问题在所有的机器上都存在。
- 用友U8 局域网,服务器server2000,在进入报表时,只能登陆到选择操作员界面,然后就一点反映也没有.在之前服务器没出问题时都正常,而且在客户端报表使用都正常.服务器是重做的系统.
- 用友U8 用户通过应收系统的凭证查询查询凭证时提示示此凭证已在数据库中删除,无法查询,应收应付系统所有凭证都提示此项错误.
- 用友U8 登陆系统时提示日期格式不对,日期格式是正确的,不过不上VPN是可以正常登陆软件的,连上VPN就不行了
- 用友U8 银行对帐不平,余额调节表显示不平衡.检查后发现是客户辅助帐中有重复记录,但删除后仍对帐不平.
- 用友U8 银行日记帐里查询时,有一个非帐套主管的用户可以看到,但以帐套主管身份看看不到
- 用友U8 销售发货单审核失败
想请教大家一个问题,我们一月份有张抵扣票上个月税务局查出有问题,让我们补缴税款了,我在账上应该做进项税转出,具体账务操作是这样的呢? _0想请教大家一个问题,我们一月份有张抵扣票上个月税务局查出有问题,让我们补缴税款了,我在账上应该做进项税转出,具体账务操作是这样的呢?[]
@曹倩查补增值税账务调整,应设置“应交税金——增值税检查调整”专门账户,凡检查后应调减账面进项税额或调增销项税额和进项税额转出的,借记本科目,贷记有关科目。全部调整事项入账后,应结出本账户余额(即贷方余额)并予转出:
在结算成本处理操作界面点击暂估时提示结算失败在结算成本处理操作界面点击暂估时提示结算失败
|
- 银行对账单导入的时候,提示时间错误-
- 用友安装之后,进去点总账,出现“Automation错误”,这是什么原因
- 用友T3通2005版2005年度查明细账总账第一列日期显示1999年
- 用友T6企业管理软件中打开工资模块时提示“区域选项日期标签页中的短日期格式应设置为yyyy-MM-d
- 用友记账宝创建账套保存时提示“启用期间过小”?
- 通2005在查询2005年明细账时左边日期却出现1999年但发生额和内容是正确。安月排序2005日期
- 通2005版2005年度查明细账,总账第一列日期显示1999年
- 用友安装之后,进去点总账,出现“Automation错误”,这是什么原因
- 保存报表时提示保存失败问题
- 用友T3-财务通普及版10.8plus1无此任务号,不能释放?
用友T3标准版10.8plus1-发货统计表-打开时无反应用友T3标准版10.8plus1"发货统计表"打开时无反应
报表格式错乱
1、做好账套备份。
2、查询分析器里执行如下语句(删除RPT开头的七张表以001账套,2013年度为例):
use UFDATA_001_2013
drop table dbo.Rpt_FldDEF
drop table dbo.Rpt_FltDEF
drop table dbo.Rpt_Folder
drop table dbo.Rpt_GlbDEF
drop table dbo.RPT_GRPDEF
drop table dbo.RPT_ItmDEF
drop table dbo.Rpt_RelDEF
- 用友在U821升级到U852的过程中,升级失败
- G6医院专版10.6 环境:windows2008 R2 32位 数据库:SQL2005 SP2,自动备份日期文件夹生成了,但里面是空的,SQL代理服务也是启动的,还能怎么解决?
- G6点填制凭证提示错误
- sql2000数据库,如何实现自动备份,也添加了相应的计划,在指定的备份目录里只有空目录,没有文件,是不是还要打开哪个服务才能备份呢?谢谢!
- T+12.0普及版,在凭证管理审核凭证的时候回出现一个295数据库粗无,记账会出来8152数据库错误,在填制凭证那里审核记账没有问题,请问是怎么回事?(打过最新补丁,重新配置过数据库,SQL也是完整版的2008)
- T+12.0普及版,在凭证管理审核凭证的时候回出现一个295数据库错误
- T+12.0标准版,装了数据库2008R2的,系统是win7旗舰版32位的,收发存汇总表查询的时候出现如图所示的问题。请问要怎么处理呢?设置备份计划的时候,确定后,退出,却没有备份计划。
- T+12.0版本的审核凭证是出现数据类型报错,如下图
- T+导出数据时提示这个!怎样解决
- T+普及12.1如何导入报表模板
用友在进行数据库配置时,提示“数据库连接测试不成功”?在进行数据库配置时,提示“数据库连接测试不成功”?
知识库详细内容
|
销售订单执行统计表 存货订单执行情况有的数据出不来时怎么回事? 销售订单执行统计表 存货订单执行情况有的数据出不来时怎么回事?
需要检查销售订单后续生单关联单据的执行情况。@畅捷支持矦椿寳1976:这写数据我时同一张做的。 为什么有的出来了。有的没出来?都做到出库单而已 销售订单→ 销售出库单!为什么都是显示辅舒数量,在设置那里看看有没有显示主数量的检查问题存货的计量单位。@畅捷支持矦椿寳1976:哦 上面能显示的是多计量,下面的是单计量。那要怎么调整都显示出来设置,显示表体主计量字段。@畅捷支持矦椿寳1976:有可能,您帮我看一下。http://218.86.38.26:3086/tplus/login.aspx 这个地址我怎么一直连接不上去怎么回事。其他的都可以连接登录正常。@畅捷支持矦椿寳1976:可是我登录不了用户如果在局域网登录,使用局域网IP。@畅捷支持矦椿寳1976:那个是外网,我的也是外网360浏览器医生修复,除了重置浏览器,其余勾选修复,关闭防火墙。检查动态域名解析工具是否正常。
外网ping 域名地址是否有返回响应时间。
外网是否有正常访问过。
百度ip138的外网地址,是否与花生壳之类的工具解析出绑定域名的ip一致。
如果不一致需要与 宽带运营商沟通 网络ip分配是否跨网段。
cmd中尝试以下命令,例如
ping bjherushangmao.imwork.net -t
是否可以ping通。
telnet bjherushangmao.imwork.net 10359
是否telnet 不通。
需要联系服务商开通此端口,或者换其他端口尝试。
用友知识库
更多使用技巧
热点文章
问题解答
-
单据记账之后不能恢复记账。
单据记账之后不能恢复记账。单据记账之后不能恢复记账。 2016-10-17日期格式不正确,检查控件面板-日期格式-短日期格式。应该为yyyy-mm-dd。用友天龙瑞德,购买用友产品和服务010-59798025
-
在系统管理中设置的备份计划没有得到执行
在系统管理中设置的备份计划没有得到执行在系统管理中设置的备份计划没有得到执行
问题版本: 803-U8.52 问题模块: 804-系统环境 所属行业: 0-通用 问题状态: http://yun.kuaiji66.com公示 关 键 字: 在系统管理中设置的备份计划没有得到执行 适用产品: 85x 补 丁 号: 开放状态: 用友云基地注册用户 原问题号: 提交时间: 2008-1-8 问题名称: 在系统管理中设置的备份计划没有得到执行 问题现象: 在系统管理中设置的备份计划没有得到执行。 原因分析: 修复软件,无任何作用,使用系统管理的手工备份,可以正常备份完毕。最后发现控制面板中-区域选项-日期格式设置为“yyyy-m-d” 更改为“yyyy-mm-dd”。测试备份计划能够正常执行。 解决方案: 复软件,无任何作用,使用系统管理的手工备份,可以正常备份完毕。最后发现控制面板中-区域选项-日期格式设置为“yyyy-m-d” 更改为“yyyy-mm-dd”。测试备份计划能够正常执行。
用友热销产品
解决方案
-
用友U8 U851总账录入凭证时,录辅助核算无法选入
用友U8 U851总账录入凭证时,录辅助核算无法选入用友U8 U851总账录入凭证时,录辅助核算无法选入 问题原因:系统区域设置中的日期格式设置 解决方法:修改区域设置为短日期格式(YYYY-MM-DD)问题解决。
解决方案:
问题原因:系统区域设置中的日期格式设置 解决方法:修改区域设置为短日期格式(YYYY-MM-DD)问题解决。
www.kuaiji66.com 天龙瑞德 -
用友U8 为什么经常性站点提示“帐套年度错误”?而别的模块运行正常。远程配置做了,而且,别的模块都运行正常。 单机版软件也经常有这个问题,别的模块没什么问题,而UFO报表“帐套年度错误”,有时候重装也不管用。
用友U8 为什么经常性站点提示“帐套年度错误”?而别的模块运行正常。远程配置做了,而且,别的模块都运行正常。 单机版软件也经常有这个问题,别的模块没什么问题,而UFO报表“帐套年度错误”,有时候重装也不管用。用友U8 为什么经常性站点提示“帐套年度错误”?而别的模块运行正常。远程配置做了,而且,别的模块都运行正常。 单机版软件也经常有这个问题,别的模块没什么问题,而UFO报表“帐套年度错误”,有时候重装也不管用。 问题原因:配置问题 解决方法:请配置远程配置,将其指向服务器。请在控制面板中设置短日期格式为yyyy-mm-dd
解决方案:
问题原因:配置问题 解决方法:请配置远程配置,将其指向服务器。请在控制面板中设置短日期格式为yyyy-mm-dd
www.kuaiji66.com 天龙瑞德
- 最新文章排行
- 热门文章排行
- T6软件如何处理形态转换业务
- T6形态转换单单据流程
- T3软件中库存管理中可以处理形态转换业务
- 出库调整单记账时提示“调整之后会造成负单价,不允许调整”
- 用友软件无法正常安装软件,提示ccpstartor-.net, unable to find a version of the runtime to run this application
- 产品结构中的定额数量只能到小数点后2位吗?如何能改变为小数点后4位?
- 餐饮行业,调拨给其他门店物品,已计提了9个月摊销,还有15个月没摊,按原值调拨,怎么样做账务处理?谢谢
- 餐厅的装潢费用摊销怎么做账?
- 顶尖POS收款机怎样往里录入供应商还有库存管理,是不是不录入供应商信息就无法使用库存呢?希望高手解答。
- 阿里怎么设置付款减库存
产品介绍
产品资讯
-
用友在使用企业门户时总会报错,特别是一些与查询有关的操作
用友在使用企业门户时总会报错,特别是一些与查询有关的操作在使用企业门户时总会报错,特别是一些与查询有关的操作
问题版本: 803-U8.52 问题模块: 28-企业文化 所属行业: 0-通用 问题状态: http://yun.kuaiji66.com公示 关 键 字: 企业门户 适用产品: U852-企业门户 补 丁 号: 开放状态: 用友云基地注册用户 原问题号: 提交时间: 2008-1-8 问题名称: 在使用企业门户时总会报错,特别是一些与查询有关的操作 问题现象: 在使用企业门户时总会报错,特别是一些与查询有关的操作 原因分析: 时间格式选择不对 解决方案: 将时间格式选对就可以了,控制面板-区域选项-日期-短日期格式选择为“YYYY-MM-DD”
用友在升级8.12数据报错:需要修改的摘要名称:[441]单位欠款
用友在升级8.12数据报错:需要修改的摘要名称:[441]单位欠款在升级8.12数据报错:需要修改的摘要名称:[441]单位欠款
|