Answer Posted / r dhamu

System will not generate Entries for Requisition, Quotation and Purchase Order.

When we receive the Goods &Receipt

Inventory Receiving A/C Dr
Inventory AP Accural A/C Cr

When Goods Move to Inventory

Inventory Material Value A/C Dr
Inventory Receiving A/C Cr


When we enter the Invoice in AP Module

If we match with PO

AP Accrual A/C Dr
Liability A/C Cr

If we do not match with PO

Charge or Item Expense A/C Dr
Liability A/C Cr

When we issue the Payment for entered Invoice

Liability A/C Dr
Cash Clearing A/C Cr


When Reconcile or Clear the Payment

Cash Clearing A/C Dr
Cash A/C Cr

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

2083

---

I am working on PPR process to print checks. Currently the checks are printing for each supplier, supplier site and payment method group. My requirement is the invoice level one DFF is available (like A and B are the input values). Please let me know how include this DFF at invoice grouping level.

1621

---

In Subinventories Form, how to enable the Locator Control. A message displayed when changing the drop down list "FRM-40200: Field is protected against update.

3148

---

HI, once we create the standard invoice then we can get journal entry item expense a/c-dr to liability a.c then item it will reflect through inventory, but liability a/c . it will reflect from GL , it is possible .

1955

---

What do you mean by Category Set ? and what is its Relevance ?

2420

---

How do write a discoverer report to identify zero dollar suppliers/invoices where the supplier is on hold?

2705

---

Explain about Localization (IND & US ) in Oracle Apps ?

3147

---

What is the Invoicing System in Oracle R12

1415

---

What is meaning of deprecation?

1137

---

What is the use of gl set of books name, while configure multiorg?

1095

---

When we run a GL Reconciliation Report, we also see the void payments in that report. Even though i disable the option of Show Void payments, its appearing in the report.How do i proceed so that i dont see those void payments in the GL Reconciliation Report?

2905

---

Explain Customization process?

1946

---

I am created credit memo in at but while trying to complete it showing error message-hz_party_location

1452

---

explain with examples what r the roles & Responsiblities of a functional consultant who reviews the Test Scripts, Test Cases and Test Execution Results of AP, FA and GL.

2578

---

what is the difference between before pages trigger and after parameter trigger in reports ?

2394

---