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

By
Advertisement


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

4 comments:

  1. My cousin recommended this blog and she was totally right keep up the fantastic work!



    Account Software

    ReplyDelete
  2. Hi Valli,

    Thanks for your reply.

    Regards,
    Raju.

    ReplyDelete
  3. Very interesting blog. Thanks for sharing this useful information.

    Want to buy Auto repair shop software mechanic garage.

    ReplyDelete
  4. My spouse and I love your blog and find almost all of your posts to be just what I’m looking for. Appreciating the persistence you put into your blog and the detailed information you provide. I found another one blog like you Oracle ADF.Actually I was looking for the same information on internet for Oracle Application Development Framework and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.


    ReplyDelete