你好 T3登录提示怎么 是什么原因啊
2019-4-5 8:0:0 用友NC小编你好 T3登录提示怎么 是什么原因啊
你好 T3登录提示怎么 是什么原因啊您好!检查一下计算机名称是否含有特殊字符,如果有特殊字符请修改为纯英文名称,修改完计算机名称重启电脑再登录;还有检查系统日期格式是否符合下面的要求:短日期格式:yyyy-MM-dd,长日期格式:yyyy'年'M'月'd'日'。(检查方法:点击”开始菜单“-”控制面板“,依次找到”时钟、语言和区域“-”设置时间和日期“-”更改日期和时间“-”更改日历设置“-”日历设置“-【日期】页签中进行查看和修改。) 因为 在卸载的时候没有卸载干净造成的,需要备份账套,然后卸载T3,删除安装路径以及c\windows\system32下面的ufcomsql文件以及注册表,然后重启电脑在进行安装;
或者可以参考知识库:http://service.chanjet.com/zhi ... b459e
如果您的问题还没有解决,可以到 T+搜索>>上找一下
相关阅读
- 银行对账单导入的时候,提示时间错误-2019-4-5 8:0:0
- 单据记账之后不能恢复记账。2019-4-5 8:0:0
- 用友U8其他812工资汇总工资类别的数据不正确2019-4-5 8:0:0
- 用友U8其他812无法升级到8522019-4-5 8:0:0
- 用友U8其他813 ufo报表打不开,提示‘年度错误’2019-4-5 8:0:0
- 用友U8其他813 ufo报表打不开,提示‘年度错误’_02019-4-5 8:0:0
- 您好 客户是10.6的版本 好早就买了 今年做了一次版本升级 升级到了标准版 现在总共四台电脑再用 今天需要新安装一台分机 分机安装好了 也能登主机的地址 但是进入模块的时候就提示子系统登录失败 其他的电脑都能使用 请问 这个是什么原因 新机子 系统是win7旗舰版32位的 站点是有六个站点不存在站点不足的原因2019-4-5 8:0:0
- T3标准版,在打开“系统管理”的时候提示如图错误,请各位老师帮忙解决一下。2019-4-5 8:0:0
- T3登录就报错了2019-4-5 8:0:0
- T3登录时页面一堆问号。进系统管理也是乱码?这是怎么回事2019-4-5 8:0:0
最新信息
委外结算 委外结算
问题号: | 39310 |
---|---|
适用产品: | T6系列 |
软件版本: | T6-企业管理软件V6.1 |
软件模块: | 委外管理 |
问题名称: | 委外结算 |
问题现象: | 委外订单A 100KG,需要材料B 100KG,现B委外出库100KG,A委外入库90KG,剩A 10KG在误差范围内,损耗不需要入库。委外结算时A所需材料费是B 90KG。但现需要A所需材料费是B 100KG全部分摊到到A,如何处理? |
问题原因: | 软件使用问题。 |
关键字: | 委外结算 |
解决方案: | <P>90个入库想和100个材料结算按照如下操作:</P> <P>1. 在结算的时候先‘选单’,选中对应入库单</P> <P>2. 点下菜单栏的‘对应出库单’,把100个材料出库单选中,点确定去结算。</P> <P>3. 结算后,100个B材料出库成本分摊到90个A入库成本中。</P> |
行业: | 通用 |
补丁编号: | |
解决状态: | 临时解决方案 |
录入日期: | 2016-03-16 15:23:45 |
最后更新时间: |
使用速达财务转用友工具,想把速达的凭证转到用友T3普及版里,数据库连接上,输入数据库名字,点确认提示结转成功,但是用友T3里面什么都没有,请问这个工具具体怎么操作的,能把凭证转过来吗 使用速达财务转用友工具,想把速达的凭证转到用友T3普及版里,数据库连接上,输入数据库名字,点确认提示结转成功,但是用友T3里面什么都没有,请问这个工具具体怎么操作的,能把凭证转过来吗[]
您好!速达有两个工具,具体版本是符合工具要求么?@服务社区刘明新:是的,财务单机版这个工具是只支持T3标准版还是T3普及版也支持@TINGYUE2012:这个工具不限制T3标普的,如果转完之后没有数据的话,就需要进一步查看数据进行处理,需要您联系代理商,由代理商在支持网上提交数据问题,有我们进一步查看数据处理;@服务社区刘明新:这个工具是只支持t3标准版还是同时支持普及版@TINGYUE2012:都支持的
- 用友U8 UFO报表资产负债表公式取数不对,现金流量表取不到数
- 用友U8 WEB调拨单不能上传,提示char型数据转换Datatime型数据导致Datatime型数据下标越界。
- 用友U8 同一张UFO报表拷到另外一台机器上,打开的数据确不同?如在AA机上打的的报表分别是1月和2月的表页,而在BB机上打开的却只有1月的表页,且数据错误,(帐套号正确)。注:在UFO刚装好时,进入提示输入帐套号和年度,该用户有001和002两个帐套,但总帐数据在001中,当帐套号输入001时,提示帐套年度错误?如点击“取消”,可进入但提示:演示版。
- 用友U8 启用固定资产,初始化后,提示类型不匹配,1.可能是系统管理正在关闭 2.可能是旧版本帐套 3.不是帐套文件
- 用友U8 固定资产提示:帐套类型不匹配_1
- 用友U8 在升级8.12数据时,从812—-》8.21过程,升级总帐的过程中,报错:需要修改的摘要名称:[441]单位欠款
- 用友U8 存货不能记帐
- 用友U8 存货单据不能记账
- 用友U8 存货期未处理时提示错误信息:类型不相符
- 用友U8 客户端查询银行日记账没有数据出现,其他客户端和服务器正常
用友U8 登陆用友时在密码输入正确的情况下一样提示密码不正确用友U8 登陆用友时在密码输入正确的情况下一样提示密码不正确
问题原因:之前引入过其他服务器输出的账套,系统会把用户编码和名称相同的用户后面加“”。 解决方法:把带有“”的用户删除或改名
解决方案:
问题原因:之前引入过其他服务器输出的账套,系统会把用户编码和名称相同的用户后面加“”。 解决方法:把带有“”的用户删除或改名
其他出库单无法参照现存量 其他出库单无法参照现存量
问题号: | 27121 |
---|---|
适用产品: | T3系列 |
软件版本: | 1071-用友T3-用友通标准版10.6plus1 |
软件模块: | 16-存货核算 |
问题名称: | 其他出库单无法参照现存量 |
问题现象: | 新增其他出库单,选择存货的放大镜,在参照界面的栏目里没有“现存量”这一项,演示帐套都是正常的,是什么原因?<BR> |
问题原因: | 该问题与选项的设置有关。 |
关键字: | 现存量 |
解决方案: | 如果仓库设置为“允许零出库”,则不显示“现存量”这个栏目;如果想显示“现存量”这个栏目,在“库存业务范围设置”里,将“是否允许零出库”前面的勾取消即可。 |
行业: | 0-通用 |
补丁编号: | |
解决状态: | 2-最终解决方案 |
录入日期: | 2016-03-16 15:23:45 |
最后更新时间: |
- 凭证输现金流量后提示一下图示?怎么处理?
- 刚刚安装的T3标准版11.0软件 打开以后提示报错。演示数据同样错误。请帮忙给看看
- 启动服务的时候提示这个是怎么回事?已经重装一遍
- 在w10里面安装T311.0和10.9都是这个提示,普及版
- 在查询科目总账的时候,提示运行错误3021,这个要怎么操作,并不是选择所有的科目提示这个错误,是有一些出现这个错误的
- 新建年度帐时报错
- 新装打开系统管理提示运行时错误字符串之前有未闭合的引号,怎么处理
- 点击模块提示如下图
- 用友T3软件打开时出现:Automation 错误(-2147024770),然后点击确定,软件就关闭了,请问怎么解决
- 用友通精算普及版 核算模块无法打开 出现如图提示 原因为何 如何解决?
t+登录界面不正常 且不能登录 t+登录界面不正常 且不能登录
12.1版本T+浏览器使用T+浏览器登录。12.0请点击右上方的浏览器设置,设置后再登录。要如何设置呢? 12.1的 用T+浏览器登录也不能登@达治萍:1、重启服务:点击服务器电脑的开始菜单—所有程序—T+—工具箱—T+服务管理器,打开之后全选服务重新启动。清除缓存后重新登录。
2、点击电脑开始—运行,输入regedit进入注册表,找到:HKEY_LOCAL_MACHINE \System\CurrentControlSet\Control\Lsa下"FIPSAlgorithmPolicy" 把它的值1改成0。
繁体中文系统能不能装T6软件? 繁体中文系统能不能装T6软件?
问题号: | 34994 |
---|---|
适用产品: | T6系列 |
软件版本: | T6-企业管理软件V6.1 |
软件模块: | 平台门户 |
问题名称: | 繁体中文系统能不能装T6软件? |
问题现象: | 安装好操作系统后发现是是繁体中文的,能不能安装T6软件?如果不能装应该怎么处理? |
问题原因: | 见问题答案。 |
关键字: | 软件安装 |
解决方案: | 可以转换成中文(中国),繁体中文版和英文版都可以在控制面板中的区域和语言选项设置成中文(中国)。 |
行业: | 通用 |
补丁编号: | |
解决状态: | 临时解决方案 |
录入日期: | 2016-03-16 15:23:45 |
最后更新时间: |
dos3.11工资升级到U8普及版提示:“部门档案重复”dos3.11工资升级到U8普及版提示:“部门档案重复”
|
当做计提折旧时,报折旧中断 当做计提折旧时,报折旧中断
问题号: | 3272 |
---|---|
解决状态: | 最终解决方案 |
软件版本: | 8.51 |
软件模块: | 固定资产 |
行业: | 通用 |
关键字: | 当做计提折旧时,报折旧中断 |
适用产品: | 8.51 |
问题名称: | 当做计提折旧时,报折旧中断 |
问题现象: | 当做计提折旧时,报折旧中断 |
问题原因: | 用户采取了平均年限法(二),卡片已到期,分母为0导致的 |
解决方案: | 修改卡片折旧状态或方法 |
补丁编号: | |
录入日期: | 2016-03-16 15:23:45 |
最后更新时间: |
我平时血压100——160,连续服药后降到50——110,出现有时头晕的感觉,请问这是什么问题 我平时血压100——160,连续服药后降到50——110,出现有时头晕的感觉,请问这是什么问题 连线服药是应该的,降压太快请医生调整用药量或品种。你好,你所说的是高血压,要多测量几次,要联合用药,要把血压控制在正常的范围内,同时注意休息降压药吃多了太低了,这样也是很危险的!降得太低了不要这样连续服药,这样容易搞坏身体怎么可以连续服药呢?不低才怪!这样对心脏不利
- 银行对账单导入的时候,提示时间错误-
- 保存报表时提示保存失败问题
- 用友T3通2005版2005年度查明细账总账第一列日期显示1999年
- 用友T6企业管理软件中打开工资模块时提示“区域选项日期标签页中的短日期格式应设置为yyyy-MM-d
- 用友记账宝创建账套保存时提示“启用期间过小”?
- 通2005在查询2005年明细账时左边日期却出现1999年但发生额和内容是正确。安月排序2005日期
- 通2005版2005年度查明细账,总账第一列日期显示1999年
- 用友安装之后,进去点总账,出现“Automation错误”,这是什么原因
- 用友T3-财务通普及版10.8plus1无此任务号,不能释放?
- 用友T3中在查询2005年明细账时左边日期却出现1999年但发生额和内容是正确。安月排序2005日期
报销私人车辆的上下班通勤费是否缴个税 报销私人车辆的上下班通勤费是否缴个税
问题:单位高层领导是自己买的车。公司决定上下班车费单位报锁,这费用能在个人所得税前扣除吗?
答复:根据《个人所得税法实施条例》第十条,个人所得的形式,包括个人取得的现金、实物、有价证券和其他形式的经济利益。因此,对于公司发给员工的通勤费用,应并入工资薪金所得征税。
- 凭证反记帐后修改会计科目提示241数据库错误
- 刚装的T3,为什么打开出纳就会有这个提示呢?
- 加密锁注册完成之后显示的是乱码的问题,这个是因为什么导致的呢?有点疑惑。。
- 启用不了模块,,
- 固定资产计提时候,提示420数据库错误,从字符串转换日期或时间时,转换失败
- 备份计划设置好了,但就不备份,备份日志也没有。怎么回事?
- 用友t3凭证摘要录入汉字是乱码 怎么办
- 用友T3普及版,在运行“系统管理”时,出现“运行时错误‘-2147024770(8007007e)’A utomation错误”
- 用友自动备份设置好后,能在备份目录下建立帐套目录,但没有备份文件,备份日志提示备份失败.
- 登录T6 企业门户时出现 运行时错误'0'
用友在工序报工方面,企业应用的模式有几种- 在工序报工方面,企业应用的模式有几种?
? 企业可以根据派工明细报工、根据工序计划报工、也可混合报工,企业可以在多种报工的模式中选择适合的方式。派工明细报工适合先派工、后报工的车间作业模式;
????工序计划报工使企业可以不派工直接按照工序计划报工;混合报工是指如果有派工资料,则只显示派工资料,如果没有派工资料,则显示工序计划信息。
您好:T1财贸宝。图形菜单界面点击财务管理,旁边的界面显示出财务流程。此时界面正常。但进入凭证管理,并点击其中一张凭证打开查看后,再关掉凭证管理界面,回到流程界面,此时流程界面就显示不正常了,如图所示。这是怎么回事??关了软件重新进又正常,然后重复以上操作该问题重现。 您好:T1财贸宝。图形菜单界面点击财务管理,旁边的界面显示出财务流程。此时界面正常。但进入凭证管理,并点击其中一张凭证打开查看后,再关掉凭证管理界面,回到流程界面,此时流程界面就显示不正常了,如图所示。这是怎么回事??关了软件重新进又正常,然后重复以上操作该问题重现。
将安装路径下客户端程序文件夹下 users下账套文件夹删除之后重新进去@服务社区李珊:清理后,登陆到这个界面就卡死了,怎么回事呢??@服务社区李珊:@服务社区李珊:删除后重新进去,然后问题还是同样存在呢???@tanglin0:备份好数据之后,下载服务和社区,产品线,T1里面对应版本的补丁安装并执行补丁脚本后再操作。下载地址:
http://service.chanjet.com/chanjet/T1@服务社区李珊:已经打了最后一个补丁了、没有补丁可以再打了@tanglin0:去新建一个状态看下是否也存在这样的问题现象。若也是存在的话,先将软件数据卸载重新安装下,还未解决,则更换电脑,排除是否是电脑显卡问题
新账套不存在此现象的话,则您将客户账套数据在支持网 http://support.chanjet.com提交,有后台数据工程师进一步检测下吧 [/微笑]@服务社区李珊:这台电脑以前是可以的,但重装了一下电脑后再重装软件就出现这样的情况,这台电脑是T1的服务器端。客户端也一样的有这个问题,所以我推测应该不是电脑显卡的问题。预计应该是要重装软件。
用友知识库
更多使用技巧
热点文章
问题解答
-
在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收款机怎样往里录入供应商还有库存管理,是不是不录入供应商信息就无法使用库存呢?希望高手解答。
- 阿里怎么设置付款减库存
产品介绍
产品资讯
-
用友在使用企业门户时总会报错,特别是一些与查询有关的操作
用友在使用企业门户时总会报错,特别是一些与查询有关的操作在使用企业门户时总会报错,特别是一些与查询有关的操作
问题版本: 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]单位欠款
|