自定义的报表在设置报表的电脑上可以打开,其他客户端打开有如下提示,服务器打开报表区域是黑色的
2018-4-8 0:0:0 wondial自定义的报表在设置报表的电脑上可以打开,其他客户端打开有如下提示,服务器打开报表区域是黑色的
自定义的报表在设置报表的电脑上可以打开,其他客户端打开有如下提示,服务器打开报表区域是黑色的![](http://sto.chanapp.chanjet.com/4a47ecad-3fcd-422b-879b-b2df91606e00/img/2016/06/08/1465364968eSxr.png)
浏览器问题,退出软件从新打开,再登录界面点击右上方浏览器设置,下载设置工具后自动检测修复一下再试。
如果您的问题还没有解决,可以到 T+搜索>>上找一下
相关阅读
- 年结的时候出现,本机已经运行【系统控制台程序】,请退出再运行2020-4-28 8:53:21
- 填制凭证类别时显示互斥站点2020-4-28 8:40:34
- 用友软件访问数据库是要通过SA来访问的,是否可以用其他的用户名2020-4-26 23:40:53
- 版本号-12.100.001.0076.0514 票据类型无法记忆,设置单据中已经打开票据类型记忆功能,同客户无法实现记忆,升级到新版之后,出现的问题!2019-5-22 8:0:0
- 12.0普及版,盘点单保存报“计量单位2必须为空”。经检查是某个存货单计量,在盘点单带出了计量单位2,在别的单据不会带出单位2.怎么解决,有补丁解决么?2019-5-22 8:0:0
- 产成品入库单删除报错, 查询联查没有任何单据2019-5-22 8:0:0
- 更新了最新补丁提示微信结算方式与其他结算方式冲突是什么原因2019-5-22 8:0:0
- 为啥客户端老是提示这个2019-5-13 9:0:0
- T3 卸载不了,怎么解决2019-4-30 8:0:0
- 安装T3后没有服务启动项,点击卸载就又是安装,安装时没有任何报错,请问是什么原因造成的,怎么解决2019-4-30 8:0:0
最新信息
![我的是T+12.0 补丁是最新打了的 但在设计凭证打印模版时一直弄不好 一直是如下图,麻烦老师了 求助](http://sto.chanapp.chanjet.com/4a47ecad-3fcd-422b-879b-b2df91606e00/img/2016/04/28/1461801324zBgu.png)
我的是T+12.0 补丁是最新打了的 但在设计凭证打印模版时一直弄不好 一直是如下图,麻烦老师了 求助 我的是T+12.0 补丁是最新打了的 但在设计凭证打印模版时一直弄不好 一直是如下图,麻烦老师了 求助
您在系统模板上重新设置下,再另存新模板使用。我一直在设置 就是会出现这种情况 你说的系统模版是指哪 麻烦说具体点 好吗@陈诚6jU:我找到的系统模版是总账内全设置报表的 没有凭证打印模版设置@陈诚6jU:账套里默认的那个金额式的就是系统模板。@陈诚6jU:在总账—凭证—打印凭证,点击打印模板设置。谢谢
![未收齐出口单证能否延期办理出口退税](https://www.kuaiji66.com/nc/zb_users/plugin/MiniTu/noimg.png)
未收齐出口单证能否延期办理出口退税 未收齐出口单证能否延期办理出口退税
【问题】
企业采取远期收汇出口货物的,在规定的期限内无法收齐单证,能否因此申请延期申报办理?
【解答】
答:根据国家总局、国家外汇管理局《关于远期收汇出口货物出口退税有关问题的通知》(国税发[2006]168号)规定,企业出口货物如果采取远期收汇方式,应在规定期限内向税务机关申报办理出口货物退(免)税,申报时需凭所在地外汇管理局开具的《远期收汇备案证明》,无须提供出口收汇核销单(出口退税专用联)。因此,出口企业采取远期收汇方式的,确因其他原因无法在规定期限内收齐有关单证,可根据国家税务总局《关于出口货物退(免)税管理有关问题的通知》(国税发[2004]64号)规定,在出口货物退(免)税申报期限内,向税务机关提出延期办理出口货物退(免)税申报的申请,经批准后,可延期3个月申报。
- 用友U8 仓库(A、B)计价方式:移动平均 存货X在仓库A的结存单价为0 存货X在仓库B的结存单价为5 操作如下:做调拨单从A到B,记账后,其他出库单单价为0,而其他入库单单价为5,不是为0 补充:存货选项中的入库金额和零出库金额选择为结存成本
- 用友U8 软件无法登陆,在管理工具的服务中发现SQL无法启动,提示可能是WINDOWS错误
- 用友U8 客户能够ping通服务器,但是不能登陆用友软件。
- 用友U8 录入银行对账单保存、退出后再进入,数就变了,有些数总会重复多出一条,估计需要跟一下数据库。客户今天发现问题的时候,已经让客户把有问题的帐套做了帐套输出。
- 用友U8 总帐和存货总帐对不上
- 在录入凭证或查询辅助余额表时,能__否改成以表的形式显示项目辅助核算?
- 用友NC物资管理系统解决方案
- NC资产管理系统解决方案
- NC销售管理系统解决方案
- 用友NC软件凭证打印设置方法
![用友U8其他按类别查询时无卡片的类别报错:-Fixed row 必须小于 Rows值-](https://www.kuaiji66.com/nc/zb_users/plugin/MiniTu/noimg.png)
用友U8其他按类别查询时无卡片的类别报错:-Fixed row 必须小于 Rows值-U8其他按类别查询时无卡片的类别报错:"Fixed row 必须小于 Rows值"
U8其他-按类别查询时无卡片的类别报错:"Fixed row 必须小于 Rows值"
自动编号: | 10539 | 产品版本: | U8其他 |
产品模块: | 固定资产 | 所属行业: | 通用 |
适用产品: | 811Access | 关 键 字: | 卡片 |
问题名称: | 按类别查询时无卡片的类别报错:"Fixed row 必须小于 Rows值" | ||
问题现象: | 811固定资产进入卡片管理后,按类别查询时无卡片的类别报错:"Fixed row 必须小于 Rows值"。 | ||
原因分析: | 列头编辑中所选项目太少,而当查询到无卡片的类别时软件显示项目中有资产名称、原值等必填项目而导致报错。 | ||
解决方案: | 进入列头编辑中重新设置显示项目即可。 温馨提示:如果您的问题还没有解决,欢迎进入用友云基地。 |
![用友U8 有一客户做船务代理的,购买了应收应付、总账、报表等模块。有这一笔业务-船务代理与船之间签定船务合同,与此同时船务代理对这只船向商检局报检,商检局给船务代理开具一张发票,客户的账务处理如下: 借:应收账款 贷:应付账款 象这样的业务在软件中如何实现?](https://www.kuaiji66.com/nc/zb_users/plugin/MiniTu/noimg.png)
用友U8 有一客户做船务代理的,购买了应收应付、总账、报表等模块。有这一笔业务-船务代理与船之间签定船务合同,与此同时船务代理对这只船向商检局报检,商检局给船务代理开具一张发票,客户的账务处理如下: 借:应收账款 贷:应付账款 象这样的业务在软件中如何实现?用友U8 有一客户做船务代理的,购买了应收应付、总账、报表等模块。有这一笔业务:船务代理与船之间签定船务合同,与此同时船务代理对这只船向商检局报检,商检局给船务代理开具一张发票,客户的账务处理如下: 借:应收账款 贷:应付账款 象这样的业务在软件中如何实现?
问题原因:一笔完整的代理业务在性质上实际是应付、应收两个业务过程,对于此种情况,在软件中应该分成应付、应收两个业务处理。 解决方法:关于应收应付代理业务的处理:一笔完整的代理业务在性质上实际是应付、应收两个业务过程,对于此种情况,在软件中应该分成应付、应收两个业务处理。可以根据您的业务需要和业务性质,增加一个过渡科目,这样,在应收和应付系统中,使用这个过渡科目,分别作为贷方和借方。 例如:应付业务发生时: 借:过渡科目 贷:应付帐款 应收业务发生时: 借:应收帐款 贷:过渡科目 收入科目(如果应收与应付有差额并记入损益时)
解决方案:
问题原因:一笔完整的代理业务在性质上实际是应付、应收两个业务过程,对于此种情况,在软件中应该分成应付、应收两个业务处理。 解决方法:关于应收应付代理业务的处理:一笔完整的代理业务在性质上实际是应付、应收两个业务过程,对于此种情况,在软件中应该分成应付、应收两个业务处理。可以根据您的业务需要和业务性质,增加一个过渡科目,这样,在应收和应付系统中,使用这个过渡科目,分别作为贷方和借方。 例如:应付业务发生时: 借:过渡科目 贷:应付帐款 应收业务发生时: 借:应收帐款 贷:过渡科目 收入科目(如果应收与应付有差额并记入损益时)
![用友T3-用友通打开工资类别报错](https://www.kuaiji66.com/nc/zb_users/plugin/MiniTu/noimg.png)
用友T3-用友通打开工资类别报错 用友T3-用友通打开工资类别报错
打开工资类别的时候提示“运行时错误 2147217887,多步操作产生错误。请检查每一步的状态值”,点击“确定”后提示“运行时错误440? automation错误,子系统登录失败”,软件无法进行操作,请问是何原因?系统日期格式的问题,将长日期按要求进行设置即可。打开“控制面板”–“区域和语言选项”–设置“长日期”格式为:“yyyy’年’M’月’d’日’”即可。如下图:如有其它问题,请联系在线客服咨询。用友云基地
- 用友t3怎样取消审核
- 用友t6如何取消审核凭证
- 请问下,我建账选择的是小企业会计准则(2013年)行业性质,但是为什么在会计科目那里显示的都是小企业会计制度的会计科目?
- 前台收银程序T+pos启动后,提示数据库错误,编号11,绑定数据库错误。如何处理啊?
- 老师请问:怎么样才能把不能够按照默认供货商为单位来查询诸如销量、库存等等各类参数的问题反馈给开发团队??我们超市这单是和各个供货商对接库存和销售量都快疯了。这样一个带前端销售的软件怎么会这个基本的功能都没有……还需要做什么自定义项那么麻烦
- T3卸载不了提示这个是什么意思?
- 请问t3标准版为什么从系统卸载不掉,请问怎么才能卸载掉?
- 请问这是怎么一回事,老是说登录不上服务器,防火墙都已经关闭了,提示下面这种
- 为什么卸载的时候提示这个??
- 我用的是用友T3普及版 ,现在我点击注册登录时输入密码之后没有账套出来,我确定密码和用户名都是对的!还有点击系统管理的时候电脑没有反应,打不开系统管理!这个是什么原因呢?
![分别查询固定资产原始资产与新增资产](https://www.kuaiji66.com/nc/zb_users/plugin/MiniTu/noimg.png)
分别查询固定资产原始资产与新增资产 分别查询固定资产原始资产与新增资产
问题号: | 36604 |
---|---|
适用产品: | T3系列 |
软件版本: | T3-用友通标准版10.8plus1 |
软件模块: | 固定资产 |
问题名称: | 分别查询固定资产原始资产与新增资产 |
问题现象: | 如何分别查询固定资产的原始资产与新增资产? |
问题原因: | 见问题答案。 |
关键字: | 区分原始资产与新增资产 |
解决方案: | <P>可以通过卡片管理中的自定义查询,按照开始使用日期的来区分。</P> <P>例如:2011年11月30日开始启用的固定资产模块,30日之前的全部是原始资产。30日当天和之后的都录入的新增资产。</P> <P>1、点开“卡片管理”,选择“自定义查询”。</P> <P>2、选择“添加查询”中的“新增行”。(项目填写“开始使用日期”、比较符选择“<”、比较值填写 2011.11.30 )</P> <P>3、输入“查询表名称”为“原始资产”后点“确定”,即可查询到原始资产。</P> |
行业: | 通用 |
补丁编号: | |
解决状态: | 临时解决方案 |
录入日期: | 2016-03-16 15:23:45 |
最后更新时间: |
![软件也重装了 数据库也重装 还是连接不到服务器](http://sto.chanapp.chanjet.com/4a47ecad-3fcd-422b-879b-b2df91606e00/img/2016/10/09/14759846141Uo6.jpg)
软件也重装了 数据库也重装 还是连接不到服务器 软件也重装了 数据库也重装 还是连接不到服务器
密码对吗?您的软件是什么版本呢@畅捷服务李笑旺:6.5的 我没有设置密码@小龙哥哥:软件安装成功的情况下
1.检查是否能ping通
2、检查1433和4630的端口问题
3、检查host文件配置
4、检查数据库的tcp/ip协议
5、regedit打开注册表,然后software/64、32node/ufsoft/8520/login/打开涉及到的server的文件,看看是不是服务器的IP地址或者计算机名称@畅捷服务李笑旺:这个是单机版的@小龙哥哥:单机版也要端口开通的@畅捷服务李笑旺:怎么查看端口是否开通啊@小龙哥哥:您百度换一下,对端口描写很详细的
![第二篇 建账篇(填报表、装订凭证、账簿)(一)](https://www.kuaiji66.com/nc/zb_users/plugin/MiniTu/noimg.png)
第二篇 建账篇(填报表、装订凭证、账簿)(一) 第二篇 建账篇(填报表、装订凭证、账簿)(一)
怎样设置会计报表?
会计报表是根据帐簿记录对日常会计核算资料的归集、加工、汇总,并按照一定的格式和内容要求编制的报告文书,是提供会计信息的一种文件。
对外公布的三张主要会计报表,即资产负债表、损益表、现金流量表是由国家财政部门统一制定的。因此会计报表的设置主要指的是企业内部会计报表的设置。会计报表的内容通常应该包括如下各项:①报表名称;②报表的编制时间;③货币单位;④编制单位;⑤栏目;⑥填表人;⑦审核人;⑧财务主管。
![用友U8 想把前期测试的OA数据清空掉,因为系统马上要正式运行了。](https://www.kuaiji66.com/nc/zb_users/plugin/MiniTu/noimg.png)
用友U8 想把前期测试的OA数据清空掉,因为系统马上要正式运行了。用友U8 想把前期测试的OA数据清空掉,因为系统马上要正式运行了。
问题原因:同解决方案 解决方法:您好, 是可以清空业务数据的。在以DEMO登录“系统管理”--“年度账”--“清空数据库”,可以选择清空‘全部OA数据’或‘部分OA数据’的。
解决方案:
问题原因:同解决方案 解决方法:您好, 是可以清空业务数据的。在以DEMO登录“系统管理”--“年度账”--“清空数据库”,可以选择清空‘全部OA数据’或‘部分OA数据’的。
www.kuaiji66.com 天龙瑞德
![用友U8 销售系统发货结算勾对表查出有很多负数未结算,但在开销售发票时参照不到这些未结算的发货单。](https://www.kuaiji66.com/nc/zb_users/plugin/MiniTu/noimg.png)
用友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 )
- 年结的时候出现,本机已经运行【系统控制台程序】,请退出再运行
- 填制凭证类别时显示互斥站点
- 用友软件访问数据库是要通过SA来访问的,是否可以用其他的用户名
- 版本号-12.100.001.0076.0514 票据类型无法记忆,设置单据中已经打开票据类型记忆功能,同客户无法实现记忆,升级到新版之后,出现的问题!
- 12.0普及版,盘点单保存报“计量单位2必须为空”。经检查是某个存货单计量,在盘点单带出了计量单位2,在别的单据不会带出单位2.怎么解决,有补丁解决么?
- 更新了最新补丁提示微信结算方式与其他结算方式冲突是什么原因
- 产成品入库单删除报错, 查询联查没有任何单据
- 为啥客户端老是提示这个
- T3 卸载不了,怎么解决
- 安装T3后没有服务启动项,点击卸载就又是安装,安装时没有任何报错,请问是什么原因造成的,怎么解决
![您好:- 我目前只启用的是用友T3核算模块,分了仓库,存货设置了类别。因为存货较多,使用EXCEL导入存货时忘记设置类别,结果导入的存货在存货档案里找不到,而在录入库单的时候输入其代码看得到存货,想请问如果去修改这些看不到的存货,如何把他们删除掉。](https://www.kuaiji66.com/nc/zb_users/plugin/MiniTu/noimg.png)
您好:- 我目前只启用的是用友T3核算模块,分了仓库,存货设置了类别。因为存货较多,使用EXCEL导入存货时忘记设置类别,结果导入的存货在存货档案里找不到,而在录入库单的时候输入其代码看得到存货,想请问如果去修改这些看不到的存货,如何把他们删除掉。 您好: 我目前只启用的是用友T3核算模块,分了仓库,存货设置了类别。因为存货较多,使用EXCEL导入存货时忘记设置类别,结果导入的存货在存货档案里找不到,而在录入库单的时候输入其代码看得到存货,想请问如果去修改这些看不到的存货,如何把他们删除掉。[]
备份好数据 然后数据库执行
delete from inventory做好备份,删除inventory表中的内容,然后重导存货
![期初建帐的时候有产成品期初数40吨,本月产成品入库73.21吨,现在销售出库(或销货单)出库73.21时,总是显示库存不足,通过现存量查询时,显示现存量113.21吨,可用量40吨,不知怎么回事](https://www.kuaiji66.com/nc/zb_users/plugin/MiniTu/noimg.png)
期初建帐的时候有产成品期初数40吨,本月产成品入库73.21吨,现在销售出库(或销货单)出库73.21时,总是显示库存不足,通过现存量查询时,显示现存量113.21吨,可用量40吨,不知怎么回事 期初建帐的时候有产成品期初数40吨,本月产成品入库73.21吨,现在销售出库(或销货单)出库73.21时,总是显示库存不足,通过现存量查询时,显示现存量113.21吨,可用量40吨,不知怎么回事[]
可能是库存不足,请点击更多--工具下载--T+,整理现存量,使用此工具整理现存量后再试。@服务社区刘佳佳:在使用工具时用不用提前备份好数据@遇见夏天:用的用的,一定要先提前做好备份。请在使用工具前先做好数据备份哦。
![自动备份计划设置了,每个账套都分开时间段来备份,但是备份文件里面都是空的](https://www.kuaiji66.com/nc/zb_users/plugin/MiniTu/noimg.png)
自动备份计划设置了,每个账套都分开时间段来备份,但是备份文件里面都是空的 自动备份计划设置了,每个账套都分开时间段来备份,但是备份文件里面都是空的[]
请使用下面的内容进行排查问题:
1、鼠标右键点击 我的电脑-- 管理--服务 启动‘tong备份服务’即可。 2、 自动备份的服务没有启动。 重启备份的服务。依次点击“我的电脑”右键—“管理”—“服务和应用程序”—“服务”。启动“SQL SERVER AGENT”服务。如图:
3、 时间不对,包括开始时间,触发时间。
4、 备份路径下的文件夹的文件名不是英文。备份路径过长,修改过备份路径。
5、 系统的日期格式不对。点击开始“控制面板”-“语言和区域选项”-“区域选项”-“自定义”-“日期”-短日期格式选择“yyyy-mm-dd”,长日期格式选择“dddd yyyy'年'M'月'd'日'”确定。
6、 登陆系统的操作员不是系统管理员。系统盘空间和备份盘空间不够大。
7、 一个账套设置一个备份计划。
8、如果存在多个备份计划,不要把所有备份计划同时启用一个时间点,要错开时间,最好为1小时。
9、在有效触发时间内,请不要使用用友通。
10、清除ufsystem数据库中的ua_log数据表的日志。
上面的一般是自动备份不成功的一些原因,敬请您参考排查;
![手工帐年末结账图解](http://www.kuaiji66.com/t6/zb_users/upload/2016/1/2016010582052801.jpg)
手工帐年末结账图解
一、操作流程:
1、先做数据备份
2、新建年度帐
3、结转上年数据
二、具体步骤:
1、数据备份:
系统管理→系统→注册→用户名admin 密码为空→确定→账套→备份→选择要备份的账套→确定→选择备份路径→完成备份
2、新建年度帐(以2016年结转到2017年为例):
系统管理-系统-注册-用户名是您自己的名字如demo密码demo-选择帐套001-年度2016-确定-年度帐-建立-2017年年度帐-确定-关闭系统管理
3、结转上年数据:
系统管理-系统-注册-用户名是您自己的名字如demo密码demo-选择帐套-年度2017-确定-年度帐--结转上年数据-总账系统结转-选择结转方式-明细方式-错误结转科目为0说明结转成功