你好- 客户开票日期格式原来是yyyy-mm-dd,开了一部分销售单,单号是每天递增, 但是我给把格式改成yyyy-m-d,在开销售单票号又0001开始递增(做了29张单据),现在在软件里就找不到这29张单据,但是总库存数已经减少了,
2019-4-5 8:0:0 用友NC小编你好- 客户开票日期格式原来是yyyy-mm-dd,开了一部分销售单,单号是每天递增, 但是我给把格式改成yyyy-m-d,在开销售单票号又0001开始递增(做了29张单据),现在在软件里就找不到这29张单据,但是总库存数已经减少了,
你好 客户开票日期格式原来是yyyy-mm-dd,开了一部分销售单,单号是每天递增, 但是我给把格式改成yyyy-m-d,在开销售单票号又0001开始递增(做了29张单据),现在在软件里就找不到这29张单据,但是总库存数已经减少了,[]请查询时间用1999-01-01到9999-01-01查询,并且请时间格式更改为之前的格式
如果您的问题还没有解决,可以到 T+搜索>>上找一下
相关阅读
- 用友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
- 期初余额无法录入累计贷和累计借2019-4-5 8:0:0
- 客户每次查询明细账,都跳出来的错误,一台客户端,别的没问题,重做系统没解决,帮忙看看2019-4-5 8:0:0
- 客户端提示登录失败,账套用户名正确的可以看见,这么解决2019-4-5 8:0:0
- 客户端登录提示13错误2019-4-5 8:0:0
- 客户端装好后,登入提示-运行时错误“13”,类型不匹配是怎么回事?在装的时候是没有保错的2019-4-5 8:0:0
- 请问找不到加密狗是什么原因2019-4-5 8:0:0
最新信息
- 你好老师,我这有个客户用的T3标准版10.8plus1,客户端安装好后,能连接到服务器,但是一点击核算管理,就提示子系统注册失败,请问是怎么回事
- 你好,我T+快速计提报错241,根据服务社区的文档改了之后点击固定资产就报错英文了,什么问题哦?
- 你好,我使用的是T+12.0的普及版,重装电脑系统后重装软件,登录帐套后查询应收总账提示如下图,打上最新补丁后还是提示这个错误,请问怎么解决,谢谢
- 请问找不到加密狗是什么原因
- 我重做系统,重装了T3,win732位,现在打开T3,点总账系统,如图1,点一下,出图2,这是神么原因
- 登录 后提示这个是为什么?
- 241数据库错误,什么原因,数据库可以联通
- G3帐务管理系统 进入总帐系统时出现如下错误,怎么处理?
- G6固定资产初始化完成,点部门对应折旧科目时提示初始化时发生错误,请从新进去设置如图
- T+11.6产品进行12月份结账时提示这个错误,请问怎么解决
您好 T1财贸宝 更换数据库 两个数据库里面安装路径里面都没有物理文件了 但是还是提示数据库同名了 建不了账套 两个不同的数据库 允许重名吗你可以新建帐套后面加个1嘛,这样名字就 不一样了,就可以新建了数据库master表sublist里肯定有原账套的记录在,您换个账套名@服务社区黄旻:我需要物理替换 所以就不能改账套名回复 梦之蓝2016:把物理文件重命名,或是但我说的那张表里去删除账套信息
- 用友U8 U851总账录入凭证时,录辅助核算无法选入
- 用友U8 在增加发货单界面不能查询以前录入的单据,复制功能也不能使用
- 用友U8 在存货核算中,进行各种单据修改时,提示:单据保存失败,无法将CHAR值转换为MONEY,该CHAR值的语法有误,修改单据失败!该问题在所有的机器上都存在。
- 用友U8 客户端查询银行日记账没有数据出现,其他客户端和服务器正常
- 用友U8 注册UFO时,提示-账套-年度错误-
- 用友U8 环境有问题
- U8其他明细账进行账簿打印时,服务器与工作站显示的内容不一致
- U8其他经常性站点提示“帐套年度错误”?
- 用友U8其他812工资汇总工资类别的数据不正确
- 用友U8其他812无法升级到852
凭证非套打模版文件 凭证非套打模版文件
问题号: | 39507 |
---|---|
适用产品: | T6系列 |
软件版本: | T6-企业管理软件V6.1 |
软件模块: | 总账 |
问题名称: | 凭证非套打模版文件 |
问题现象: | 凭证非套打模版文件名是什么,模版文件存放在什么路径下面。 |
问题原因: | 见问题答案。 |
关键字: | 凭证非套打模版文件 |
解决方案: | <P>1.金额式凭证非套打打印模板glpzje.rep,.外币数量式凭证非套打打印模板glpzwb.rep,根据总账–设–选项–账簿中凭证行数确定模版名称从5到20,如:金额式5行凭证非套打打印模板glpzje5.rep,金额式6行凭证非套打打印模板glpzje6.rep。</P> <P>2.凭证非套打模版存放的路径在T6安装路径下面,如T6安装在D盘,凭证模版文件路径在D:/T6SOFT/ZW/rep下面。</P> |
行业: | 通用 |
补丁编号: | |
解决状态: | 最终解决方案 |
录入日期: | 2016-03-16 15:23:45 |
最后更新时间: |
- T3打开系统管理就报这个错 系统时间的格式设置都没问题 怎么解决呀
- T3新做的系统,恢复帐套后,发现软件界面正下方这里的单位名称显示乱码。正常应该是显示加密锁注册的单位名称,是吧。这个乱码是怎么回事??版本10.8.2,更新了补丁。加密锁注册界面显示的名称正常。
- T3普及版,无法打开,界面上显示乱码,T3服务启用又停止,UF2000文本里也显示乱码,请问什么原因,怎么解决
- T3标准版10.6,安装在win7旗舰版32位,使用都正常,就是不能自动备份,产生的备份文件都是空的,知识库找的方法全部都测试过了,还是一样。
- t3标准版设置了自动备份,备份服务已经开启,为什么不自动备份
- T3标准版,子系统登录失败
- T3设置的自动备份没有备份是怎么回事啊?
- T6 6.5 设置备份计划,不执行 没有备份日志 。手工备份没有问题 。帐套路径没有问题,备份服务都启动了, 怎么回事啊?还有那个系统管理登录进去后,隔了几分钟 自动退出怎么回事 ?
- T6 手动备份成功 自动备份不行 日志显示备份失败 sql服务 日期格式那些都是正确的
- T63.3数据升级到T65.1后点击余额表时报错:从数据类型varchar转换为tinyint时出错,补丁打了,升级帐套时报错。怎么办呀???
对微利、亏损企业,可否减免印花税 对微利、亏损企业,可否减免印花税
根据国家税务总局《关于印花税若干具体问题的规定》(国税地字[1988]第025号)第二十条的规定,对微利、亏损企业不能减免印花税。但是,对微利、亏损企业记载资金的帐簿,第一次贴花数额较大,难以承担的,经当地税务机关批准,可以允许在三年内分次贴足印花。
资产清查 之前的包装盒不见了 急需一个 T3企业管理信息化软件教育专版-营改增版10.8.2 盒子 书 光盘 资产清查 之前的包装盒不见了 急需一个 T3企业管理信息化软件教育专版-营改增版10.8.2 盒子 书 光盘[]
您好,软件是从哪个经销商买的呢?您联系一下他们。如果您着急,可以从咱们服务社区下载软件的安装文件、产品手册。
手册地址:http://service.chanjet.com/prodown/T3
软件的安装文件地址(第四个):http://service.chanjet.com/prodown/T3?page=2如果只是为了应对资产清查的话,完全可以把采购软件的发票、软件的安装程序、加密狗、采购合同及采集使用软件的操作界面。您公司是内部检查还是要上市做资产清查?其实,无论是哪种检查,发票、合同、付款的证明是最有力的证明。
用友U8财务会计外币科目期初余额 用友U8财务会计外币科目期初余额
1月份记帐已取消,在删除某费用科目的期初余额时,提示请输入金额;无法删除掉期初余额?因客户的科目是外币辅助核算,外币金额已经是零,但是本位币金额有数导致,增加本位币金额后删除外币可以删除,删除外币后将本位币金额删除。如有用友U8其它问题,请在下面回复疑问,我们将第一时间与您联系,帮助您解决问题。同时您也可以联系用友
用友天龙瑞德用友软件,用友财务软件,寻找用友U8服务商,咨询用友U8价格,用友U8多少钱?,用友U8报价,欢迎咨询。我们将竭诚为您服务。联系电话:010-59798025。网址:http://yun.kuaiji66.com用友云基地
- 用友T3通2005版2005年度查明细账总账第一列日期显示1999年
- 用友T6企业管理软件中打开工资模块时提示“区域选项日期标签页中的短日期格式应设置为yyyy-MM-d
- 用友记账宝创建账套保存时提示“启用期间过小”?
- 通2005在查询2005年明细账时左边日期却出现1999年但发生额和内容是正确。安月排序2005日期
- 通2005版2005年度查明细账,总账第一列日期显示1999年
- 用友U8 U851总账录入凭证时,录辅助核算无法选入
- 用友U8 “机器考勤数据符合要求的格式:考勤卡号+分隔符号+刷卡日期+分隔符号+刷卡时间;分隔符号:空格;刷卡日期格式:YYYY-MM-DD ;刷卡时间格式:HH24-MM-SS”这句话是考勤管理帮助中的,我反复看也没看懂,请举个例子详细说明一下。现用户要求刷卡机的考勤数据导入考勤管理中。
- 用友U8 升级报日期错,显示日期格式不对!
- 用友U8 在由812升级U852过程中先出现一个红叉又出现一个黄叹号(具分析问题应该出现在固定资产模块上)具体问题出现的提示有图片,和数据放在一起了.
- 用友U8 在系统管理中设置的备份计划没有得到执行。
卸载T+12.1 重新安装后,提示创建系统库失败,怎么解决?? 卸载T+12.1 重新安装后,提示创建系统库失败,怎么解决??[]
利用360清理下操作系统,重新后安装12.1版本删掉系统库,配置数据库 创建新的系统库@qq332055283:怎么删除系统库?可是电脑上的T6 、GRP—U8都能正常用的@用户7BVz2i:进数据库里面 有帐套数据就先备份物理文件,没有的话 直接删除@qq332055283:直接卸载T+重新安装,一直停在了配置产品80%不动;
- 用友T3通2005版2005年度查明细账总账第一列日期显示1999年
- 用友T6企业管理软件中打开工资模块时提示“区域选项日期标签页中的短日期格式应设置为yyyy-MM-d
- 用友记账宝创建账套保存时提示“启用期间过小”?
- 通2005在查询2005年明细账时左边日期却出现1999年但发生额和内容是正确。安月排序2005日期
- 通2005版2005年度查明细账,总账第一列日期显示1999年
- 保存报表时提示保存失败问题
- 银行对账单导入的时候,提示时间错误-
- 用友T3-财务通普及版10.8plus1无此任务号,不能释放?
- 用友T3中在查询2005年明细账时左边日期却出现1999年但发生额和内容是正确。安月排序2005日期
- 用友T3标准版设置好备份计划后不能自动备份
#行业问题#各位大师问一下,勘测工程收入三百万,但是是工程结束之后才开的票,假设工程在九月结束,那我1-8月先付出的劳务成本(都是现金付的没有库存)要怎么做?直接挂1-8月的主营成本吗?还是也是挂工程物资? #行业问题#各位大师问一下,勘测工程收入三百万,但是是工程结束之后才开的票,假设工程在九月结束,那我1-8月先付出的劳务成本(都是现金付的没有库存)要怎么做?直接挂1-8月的主营成本吗?还是也是挂工程物资?[]
补充一下,没有按合同进度什么的确认收入的,都是在开票期间确认全部收入的先进工程施工进行归集
- 用友运行错误
- 用友运行错误339,部件UFRTPrn.ocx
- G6医院专版10.6 环境:windows2008 R2 32位 数据库:SQL2005 SP2,自动备份日期文件夹生成了,但里面是空的,SQL代理服务也是启动的,还能怎么解决?
- G6点填制凭证提示错误
- sql2000数据库,如何实现自动备份,也添加了相应的计划,在指定的备份目录里只有空目录,没有文件,是不是还要打开哪个服务才能备份呢?谢谢!
- T+12.0普及版,在凭证管理审核凭证的时候回出现一个295数据库粗无,记账会出来8152数据库错误,在填制凭证那里审核记账没有问题,请问是怎么回事?(打过最新补丁,重新配置过数据库,SQL也是完整版的2008)
- T+12.0普及版,在凭证管理审核凭证的时候回出现一个295数据库错误
- T+12.0标准版,装了数据库2008R2的,系统是win7旗舰版32位的,收发存汇总表查询的时候出现如图所示的问题。请问要怎么处理呢?设置备份计划的时候,确定后,退出,却没有备份计划。
- T+12.0版本的审核凭证是出现数据类型报错,如下图
- T+导出数据时提示这个!怎样解决
用友知识库
更多热点文章
问题解答
-
单据记账之后不能恢复记账。
单据记账之后不能恢复记账。单据记账之后不能恢复记账。 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收款机怎样往里录入供应商还有库存管理,是不是不录入供应商信息就无法使用库存呢?希望高手解答。
- 阿里怎么设置付款减库存
产品介绍
产品资讯
-
凭证反记帐后修改会计科目提示241数据库错误
凭证反记帐后修改会计科目提示241数据库错误 凭证反记帐后修改会计科目提示241数据库错误
检查系统日期格式是否符合下面的要求:短日期格式:yyyy-MM-dd,长日期格式:yyyy-MM-dd'。(检查方法:点击”开始菜单“-”控制面板“,依次找到”时钟、语言和区域“-”设置时间和日期“-”更改日期和时间“-”更改日历设置“-”日历设置“-【日期】页签中进行查看和修改。)
如果修改后还有提示,请修改注册表:
"可以在注册表中HKEY_USERS\S-1-5-20\Control Panel\International 位置下的sShortDate的值改为 yyyy/M/d 。操作前对注册表做好备份,以免操作失误。
B.开始-运行中输入regedit ,修改注册表 ,去除这两个位置的特殊字符 ,并且使键一致(可参照正常机器修改,或者直接更换操作系统)
1.HKEY_CURRENT_USER\Control Panel\International下的“sShortDate” 'sDate' 中的格式
2.HKEY_USER\.Default\Control Panel\International下的“sShortDate” 'sDate' 中的格式
C.磁盘格式需要NTFS。
D、修改注册表:HKEY_USERS\.DEFAULT\Control Panel\International下sShortDate、sLongDate的值,去掉星期dddd。
【方法:先在控制面板里改好 然后复制粘贴到注册表里
而且长短格式都是yyyy-mm-dd
注册表里长日期格式默认没有yyyy-mm-dd 就在短日期格式里先选好然后复制粘贴到长日期里】参照你这个修改了也不行,没记帐的凭证可以修改,记帐的凭证反记帐后就不能修改了。用数据库检测修复工具检测下是否有一致性错误。工具下载地址:
http://gongju.chanjet.com/chan ... d%3D2
如果检查没错误不能处理的话,请在支持网提交问题和账套进一步测试和处理 -
刚装的T3,为什么打开出纳就会有这个提示呢?
刚装的T3,为什么打开出纳就会有这个提示呢? 刚装的T3,为什么打开出纳就会有这个提示呢?
检查看安装目录ufsmart--cnt--ufnotedata--data下有没有系统库的物理文件,有的话,数据库中分离该数据库后,再用物理文件附加,注意备份账套@服务社区刘明新:谢谢@XXWTH:[/微笑]@服务社区刘明新:为什么从出纳通以前导出来的现金日记账现在想导回去数据都是错的?@XXWTH:具体报错信息是什么@服务社区刘明新:导进去数都是错乱的@XXWTH:重新导出的在导入吧,第二个图的错误没有关系,不影响,点确定就可以了,第一个应该是格式问题,选标准的日期格式@服务社区刘明新:就是选标准的日期格式,但是以前导出来的时候就是2011年01月01日的日期格式,然后导入向导里边又是2011-01-01,所以提示错误,本来我想试着改EXCEL模板的日期,但是单元格格式设置那里没有YYYY-MM-DD的,自定义又不能批量设置,很奇怪,而且导入进去就是错的,也打了最新补丁了,是什么情况呢?@服务社区刘明新:这个怎么解决呢?提示的报错也就一直点确定了,但是就是导进去数据都对不上还是错的,明明是从系统导出来的为什么导进去会出现这种情况呢?@XXWTH:先导入一条试试,看是否正常,如果正常就是模版里面的相关记录有问题;