系统余额表不平衡gl_balances

Oracle_FIN

winmaster 发表于 2012-4-17 08:22
各位好，还没解决，影响到二个汇总科目（应收账款_缺省，主营业务收入_外销），共计20个明细科目，想UPdate ...

正规应该把QUARTER_TO_DATE和PROJECT_TO_DATE数据也改了。汇总科目不用管，删除汇总模板后重建，系统会重新计算

hanfei108

最近我也遇到类似问题，感谢大家指点，现附上Update SQL：
-- 12211 Nov-13

UPDATE gl_balances
   SET begin_balance_cr = begin_balance_cr - 106.23
      ,quarter_to_date_cr = quarter_to_date_cr - 106.23
      ,project_to_date_cr = project_to_date_cr - 106.23
WHERE set_of_books_id =  ***
and code_combination_id = 51302
and period_name = 'Nov-13';

-- 12211 Dec-13
UPDATE gl_balances
   SET begin_balance_cr = begin_balance_cr - 106.23
      ,quarter_to_date_cr = quarter_to_date_cr - 106.23
      ,project_to_date_cr = project_to_date_cr - 106.23
WHERE set_of_books_id = ***
and code_combination_id = 51302
and period_name = 'Dec-13';

-- 60611 Nov-13

UPDATE gl_balances
   SET begin_balance_dr = begin_balance_dr - 106.23
      ,quarter_to_date_dr = quarter_to_date_dr - 106.23
      ,project_to_date_dr = project_to_date_dr - 106.23
WHERE set_of_books_id = ***
and code_combination_id = 49500
and period_name = 'Nov-13';

-- 60611 Dec-13

UPDATE gl_balances
   SET begin_balance_dr = begin_balance_dr - 106.23
      ,quarter_to_date_dr = quarter_to_date_dr - 106.23
      ,project_to_date_dr = project_to_date_dr - 106.23
WHERE set_of_books_id = ***
and code_combination_id = 49500
and period_name = 'Dec-13';

/

zerojust

按照楼上修复的方法就可以解决了吗

zerojust

通用遇到这个问题，ORACLE 11i的