Background：用户cancel invoice并错误地创建会计分录到2010-12（实际应该是2009-12），未传递到GL，SQL修正，请谨慎使用

----UPDATE------------1
CREATE TABLE AP_INVOICE_DISTRIBUTIONS_BAC
AS SELECT * FROM AP_INVOICE_DISTRIBUTIONS_ALL
WHERE INVOICE_ID IN (215563,215564)
AND ACCOUNTING_DATE=TO_DATE('2010-12-01','YYYY-MM-DD')

UPDATE AP_INVOICE_DISTRIBUTIONS_ALL
SET ACCOUNTING_DATE=TO_DATE('2009-12-01','YYYY-MM-DD')
,PERIOD_NAME='Dec-09'
WHERE INVOICE_ID IN (215563,215564)
AND ACCOUNTING_DATE=TO_DATE('2010-12-01','YYYY-MM-DD')

----UPDATE-------------2
create table accounting_event_backup as select * from ap_accounting_events_all
where org_id=102
and accounting_date=to_date('2010-12-01','yyyy-mm-dd')
order by creation_date desc

update ap_accounting_events_all
set ACCOUNTING_DATE=TO_DATE('2009-12-01','YYYY-MM-DD')
where org_id=102
and accounting_date=to_date('2010-12-01','yyyy-mm-dd')

----UPDATE------------3

create table ap_ae_headers_all_back as

select * from ap_ae_headers_all

where accounting_event_id in (258937,258936)

update ap_ae_headers_all
set ACCOUNTING_DATE=TO_DATE('2009-12-01','YYYY-MM-DD')
, PERIOD_NAME='Dec-09'
where accounting_event_id in (258937,258936)

 

-------------------传递GL，测试OK