Create accounting Issue
Hi ,
We have some unprocessed events in create accounting : Eg
14517810 | 13795402 | DEPRECIATION | U | U | 31-MAY-2018 00:00:00 | N | 3452 | 02-MAY-2018 23:28:44 |
14540240 | 13795402 | ROLLBACK_DEPRECIATION | U | I | 30-APR-2018 00:00:00 | N | 3452 | 03-MAY-2018 21:25:07 |
We are currently in Aug- 18 and the query :
select ev.event_id, ev.event_type_code, ev.event_status_code, ev.process_status_code
from xla_events ev,
xla_transaction_entities et
where ev.application_id = 140
and ev.event_status_code not in ('N', 'Z', 'P')
and ev.process_status_code not in ('P', 'Z')
and et.entity_id = ev.entity_id
and et.valuation_method = 'CN CNY CORP'
order by ev.event_id;
As provided us earlier gives us 18 rows.