Wednesday, September 02, 2015

Difference between Draft, Final, etc in Create Accounting / Online Accounting

Online Create Accounting:

1. Create Draft Accounting:

Draft will create journal entries, which are not final, which means they are not ready to be transferred to GL.

You can see the accounting in xla_ae_headers and xla_ae_lines. But the xla_ae_headers.accounting_entry_status_code is D and also the xla_events.process_status_code is D and event_status_code is U.

You can run create accounting on this transaction again and again, which will delete the old journal entries and create new ones.

You can't transfer these journal entries to GL.

2.Create Final Accounting:

Final will create journal entries, which can be transferred to GL.

You can see the accounting in xla_ae_headers and xla_ae_lines. But the xla_ae_headers.accounting_entry_status_code is F and also the xla_events.process_status_code is P and event_status_code is P.

Once it is finally accounted you can't run create accounting on the particular transaction (specifically on that event).

You can transfer them to GL using Transfer Journal Entries to GL program.

3. Create Final Accounting Post To GL:

Final Post will create journal entries in final mode, transfer them to GL and post them.

You can see the accounting in xla_ae_headers and xla_ae_lines. But the xla_ae_headers.accounting_entry_status_code is F and also the xla_events.process_status_code is P and event_status_code is P.

Once it is finally accounted you can't run create accounting on the particular transaction (specifically on that event).

It will transfer the journal entries to GL using Journal Import and you can find the data in gl_je_headers and gl_je_lines.
Now the xla_ae_headers.transfer_status_code is Y.
And also it will post to gl_balances (gl_je_headers.status is P).

Create Accounting (concurrent program): (For more entities)

1. Accounting Mode: Draft

 It is same as Draft online accounting.

2. Accounting Mode: Final, Transfer to GL: No

It is same as Final online accounting.

3. Accounting Mode: Final, Transfer to GL: Yes, Post to GL: No

 It will create journal entries in final mode, transfer them to GL.

You can see the accounting in xla_ae_headers and xla_ae_lines. But the xla_ae_headers.accounting_entry_status_code is F and also the xla_events.process_status_code is P and event_status_code is P.

Once it is finally accounted you can't run create accounting on the particular transaction (specifically on that event).

It will transfer the journal entries to GL using Journal Import and you can find the data in gl_je_headers and gl_je_lines.
Now the xla_ae_headers.transfer_status_code is Y and gl_je_headers.status is U.

4. Accounting Mode: Final, Transfer to GL: Yes, Post to GL: Yes

 It is same as Final Post online accounting.

Main differences:
1. Report Output
2. Bulk Accounting

No comments:

Post a Comment

Clear BNE Cache for WebADI Changes

It Sometime happens that WebAdi Changes doesn't reflect once migrated in controlled instances. Here are the quick steps(Generally perfor...