问题现象: | 固定资产做了部门变动后,卡片管理中原值合计数与变动前不一. 六月,部门为制炼车间的固定资产原值合计为42667045.51 七月,在制炼车间下级部门间做了变动后,固定资产原值合计为42667045.52 但手工将固定资产卡片原值累计,则为 42667045.53. |
问题原因: | |
解决方案: | 您好 该数据再次分析答复如下: 远程已经解决了卡片管理和对账界面数据不一致问题,如果需要再对固定资产原值一览表,需要更改其他表数据, 客户数据是由于后台尾差造成的,如果非要修改,需要修改所有表的数据,请和客户协商,慎重考虑.并提前做好数据备份. 一,请执行脚本: update fa_cards set dblvalue=12569.35 from fa_cards where scardnum='00564' update fa_Cards_Detail set dblvalue=12569.35 from fa_Cards_Detail where scardnum='00564' update fa_DeprTransactions_Detail set dblmonthvalue1=12569.35,dblmonthvalue2=12569.35,dblmonthvalue3=12569.35, dblmonthvalue4=12569.35,dblmonthvalue5=12569.35,dblmonthvalue6=12569.35,dblmonthvalue7=12569.35, dblmonthvalue8=12569.35,dblmonthvalue9=12569.35,dblmonthvalue10=12569.35, dblmonthvalue11=12569.35,dblmonthvalue12=12569.35 from fa_DeprTransactions_Detail where scardnum='00564' update fa_DeprTransactions set dblinputvalue=12569.35,dblmonthvalue=12569.35,dblperiodvalue=12569.35,dblmonthvalue0=12569.35, dblmonthvalue1=12569.35,dblmonthvalue2=12569.35,dblmonthvalue3=12569.35,dblmonthvalue4=12569.35,dblmonthvalue5=12569.35, dblmonthvalue6=12569.35,dblmonthvalue7=12569.35,dblmonthvalue8=12569.35,dblmonthvalue9=12569.35,dblmonthvalue10=12569.35, dblmonthvalue11=12569.35,dblmonthvalue12=12569.35 from fa_DeprTransactions where scardnum='00564' -- update fa_cards set dblvalue=12569.36 from fa_cards where scardnum='00565' update fa_Cards_Detail set dblvalue=12569.36 from fa_Cards_Detail where scardnum='00565' update fa_DeprTransactions_Detail set dblmonthvalue1=12569.36,dblmonthvalue2=12569.36,dblmonthvalue3=12569.36, dblmonthvalue4=12569.36,dblmonthvalue5=12569.36,dblmonthvalue6=12569.36,dblmonthvalue7=12569.36, dblmonthvalue8=12569.36,dblmonthvalue9=12569.36,dblmonthvalue10=12569.36, dblmonthvalue11=12569.36,dblmonthvalue12=12569.36 from fa_DeprTransactions_Detail where scardnum='00565' update fa_DeprTransactions set dblinputvalue=12569.36,dblmonthvalue=12569.36,dblperiodvalue=12569.36,dblmonthvalue0=12569.36, dblmonthvalue1=12569.36,dblmonthvalue2=12569.36,dblmonthvalue3=12569.36,dblmonthvalue4=12569.36,dblmonthvalue5=12569.36, dblmonthvalue6=12569.36,dblmonthvalue7=12569.36,dblmonthvalue8=12569.36,dblmonthvalue9=12569.36,dblmonthvalue10=12569.36, dblmonthvalue11=12569.36,dblmonthvalue12=12569.36 from fa_DeprTransactions where scardnum='00565' -- update fa_cards set dblvalue=82588.84 from fa_cards where scardnum='00417' update fa_Cards_Detail set dblvalue=82588.84 from fa_Cards_Detail where scardnum='00417' update fa_DeprTransactions_Detail set dblmonthvalue1=82588.84,dblmonthvalue2=82588.84,dblmonthvalue3=82588.84, dblmonthvalue4=82588.84,dblmonthvalue5=82588.84,dblmonthvalue6=82588.84,dblmonthvalue7=82588.84, dblmonthvalue8=82588.84,dblmonthvalue9=82588.84,dblmonthvalue10=82588.84, dblmonthvalue11=82588.84,dblmonthvalue12=82588.84 from fa_DeprTransactions_Detail where scardnum='00417' update fa_DeprTransactions set dblinputvalue=82588.84,dblmonthvalue=82588.84,dblperiodvalue=82588.84,dblmonthvalue0=82588.84, dblmonthvalue1=82588.84,dblmonthvalue2=82588.84,dblmonthvalue3=82588.84,dblmonthvalue4=82588.84,dblmonthvalue5=82588.84, dblmonthvalue6=82588.84,dblmonthvalue7=82588.84,dblmonthvalue8=82588.84,dblmonthvalue9=82588.84,dblmonthvalue10=82588.84, dblmonthvalue11=82588.84,dblmonthvalue12=82588.84 from fa_DeprTransactions where scardnum='00417' -- update fa_cards set dblvalue=82588.84 from fa_cards where scardnum='00418' update fa_Cards_Detail set dblvalue=82588.84 from fa_Cards_Detail where scardnum='00418' update fa_DeprTransactions_Detail set dblmonthvalue1=82588.84,dblmonthvalue2=82588.84,dblmonthvalue3=82588.84, dblmonthvalue4=82588.84,dblmonthvalue5=82588.84,dblmonthvalue6=82588.84,dblmonthvalue7=82588.84, dblmonthvalue8=82588.84,dblmonthvalue9=82588.84,dblmonthvalue10=82588.84, dblmonthvalue11=82588.84,dblmonthvalue12=82588.84 from fa_DeprTransactions_Detail where scardnum='00418' update fa_DeprTransactions set dblinputvalue=82588.84,dblmonthvalue=82588.84,dblperiodvalue=82588.84,dblmonthvalue0=82588.84, dblmonthvalue1=82588.84,dblmonthvalue2=82588.84,dblmonthvalue3=82588.84,dblmonthvalue4=82588.84,dblmonthvalue5=82588.84, dblmonthvalue6=82588.84,dblmonthvalue7=82588.84,dblmonthvalue8=82588.84,dblmonthvalue9=82588.84,dblmonthvalue10=82588.84, dblmonthvalue11=82588.84,dblmonthvalue12=82588.84 from fa_DeprTransactions where scardnum='00418' 二.执行完上面脚本后,再对数据库执行工具: 固定资产总账重算工具89x.exe 这里测试,卡片管理,对账,固定资产原值一览表的数据均一致. 由于直接修改数据库,修改前请务必做好数据备份,验证确认没有问题再使用! 如对问题答复有疑问敬请及时反馈 U8/CRM/PLM |
相关补丁: | |
版本: | 8.90 |
模块: | 固定资产 |
产品: | 财务会计 |
问题名称: | 固定资产做部门变动后原值合计数与变动前不一致 |
最后更新: | 2011-08-25 23:24:39 |