Answer Posted / tgs100
For AP, there are few standard steps.
1. Complete the invoice import process - Make sure that no records get struck in invoice interface table.
2. Run Invoice Validation with option as "All" and make sure that all the invoices are validated in the period in which closing is done.
3. All the invoices are approved (if applicable), accounted and transferred to GL.
4. All the payment batches (which belongs to the closing period) are in either confirmed status or in cancelled status.
5. Accounting is done for all payment batches and transferred to GL.
6. Optionally use sweep program to transfer documents to next period. (Better to get concurrence from finance before any sweep).
7. Run "AP Data Validation Report" (available in R12.2, check if it is available in earlier versions). This report can be used to check all the errors.
8. Run standard reconciliation reports like Posted invoice register, Posted Payment Register, Trial balance report.
Standard formula is Prev period closing balance in trial balance+invoice register total-payment register total = current period trial balance closing balance.
Compare the results with the account analysis report and GL trial balance reports.
Note: It is very easy to list down the above steps, but in reality, reconciliation is a very tedious process (atleast for few months), nothing tally in one go.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to Reconciliation AP to CM ? How to Reconciliation AR to CM ?
What is multi org? What is difference between 11i and 12i multi org structure?
Provide an overview of AR cash receipt processing.
What is difference between primary and secondary ledger
What are register in India localisation?
I am currently working in reputed Org as a Oracle apps end user (AR). Learned R12 functional course, but no real time exp as in support or implementation project.Please guide. thank you.
What is the Process of Reconciliation Between AP to GL
Re: what are the Issue that we face in Gl,PO and AP while Supporting
We have both consumption tax and With Holding Tax on each invoice, will there be any conflict involved?
What is gap analysis, how do you defined. What are the pre-requisities?
What are the types of setups in apps inventory module
What is the Invoicing System in Oracle R12
what is VAT claim process?
Hi I'm new in ERP - Oracle Application i appriciate if any one help me in this issue i need SQL to get badeget balance Acutal Balance Encumbrance Balance fund Avalable thanx ahmed
can any one tell me what exactly functional consultant do on daily basis? client requirements?
