|Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today|
Manual Subledger Journal
A manual subledger journal entry is not associated with a transaction or document of a subledger application. When users create a manual subledger journal entry, it is created with the event class and event type Manual that is seeded automatically when the subledger application is registered.
Why Its Needed
Manual entries are typically adjustments in nature. If the adjustments are due to specific subledger activity such as Payables or AR or FA, then you may want to enter an SLA manual entry instead of a GL entry.
Such entries to recorded in SLA are tied the subledger source and therefore provided more accurate subledger accounting reporting.
You need to have account, debit, and credit amounts, and accounting class in Order to pass a manual entry. in case if you have to optionally enter third party information then description, and currency details for each line of the subledger journal entry is important.
Manual journey entry process
The figure below shows the create and complete manual journey entry process and is described below.
Options 1 :Create manual Journal Entries in XLA
Lets say you have to made a JE via XLA for AR, then with your Receivables Responsibility you need to please perform the following:
Inquiry --> Accounting --> Subledger Journal Entries --> Headers
Click on Create Journal Entries
Enter the following:
Ledger: <Enter the ledger Name>
GL Date: <Click on the Calendar Icon and choose the appropiate date>
Category: <Choose the correct Category from the LOV by Clicking on the magnifying lense>
Description: <Enter the description>
Enter the Accounts and the amounts
Click on Continue.
Click on Finish.
Options 2 :Create manual Journal Entries in XLA via API's
In last post, we found the API . let do a quick mapping with API functions with these :
The create and complete manual journal entry process includes the following steps:
- Create journal entry header is typically done by calling CREATE_JOURNAL _ENTRY_HEADER API.
- Create journal entry line is typically done by calling CREATE_JOURNAL_ENTRY_LINE API.
- Update the journal entry header is typically done by calling UPDATE_JOURNAL_ENTRY_HEADER API.
- Update the journal entry line is typically done by calling UPDATE_JOURNAL_ENTRY_LINE API.
- Delete the journal entry line is typically done by calling DELETE_JOURNAL_ENTRY_LINE API.
- Complete the journal entry is typically done by calling COMPLETE_JOURNAL_ENTRY API.
- Optionally, reverse the journal entry is typically done by calling REVERSE_JOURNAL_ENTRY API.
Users can delete the journal entry at anytime by calling DELETE_JOURNAL_ENTRY API if the journal entry is not transferred to General Ledger.
Reconcile Manual Journal Entry Lines
In case if you want to utilize the Reconciliation Reference , you need to enter the Reconciliation Reference in the Other Information tab before entering the journal lines.
As per the R12 User's Guide page 1-216, "The header level reconciliation reference must already be provided before the reconciliation journal line is created for the reference value to apply to the line. Changing this header level reconciliation reference will not automatically update existing reconciliation JE lines, but will apply to new journal lines added after the change. You can manually update the reconciliation reference of the individual journal lines anytime before the journal is posted."
Therefore you have to create new manual Journal and before entering Journal lines, and you need to capture reconciliation reference at header level (Other Information tab) then create Journal lines and then you will be able to find out the corresponding Journal lines in the Reconciliation form.