Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

R12 : Setting up for AP/AR Netting

Posted on January 21st, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

AP/AR Netting automatically compares Payables to Receivables and creates the appropriate transaction in each system to net supplier invoices and customer invoices. With this functionality, A receivables user can

  • View netted receipt details directly from the receipt
  • Create Netting Agreements and Netting Batches

With this functionality, there is significant increase in user productivity and effectiveness because of tight integration and automation.

You can access the process via:

  • Navigation: Receipts > Netting > Netting Batch
  • Navigation: Receipts > Netting > Netting Agreement
  • Receipts > Receipts > Action Menu : AP/AR Netting
    After Querying a netted receipt, the user can see more details about the batch by selecting AP/AR Netting from the Action menu. This launches the AP/AR Netting batch window. Netted Receipts are created automatically by the AP/AR Netting process and cannot be updated by the user from the Receipts Workbench

As we have seen Contra charging has been replaced by AP/AR Netting, lets take a setup walk though to use this functionality.

1.Define netting control account

Setup>Financials>Flex field>key>values

2.Create bank

Setup>payment>Bank and Bank Branches

You should note ,Payment document is not required for netting bank account.

3.Go to receivables responsibility, receipt class definition form

Setup>Receipts>Receipt class

Query the 'AP/AR Netting' receipt class which is a seeded one.

netting

4. Attach your bank account in this receipt class.

5.Go to system options, transaction and customer tabbed region, there enable 'Allow payment of Unrelated Transactions'check box

2-1

6. Create netting agreement

Receipts>Netting>Netting Agreement

3

7. Enter an Invoice in Payables, validate and run create accounting.

8. Enter a transaction in receivables.

9. Create Netting Batch

Receipts >Netting >Netting Batch

4-1

10. Query your netting batch and see the status as Complete. also click on view report icon on right side.click on run push button, you can see the final netting report.

11.Go to view>request>find

You can see 3 concurrent request programs

  • Create Netting batch
  • Settle netting batch
  • Netting Data Extract

12.Now go to receipts and query the AP/AR netting receipt.

13.Now Go to Tools >view Accounting, you can see Netting control account (defined in first step a) debited and receivable account credited.

14. Now go to payables and query your invoice number and click the tab view payments. You can see the payment details and copy the document number.

15.Query your copied payment document number.What you can see the payment type as Netting .

16.Click actions button and enable the check box create accounting .

17.Go to tools>view accounting .You can see the accounting entry

Related Posts

Posted in Oracle Payable, Oracle Receivable, R12, Release12 | 10 Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
10 Responses
  1. Military Blog Updates » R12 : Setting up for AP/AR Netting Says:

    […] Read the rest of this great post here […]

  2. Shanmuga Says:

    Thanks a lot for this wonderful document!! Small suggestion.. step 5 in this processes is not valid. Please do check.

  3. Navneeth Says:

    Hi

    I tried to setup and erred at the first step.

    In the Receipt classes, I tried to enter the Bank Accounts and found none of my Bank accounts appearing in the LOV. Is it due to any missing setup or bug. Pls advise.

  4. sanjitanand Says:

    have you done the setup for Bank master and house bank account.

    Your bank setup with accounts is missing for the LE , under which you are dealing with.

  5. Ravi Says:

    Hi
    can somebody thro some light on intercompany netting?

  6. Bobby Says:

    Hi,
    I have a situation where I want to create a single payment to multiple sites of a supplier.

    Also the same time the supplier sites acts as customer.

    In the end of the day, I will have to both pay and collect money from the sites…

    Can I utilize the AP/AR netting for this scenario?

    Also the preference of netting is payments. (90% of the time I need to pay the sites after netting)

    Please throw some light on this scenario.

  7. Sanjit Anand Says:

    Dear Bobby,

    Not sure, what version you are using

    if you are in 11i, there is something called Contra Charging, where supplier and customer as treated as customer and supplier to each other and at the end of month, you need to net off the amount and then raise credit memo or debit memo depends what is total net off amount.

    In R12, The same functionality have been enhanced by Ap-AR netting.

    If you need any further information , do let me know, i will help you.

    there is seperate Post in some time, just check the details
    Sanjit

  8. Kumar Says:

    Hi can any one help me how to apply Inter company Receipts (I hav a common customer in 2 companies, now he send one receipt for both companies outstanding). how can i apply this receipt???

    R12 environment.

    pls help me in this context.

    cheers
    Kumar.

  9. sachin Says:

    In netting receipt accounting, the netting control account is not coming. It is showing cash account..What could be missing?

  10. Dilip Says:

    While i create the netting agreement, i am not able to see the Bank Account in the LOV.

    I have done the foll.

    1) Created a Dummy bank, branch and acocunt and marked it as a netting account.

    2) Created a doc seq.

    3) Enabled the flag in system option.

    could you let me know what am i missing.

    thanks, Dilip

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.