--凭证年度结转 出现科目错误，管理项目多一个勾。 
--SELECT * FROM SACCT WHERE CO_CD='1000'
UPDATE SACCT SET NORM_CD1 ='0', NORM_CD2='0' WHERE CO_CD='1000'


hezheyuluo  136-0530-2009 
--固定资产年度结转 出现错误
SELECT * FROM ASSET WHERE CO_CD='2000' AND DIV_CD='1000'
SELECT * FROM ASSET WHERE GET_AM='0'					 --查看资产原值=0项
SELECT * FROM ASSET WHERE DUMMY1<>'0' DUMMY1 AND		 -- 有0.00 或空值
--计提方法－DPRE_FG= N'1',  折旧年限－DPRE_CNT= 6, 净残值率－SLACK_AM，  折旧状态－ DPRE_ST 
SELECT * FROM ASSET WHERE DUMMY1='' or DUMMY1 IS NULL 
-- UPDATE ASSET SET DUMMY1='0' WHERE DUMMY1='' or DUMMY1 IS NULL  
SELECT * FROM ASSET WHERE GET_AM='0' OR  DUMMY1<>'0' OR DUMMY1='' or DUMMY1 IS NULL   --全部，不行查新资产折旧状态错误，
SELECT * FROM ADPREY WHERE GISU='11'
-- DELETE  FROM ADPREY WHERE GISU='11' AND CO_CD='2000'
--ADPREY- 固定资产折旧数据表，查看哪个资产没有数据。 
SELECT ASSET_CD FROM ASSET WHERE  ASSET_CD NOT IN ( SELECT ASSET_CD FROM ADPREY WHERE GISU='11' ) AND CO_CD='1000'
-- 再不行把[SPA_DEPREM_C]存储过程的TANSACTION注释掉结帐后查看哪个资产没有结转过去。


--凭证借贷不平时记账审核的凭证恢复到录入状态--
SELECT * FROM ADOCUH WHERE ISU_DT='20080331' AND ISU_SQ='78' and co_cd='8000'
--UPDATE ADOCUH SET DOCU_ST='0',FILL_NB='0',FILL_DT='00000000',SET_ID='',ADMIT_ID='' WHERE ISU_DT='20080331' AND ISU_SQ='7' and co_cd='1000'


--ERPX升级到ICUBE资产减少不对
--0.
select * from asset_d where chg_fg = '2'
--1.
update adprey set pre_am = (select pre_am=pre_am+grow_am from adprey where asset_cd='test2' and gisu = '3')
 where asset_cd='test2' and gisu = '4' --资产减少年度

update adprey set drop_am = pre_am,drop_dam = pre_dam+cur_dam where asset_cd='' and gisu = --资产减少年度
--2.
update adprey set pre_am = 0,drop_am = 0,pre_dam=0,cur_dam=0,drop_dam = 0 where asset_cd='' and gisu > 


找出-结算资料录入-固定资产折旧-累计折旧科目为空的项目
--INSERT INTO AFSCLSD_CFG_ASSET (CO_CD,GR_CD,CTRL_VL)
SELECT '1000',A.GR_CD,A.CT_DEPT
FROM ASSET A
LEFT OUTER JOIN AFSCLSD_CFG_ASSET B ON A.GR_CD = B.GR_CD AND A.CT_DEPT = B.CTRL_VL
WHERE B.CTRL_VL IS NULL
GROUP BY A.GR_CD,A.CT_DEPT,B.CTRL_VL


/*
DELETE FROM ADSUM

INSERT INTO ADSUM (CO_CD,DIV_CD,FILL_DT,ACCT_CD,DRCR_FG,ACCT_AM)
SELECT A.CO_CD,A.DIV_CD,A.FILL_DT,A.ACCT_CD,A.DRCR_FG,SUM(A.ACCT_AM)
FROM   
  (SELECT A.CO_CD,A.DIV_CD,A.FILL_DT,A.DRCR_FG,A.ACCT_CD,A.ACCT_AM
   FROM ADOCUD A
   INNER JOIN ADOCUH B ON A.CO_CD = B.CO_CD AND A.ISU_DT = B.ISU_DT AND A.ISU_SQ = B.ISU_SQ AND A.DIV_CD = B.DIV_CD
   WHERE  B.FILL_DT > '00000000' ) A
GROUP BY A.CO_CD,A.DIV_CD,A.FILL_DT,A.ACCT_CD,A.DRCR_FG
*/