客户新购软件,新安装,新帐套,新电脑,新系统。系统日期格式也改过了。12.000.001.0088
2019-4-5 8:0:0 用友NC小编客户新购软件,新安装,新帐套,新电脑,新系统。系统日期格式也改过了。12.000.001.0088
客户新购软件,新安装,新帐套,新电脑,新系统。系统日期格式也改过了。12.000.001.0088原因分析: 日期格式没有设置好或者为ghost系统
解决方案:
(1)将系统长日期格式设置为yyyy'年'M'月'd'日',短日期格式设置为yyyy-MM-dd
(2)如果是ghost系统,需要更换成纯净版系统,部分ghost系统长短日期格式没有以上格式或由于缺少相关组件导致报错
到注册表中也进行修改:HKEY_USERS\.DEFAULT\Control Panel\International\sLongDate检查下注册表中,应该是没有改对。检查操作系统的 纯净度。排查是否ghost定制系统。
日期格式需要 YYYY-MM-DD 形式。--纯静的系统,长日期格式有,改了不行@鼎峰冯世盛:这个就是时间的问题了,今天这边电脑也出现过同样的提示,注册表和日期格式修改好就能正常了,您修改之后重新配置下数据库,再不行那只能重新安装了。
如果您的问题还没有解决,可以到 T+搜索>>上找一下
相关阅读
- 用友T3通2005版2005年度查明细账总账第一列日期显示1999年2019-4-5 8:0:0
- 用友T6企业管理软件中打开工资模块时提示“区域选项日期标签页中的短日期格式应设置为yyyy-MM-d2019-4-5 8:0:0
- 用友记账宝创建账套保存时提示“启用期间过小”?2019-4-5 8:0:0
- 通2005在查询2005年明细账时左边日期却出现1999年但发生额和内容是正确。安月排序2005日期2019-4-5 8:0:0
- 通2005版2005年度查明细账,总账第一列日期显示1999年2019-4-5 8:0:0
- 用友U8其他UFO报表函数错或函数定义错2019-4-5 8:0:0
- 用友U8其他UFO报表资产负债表公式取数不对,现金流量表取不到数2019-4-5 8:0:0
- 用友U8其他保存报表时提示保存失败问题2019-4-5 8:0:0
- 用友U8其他发货单录入后,在发货单列表中有显示,但是在发货单界面下无法查询到2019-4-5 8:0:0
- 你好老师,我这有个客户用的T3标准版10.8plus1,客户端安装好后,能连接到服务器,但是一点击核算管理,就提示子系统注册失败,请问是怎么回事2019-4-5 8:0:0
最新信息
T3 10.8.2 普及版 客户发现2015年账有问题,就重新调整后。2015年也是平的 。总账和明细账是一致的。在重新做了年节后,造成 应收应付总账和明细账余额不平 。 T3 10.8.2 普及版 客户发现2015年账有问题,就重新调整后。2015年也是平的 。总账和明细账是一致的。在重新做了年节后,造成 应收应付总账和明细账余额不平 。
你按照余额结转方式结转试一下就是余额结转的 ,在2015年里是平的,结转后就发生总账和明细账余额不平看有没有凭证记账了。如果还是不行就发数据给服务器检查一下吧是期初就不平的,怎么会有记账
委外产成品入库的时候参照不到对应的“委外订单” 委外产成品入库的时候参照不到对应的“委外订单”
问题号: | 28150 |
---|---|
适用产品: | T6系列 |
软件版本: | 1089-T6-企业管理软件V6.0 |
软件模块: | 829-委外管理 |
问题名称: | 委外产成品入库的时候参照不到对应的“委外订单” |
问题现象: | <P>填写的委外订单,没有做委外材料出库单,委外产成品入库的时候参照不到对应的“委外订单”?</P> |
问题原因: | 软件操作使用问题。 |
关键字: | 入库参照不到委外订单 |
解决方案: | 在库存管理模块—选项—专用设置,把“委外领料后方可入库”的勾去掉! |
行业: | 0-通用 |
补丁编号: | |
解决状态: | 1-临时解决方案 |
录入日期: | 2016-03-16 15:23:45 |
最后更新时间: |
- 用友U8 812工资汇总工资类别的数据不正确
- 用友U8 812无法升级到852
- 用友U8 813 ufo报表打不开,提示‘年度错误’
- 用友U8 813 ufo报表打不开,提示‘年度错误’_0
- 用友U8 “机器考勤数据符合要求的格式:考勤卡号+分隔符号+刷卡日期+分隔符号+刷卡时间;分隔符号:空格;刷卡日期格式:YYYY-MM-DD ;刷卡时间格式:HH24-MM-SS”这句话是考勤管理帮助中的,我反复看也没看懂,请举个例子详细说明一下。现用户要求刷卡机的考勤数据导入考勤管理中。
- 用友U8 发货单录入后,在发货单列表中有显示,但是在发货单界面下无法查询到(只有工作站有这种现象)
- 用友U8 合同打开后,做合同结算时,选择日期后,显示没有找到单据.其他客户端正常,是本机环境问题.
- 用友U8 填制凭证时报运行时错误“5”等错误
- 用友U8 填制凭证时提示‘tempdb无效,未指定表名’
- 用友U8 客户端查询银行日记账没有数据出现,其他客户端和服务器正常
用友U8 订单变更列表的栏目设置(表体自定义项)不能保存,关掉当前窗口下次进入又变了用友U8 订单变更列表的栏目设置(表体自定义项)不能保存,关掉当前窗口下次进入又变了
问题原因:在栏目中直接修改名称无法保存 解决方法:可以进入基础设置页签—》基础档案—》其他—》自定义项—》在这里选择您要修改的自定义项更改名称即可。
解决方案:
问题原因:在栏目中直接修改名称无法保存 解决方法:可以进入基础设置页签—》基础档案—》其他—》自定义项—》在这里选择您要修改的自定义项更改名称即可。
期间损益结转出错 _0期间损益结转出错
问题号: | 13698 |
---|---|
解决状态: | 最终解决方案 |
软件版本: | 8.52 |
软件模块: | 总账 |
行业: | 通用 |
关键字: | 期间损益结转出错 |
适用产品: | U8 |
问题名称: | 期间损益结转出错 |
问题现象: | 期间损益结转出错,active429 |
问题原因: | 发现不是软件控件异常, |
解决方案: | 删除定义后重设正常,原来是数据库定义内容丢失 |
补丁编号: | |
录入日期: | 2016-03-16 15:23:45 |
最后更新时间: |
- 你好- 客户开票日期格式原来是yyyy-mm-dd,开了一部分销售单,单号是每天递增, 但是我给把格式改成yyyy-m-d,在开销售单票号又0001开始递增(做了29张单据),现在在软件里就找不到这29张单据,但是总库存数已经减少了,
- 你好,t3 10.8.1打开总账提示如下,计算机名合适着,会是什么问题?
- 保存凭证的时候出现在这个提示 从字符串转换到日期或时间时 转换失败 改过日期格式了 还是不行
- 您好u8装什么操作系统合适?
- 我想试用下用友T3,但不会安装,能否帮忙?
- 新建年度帐时报错
- 新装打开系统管理提示运行时错误字符串之前有未闭合的引号,怎么处理
- 点击模块提示如下图
- 用友T3软件打开时出现:Automation 错误(-2147024770),然后点击确定,软件就关闭了,请问怎么解决
- 用友通精算普及版 核算模块无法打开 出现如图提示 原因为何 如何解决?
T+12.1做单模糊查询客户档案的时候,出来很多个重复的客户信息,这是怎么回事 T+12.1做单模糊查询客户档案的时候,出来很多个重复的客户信息,这是怎么回事
请打开此往来单位档案重新保存一下。@服务社区刘佳佳:没效果,而且是所有档案都这样。不可能一个个去打开啊。
定期性赠与契约书 定期性赠与契约书
赠与者x x x(以下简称甲方)
受赠者x x x(以下简称乙方)
双方就定期性赠与事宜缔结契约如下:
第一条 甲方提供乙方监护、养育其子x x x(以下简称丙方)的养育补助费,于每年六月底及十二月底,无偿赠与人民币各x x元整。
第二条 前条定期赠与期间,自x x x x年六月三十日始至丙方成年为止。
第三条 乙、丙双方倘有不良行为依刑法有关处罚之明文者,甲方可撤销本契约。
- 用友U8 812工资汇总工资类别的数据不正确
- 用友U8 812无法升级到852
- 用友U8 813 ufo报表打不开,提示‘年度错误’
- 用友U8 813 ufo报表打不开,提示‘年度错误’_0
- 用友U8 升级报日期错,显示日期格式不对!
- 用友U8 填制凭证时报运行时错误“5”等错误
- 用友U8 填制凭证时提示‘tempdb无效,未指定表名’
- 用友U8 局域网,服务器server2000,在进入报表时,只能登陆到选择操作员界面,然后就一点反映也没有.在之前服务器没出问题时都正常,而且在客户端报表使用都正常.服务器是重做的系统.
- 用友U8 某台客户端用账套主管身份登陆查询银行日记账没有数据出现也没有错误提示,其他机器一切正常,重新安装U8也未能解决
- 用友U8 查询现金日记帐与银行日记帐从char数据类型转换成smalldata类型值超界
在存货页面,图片显示只能出来当页的图片,比如每页显示500条,当前页面只能够显示20条,20条的图片是正常的,鼠标往下滑看其他存货条数,图片显示是不对的,自己新建账套测试也存在这样问题 在存货页面,图片显示只能出来当页的图片,比如每页显示500条,当前页面只能够显示20条,20条的图片是正常的,鼠标往下滑看其他存货条数,图片显示是不对的,自己新建账套测试也存在这样问题
根据您提供的截图是图片不会跟随行显示把,这个您可以通过调整下浏览器的显示比例再看下。
MRP运算结果不对MRP运算结果不对
|
- 银行对账单导入的时候,提示时间错误-
- 保存报表时提示保存失败问题
- 用友安装之后,进去点总账,出现“Automation错误”,这是什么原因
- 用友T3通2005版2005年度查明细账总账第一列日期显示1999年
- 用友T6企业管理软件中打开工资模块时提示“区域选项日期标签页中的短日期格式应设置为yyyy-MM-d
- 用友记账宝创建账套保存时提示“启用期间过小”?
- 通2005在查询2005年明细账时左边日期却出现1999年但发生额和内容是正确。安月排序2005日期
- 通2005版2005年度查明细账,总账第一列日期显示1999年
- 用友安装之后,进去点总账,出现“Automation错误”,这是什么原因
- 用友T3-财务通普及版10.8plus1无此任务号,不能释放?
请教:施工企业劳务做人工工资和开具劳务发票那个更能省,各自需要注意什么税种? 请教:施工企业劳务做人工工资和开具劳务发票那个更能省,各自需要注意什么税种?[]
如果发工资应该作为员工管理,还有交社会保险的义务,开劳务费没这个义务,但是劳务费个税比工资个税高一些但是农民工都买了工程意外保险,还需要交社保吗?做为员工管理就有交社保义务了开具劳务发票怎么开呢?不能抵扣怎么办?
利润表费用类的科目想取到贷方发生数 利润表费用类的科目想取到贷方发生数
问题号: | 28411 |
---|---|
适用产品: | T6系列 |
软件版本: | 1089-T6-企业管理软件V6.0 |
软件模块: | 2-UFO报表 |
问题名称: | 利润表费用类的科目想取到贷方发生数 |
问题现象: | 费用类的科目在填制凭证时又记在贷方,利润表取数时能否把借方和贷方发生数都取到? |
问题原因: | 在填制费用凭证时,不想记借方红字表示,但在利润表中取不到费用的贷方数,通过设置条件公式,可以取到贷方数。 |
关键字: | 利润表 |
解决方案: | UFO报表–利润表,在格式状态下,点开费用科目的公式单元,修改公式,把公式设置为条件发生,取科目性质相反方向的发生数,摘要输入期间损益结转,即可以取到期间损益结转凭证中的发生数。 |
行业: | 0-通用 |
补丁编号: | |
解决状态: | 2-最终解决方案 |
录入日期: | 2016-03-16 15:23:45 |
最后更新时间: |
- 用友在U821升级到U852的过程中,升级失败
- T3标准版,在打开“系统管理”的时候提示如图错误,请各位老师帮忙解决一下。
- T3登录就报错了
- T3登录时页面一堆问号。进系统管理也是乱码?这是怎么回事
- T3的系统管理打不开,提示有
- T3自动备份怎么老是生成不了备份文件?
- T6 V6.1版本客户端登陆提示运行时错误‘0’ ;原先是正常可以使用的,只是在升级完T3账套后就不能允许了;
- win2008服务器和sql2008r2数据库,自动备份每天生成空文件夹没数据。
- win2008服务器和sql2008r2数据库,自动备份每天生成空文件夹没数据。还有几套账空文件夹都没有生成
- win7 64位 装T3 10.8.2,出现这样的问题,如附件,怎么解决,
你好t1提示数据库已经打开请关闭后在运行,这什么意思?怎么操作谢谢? 你好t1提示数据库已经打开请关闭后在运行,这什么意思?怎么操作谢谢?[]
是您的数据库文件basedb.mdb损坏,您先将商贸宝U盘里面的basedb.mdb拷贝出来之后,复制在其他磁盘备份好。将将商贸宝U盘里面的backup文件夹中最新修改时间最靠前的备份数据(文件名例如 BaseDB2015-05-19-16-23-15.abk)重命名为basedb.mdb然后将其拷贝到商贸宝U盘里面覆盖basedb.mdb文件,系统会提示您是否覆盖,您点击是。覆盖之后在重新运行商贸宝U盘版软件。@服务社区李珊:我这个光盘版的可以吗?带的个卡片?@fan范:若是大众版的也是一样处理方式。@服务社区李珊:噢谢谢@fan范:不客气的,祝您工作愉快![/微笑]@服务社区李珊:你好,显示备份成功但是就是没有备份下文件什么原因能不能远程给调试下了?@fan范:抱歉,社区是在线服务,不能直接远程。若是需要远程服务,需要经销商帮您处理。您可以全盘搜索 bak或是abk结尾的文件,看下是否存在,文件名例如 BaseDB2015-05-19-16-23-15.abk,后面日期是您备份的日期@服务社区李珊:之前没有备份文件,现在怎么弄回?@服务社区李珊:我能不能把数据库发给你你帮我处理下?@fan范:若是没有任何备份数据,需要联系代理商,将您的basedb.mdb文件在支持网 http://support.chanjet.com提交,有数据工程师帮您进行检测修复。社区是在线服务,不能直接处理数据问题,抱歉。@服务社区李珊:你好进来这个网址电那个咨询?@fan范:必须要经销商账号才可以提交的,您是客户是没有权限的。需要联系代理商帮您提交
#财税实务#老师们,请问:如果买的报税盘,金税盘共1050元,不做认证抵扣了,是不是可以直接进管理费用使用啊 #财税实务#老师们,请问:如果买的报税盘,金税盘共1050元,不做认证抵扣了,是不是可以直接进管理费用使用啊[]
去税局备案,是可以全额抵扣的,先进管理费用,后面抵扣了再转出,不抵扣不是浪费了1050元吗,先抵扣了再进费用不是一样的吗,有效期不是有180天么?抵扣了就不能全部进费用了这个是可以直接全额抵减增值税的,不可以作为进项税额抵扣。在填列在申报表中的应纳税额减征额这栏里。不去认证就会形成滞留票 应该去认证@陈A7V: 技术维护费和税控盘是不可以认证的,认证之后还得做进项转出。@Nano:是要认证的 但是不需抵扣进项税 所以也没有转出一说入固定资产 然后全额记减免税款 再通过折旧实现递延收益@Nano: 我们这边一律不准认证,直接全额抵减当月应纳税额。而且也不用进固定资产,直接进费用就行。最新会计准则取消了进入递延收益的做法,而应该直接计入营业外收入,我前几天刚去北京培训完。@Nano:哦 我用的是14年的规定处理的 最新的还真的没接触呢 不过认证的问题是前几天才咨询了国税的 那边说要认证 否则会形成滞留票 所以~~呵呵 你有这么及时的新政策新知识培训的机会 真是好羡慕!!@陈A7V: 嗯我们这边认证就涉嫌偷税[/流泪],税务局这么答复的。我们这也不用认证,全额抵扣。@Nano:账务上怎么处理呢?@勿忘初心1437751819: 借:管理费用
贷:库存现金
借:应交税费--应交增值税(减免税款)
贷:营业外收入#财税实务#参考财会[2012]13号规定了具体财务处理、
财税[2012]15号,三、增值税一般纳税人支付的二项费用在增值税应纳税额中全额抵减的,其增值税专用发票不作为增值税抵扣凭证,其进项税额不得从销项税额中抵扣。
用友知识库
更多使用技巧
热点文章
问题解答
-
单据记账之后不能恢复记账。
单据记账之后不能恢复记账。单据记账之后不能恢复记账。 2016-10-17日期格式不正确,检查控件面板-日期格式-短日期格式。应该为yyyy-mm-dd。用友天龙瑞德,购买用友产品和服务010-59798025
-
在U821升级到U852的过程中,升级失败
在U821升级到U852的过程中,升级失败在U821升级到U852的过程中,升级失败
问题版本: 803-U8.52 问题模块: 804-系统环境 所属行业: 0-通用 问题状态: http://yun.kuaiji66.com公示 关 键 字: 在U821升级到U852的过程中,升级失败 适用产品: U852 补 丁 号: 开放状态: 用友云基地注册用户 原问题号: 提交时间: 2008-1-8 问题名称: 在U821升级到U852的过程中,升级失败 问题现象: 在U821升级到U852的过程中,升级固定资产数据时提示错误,升级失败。 原因分析: 根据跟踪情况,对数据表fa_card表进行分析,发现问题:一条记录日期格式不对 解决方案: 将上述找到的错误字段值修改后,重新升级,ok!
用友热销产品
解决方案
-
用友U8 812工资汇总工资类别的数据不正确
用友U8 812工资汇总工资类别的数据不正确用友U8 812工资汇总工资类别的数据不正确 问题原因:工资模块中汇总工资类别的数据不正确,且不能进行部门汇总,原因是用户没有在工资变动中进行计算与汇总,后发现部门汇总表的数据与单个工资类别的数据不正确 解决方法:针对该问题,将控制面板的日期格式改为YYYY-MM-DD,再进行汇总即可.
解决方案:
问题原因:工资模块中汇总工资类别的数据不正确,且不能进行部门汇总,原因是用户没有在工资变动中进行计算与汇总,后发现部门汇总表的数据与单个工资类别的数据不正确 解决方法:针对该问题,将控制面板的日期格式改为YYYY-MM-DD,再进行汇总即可.
www.kuaiji66.com 天龙瑞德 -
用友U8 812无法升级到852
用友U8 812无法升级到852用友U8 812无法升级到852 问题原因:812数据有问题:1、销售发票和采购订单的日期格式非法。2、成本模块的视图丢失。 解决方法:2000年的数据:1、修该salebillvouchs、po_pomain的非法日期1)update salebillvouchs set ddate=#1999-12-30# where ddate<#2000-1-1#2)po_pomain表字段dpodate的值请手工修改,共有五条记录(年度为200,请改为2000)。2、升级到8213、将数据引入852后,升级前在数据库中增加视图caq_inventory,caq_amoname,caq_depdata,caq_deptauthex,caq_mxb,caq_predepdata,caq_serviceprice,caq_userproperty,然后升级。CREATE VIEW ca_inventory AS SELECT Inventory.cInvCode, Inventory.cInvName, Inventory.cInvStd,Inventory.iInvRCost,Inventory.cInvCCode, ComputationUnit.cComUnitName AS cInvM_Unit,InventoryClass.cInvCName FROM Inventory LEFT OUTER JOIN InventoryClass ON Inventory.cInvCCode = InventoryClass.cInvCCode LEFT OUTER JOIN ComputationUnit ON Inventory.cComunitCode = ComputationUnit.cComunitCodegoCREATE view caq_amoname as select distinct 1 as amotypeno,‘0‘ as amotype,‘材料费用‘ as amotypename,b.cinvcode as amoid,b.cinvname as amoname,b.cinvccode as cinvccode ,b.cinvcname as cinvcname,b.cinvstd as cinvstd,b.cinvm_unit as cunit from ca_amoct a,ca_inventory b where a.camoid= b.cinvcode Union select 2 as amotypeno,‘0‘,‘材料费用‘,‘-1‘,‘废品回收‘,‘‘,‘‘,‘‘,‘‘ Union select 3 as amotypeno,‘3‘,‘制造费用‘,camoid,camoname,‘‘,‘‘,‘‘,‘‘ from caq_manufacture Union select 4 as amotypeno,‘2‘,‘辅助费用‘,cprocedureid,cprocedurename,‘‘,‘‘,‘‘,‘‘ from ca_predf where bisauxi<>0 Union select 5 as amotypeno,‘4‘,‘其他费用‘,camoid,camoname,‘‘,‘‘,‘‘,‘‘ from caq_others Union select 6 as amotypeno,‘1‘,‘人工费用‘,‘‘,‘直接人工‘,‘‘,‘‘,‘‘,‘‘goCREATE view caq_userproperty as select cuserid,caccode as cdeptid ,cfuncid from aa_holdauth where cbusobid=‘department‘goCREATE view caq_serviceprice as select max(iperiod) as iperiod,max(cprocedureid) as cprocedureid,sum(itotalamo)/sum(iqua) as price from ca_samoct group by cprocedureidgoCREATE view caq_predepdata as select ‘专用‘ as cType,a.iperiod,a.cdeptid,0 as amotypeno,‘0‘ as amotype ,a.cmatid as amoid,a.iqua as curqua,a.imatqua as curamo,b.irestqua as endqua,b.iprice * b.irestqua as endamo from ca_mabsw a left join ca_enmmc b on a.cdeptid=b.cdeptid and a.cmatid=b.cmatid and a.iperiod = b.iperiod where a.cppid is null union SELECT ‘共用‘ ,a.iperiod, a.cdeptid, 0 AS amotypeno, ‘0‘ AS amotype, a.cmatid AS amoid,a.iqua AS curqua, a.imatqua AS curamo, b.irestqua AS endqua,b.iprice * b.irestqua AS endamo FROM ca_mabsw a LEFT JOIN ca_enmom b ON a.cdeptid = b.cdeptid AND a.cmatid = b.cmatid AND a.iperiod = b.iperiod where a.cppid is not null Union select ‘废品‘ ,max(a.iperiod),max(b.cdepcode),1,‘0‘,‘-1‘,0,sum(irecamo),0,0 from ca_waspr a,productstructureex b where a.cppid = b.cpspcode group by cdepcode Union select ‘‘ ,iperiod,cdeptid,2,‘3‘,camoid,0,imanamo,0,0 from ca_manct Union select ‘‘ ,a.iperiod,a.cdeptid,3,‘2‘,a.cprocedureid,a.iqua,a.iqua* b.price,0,0 from ca_asscw a , caq_serviceprice b where a.iperiod=b.iperiod and a.cprocedureid=b.cprocedureid Union select ‘‘ ,max(iperiod),max(cdeptid),4,‘4‘,max(cothamoid),0,sum(iothamo),0,0 from ca_onlia group by cdeptid,iperiod,cothamoid Union select ‘‘ ,iperiod,cdeptid,5,‘1‘,‘‘,0,iDirectPay,0,0 from ca_dirmagoCREATE view caq_depdata as select a.iperiod as 期间,a.cdeptid as 部门编码,b.cdepname as 部门名称, a.amotypeno as 费用类型序号,a.amotype as 费用类型编码,c.amotypename as 费用类型名称,a.cType as 材料类别, c.cinvccode as 存货分类编码,c.cinvcname as 存货分类名称,a.amoid as 费用明细编码,c.amoname as 费用明细名称, a.curqua as 本期发生数量,a.curamo as 本期发生金额, a.endqua as 期末盘存数量,a.endamo as 期末盘存金额 from caq_predepdata a,department b,caq_amoname c Where a.cdeptid = b.cDepCode and a.amotype=c.amotype and a.amoid=c.amoidgoCREATE view CAQ_DeptAuthEx as SELECT CAQ_UserProperty.cUserID, Department.cDepCode,Department.cDepName FROM Department INNER JOIN CAQ_UserProperty ON Department.cDepCode = CAQ_UserProperty.cDeptIDgoCREATE view caq_mxb as select a.iperiod as 期间,a.cppid as 产品编码,f.cinvname as 产品名称,a.cbatch as 批号, b.cinvstd as 规格型号,b.cunit as 单位, b.cinvccode as 存货分类编码,b.cinvcname as 存货分类名称 , c.cdepcode as 部门编码,d.cdepname as 部门名称, b.amotypeno as 费用类型序号,b.amotype as 费用类型编码,b.amotypename as 费用类型名称, case when ifinqua=0 then 0 else iqua*(1-0.6)/(case when ifinqua=0 then 1 else ifinqua end) end as 完工数量单位成本, iqua *(1-0.5) as 完工数量总成本, iqua * 1 as 在产数量总成本, iqua as 产品数量总成本, case when ifinqua=0 then 0 else itotalamo*(1-0.5)/(case when ifinqua=0 then 1 else ifinqua end) end as 完工金额单位成本, itotalamo *(1-0.5) as 完工金额总成本, itotalamo * 1 as 在产金额总成本, itotalamo as 产品金额总成本, ifinpdtunitamo * iIntoamo as 入库金额总成本, case when ifinqua=0 then 0 else iqua*(1-0.5)/(case when ifinqua=0 then 1 else ifinqua end)*e.iIntoamo end as 入库数量总成本, 0.5 As 在产分配率 from ca_amoct a,caq_amoname b,productstructure c,department d,ca_compd e,inventory f Where a.camotype = b.amotype And a.camoid = b.amoid And a.cPPid = C.cpspcode and c.cdepcode=d.cdepcode and a.iperiod=e.iperiod and a.cppid= e.cppid and a.cbatch = e.cbatch and a.cppid=f.cinvcodego升级成功后再重建视图caq_mxbCREATE view caq_mxb as select a.iperiod as 期间,a.cppid as 产品编码,f.cinvname as 产品名称,a.cbatch as 批号, b.cinvstd as 规格型号,b.cunit as 单位, b.cinvccode as 存货分类编码,b.cinvcname as 存货分类名称 , c.cdepcode as 部门编码,d.cdepname as 部门名称, b.amotypeno as 费用类型序号,b.amotype as 费用类型编码,b.amotypename as 费用类型名称, case when ifinqua=0 then 0 else iqua*(1-onpration)/(case when ifinqua=0 then 1 else ifinqua end) end as 完工数量单位成本, iqua *(1-onpration) as 完工数量总成本, iqua * onpration as 在产数量总成本, iqua as 产品数量总成本, case when ifinqua=0 then 0 else itotalamo*(1-onpration)/(case when ifinqua=0 then 1 else ifinqua end) end as 完工金额单位成本, itotalamo *(1-onpration) as 完工金额总成本, itotalamo * onpration as 在产金额总成本, itotalamo as 产品金额总成本, ifinpdtunitamo * iIntoamo as 入库金额总成本, case when ifinqua=0 then 0 else iqua*(1-onpration)/(case when ifinqua=0 then 1 else ifinqua end)*e.iIntoamo end as 入库数量总成本, onpration As 在产分配率 from ca_amoct a,caq_amoname b,productstructure c,department d,ca_compd e,inventory f Where a.camotype = b.amotype And a.camoid = b.amoid And a.cPPid = C.cpspcode and c.cdepcode=d.cdepcode and a.iperiod=e.iperiod and a.cppid= e.cppid and a.cbatch = e.cbatch and a.cppid=f.cinvcode2003年帐套:1、在salebillvouchs删除autoid=(164,166,343)delete from salebillvouchs where autoid in(164,166,343)2、先升级到8213、将数据引入852后,升级前在数据库中增加视图caq_inventory,caq_amoname,caq_depdata,caq_deptauthex,caq_mxb,caq_predepdata,caq_serviceprice,caq_userproperty,然后升级。CREATE VIEW ca_inventory AS SELECT Inventory.cInvCode, Inventory.cInvName, Inventory.cInvStd,Inventory.iInvRCost,Inventory.cInvCCode, ComputationUnit.cComUnitName AS cInvM_Unit,InventoryClass.cInvCName FROM Inventory LEFT OUTER JOIN InventoryClass ON Inventory.cInvCCode = InventoryClass.cInvCCode LEFT OUTER JOIN ComputationUnit ON Inventory.cComunitCode = ComputationUnit.cComunitCodegoCREATE view caq_amoname as select distinct 1 as amotypeno,‘0‘ as amotype,‘材料费用‘ as amotypename,b.cinvcode as amoid,b.cinvname as amoname,b.cinvccode as cinvccode ,b.cinvcname as cinvcname,b.cinvstd as cinvstd,b.cinvm_unit as cunit from ca_amoct a,ca_inventory b where a.camoid= b.cinvcode Union select 2 as amotypeno,‘0‘,‘材料费用‘,‘-1‘,‘废品回收‘,‘‘,‘‘,‘‘,‘‘ Union select 3 as amotypeno,‘3‘,‘制造费用‘,camoid,camoname,‘‘,‘‘,‘‘,‘‘ from caq_manufacture Union select 4 as amotypeno,‘2‘,‘辅助费用‘,cprocedureid,cprocedurename,‘‘,‘‘,‘‘,‘‘ from ca_predf where bisauxi<>0 Union select 5 as amotypeno,‘4‘,‘其他费用‘,camoid,camoname,‘‘,‘‘,‘‘,‘‘ from caq_others Union select 6 as amotypeno,‘1‘,‘人工费用‘,‘‘,‘直接人工‘,‘‘,‘‘,‘‘,‘‘goCREATE view caq_userproperty as select cuserid,caccode as cdeptid ,cfuncid from aa_holdauth where cbusobid=‘department‘goCREATE view caq_serviceprice as select max(iperiod) as iperiod,max(cprocedureid) as cprocedureid,sum(itotalamo)/sum(iqua) as price from ca_samoct group by cprocedureidgoCREATE view caq_predepdata as select ‘专用‘ as cType,a.iperiod,a.cdeptid,0 as amotypeno,‘0‘ as amotype ,a.cmatid as amoid,a.iqua as curqua,a.imatqua as curamo,b.irestqua as endqua,b.iprice * b.irestqua as endamo from ca_mabsw a left join ca_enmmc b on a.cdeptid=b.cdeptid and a.cmatid=b.cmatid and a.iperiod = b.iperiod where a.cppid is null union SELECT ‘共用‘ ,a.iperiod, a.cdeptid, 0 AS amotypeno, ‘0‘ AS amotype, a.cmatid AS amoid,a.iqua AS curqua, a.imatqua AS curamo, b.irestqua AS endqua,b.iprice * b.irestqua AS endamo FROM ca_mabsw a LEFT JOIN ca_enmom b ON a.cdeptid = b.cdeptid AND a.cmatid = b.cmatid AND a.iperiod = b.iperiod where a.cppid is not null Union select ‘废品‘ ,max(a.iperiod),max(b.cdepcode),1,‘0‘,‘-1‘,0,sum(irecamo),0,0 from ca_waspr a,productstructureex b where a.cppid = b.cpspcode group by cdepcode Union select ‘‘ ,iperiod,cdeptid,2,‘3‘,camoid,0,imanamo,0,0 from ca_manct Union select ‘‘ ,a.iperiod,a.cdeptid,3,‘2‘,a.cprocedureid,a.iqua,a.iqua* b.price,0,0 from ca_asscw a , caq_serviceprice b where a.iperiod=b.iperiod and a.cprocedureid=b.cprocedureid Union select ‘‘ ,max(iperiod),max(cdeptid),4,‘4‘,max(cothamoid),0,sum(iothamo),0,0 from ca_onlia group by cdeptid,iperiod,cothamoid Union select ‘‘ ,iperiod,cdeptid,5,‘1‘,‘‘,0,iDirectPay,0,0 from ca_dirmagoCREATE view caq_depdata as select a.iperiod as 期间,a.cdeptid as 部门编码,b.cdepname as 部门名称, a.amotypeno as 费用类型序号,a.amotype as 费用类型编码,c.amotypename as 费用类型名称,a.cType as 材料类别, c.cinvccode as 存货分类编码,c.cinvcname as 存货分类名称,a.amoid as 费用明细编码,c.amoname as 费用明细名称, a.curqua as 本期发生数量,a.curamo as 本期发生金额, a.endqua as 期末盘存数量,a.endamo as 期末盘存金额 from caq_predepdata a,department b,caq_amoname c Where a.cdeptid = b.cDepCode and a.amotype=c.amotype and a.amoid=c.amoidgoCREATE view CAQ_DeptAuthEx as SELECT CAQ_UserProperty.cUserID, Department.cDepCode,Department.cDepName FROM Department INNER JOIN CAQ_UserProperty ON Department.cDepCode = CAQ_UserProperty.cDeptIDgoCREATE view caq_mxb as select a.iperiod as 期间,a.cppid as 产品编码,f.cinvname as 产品名称,a.cbatch as 批号, b.cinvstd as 规格型号,b.cunit as 单位, b.cinvccode as 存货分类编码,b.cinvcname as 存货分类名称 , c.cdepcode as 部门编码,d.cdepname as 部门名称, b.amotypeno as 费用类型序号,b.amotype as 费用类型编码,b.amotypename as 费用类型名称, case when ifinqua=0 then 0 else iqua*(1-0.6)/(case when ifinqua=0 then 1 else ifinqua end) end as 完工数量单位成本, iqua *(1-0.5) as 完工数量总成本, iqua * 1 as 在产数量总成本, iqua as 产品数量总成本, case when ifinqua=0 then 0 else itotalamo*(1-0.5)/(case when ifinqua=0 then 1 else ifinqua end) end as 完工金额单位成本, itotalamo *(1-0.5) as 完工金额总成本, itotalamo * 1 as 在产金额总成本, itotalamo as 产品金额总成本, ifinpdtunitamo * iIntoamo as 入库金额总成本, case when ifinqua=0 then 0 else iqua*(1-0.5)/(case when ifinqua=0 then 1 else ifinqua end)*e.iIntoamo end as 入库数量总成本, 0.5 As 在产分配率 from ca_amoct a,caq_amoname b,productstructure c,department d,ca_compd e,inventory f Where a.camotype = b.amotype And a.camoid = b.amoid And a.cPPid = C.cpspcode and c.cdepcode=d.cdepcode and a.iperiod=e.iperiod and a.cppid= e.cppid and a.cbatch = e.cbatch and a.cppid=f.cinvcodego升级成功后再重建视图caq_mxbCREATE view caq_mxb as select a.iperiod as 期间,a.cppid as 产品编码,f.cinvname as 产品名称,a.cbatch as 批号, b.cinvstd as 规格型号,b.cunit as 单位, b.cinvccode as 存货分类编码,b.cinvcname as 存货分类名称 , c.cdepcode as 部门编码,d.cdepname as 部门名称, b.amotypeno as 费用类型序号,b.amotype as 费用类型编码,b.amotypename as 费用类型名称, case when ifinqua=0 then 0 else iqua*(1-onpration)/(case when ifinqua=0 then 1 else ifinqua end) end as 完工数量单位成本, iqua *(1-onpration) as 完工数量总成本, iqua * onpration as 在产数量总成本, iqua as 产品数量总成本, case when ifinqua=0 then 0 else itotalamo*(1-onpration)/(case when ifinqua=0 then 1 else ifinqua end) end as 完工金额单位成本, itotalamo *(1-onpration) as 完工金额总成本, itotalamo * onpration as 在产金额总成本, itotalamo as 产品金额总成本, ifinpdtunitamo * iIntoamo as 入库金额总成本, case when ifinqua=0 then 0 else iqua*(1-onpration)/(case when ifinqua=0 then 1 else ifinqua end)*e.iIntoamo end as 入库数量总成本, onpration As 在产分配率 from ca_amoct a,caq_amoname b,productstructure c,department d,ca_compd e,inventory f Where a.camotype = b.amotype And a.camoid = b.amoid And a.cPPid = C.cpspcode and c.cdepcode=d.cdepcode and a.iperiod=e.iperiod and a.cppid= e.cppid and a.cbatch = e.cbatch and a.cppid=f.cinvcode4、在salebillvouchs中手工加入删除的记录,字段sbvid的值可以通过查询销售发票主表发票号得到。
解决方案:
问题原因:812数据有问题:1、销售发票和采购订单的日期格式非法。2、成本模块的视图丢失。 解决方法:2000年的数据:1、修该salebillvouchs、po_pomain的非法日期1)update salebillvouchs set ddate=#1999-12-30# where ddate<#2000-1-1#2)po_pomain表字段dpodate的值请手工修改,共有五条记录(年度为200,请改为2000)。2、升级到8213、将数据引入852后,升级前在数据库中增加视图caq_inventory,caq_amoname,caq_depdata,caq_deptauthex,caq_mxb,caq_predepdata,caq_serviceprice,caq_userproperty,然后升级。CREATE VIEW ca_inventory AS SELECT Inventory.cInvCode, Inventory.cInvName, Inventory.cInvStd,Inventory.iInvRCost,Inventory.cInvCCode, ComputationUnit.cComUnitName AS cInvM_Unit,InventoryClass.cInvCName FROM Inventory LEFT OUTER JOIN InventoryClass ON Inventory.cInvCCode = InventoryClass.cInvCCode LEFT OUTER JOIN ComputationUnit ON Inventory.cComunitCode = ComputationUnit.cComunitCodegoCREATE view caq_amoname as select distinct 1 as amotypeno,‘0‘ as amotype,‘材料费用‘ as amotypename,b.cinvcode as amoid,b.cinvname as amoname,b.cinvccode as cinvccode ,b.cinvcname as cinvcname,b.cinvstd as cinvstd,b.cinvm_unit as cunit from ca_amoct a,ca_inventory b where a.camoid= b.cinvcode Union select 2 as amotypeno,‘0‘,‘材料费用‘,‘-1‘,‘废品回收‘,‘‘,‘‘,‘‘,‘‘ Union select 3 as amotypeno,‘3‘,‘制造费用‘,camoid,camoname,‘‘,‘‘,‘‘,‘‘ from caq_manufacture Union select 4 as amotypeno,‘2‘,‘辅助费用‘,cprocedureid,cprocedurename,‘‘,‘‘,‘‘,‘‘ from ca_predf where bisauxi<>0 Union select 5 as amotypeno,‘4‘,‘其他费用‘,camoid,camoname,‘‘,‘‘,‘‘,‘‘ from caq_others Union select 6 as amotypeno,‘1‘,‘人工费用‘,‘‘,‘直接人工‘,‘‘,‘‘,‘‘,‘‘goCREATE view caq_userproperty as select cuserid,caccode as cdeptid ,cfuncid from aa_holdauth where cbusobid=‘department‘goCREATE view caq_serviceprice as select max(iperiod) as iperiod,max(cprocedureid) as cprocedureid,sum(itotalamo)/sum(iqua) as price from ca_samoct group by cprocedureidgoCREATE view caq_predepdata as select ‘专用‘ as cType,a.iperiod,a.cdeptid,0 as amotypeno,‘0‘ as amotype ,a.cmatid as amoid,a.iqua as curqua,a.imatqua as curamo,b.irestqua as endqua,b.iprice * b.irestqua as endamo from ca_mabsw a left join ca_enmmc b on a.cdeptid=b.cdeptid and a.cmatid=b.cmatid and a.iperiod = b.iperiod where a.cppid is null union SELECT ‘共用‘ ,a.iperiod, a.cdeptid, 0 AS amotypeno, ‘0‘ AS amotype, a.cmatid AS amoid,a.iqua AS curqua, a.imatqua AS curamo, b.irestqua AS endqua,b.iprice * b.irestqua AS endamo FROM ca_mabsw a LEFT JOIN ca_enmom b ON a.cdeptid = b.cdeptid AND a.cmatid = b.cmatid AND a.iperiod = b.iperiod where a.cppid is not null Union select ‘废品‘ ,max(a.iperiod),max(b.cdepcode),1,‘0‘,‘-1‘,0,sum(irecamo),0,0 from ca_waspr a,productstructureex b where a.cppid = b.cpspcode group by cdepcode Union select ‘‘ ,iperiod,cdeptid,2,‘3‘,camoid,0,imanamo,0,0 from ca_manct Union select ‘‘ ,a.iperiod,a.cdeptid,3,‘2‘,a.cprocedureid,a.iqua,a.iqua* b.price,0,0 from ca_asscw a , caq_serviceprice b where a.iperiod=b.iperiod and a.cprocedureid=b.cprocedureid Union select ‘‘ ,max(iperiod),max(cdeptid),4,‘4‘,max(cothamoid),0,sum(iothamo),0,0 from ca_onlia group by cdeptid,iperiod,cothamoid Union select ‘‘ ,iperiod,cdeptid,5,‘1‘,‘‘,0,iDirectPay,0,0 from ca_dirmagoCREATE view caq_depdata as select a.iperiod as 期间,a.cdeptid as 部门编码,b.cdepname as 部门名称, a.amotypeno as 费用类型序号,a.amotype as 费用类型编码,c.amotypename as 费用类型名称,a.cType as 材料类别, c.cinvccode as 存货分类编码,c.cinvcname as 存货分类名称,a.amoid as 费用明细编码,c.amoname as 费用明细名称, a.curqua as 本期发生数量,a.curamo as 本期发生金额, a.endqua as 期末盘存数量,a.endamo as 期末盘存金额 from caq_predepdata a,department b,caq_amoname c Where a.cdeptid = b.cDepCode and a.amotype=c.amotype and a.amoid=c.amoidgoCREATE view CAQ_DeptAuthEx as SELECT CAQ_UserProperty.cUserID, Department.cDepCode,Department.cDepName FROM Department INNER JOIN CAQ_UserProperty ON Department.cDepCode = CAQ_UserProperty.cDeptIDgoCREATE view caq_mxb as select a.iperiod as 期间,a.cppid as 产品编码,f.cinvname as 产品名称,a.cbatch as 批号, b.cinvstd as 规格型号,b.cunit as 单位, b.cinvccode as 存货分类编码,b.cinvcname as 存货分类名称 , c.cdepcode as 部门编码,d.cdepname as 部门名称, b.amotypeno as 费用类型序号,b.amotype as 费用类型编码,b.amotypename as 费用类型名称, case when ifinqua=0 then 0 else iqua*(1-0.6)/(case when ifinqua=0 then 1 else ifinqua end) end as 完工数量单位成本, iqua *(1-0.5) as 完工数量总成本, iqua * 1 as 在产数量总成本, iqua as 产品数量总成本, case when ifinqua=0 then 0 else itotalamo*(1-0.5)/(case when ifinqua=0 then 1 else ifinqua end) end as 完工金额单位成本, itotalamo *(1-0.5) as 完工金额总成本, itotalamo * 1 as 在产金额总成本, itotalamo as 产品金额总成本, ifinpdtunitamo * iIntoamo as 入库金额总成本, case when ifinqua=0 then 0 else iqua*(1-0.5)/(case when ifinqua=0 then 1 else ifinqua end)*e.iIntoamo end as 入库数量总成本, 0.5 As 在产分配率 from ca_amoct a,caq_amoname b,productstructure c,department d,ca_compd e,inventory f Where a.camotype = b.amotype And a.camoid = b.amoid And a.cPPid = C.cpspcode and c.cdepcode=d.cdepcode and a.iperiod=e.iperiod and a.cppid= e.cppid and a.cbatch = e.cbatch and a.cppid=f.cinvcodego升级成功后再重建视图caq_mxbCREATE view caq_mxb as select a.iperiod as 期间,a.cppid as 产品编码,f.cinvname as 产品名称,a.cbatch as 批号, b.cinvstd as 规格型号,b.cunit as 单位, b.cinvccode as 存货分类编码,b.cinvcname as 存货分类名称 , c.cdepcode as 部门编码,d.cdepname as 部门名称, b.amotypeno as 费用类型序号,b.amotype as 费用类型编码,b.amotypename as 费用类型名称, case when ifinqua=0 then 0 else iqua*(1-onpration)/(case when ifinqua=0 then 1 else ifinqua end) end as 完工数量单位成本, iqua *(1-onpration) as 完工数量总成本, iqua * onpration as 在产数量总成本, iqua as 产品数量总成本, case when ifinqua=0 then 0 else itotalamo*(1-onpration)/(case when ifinqua=0 then 1 else ifinqua end) end as 完工金额单位成本, itotalamo *(1-onpration) as 完工金额总成本, itotalamo * onpration as 在产金额总成本, itotalamo as 产品金额总成本, ifinpdtunitamo * iIntoamo as 入库金额总成本, case when ifinqua=0 then 0 else iqua*(1-onpration)/(case when ifinqua=0 then 1 else ifinqua end)*e.iIntoamo end as 入库数量总成本, onpration As 在产分配率 from ca_amoct a,caq_amoname b,productstructure c,department d,ca_compd e,inventory f Where a.camotype = b.amotype And a.camoid = b.amoid And a.cPPid = C.cpspcode and c.cdepcode=d.cdepcode and a.iperiod=e.iperiod and a.cppid= e.cppid and a.cbatch = e.cbatch and a.cppid=f.cinvcode2003年帐套:1、在salebillvouchs删除autoid=(164,166,343)delete from salebillvouchs where autoid in(164,166,343)2、先升级到8213、将数据引入852后,升级前在数据库中增加视图caq_inventory,caq_amoname,caq_depdata,caq_deptauthex,caq_mxb,caq_predepdata,caq_serviceprice,caq_userproperty,然后升级。CREATE VIEW ca_inventory AS SELECT Inventory.cInvCode, Inventory.cInvName, Inventory.cInvStd,Inventory.iInvRCost,Inventory.cInvCCode, ComputationUnit.cComUnitName AS cInvM_Unit,InventoryClass.cInvCName FROM Inventory LEFT OUTER JOIN InventoryClass ON Inventory.cInvCCode = InventoryClass.cInvCCode LEFT OUTER JOIN ComputationUnit ON Inventory.cComunitCode = ComputationUnit.cComunitCodegoCREATE view caq_amoname as select distinct 1 as amotypeno,‘0‘ as amotype,‘材料费用‘ as amotypename,b.cinvcode as amoid,b.cinvname as amoname,b.cinvccode as cinvccode ,b.cinvcname as cinvcname,b.cinvstd as cinvstd,b.cinvm_unit as cunit from ca_amoct a,ca_inventory b where a.camoid= b.cinvcode Union select 2 as amotypeno,‘0‘,‘材料费用‘,‘-1‘,‘废品回收‘,‘‘,‘‘,‘‘,‘‘ Union select 3 as amotypeno,‘3‘,‘制造费用‘,camoid,camoname,‘‘,‘‘,‘‘,‘‘ from caq_manufacture Union select 4 as amotypeno,‘2‘,‘辅助费用‘,cprocedureid,cprocedurename,‘‘,‘‘,‘‘,‘‘ from ca_predf where bisauxi<>0 Union select 5 as amotypeno,‘4‘,‘其他费用‘,camoid,camoname,‘‘,‘‘,‘‘,‘‘ from caq_others Union select 6 as amotypeno,‘1‘,‘人工费用‘,‘‘,‘直接人工‘,‘‘,‘‘,‘‘,‘‘goCREATE view caq_userproperty as select cuserid,caccode as cdeptid ,cfuncid from aa_holdauth where cbusobid=‘department‘goCREATE view caq_serviceprice as select max(iperiod) as iperiod,max(cprocedureid) as cprocedureid,sum(itotalamo)/sum(iqua) as price from ca_samoct group by cprocedureidgoCREATE view caq_predepdata as select ‘专用‘ as cType,a.iperiod,a.cdeptid,0 as amotypeno,‘0‘ as amotype ,a.cmatid as amoid,a.iqua as curqua,a.imatqua as curamo,b.irestqua as endqua,b.iprice * b.irestqua as endamo from ca_mabsw a left join ca_enmmc b on a.cdeptid=b.cdeptid and a.cmatid=b.cmatid and a.iperiod = b.iperiod where a.cppid is null union SELECT ‘共用‘ ,a.iperiod, a.cdeptid, 0 AS amotypeno, ‘0‘ AS amotype, a.cmatid AS amoid,a.iqua AS curqua, a.imatqua AS curamo, b.irestqua AS endqua,b.iprice * b.irestqua AS endamo FROM ca_mabsw a LEFT JOIN ca_enmom b ON a.cdeptid = b.cdeptid AND a.cmatid = b.cmatid AND a.iperiod = b.iperiod where a.cppid is not null Union select ‘废品‘ ,max(a.iperiod),max(b.cdepcode),1,‘0‘,‘-1‘,0,sum(irecamo),0,0 from ca_waspr a,productstructureex b where a.cppid = b.cpspcode group by cdepcode Union select ‘‘ ,iperiod,cdeptid,2,‘3‘,camoid,0,imanamo,0,0 from ca_manct Union select ‘‘ ,a.iperiod,a.cdeptid,3,‘2‘,a.cprocedureid,a.iqua,a.iqua* b.price,0,0 from ca_asscw a , caq_serviceprice b where a.iperiod=b.iperiod and a.cprocedureid=b.cprocedureid Union select ‘‘ ,max(iperiod),max(cdeptid),4,‘4‘,max(cothamoid),0,sum(iothamo),0,0 from ca_onlia group by cdeptid,iperiod,cothamoid Union select ‘‘ ,iperiod,cdeptid,5,‘1‘,‘‘,0,iDirectPay,0,0 from ca_dirmagoCREATE view caq_depdata as select a.iperiod as 期间,a.cdeptid as 部门编码,b.cdepname as 部门名称, a.amotypeno as 费用类型序号,a.amotype as 费用类型编码,c.amotypename as 费用类型名称,a.cType as 材料类别, c.cinvccode as 存货分类编码,c.cinvcname as 存货分类名称,a.amoid as 费用明细编码,c.amoname as 费用明细名称, a.curqua as 本期发生数量,a.curamo as 本期发生金额, a.endqua as 期末盘存数量,a.endamo as 期末盘存金额 from caq_predepdata a,department b,caq_amoname c Where a.cdeptid = b.cDepCode and a.amotype=c.amotype and a.amoid=c.amoidgoCREATE view CAQ_DeptAuthEx as SELECT CAQ_UserProperty.cUserID, Department.cDepCode,Department.cDepName FROM Department INNER JOIN CAQ_UserProperty ON Department.cDepCode = CAQ_UserProperty.cDeptIDgoCREATE view caq_mxb as select a.iperiod as 期间,a.cppid as 产品编码,f.cinvname as 产品名称,a.cbatch as 批号, b.cinvstd as 规格型号,b.cunit as 单位, b.cinvccode as 存货分类编码,b.cinvcname as 存货分类名称 , c.cdepcode as 部门编码,d.cdepname as 部门名称, b.amotypeno as 费用类型序号,b.amotype as 费用类型编码,b.amotypename as 费用类型名称, case when ifinqua=0 then 0 else iqua*(1-0.6)/(case when ifinqua=0 then 1 else ifinqua end) end as 完工数量单位成本, iqua *(1-0.5) as 完工数量总成本, iqua * 1 as 在产数量总成本, iqua as 产品数量总成本, case when ifinqua=0 then 0 else itotalamo*(1-0.5)/(case when ifinqua=0 then 1 else ifinqua end) end as 完工金额单位成本, itotalamo *(1-0.5) as 完工金额总成本, itotalamo * 1 as 在产金额总成本, itotalamo as 产品金额总成本, ifinpdtunitamo * iIntoamo as 入库金额总成本, case when ifinqua=0 then 0 else iqua*(1-0.5)/(case when ifinqua=0 then 1 else ifinqua end)*e.iIntoamo end as 入库数量总成本, 0.5 As 在产分配率 from ca_amoct a,caq_amoname b,productstructure c,department d,ca_compd e,inventory f Where a.camotype = b.amotype And a.camoid = b.amoid And a.cPPid = C.cpspcode and c.cdepcode=d.cdepcode and a.iperiod=e.iperiod and a.cppid= e.cppid and a.cbatch = e.cbatch and a.cppid=f.cinvcodego升级成功后再重建视图caq_mxbCREATE view caq_mxb as select a.iperiod as 期间,a.cppid as 产品编码,f.cinvname as 产品名称,a.cbatch as 批号, b.cinvstd as 规格型号,b.cunit as 单位, b.cinvccode as 存货分类编码,b.cinvcname as 存货分类名称 , c.cdepcode as 部门编码,d.cdepname as 部门名称, b.amotypeno as 费用类型序号,b.amotype as 费用类型编码,b.amotypename as 费用类型名称, case when ifinqua=0 then 0 else iqua*(1-onpration)/(case when ifinqua=0 then 1 else ifinqua end) end as 完工数量单位成本, iqua *(1-onpration) as 完工数量总成本, iqua * onpration as 在产数量总成本, iqua as 产品数量总成本, case when ifinqua=0 then 0 else itotalamo*(1-onpration)/(case when ifinqua=0 then 1 else ifinqua end) end as 完工金额单位成本, itotalamo *(1-onpration) as 完工金额总成本, itotalamo * onpration as 在产金额总成本, itotalamo as 产品金额总成本, ifinpdtunitamo * iIntoamo as 入库金额总成本, case when ifinqua=0 then 0 else iqua*(1-onpration)/(case when ifinqua=0 then 1 else ifinqua end)*e.iIntoamo end as 入库数量总成本, onpration As 在产分配率 from ca_amoct a,caq_amoname b,productstructure c,department d,ca_compd e,inventory f Where a.camotype = b.amotype And a.camoid = b.amoid And a.cPPid = C.cpspcode and c.cdepcode=d.cdepcode and a.iperiod=e.iperiod and a.cppid= e.cppid and a.cbatch = e.cbatch and a.cppid=f.cinvcode4、在salebillvouchs中手工加入删除的记录,字段sbvid的值可以通过查询销售发票主表发票号得到。
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收款机怎样往里录入供应商还有库存管理,是不是不录入供应商信息就无法使用库存呢?希望高手解答。
- 阿里怎么设置付款减库存
产品介绍
产品资讯
-
T3标准版,在打开“系统管理”的时候提示如图错误,请各位老师帮忙解决一下。
T3标准版,在打开“系统管理”的时候提示如图错误,请各位老师帮忙解决一下。 T3标准版,在打开“系统管理”的时候提示如图错误,请各位老师帮忙解决一下。
检查计算机名称是否含有特殊字符像‘-’等,如果有,请修改为纯英文名称,修改完成之后请重启电脑;或者更改系统环境变量中用户变量的Tmp变量值。具体方法:首先在C盘下建立一个空文件夹,更名为temp,然后在‘我的电脑处’单击鼠标右键,属性里点高级页签,然后点‘环境变量’,将temp和tmp的值都修改为c:\temp(通过点‘编辑’按钮进行修改;还有检查系统日期格式是否符合下面的要求:短日期格式:yyyy-MM-dd,长日期格式:yyyy'年'M'月'd'日'。(检查方法:点击”开始菜单“-”控制面板“,依次找到”时钟、语言和区域“-”设置时间和日期“-”更改日期和时间“-”更改日历设置“-”日历设置“-【日期】页签中进行查看和修改。)
然后再登录操作你好,按您的回复进行操作,还是一样的提示。@畅捷服务苏娜_:按您的回复进行操作,还是一样的提示。把账套的物理文件拷贝出来保存好,卸载软件,然后重新安装。账套物理文件恢复数据的方式请参照文档中的方法二或方法三:
http://service.chanjet.com/zhi ... 2edd2 -
T3登录就报错了
T3登录就报错了 T3登录就报错了
您好,建议您可以尝试以下几个方法:
1.检查计算机名是否有特殊字符,如果有则修改;
2.检查日期格式是否是正确的日期格式,点击“开始”-“控制面板”-“区域和语言选项”-“自定义”-点击“日期”页签,将“短日期”格式设置为:YYYY-MM-DD;再将“长日期”格式设置为:“yyyy'年'M'月'd'日'”。
3.T3需要调用的操作系统组件被反注册了,需要重新注册一下组件,可以到服务社区-更多-工具中下载DLL组件注册工具,备份好账套数据后,用工具注册下组件。
4.修改环境变量。