Answer / 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.

What are the tables associated with Invoice in AP?

4 Answers  

---

Use of recurring invoice?

2 Answers  

---

I paid 10,000 Rs in advance to the employee for meeting his expenses. The employee met only 5000 expenses and the remaining 5000 he has to retern to the company. How will you define it.

4 Answers   Sonata,

---

How can FSG be generated to provide dynamic report i.e. current month, previous month and 2 months before balances for a given period?

1 Answers  

---

How can i deactivate the segment value?

2 Answers  

---

What is the Process of Fixed Asset From Inducation to Disposal & what are the journal entry in GL , AP AND IN OTHER MODULES

1 Answers   Ramco,

---

How to set different interest rates for different suppliers ?

3 Answers   IBM,

---

what is commitment (Warranty invoice) in AR?

2 Answers   Ernst Young,

---

Can two users use same payable document simultaneously? If yes, which user will get the document number assigned first?

2 Answers  

---

what is the impact if i wrongly assign the account type to an segment value in oracle apps r12?

1 Answers   Dhanush Infotech,

---

IS Automatic writeoff allowed for both over n under payments??

3 Answers  

---

how accounting transactions in AP module??

2 Answers   UST,

---