初学者课程：|| ｜
| 知识库: |
培训:|||| |
查看: 3581|回复: 16
T3财务报表如何设置包含为记账凭证。
马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。
才可以下载或查看，没有帐号？
T3财务报表如何设置包含为记账凭证。{:soso_e163:}
这才是高手啊，直接编公式，我用的是公司老版本的，直接没有上面说的在未记账那打勾，直接没有
设置公式的时候 有个勾打上就可以了
为什么劳动节我们不放假。
在利用函数向导为某单元编制公式时，最后一个参照对话框中有一个选项，“包含未记账凭证”，打上勾就可以了。
为什么提示输入公式失败啊！！他这个公式是怎么个意思啊！新人请教下&
bradpit1066 发表于
在利用函数向导为某单元编制公式时，最后一个参照对话框中有一个选项，“包含未记账凭证”，打上勾就可以了 ...
谢了。{:soso_e163:}{:soso_e163:}
bradpit1066 发表于
在利用函数向导为某单元编制公式时，最后一个参照对话框中有一个选项，“包含未记账凭证”，打上勾就可以了 ...
为什么提示输入公式失败啊！！他这个公式是怎么个意思啊！新人请教下
设置好了没有啊？
我给你发一个范例：
比如应收票据（科目代码1123）的期末余额公式，如果想把还未记账的涉及应收票据也包含进来，就这样编制公式QM(&1001&,月,,,,,,,&y&,,)，里面的&y&就代表的是包含未记账凭证的发生额，你按照我给的图片设置后形成的公式就是这样的。
大恩不言谢！&
利用向导就可以了来自: Android客户端
好厉害呀，研究的比较深，佩服佩服！
bradpit1066 发表于
设置好了没有啊？
我给你发一个范例：
比如应收票据（科目代码1123）的期末余额公式，如果想把还未记账的 ...
大恩不言谢！
不客气,没有这么严重的,大家互相切磋吧!&
ufida__ 发表于
大恩不言谢！
不客气,没有这么严重的,大家互相切磋吧!
哈哈哈。好的&
bradpit1066 发表于
不客气,没有这么严重的,大家互相切磋吧!
哈哈哈。好的
3楼正解， 支持
学习学习了啊，不错不错
利用向导来设置公式的就可以，包含未记账的打上勾就能解决你的问题了
Powered by>>>>用友T3软件如何设置填制凭证时手工输入凭证号？
用友T3软件如何设置填制凭证时手工输入凭证号？ 0:0:0　用友T3小编
用友T3软件如何设置填制凭证时手工输入凭证号？如何设置填制凭证时手工输入凭证号？
问题模块： 总账关键字：手工编号问题版本：用友T3-标准版10.8plus1原因分析： 见问题答案适用产品：T3系列问题答案：点击“总账”--“设置”--“选项”，在凭证编号方式区域，勾选“手工编号”即可。
如果您的问题还没有解决，可以到 上找一下答案
#财税实务#跨年补缴个税，该怎么做分录？ #财税实务#跨年补缴个税，该怎么做分录？[]
个税是个人承担，建议计入其他应收款。
#易代账#易代帐有办法添加辅助合算供应商吗？ #易代账#易代帐有办法添加辅助合算供应商吗？[]
没有辅助核算亲，你要等等了，正在开发中
多表页如何设置固定表头打印 多表页如何设置固定表头打印
通知识库问题号:21000适用产品:U6软件版本:U6普及版3.2plus1软件模块:UFO报表问题名称:多表页如何设置固定表头打印问题现象:多表页如何设置固定表头打印？要求固定表头包含报表名称及各项目名称在多页重复打印。
非货币性交易中增值税的会计处理（一） 非货币性交易中增值税的会计处理（一）
　　进行非货币性交易的会计处理，主要涉及换入的非货币性资产的入账价值的确定、收到补价方非货币性交易收益损失的确认这两大问题。《企业会计准则——非货币性交易》规定，企业发生非货币性交易时，应以换出资产的账面价值，加上应支付的相关税费，作为换入资产的入账价值。而在非货币性交易中如果发生补价，应区别不同情况处理：（1）支付补价的，应以换出资产的账面价值，加上补价和应支付的相关税费，作为换入资产的入账价值。（2）收到补价的，应按如下公式确定换入资产的入账价值和应确认的收益：
怎么修改单位名称？原因分析：在“系统管理”--“参数设置”里可以修改单位名称。问题解答：点击“系统管理”--“参数设置”--“其它”，在“其它”的单位名称里修改单位名称点击确定。
菜单向导在哪里设置？原因分析：菜单向导第一次进入新建账套的时候自动弹出的，可以在辅助中心再次打开设置。问题解答：“辅助中心”--“自定义菜单”，左下角按钮“菜单向导”。
T1升级之后，重新注册成功，但是登陆依旧 提示如下，请问是怎么回事。 T1升级之后，重新注册成功，但是登陆依旧 提示如下，请问是怎么回事。
防伪里查询下加密狗是标准版还是普及版的@服务社区黄旻:加密狗用了好几年了
应该不是 版本的问题
PS：请问个在哪里查询回复
csp李毅：服务社区～更多～正版验证里，您不是升级了吗，怕升级装错版本，您查下先@服务社区黄旻:缺点都是普及版的。@服务社区黄旻:确定那您的软件装成了标准版了@服务社区黄旻:软件是普及版@服务社区黄旻:计算机右键，管理～服务和应用程序里启动或是重启商贸宝普及版的服务@服务社区黄旻:计算机里没有T1想关服务，是这个问题吗？@csp李毅:@服务社区黄旻:找了好几遍都没有找到这个文件 是不是缺少这个文件@csp李毅:这是在软件安装目录下的，您全盘搜下，实在不行，软件卸载重装也OK
我怎么能在明细帐表这块添加上现金日记账这个选项？ 我怎么能在明细帐表这块添加上现金日记账这个选项？
您好，现金日记账是在出纳模块里面进行体现的@畅捷服务陈一:我这就是有一个帐套是有这个！另一个帐套没有！嗯，您看下您账套主管身份进去是否有？@畅捷服务陈一:哦！我明白了！你意思是讲出纳管理模块没启用！所以没法体现吧！您好，核对了下您的情况正常都会显示，您软件是否有打最新补丁，建议打上补丁后进行核对@畅捷服务陈一:这个上面有三个帐套！有一个显示！其他两个不显示！
用友T3用友通销售出库单无法删除！用友T3用友通销售出库单无法删除！
库存里的销售出库单删除不了，在删除时提示：该单据是其他人所制或您对该仓库或某些存货无权限，您无权删除！出库单的日期是，出库单号是 ，存货是生耳，客户是烟台华仁，麻烦您帮忙删除！你的帐套数据没有问题，销售出库单无法删除是因为，系统设置了“本人填制的单据不允许他人修改”所以无法删除。在“库存业务范围设置”中，“本人填制的单据是否允许他人修改”打对勾就可以删除出库单；
T3用友通销售发货单审核时提示“xx单据审核失败，保存失败”T3用友通销售发货单审核时提示“xx单据审核失败，保存失败”
在销售发货单审核时，系统提示“xx单据审核失败，单据体保存失败。vouchtype表有问题。vouchtype表有问题，先执行下面脚本，因为之前的数据库中有错误数据，因此用户在发票审核后，联查出库单可能有多张出库单。如果有这种情况，那么就弃审发货单，再审核发货单，重新生成出库单。 select * into aaa from vouchtype drop table vouchtype CREATE TABLE [VouchType] ( [cVouchType] [varchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL , [cVouchName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , CONSTRAINT [aaaaaVouchType_PK] PRIMARY KEY NONCLUSTERED ( [cVouchType] ) ON [PRIMARY] ) ON [PRIMARY] GO insert into vouchtype select * from aaa drop table aaa。
T3标准版10.8PLUS2,启用财务、采购、销售、库存和核算模块。存货有现存量，入库单据也审核，有批次管理。但是出库时候，提示此批次存货无现存量。 整理一下现存量试试
12.0生12.1时恢复提示磁盘空间不足软件都重安装了电脑系统都重装过 12.0生12.1时恢复提示磁盘空间不足软件都重安装了电脑系统都重装过[]
那应该不是空间不足的问题，您先给安装路径下的chanjet加上everyone完全控制的权限。
用友T3软件进销存统计表查询无数据。进销存统计表查询无数据。
进销存统计表查询无数据。原因分析：报表生成数据时，在后台产生临时表，其中用到了某些字段（暂估数量，暂估金额），而报表中默认没有将这些字段显示在正文区域，所以造成这种问题。问题解答：从报表格式中的“视图”下“可用字段列表”中，将暂估数量，暂估金额拖动至正文区域。保存格式即可。
创建表失败,请删除该大类后重新创建创建表失败,请删除该大类后重新创建
问题分析：1．使用 ．使用 SQLSQLSQL事件探查器对操作记录进行跟踪 事件探查器对操作记录进行跟踪 事件探查器对操作记录进行跟踪 事件探查器对操作记录进行跟踪 事件探查器对操作记录进行跟踪 事件探查器对操作记录进行跟踪 ，发现在执行插入语句 发现在执行插入语句 发现在执行插入语句 发现在执行插入语句 发现在执行插入语句 Insert intoInsert into Insert intoInsert intoInsert into Insert into Insert into，向项目大类结构表 ，向项目大类结构表 ，向项目大类结构表 ，向项目大类结构表 ，向项目大类结构表 fitemstructurefitemstructurefitemstructurefitemstructure fitemstructurefitemstructurefitemstructurefitemstructure fitemstructure fitemstructure 写 入数据时出现错误。 入数据时出现错误。 入数据时出现错误。
分公司开了发票，款却规定要转到总公司支付宝，总公司定期再把一定时期的款转给分公司，这样有什么税务风险？ 分公司开了发票，款却规定要转到总公司支付宝，总公司定期再把一定时期的款转给分公司，这样有什么税务风险？[]
票据资金流货物流不一致，如果支付宝款项有小金库之嫌的话，会一锅端的
T1和T3普及版能不能共存一台电脑么？ T1和T3普及版能不能共存一台电脑么？[]
可以使用同一台电脑，但是加密狗需要并狗的处理，要不然识别不到两个加密狗。楼上正解@服务社区黄旻:[/玫瑰]@陈增林:[/害羞]@陈增林:怎么并狗处理？@硪T:联系代理商提交商务部处理
用友软件varchar 转换为 tinyint 时出错varchar 转换为 tinyint 时出错
原因分析：存储过程GL_P_FSEYEB有问题。问题解答：第一步：----------------------------首先执行如下脚本，把存储过程删除--------------/****** 对象: StoredProcedure [dbo].[GL_P_FSEYEB] 脚本日期: 07/20/:05 ******/IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GL_P_FSEYEB]') AND type in (N'P', N'PC'))DROP PROCEDURE [dbo].[GL_P_FSEYEB]第二步：---------------------------再执行如下脚本，把正确的存储过程增加-----------------------/****** 对象: StoredProcedure [dbo].[GL_P_FSEYEB] 脚本日期: 07/20/:00 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER OFFGOCREATE Proc [dbo].[GL_P_FSEYEB](@iPer1 varchar(10),@iPer2 varchar(10),@ibk tinyint,@c_code1 varchar(60),@c_code2 varchar(60),@n_jc1 tinyint,@n_jc2 tinyint,@isend tinyint,@kmlx varchar(20) , @exch varchar(20) , @yefw1 varchar(20) ,@yefw2 varchar(20),@kmlxs varchar(500),@TRnd varchar(20)) ASSET NOCOUNT ON declare @ss varchar(8000)set @ss='TempDB..G' +'A'if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G' +'A' exec (@ss) endset @ss='select ccode into TempDB..G' +'A from codewhere code.igrade &= ' +convert(char,@n_jc1,0) + ' ' +(case when (@c_code1) is null then '' else ' and code.ccode &= ''' _code1 + ''' ' end)+(case when (@c_code2) is null then '' else ' and code.ccode &= ''' _code2 + ''' ' end)+(case when (@n_jc2) =0 then '' else ' and code.igrade &= ' +convert(char,@n_jc2,0) + ' ' end)+(case when (@isend) =0 then '' else ' and code.bend =1 ' end)+(case when (@kmlx) is null then ' and code.cclass&&''表外科目''' else ' and code.cclass = '''
+ ''' ' end)+(case when (@exch) is null then '' else ' and code.cexch_name= '''
+ ''' ' end)exec (@ss)set @ss='TempDB..G' +'C'if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G' +'C' exec (@ss) end set @ss='TempDB..G' +'B'if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G' +'B' exec (@ss) endset @ss='select distinct code.ccode into TempDB..G' +'B from code inner join TempDB..G' +'A on code.ccode like (TempDB..G' +'A.ccode+''%'') where code.bend=1'exec (@ss)set @ss='TempDB..G' +'D'if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G' +'D' exec (@ss) endif @ibk=0 beginset @ss='SELECT gl_accvouch.ccode,Sum(case when (iperiod)&'+' then md-mc else 0 end) AS mbb,Sum(case when (iperiod)&='+' then md else 0 end) AS mdd,Sum(case when (iperiod)&='+' then mc else 0 end) AS mcc,Sum(case when (iperiod)&'+' then md_f-mc_f else 0 end) AS mbb_f,Sum(case when (iperiod)&='+' then md_f else 0 end ) AS mdd_f,Sum(case when (iperiod)&='+' then mc_f else 0 end ) AS mcc_f, Sum(case when (iperiod)&'+' then nd_s-nc_s else 0 end) AS mbb_s,Sum(case when (iperiod)&='+' then nd_s else 0 end) AS mdd_s,Sum(case when (iperiod)&='+' then nc_s else 0 end) AS mcc_s,Sum(md) AS mld,Sum(mc) AS mlc,Sum(md_f) AS mld_f,Sum(mc_f) AS mlc_f,Sum(nd_s) AS mld_s,Sum(nc_s) AS mlc_s into TempDB..G' +'D FROM GL_accvouch inner join TempDB..G' +'B on gl_accvouch.ccode=TempDB..G' +'B.ccodeWHERE ibook =0 and iperiod&= 1 and iperiod &= '+' and (iflag is null or iflag=2) GROUP BY gl_accvouch.ccode'+' union all '+'SELECT gl_accsum.ccode,Sum(case when (iperiod)='+' then (case when cbegind_c=''借'' then mb else -mb end) else 0 end) AS mbb,Sum(case when (iperiod)&='+' then md else 0 end) AS mdd,Sum(case when (iperiod)&='+' then mc else 0 end) AS mcc,Sum(case when (iperiod)='+' then (case when cbegind_c=''贷'' then -mb_f else mb_f end ) else 0 end) AS mbb_f,Sum(case when (iperiod)&='+' then md_f else 0 end ) AS mdd_f,Sum(case when (iperiod)&='+' then mc_f else 0 end ) AS mcc_f, Sum(case when (iperiod)='+' then (case when cbegind_c=''贷'' then -nb_s else nb_s end ) else 0 end) AS mbb_s,Sum(case when (iperiod)&='+' then nd_s else 0 end) AS mdd_s,Sum(case when (iperiod)&='+' then nc_s else 0 end) AS mcc_s,Sum(md) AS mld,Sum(mc) AS mlc,Sum(md_f) AS mld_f,Sum(mc_f) AS mlc_f,Sum(nd_s) AS mld_s,Sum(nc_s) AS mlc_s FROM GL_accsum inner join TempDB..G' +'B on gl_accsum.ccode=TempDB..G' +'B.ccodeWHERE iperiod &= '+' GROUP BY gl_accsum.ccode'exec (@ss)set @ss='SELECT code.ccode as ccode,sum(TempDB..G' +'D.mbb) as mbb,sum(TempDB..G' +'D.mdd) as mdd,sum(TempDB..G' +'D.mcc) as mcc,sum(TempDB..G' +'D.mld) as mld,sum(TempDB..G' +'D.mlc) as mlc,sum(TempDB..G'+'D.mbb_f) as mbb_f,sum(TempDB..G'+'D.mdd_f) as mdd_f,sum(TempDB..G'+'D.mcc_f) as mcc_f,sum(TempDB..G'+'D.mld_f) as mld_f,sum(TempDB..G'+'D.mlc_f) as mlc_f,sum(TempDB..G' +'D.mbb_s) as mbb_s,sum(TempDB..G' +'D.mdd_s) as mdd_s,sum(TempDB..G' +'D.mcc_s) as mcc_s,sum(TempDB..G' +'D.mld_s) as mld_s,sum(TempDB..G' +'D.mlc_s) as mlc_s into TempDB..G' +'C FROM code inner join TempDB..G' +'D on TempDB..G' +'D.ccode like (code.ccode + ''%'') GROUP BY code.ccode'endelsebeginset @ss='SELECT gl_accsum.ccode,Sum(case when (iperiod)='+' then (case when cbegind_c=''借'' then mb else -mb end) else 0 end) AS mbb,Sum(case when (iperiod)&='+' then md else 0 end) AS mdd,Sum(case when (iperiod)&='+' then mc else 0 end) AS mcc,Sum(case when (iperiod)='+' then (case when cbegind_c=''贷'' then -mb_f else mb_f end ) else 0 end) AS mbb_f,Sum(case when (iperiod)&='+' then md_f else 0 end ) AS mdd_f,Sum(case when (iperiod)&='+' then mc_f else 0 end ) AS mcc_f, Sum(case when (iperiod)='+' then (case when cbegind_c=''贷'' then -nb_s else nb_s end ) else 0 end) AS mbb_s,Sum(case when (iperiod)&='+' then nd_s else 0 end) AS mdd_s,Sum(case when (iperiod)&='+' then nc_s else 0 end) AS mcc_s,Sum(md) AS mld,Sum(mc) AS mlc,Sum(md_f) AS mld_f,Sum(mc_f) AS mlc_f,Sum(nd_s) AS mld_s,Sum(nc_s) AS mlc_s into TempDB..G' +'D FROM GL_accsum inner join TempDB..G' +'B on gl_accsum.ccode=TempDB..G' +'B.ccodeWHERE iperiod &= '+' GROUP BY gl_accsum.ccode' exec (@ss)set @ss='SELECT code.ccode as ccode,sum(TempDB..G' +'D.mbb) as mbb,sum(TempDB..G' +'D.mdd) as mdd,sum(TempDB..G' +'D.mcc) as mcc,sum(TempDB..G' +'D.mld) as mld,sum(TempDB..G' +'D.mlc) as mlc,sum(TempDB..G'+'D.mbb_f) as mbb_f,sum(TempDB..G'+'D.mdd_f) as mdd_f,sum(TempDB..G'+'D.mcc_f) as mcc_f,sum(TempDB..G'+'D.mld_f) as mld_f,sum(TempDB..G'+'D.mlc_f) as mlc_f,sum(TempDB..G' +'D.mbb_s) as mbb_s,sum(TempDB..G' +'D.mdd_s) as mdd_s,sum(TempDB..G' +'D.mcc_s) as mcc_s,sum(TempDB..G' +'D.mld_s) as mld_s,sum(TempDB..G' +'D.mlc_s) as mlc_s into TempDB..G' +'C FROM code inner join TempDB..G' +'D on TempDB..G' +'D.ccode like (code.ccode + ''%'') GROUP BY code.ccode'endexec (@ss)-----------------------------------------------set @ss='TempDB..G' +'B'if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+'B' exec (@ss) endif not @yefw1 is null or not @yefw2 is null beginset @ss='select TempDB..G' +'C.ccode into TempDB..G' +'B fromTempDB..G' +'C inner join TempDB..G' +'A on TempDB..G' +'A.ccode=TempDB..G' +'C.ccode where '+case when @yefw1 is null then '' else ' ABS(TempDB..G'+'C.mbb+TempDB..G'+'C.mdd-TempDB..G'+'C.mcc)&=' end+case when @yefw2 is null then '' else case when @yefw1 is nullor @yefw1='' then '' else ' and ' end +' ABS(TempDB..G'+'C.mbb+TempDB..G'+'C.mdd-TempDB..G'+'C.mcc)&=' endexec (@ss)endelsebeginset @ss='SELECT TempDB..G' +'A.ccode into TempDB..G' +'B FROM TempDB..G' +'A 'exec (@ss)end------------------------------------========================================================--yxw 因为小于0的条件没有问题，所以针对大于0时把A表不满足条件的科目去掉，避免重复相加。set @ss='TempDB..G' +'G'if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+'G' exec (@ss)
endset @ss='TempDB..G' +'H'if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+'H' exec (@ss) endif not @yefw1 is nullbeginset @ss='select TempDB..G' +'C.ccode into TempDB..G' +'G from TempDB..G' +'C inner join TempDB..G' +'A on TempDB..G' +'A.ccode=TempDB..G' +'C.ccode where '+' ABS(TempDB..G'+'C.mbb+TempDB..G'+'C.mdd-TempDB..G'+'C.mcc)&=' exec (@ss)set @ss='select * into TempDB..G' +'H from TempDB..G' +'A where TempDB..G' +'A.ccode not in (select * from TempDB..G' +'G)'exec (@ss)set @ss='TempDB..G' +'A'if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+'A' exec (@ss) endset @ss='select * into TempDB..G'+'A from TempDB..G' +'G'exec (@ss)end--========================================================set @ss='TempDB..G' +'D'if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+'D' exec (@ss) endset @ss='select TempDB..G' +'A.ccode,count(*) as bs into TempDB..G' +'D from TempDB..G' +'A inner join TempDB..G' +'B on TempDB..G' +'A.ccode like (TempDB..G'+'B.ccode+''%'') group by TempDB..G' +'A.ccode'exec (@ss)set @ss='TempDB..G' +'A'if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+'A' exec (@ss) endset @ss='SELECT code.ccode into TempDB..G' +'A FROM code inner join TempDB..G'+'B on TempDB..G' +'B.ccode=code.ccode where not code.cexch_name is null'exec (@ss)set @ss='TempDB..G' +'E'if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+'E' exec (@ss) endset @ss='SELECT TempDB..G' +'A.ccode into TempDB..G' +'E FROM TempDB..G' +'A 'exec (@ss)set @ss='TempDB..G' +'F'if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+'F' exec (@ss) endset @ss='select TempDB..G' +'A.ccode,count(*) as bs into TempDB..G' +'F from TempDB..G' +'A inner join TempDB..G' +'E on TempDB..G' +'A.ccode like (TempDB..G'+'E.ccode+''%'') group by TempDB..G' +'A.ccode'exec (@ss)set @ss='SELECT '
+ ',code.ccode,code.ccode_name,code.cexch_name,sum(case when TempDB..G' +'C.mbb&0 then TempDB..G' +'C.mbb else 0 end) as sbb,sum(case when TempDB..G' +'C.mbb&0 then 0 else ABS(TempDB..G' +'C.mbb) end) as sbb1,sum(TempDB..G' +'C.mdd) as smd,sum(TempDB..G'nd +'C.mcc) as smc,sum(TempDB..G' +'C.mld) as sld,sum(TempDB..G' +'C.mlc) as slc,sum(case when TempDB..G' +'C.mbb+TempDB..G' +'C.mdd-TempDB..G' +'C.mcc&0 thenTempDB..G' +'C.mbb+TempDB..G' +'C.mdd-TempDB..G' +'C.mcc else 0 end) as smm,sum(case when TempDB..G' +'C.mbb+TempDB..G' +'C.mdd-TempDB..G' +'C.mcc&0 then0 else ABS(TempDB..G' +'C.mbb+TempDB..G' +'C.mdd-TempDB..G' +'C.mcc) end) as smm1,sum(case when (code.cexch_name) is null then 0 else TempDB..G'+'C.mbb_f end) as sbb_f,sum(case when (code.cexch_name) is null then 0 else TempDB..G'+'C.mdd_f end) as smd_f,sum(case when (code.cexch_name) is null then 0 else TempDB..G'+'C.mcc_f end) as smc_f,sum(case when (code.cexch_name) is null then 0 else TempDB..G'+'C.mld_f end) as sld_f,sum(case when (code.cexch_name) is null then 0 else TempDB..G'+'C.mlc_f end) as slc_f,sum(case when (code.cexch_name) is null then 0 else TempDB..G' +'C.mbb_f+TempDB..G' +'C.mdd_f-TempDB..G' +'C.mcc_f end) as smm_f,sum(case when (code.cmeasure) is null then 0 else TempDB..G' +'C.mbb_s end) as sbb_s,sum(case when (code.cmeasure) is null THEN 0 else TempDB..G' +'C.mdd_s end) as smd_s,sum(case when (code.cmeasure) is null then 0 else TempDB..G' +'C.mcc_s end) as smc_s,sum(case when (code.cmeasure) is null THEN 0 else TempDB..G' +'C.mld_s end) as sld_s,sum(case when (code.cmeasure) is null then 0 else TempDB..G' +'C.mlc_s end) as slc_s,sum(case when (code.cmeasure) is null then 0 else TempDB..G' +'C.mbb_s+TempDB..G' +'C.mdd_s-TempDB..G' +'C.mcc_s end) as smm_s FROM code inner join TempDB..G' +'C ON TempDB..G' +'C.ccode=code.ccode inner join TempDB..G' +'B oncode.ccode=TempDB..G' +'B.ccode GROUP BY code.cclass,code.ccode,code.ccode_name,code.cexch_name'+' union all '+'SELECT '+',''zz'' as ccode, '''' as ccode_name,'''' as cexch_name,sum(case when TempDB..G' +'C.mbb&0 then TempDB..G' +'C.mbb else 0 end) as sbb,sum(case when TempDB..G' +'C.mbb&0 then 0 else ABS(TempDB..G' +'C.mbb) end) as sbb1,sum(TempDB..G' +'C.mdd) as smd,sum(TempDB..G' +'C.mcc) as smc,sum(TempDB..G' +'C.mld) as sld,sum(TempDB..G' +'C.mlc) as slc,sum(case when TempDB..G' +'C.mbb+TempDB..G' +'C.mdd-TempDB..G' +'C.mcc&0 thenTempDB..G' +'C.mbb+TempDB..G' +'C.mdd-TempDB..G' +'C.mcc else 0 end) as smm,sum(case when TempDB..G' +'C.mbb+TempDB..G' +'C.mdd-TempDB..G' +'C.mcc&0 then0 else ABS(TempDB..G' +'C.mbb+TempDB..G' +'C.mdd-TempDB..G' +'C.mcc) end) as smm1,0 as sbb_f,0 as smd_f,0 as smc_f,0 as sld_f,0 as slc_f,0 as smm_f,0 as sbb_s,0 as smd_s,0 as smc_s,0 as sld_s,0 as slc_s,0 as smm_s FROM TempDB..G' +'C inner join (code inner join TempDB..G' +'D ON code.ccode=TempDB..G' +'D.ccode) ON code.ccode=TempDB..G'+'C.ccode where TempDB..G' +'D.bs=1 GROUP BY code.cclass '+'union all '+'SELECT ' + ', ''zzzz''+code.cexch_name as ccode, '''' as ccode_name,'''' as cexch_name,0 as sbb,0 as sbb1,0 as smd,0 as smc,0 as sld,0 as slc,0 as smm,0 as smm1,sum(TempDB..G'+'C.mbb_f) as sbb_f,sum(TempDB..G'+'C.mdd_f) as smd_f,sum(TempDB..G'+'C.mcc_f) as smc_f,sum(TempDB..G'+'C.mld_f) as sld_f,sum(TempDB..G'+'C.mlc_f) as slc_f,sum(TempDB..G' +'C.mbb_f+TempDB..G' +'C.mdd_f-TempDB..G' +'C.mcc_f) as smm_f,0 as sbb_s,0 as smd_s,0 as smc_s,0 as sld_s,0 as slc_s,0 as smm_s FROM TempDB..G' +'C inner join code inner join TempDB..G' +'F ON code.ccode=TempDB..G' +'F.ccode ON code.ccode=TempDB..G'+'C.ccode '+'where TempDB..G' +'F.bs=1'+'GROUP BY code.cclass,code.cexch_name' +' union all SELECT 9 as lx,''zz'' as ccode, '''' as ccode_name,'''' as cexch_name,sum(case when TempDB..G' +'C.mbb&0 then TempDB..G' +'C.mbb else 0 end) as sbb,sum(case when TempDB..G' +'C.mbb&0 then 0 else ABS(TempDB..G' +'C.mbb) end) as sbb1,sum(TempDB..G' +'C.mdd) as smd,sum(TempDB..G' +'C.mcc) as smc,sum(TempDB..G' +'C.mld) as sld,sum(TempDB..G' +'C.mlc) as slc,sum(case when TempDB..G' +'C.mbb+TempDB..G' +'C.mdd-TempDB..G' +'C.mcc&0 thenTempDB..G' +'C.mbb+TempDB..G' +'C.mdd-TempDB..G' +'C.mcc else 0 end) as smm,sum(case when TempDB..G' +'C.mbb+TempDB..G' +'C.mdd-TempDB..G' +'C.mcc&0 then0 else ABS(TempDB..G' +'C.mbb+TempDB..G' +'C.mdd-TempDB..G' +'C.mcc) end) as smm1,0 as sbb_f,0 as smd_f,0 as smc_f,0 as sld_f,0 as slc_f,0 as smm_f,0 as sbb_s,0 as smd_s,0 as smc_s,0 as sld_s,0 as slc_s,0 as smm_s FROM TempDB..G' +'C inner join TempDB..G' +'D ONTempDB..G' +'C.ccode=TempDB..G' +'D.ccode where TempDB..G' +'D.bs=1 '+'union all '+'SELECT 9 as lx, ''zzzz''+code.cexch_name as ccode, '''' as ccode_name,'''' as cexch_name,0 as sbb,0 as sbb1,0 as smd,0 as smc,0 as sld,0 as slc,0 as smm,0 as smm1,sum(TempDB..G'+'C.mbb_f) as sbb_f,sum(TempDB..G'+'C.mdd_f) as smd_f,sum(TempDB..G'+'C.mcc_f) as smc_f,sum(TempDB..G'+'C.mld_f) as sld_f,sum(TempDB..G'+'C.mlc_f) as slc_f,sum(TempDB..G' +'C.mbb_f+TempDB..G' +'C.mdd_f-TempDB..G' +'C.mcc_f) as smm_f,0 as sbb_s,0 as smd_s,0 as smc_s,0 as sld_s,0 as slc_s,0 as smm_s FROM TempDB..G' +'C inner join code inner join TempDB..G' +'F ON code.ccode=TempDB..G' +'F.ccode ON code.ccode=TempDB..G'+'C.ccode where TempDB..G' +'F.bs=1'+'GROUP BY code.cexch_name order by lx,code.ccode ' exec (@ss)set @ss='TempDB..G' +'A'if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+'A' exec (@ss) endset @ss='TempDB..G' +'B'if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+'B' exec (@ss) endset @ss='TempDB..G' +'C'if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+'C' exec (@ss) endset @ss='TempDB..G' +'D'if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+'D' exec (@ss) endset @ss='TempDB..G' +'E'if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+'E' exec (@ss) endset @ss='TempDB..G' +'F'if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+'F' exec (@ss) endset @ss='TempDB..G' +'G'if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+'G' exec (@ss) endset @ss='TempDB..G' +'H'if not object_id(@ss) is null begin set @ss='DROP TABLE TempDB..G'+'H' exec (@ss) end
工资模块操作员权限设置原因分析：工资权限设置需要在工资模块中赋予相应工资项目及部门权限才可使用。问题解答：先在系统管理中将操作员设置客户账套“工资管理”的权限。然后先用账套主管（例如demo）登陆账套，在菜单 “工资”－“设置”－“权限设置”，选择操作员，点“修改”然后赋予此操作员操作工资类别主管权限后，使用新增操作员可以登陆工资模块并使用工资。
用友畅捷通T3保存凭证提示不满足凭证必有条件，借方贷方必有条件t3保存凭证提示不满足凭证必有条件
标题:保存凭证提示不满足凭证必有条件问题现象:填制凭证后保存提示：&不满足凭证必有条件&，无法保存。原因分析:见问题答案。问题答案:1、查看在&基础设置&-&财务&-&凭证类别&中的凭证类别设置了&限制科目&及&限制类型&。
用友T3用友通采购订单列表不能按项目查询用友T3用友通采购订单列表不能按项目查询
有一装饰公司需要按订单控制装饰项目的采购和用料情况，但在采购订单列表查询中无项目过滤条件。进入采购订单列表后，点‘格式’，找到项目编码、项目大类编码、项目名称、项目大类名称后，将对应的显示项打上勾，确认后，再次过滤时，就有项目过滤条件了。
赵树峰老师你好，听到你讲的初级会计实务非常好。想听你讲的初级经济法基础在哪儿能听到、 赵树峰老师你好，听到你讲的初级会计实务非常好。想听你讲的初级经济法基础在哪儿能听到、[]
经济法基础是曾雪枫老师讲的，讲堂里有，赵老师没讲[/龇牙]谢谢！很少有老师讲全科的吧@yiyiyaya:同感[/憨笑][/憨笑]
赵老师，请问财务状况表具体指什么？ 赵老师，请问财务状况表具体指什么？[]
财务状况变动表吧？财务状况变动表是根据企业在一定时期内资产项目和权益项目的增减变动来揭示资金的流入，流出和转换的会计报表。财务状况变动表的主要作用是反映企业在报告期内财务状况的全貌，并沟通了损益表和资产负债表。
1、2、3、4、5、6、7、8、9、10、
用友软件T3恢复账套数据的三种方法用友软件恢复数据的三种方法由于各种原因，会导致当前的电脑系统出现问题，进而用友通软件无法正常使用，那么如何在新的系统上把用友T3的数据恢复，用以后续正常使用软件呢？下面就几种情形下谈谈如何快速恢复用友通的数据。1、最简单的方法。当然就是用用友通自身的系统管理备份了帐套数据，如果发生意外情况，那么只需要在新的系统中安装数据库、用友通软件，然后登陆系统管理，选择之前已经备份的数据，进行帐套恢复即可。优点：操作简单，一般的用户都会自行恢复数据；缺点：A、需要客户养成定期备份数据的习惯；B、由于备份数据是定时备份或者操作者自行备份的，所以恢复帐套之后，需要手工把备份帐套到丢失帐套期间所缺少的业务数据重新补录一遍；C、为了尽可能的保证备份数据的完整，建议做自动备份的计划；2、比较简单的方法。在新的系统中安装数据库、用友通软件，然后建立对应的帐套，然后再停止SQL数据库的服务，拷贝之前的帐套对应文件夹替换新系统中建立的文件夹及文件，再重新启动SQL数据库服务和用友通服务，进入软件即可。优点：此种方法一般用户在掌握要领之后，也比较好操作，但是需要注意以下几点：A、建立帐套时的年度选择应该是对应帐套的第一个年度，启用月份、启用模块、帐套的参数需要保持一致；B、建立完第一个年度之后，需要以帐套主管登陆系统管理，建立后续的年度帐；C、如果不能把握当初的帐套参数，可以在替换文件时，把ufsmart\admin\ufsystem.mdf和ufsystem.ldf也替换，但是前提是文件夹的位置要和之前的位置一样；缺点：如果软件使用者把数据安装在C盘，系统盘c盘崩溃了，则需要专业的技术人员才能取到数据，进行后续的数据恢复工作；所以建议再安装软件时，请都安装到系统盘之外的盘符；3、复杂的恢复方法。能找到之前用友的文件夹，尤其是存在帐套数据的ADMIN文件夹，然后在新系统中安装SQLserver个人版或标准版，再安装用友通软件，并进系统管理，由软件自动创建系统库和演示帐套；接下来进入SQLSERVER的企业管理器，先分离ufsystem数据库，再通过SQLserver的附加数据库，把之前的ufsystem.mdf、ufsystem.ldf以及对账的帐套文件各年度都附加就可以缺点：需要安装带有SQL管理工具的SQL200个人版或者专业版，如果仅安装了MSDE，则需要再使用相应的SQL管理工具才可以；优点：不需要再建立多个帐套及年度帐，大大节省了时间。尤其当帐套和年度都比较多时，此种方法尤为有效。总之，希望大家在使用用友通软件时，都不会遇到各种的状况。万一不幸遇到了一些状况，也不需要着急，尽可以用以上的几种方法来恢复数据，最大程度的减少损失。
对master库执行如下语句可以解决此问题：sp_configure 'allow updates', 1 & &RECONFIGURE WITH OVERRIDEgouse mastergoif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_password]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
这怎么弄呢，怎么能做本年累计数呢 这怎么弄呢，怎么能做本年累计数呢
您要按照会计的要求录入期初余额，具体录入的数据您咨询一下您企业的会计@畅捷服务李笑旺:您在填写期初余额的时候要按照资产=负债+所有者权益关系填写，损益一般不录入期初不是说损益不录吗，资产=负债+所有者权益那损益期初要录吗@:不用那累计数怎么弄呢这个你根据上一期的资产负债表来录就可以了一定会平的，这个是会计恒等式来的@QQ__用友张秋同:所以你还没录好啊
这是T3什么版本？ 这是T3什么版本？
T3-10.8plus1 版本。@服务社区_郝瑞然_:用友通普及版有补丁吗？@三明鑫创Yan: 具体是标准版还是普及版请在防伪官网查询下是普及版还是标准版，http://tregister.chanjet.com/chaxun.aspx然后根据普及版或者标准版在补丁下载地址中进行下载，http://service.chanjet.com/chanjet/T3@服务社区_郝瑞然_:这个可以装T3-10.8.1财务通普及版吗？@三明鑫创Yan:这个是10.8plus1 普及版软件，补丁下载链接：http://sto.chanapp.chanjet.com ... G.rar注：做任何操作之前一定要备份下账套数据。
| Copyright &
dianhua.kuaiji66.com &All Rights Reserved 精彩会计生活 &北京天龙瑞德&版权所有 & 北京海淀上地十街辉煌国际大厦3-609&总机：010- & 售后：