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

Know 15 important things before you can do Auto lockbox setting

Posted on June 29th, 2008 by Sanjit Anand ||Email This Post Email This Post

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

Auto lockbox Implementation been never been an easy task. Though it requires own set up to handle this functionality. Therefore Its is very important to understand some key points before implementing LockBox in Oracle.

  1. How are you identifying the customer against which you apply the receipts? Are you using Auto associate, Customer Number or MICR number?
  2. What do you have for the Match Receipts “By option” in Lockbox? Is this by Customer Bill-to-Site, Customer or Lockbox?
  3. What do you have for Allow Payment of Unrelated Transactions when you submit lockbox and at the system level?
  4. Do you Require Billing Location?
  5. What do you have for Auto cash Rules?
  6. What do you have for Remaining Remittance Amount? Do you want this as unapplied or Onaccount ?
  7. Do you Apply Partial Receipts?
  8. What do you have for Remainder Rule Set? How the setup is done ? Is it at customer site or customer profile level?
  9. What do you have for Allow Payment of Unrelated Transactions?
  10. Do you use Autoassociate?
  11. What do you have for Invalid Transaction Number Handling? This mean how post partial amount as unapplied or you want reject entire receipt?
  12. Are you expecting Miscellaneous Receipt through AutoLockbox?
  13. Is customer expecting some Refunds with negative amount for returns to handled through Lockbox?
  14. Is customer expecting any adjustment through Lockbox?
  15. Are you using Lockbox standard format or have a different format? If not using standard format do you have details for transmission line details?

If you have already some more items need to be added, do share your experiences.:)

dgreybarrowSimilar Post

Related Posts

Posted in Oracle Receivable | 4 Comments »Email This Post Email This Post |

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
4 Responses
  1. shashi Says:

    Thanks A lot…ur articles are excellent

  2. ssmith Says:

    Sanjit, your articles are excellent and they are helping me discover how to support my eBusiness 11i implementation. Thank you very much.

    We are trying to integrate Payroll and Cash Management. I am told that we cannot manually clear EFT Payments. Surely there must be a solution or workaround. Are you aware of this issue and can you suggest a workaround?

  3. Ramesh Says:

    can a negat ive receipts be raised from lock box.

  4. Ramesh Says:

    how to handle this scenario…

    Is customer expecting some Refunds with negative amount for returns to handled through Lockbox?

Leave a Comment

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