Posted on January 21st, 2008 by Sanjit Anand |
Print This Post
|
Email This Post
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.
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
6. Create netting agreement
Receipts>Netting>Netting Agreement
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
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
January 22nd, 2008 at 3:10 am
[...] Read the rest of this great post here [...]
March 7th, 2008 at 11:07 am
Thanks a lot for this wonderful document!! Small suggestion.. step 5 in this processes is not valid. Please do check.
March 26th, 2008 at 3:08 am
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.
March 26th, 2008 at 3:49 am
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.
May 27th, 2008 at 3:09 am
Hi
can somebody thro some light on intercompany netting?
July 4th, 2008 at 1:50 am
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.
July 4th, 2008 at 2:08 am
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
July 19th, 2008 at 6:54 am
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.