Posted on February 18th, 2008 by Sanjit Anand |
Print This Post
|
Email This Post
Receivables is integrated with the following modules Cash Management, General Ledger and ipayment in Oracle Financial and have a integration with OM , Pricing , Inventory module within EBS. This can be best understood as:
Lets take some of integration aspect of Oracle AR.
Projects to Receivables
Normally invoices are transferred from Projects to Receivables for billable projects by running the PRC: Interface Invoices to Receivables request from a Projects Responsibility.
Important data in the information flow are: Customer, Line Detail.
Receivables to Cash Management
Cash Management selects Receipts directly from the Receivables tables to reconcile with bank statements.
Important data in the information flow are: Receipt Number, Receipt Amount, Date, Customer, Application Detail.Cash Management selects Unpaid Invoices and Receipts directly from the Receivables tables as Inflow components in the Cash Forecast.
Important data in the information flow are: Amount.
Cash Management to Receivables
Cash Management directly updates Receivables tables with reconciled Receipt information. Important data in the information flow are: Amount Cleared, Receipt Cleared Date, Bank Charges, Bank Errors, Rate Gain/Loss.
Receivables to General Ledger
Invoices (including Debit Memos and Credit Memos), Receipts (including Miscellaneous), Adjustments, and Charge backs are transferred from Receivables to the General Ledger by running the General Ledger Interface request from a Receivables Responsibility. Important data in the information flow are: Code Combination, Journal Amount.
The following data is shared with other modules: Customers, Banks, Payments Terms, Tax Codes, Code Combinations, Units of Measure, Items, Categories, Employees.
Receivable Integration in OPM
The following diagram clearly explain the Receivable Integration in OPM.
March 26th, 2008 at 4:20 am
Hi
Can you give me a standard solution to refund Customer Advance.
The solution that I am following is:
I have defined a Party as a Supplier as well as Customer.
I am finding the Deposit balance (Eg. 1000 USD) as of a particular date. I need to refund this 1000 USD.
Then I am creating a dummy AR Invoice for (1000 USD) and closing the Deposit.
Then I am creating a Standard Invoice in AP for 1000 USD.
Finally making the payment for 1000 USD as refund.
Is this the standard solution or is there any other solution. Pls advise.
April 13th, 2008 at 5:51 am
We got something similar process. For ex: customer has paid advance cash against some sales. Later Ordger gets returned and Credit Note gets created but the customer wants the money back ( or may be Order itself gets cancelled). We are creating AR Debit Memo which gets applied with Cash receipt received as Advance. Then AP invoice is created to pay the refund money to the customer.
April 13th, 2008 at 5:52 am
But I too has got the same clarification. Is this the only way to refund ?
April 13th, 2008 at 5:53 am
But I too have the same question. Is this the only way to refund ?
April 13th, 2008 at 6:10 am
use AP-AR netting
which is called Contra in Release 11i
Offsetting is taking care by seeded funcationlity.
April 13th, 2008 at 6:21 am
If your customer is requesting a refund for goods returned, follow these procedures to clear the credit entry from Accounts Receivable and process a
refund through Accounts Payable. This is a manual process between AR and AP.
A. Create a credit memo in AR for the returned goods. Use the same Revenue and Receivable accounts referenced on the original invoice. Here are the entries to be made:
Receivable Revenue
————— ————-
| 100 100 |
B. Create a debit memo to offset the credit memo. Use a special Debit Memo
transaction type that uses a clearing account rather than Revenue. This
will cause the following general ledger entries to be made:
Receivable Clearing
————— ————-
100 | | 100
C. In Oracle Accounts Payable, process a check crediting $100 to cash and
debiting the clearing account for $100 as below. This returns the cash and
all other accounts to zero.
Receivable Clearing
————— ————-
| 100 100 |
July 14th, 2008 at 5:03 am
Hi Anand
THe diagramatic representation of Oracle AR integration with OPM gives a good insight into the process and thanks for the same. Howsoever much the link between Sales orders and the data import into Oracle AR using Auto invoice requires more inputs.
Thanks & Regards
Ramg