1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Invoice Status is "Selected for Payment" after run Netting Batch

Discussion in 'Oracle Financials' started by yingsras, Feb 11, 2012.

  1. yingsras

    yingsras Forum Advisor

    Messages:
    155
    Likes Received:
    16
    Trophy Points:
    280
    Location:
    Bangkok, Thailand
    Hi everyone,

    I have a problem about AP/AR Netting.
    I already run the Netting Batch and the invoices are selected.
    But AP invoice is not paid, the status is "Selected for Payment"
    And the AR transaction is not receipted, the invoice is still in the Aging report.
    Do you have any idea why the AP invoice status is Selected for Payment and AR transaction is not receipted?
    Is there any configuration about this? Please suggest.

    Thanks,
     
  2. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Yingras,

    What version of Oracle are you working on? What steps have you completed till now? If its R12 have you successfully complete the Payment Process Request. If the process is not completed you will need to look at the exception and complete the same. In 11i this status could also arise because of data corruption.

    Similarly for the receipt make sure all steps of the receipt processing are completed.
    Ramji
     
  3. yingsras

    yingsras Forum Advisor

    Messages:
    155
    Likes Received:
    16
    Trophy Points:
    280
    Location:
    Bangkok, Thailand
    Hi Ramji,

    I'm working on 12.1.3
    I completed the step of running batch and can view the report "Proposed Netting Report"
    But it didn't perform payment or receipt the selected invoices.

    Thanks,
    yingsras
     
  4. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Yingsras,

    Complete all the steps. It works a treat in R12. The rationale of this process is to set off amounts due against amounts receivable and for that you use a dummy cash account. In release 11i a workaround did the trick. You need to pay using the netting bank account and enter a receipt if it makes sense.
    cheers
    Ramji
     
  5. yingsras

    yingsras Forum Advisor

    Messages:
    155
    Likes Received:
    16
    Trophy Points:
    280
    Location:
    Bangkok, Thailand
    Hi Ramji,

    Thanks for your answer. I will try as you suggested and will update this topic.

    Thanks,
    yingsras
     
  6. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Yingras,

    It works beautifully. Explore the advanced features when you test. You will be able to specify how you want to net off when multiple invoices are pending. Try it out.
    cheers
    Ramji
     
  7. yingsras

    yingsras Forum Advisor

    Messages:
    155
    Likes Received:
    16
    Trophy Points:
    280
    Location:
    Bangkok, Thailand
    Thanks Ramji,

    Now I can complete the Netting Batch and the invoices are paid and receipted.
    But I cannot see the netting account.
    Example..
    AR invoice 900
    AP invoice 1000
    Netting 900
    Where can I see the accounting entry for the Netting 900? Could you please suggest?

    Thanks,
    Yingsras
     
  8. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Yingsras,

    I have uploaded a file called AP AR simulation with multiple tabs. All screen shots start to finish are there. Please click on my name and go to the documents tab and pick it up. Should clarify all your doubts.

    Now for the question you asked. When you ran the netting batch it would have selected a payment similarly a receipt. You can view accounting on both online as you would normally. There are other ways too. Just dig deeper.
    cheers
    Ramji
     
  9. yingsras

    yingsras Forum Advisor

    Messages:
    155
    Likes Received:
    16
    Trophy Points:
    280
    Location:
    Bangkok, Thailand
    Hi Ramji,

    Thanks for your help and many useful documents. :)

    Thanks,
    yingsras
     
  10. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Dear Yingsras,

    A small request. When ever you post a query in the forum, kindly follow up with the outcome. Else it creates a void in the collaborative spirit. Also others will benefit. Again if you encounter problems with the recommendation, it helps the person recommending to keep his learning curve alive and learn why it failed. Just a friendly request.
    Cheers
    Ramji
     
  11. Avinonymous

    Avinonymous Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    75
    Hello Experts/Forum Gurus,

    I'm working on AP/AR Netting (Oracle Applications:- 12.1.1) and encountered an error. The error message is "No remittance bank account is assigned to the Receipt Method 'AP/AR Netting'.The remittance bank account should match the netting bank account associated to the netting agreement of the batch."

    I have done all the pre-requisites for Netting process properly and checked all bank setups in AP/AR netting Receipt class and Netting Agreement but still i get the above error.

    Just let me know if you need more details on the same.

    I hope this thread is not closed completely,if yes, Should i start a new thread? Please do suggest.

    Regards,
    Avinonymous
     
  12. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi,

    Can you please post the steps what you have done. By that we can help you in this.
     
  13. Avinonymous

    Avinonymous Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    75
    Bharat,

    PFB the steps:-

    1. Created a Customer in AR and a Supplier in AP just for Netting purpose
    2. Defined a Netting bank account with "Netting Account" = Yes.
    3. Added this Netting bank account to seeded AP/AR Netting receipt class.
    4. Created an AR Invoice(Complete) for 75,000 INR and AP Invoice(Validated) for 80,000 INR.(Payment terms = IMMEDIATE)
    5. Created a Netting agreement "Netting Test" with all the basic details.
    6. Defined Profile option Sequential Numbering 'Not Used' in Payables & Receivables.
    7. Created a Netting Batch 'Batch 1' associated with the above netting agreement.
    8. After creating a netting batch queried for 'Batch 1' and clicked on Update.
    9. Clicked on Save button.
    10. Clicked on 'View Report' and Run 'Proposed Netting Report'. The Status here shows 'Selected'. Clicked on Update again.
    11. Clicked Submit button which triggers a Concurrent program 'Submit Netting Batch' resulting in Complete status. The next CP 'Settle Netting Batch' errors out with the error message,"No remittance bank account is assigned to the Receipt Method 'AP/AR Netting'.The remittance bank account should match the netting bank account associated to the netting agreement of the batch"

    Did I miss anything important in this process?

    Regards,
    Avinonymous
     
  14. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ,

    Please refer to the following document which contains entire steps for AP/AR Netting Concept.

    AP/AR Netting Concept
     
  15. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Avinonymous,

    I believe there was a bug in Release 12.1.1
    Try this and let us know
    Query the AP/AR Netting Receipt Class
    When on the form press down arrow
    You might come across a AP/AR Netting1 Receipt Class.
    Point the Netting Bank account to this and save.

    Then put through the netting batch . Update the forum
    thanks
    Ramji
     
    Avinonymous and Bharat like this.
  16. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ramji,

    Yes you are right bhayya. There was such a Receipt Class conflict in that AP/AR Netting method. We need to do it for AP/AR Netting1 Receipt Class.
     
  17. Avinonymous

    Avinonymous Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    75
    Ramji,

    Thanks for the quick reply. Now it's working fine. Is it possible to disable the duplicate AP/AR Netting Receipt class so that in future problems like these don't come up?

    Regards,
    Avinonymous
     
  18. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Its not possible to disable them. You can end date that Receipt Class.