I Receive "No Open Item on File" Message When I Try to Reapply Open Credit or Payment in AR

Q: When I run my AR Aging Report, it shows that we have open items. But we aren't able to reapply some of them. When trying to reapply, users get the error "No Open Item on File." Why is that?

A: The most likely reason is because this open credit or payment has been allocated to a sales order.  Refer to the following field in your Global Setup for the Order Billing Screen:
    4. Use Payment Window for Real Time Cash Receipt
If this flag is set to "Y," then the user will be able to apply open credit or payment on the customer account to a sales order.  The idea is to reduce the balance or pay the order amount in full.  Then, during COP invoice posting, the open credit or payment will be automatically reapplied to the posted invoice.

In the above scenario, we have to protect the open credit or payment from being reapplied in the A/R module.  To accomplish this, we added the field "Applied Amount" (AR_OPN_APPLY_AMT) to the A/R Open Item Table (AROPNFIL).  If this amount equals the open amount, then it means this open credit or payment is already fully allocated to a COP sales order and, therefore, can't be reapplied in the A/R module.

Unfortunately, this "No Open Item On File" message doesn't really give a clear indication of what the situation is. In addition, the "Applied Amount" is pretty much a hidden field that does not show up in the A/R Customer Account Inquiry or the Aging Report.  The only place you can see this amount is to go to A/R -> Maintenance -> A/R Open Item File.  See the example below:


On 9/3/2014, we made a programming revision to the A/R Reapply function so if you should choose to reapply the open credit or payment record that's fully allocated, then we will display the message "This Credit Is Allocated to Sales Order" or "This Payment Is Allocated to Sales Order" to make the message a more clear reflection of the situation.

This update will be available in the next Elliott general release.

Accounts Receivable

  1. ARMENU Accounts Receivable Package Overview
  2. Feature - Elliott AR ACH Processing
  3. How to Automatically Credit Check an Order After Filling Back Order
  4. Fine-Tuning Customer File Maintenance Security
  5. I Receive "No Open Item on File" Message When I Try to Reapply Open Credit or Payment in AR
  6. Can I Reapply a Payment to a Different Customer in AR?
  7. AR Aging Report - What's the Difference Between Py and Px Payment Type ?
  8. Avg Days Pay YTD in Customer File Calculation Issue
  9. Opn Ord Pick/Inv Amt Calculation Issue
  10. Auto Assigned Sales Tax Code by State and County
  11. How to Handle Sales Tax for Single Item with Caps Amount
  12. How to Subscribe a Customer Event by Salesman?
  13. Arizona Cities Not in Elliott for Sales Tax Code Auto Assign
  14. AR0111 Accounts Receivable Carrier File Maintenance
  15. AR0112 Accounts Receivable Carrier Mode Maintenance
  16. AR0113 Accounts Receivable Freight Rate File Maintenance
  17. AR0114 Accounts Receivable Freight Zone File Maintenance
  18. AR0120 Accounts Receivable State Table File Maintenance
  19. ARACTINQ Accounts Receivable Customer Account Inquiry
  20. ARACTMNT Accounts Receivable Account File Maintenance
  21. ARACTSUM Accounts Receivable Customer Account Summary Inquiry
  22. ARADJAUD Accounts Receivable Adjustment Auditing Inquiry
  23. ARADJSCN Accounts Receivable Adjustment Auditing Report
  24. ARAGEBAL Accounts Receivable Age Customer Accounts
  25. ARAGEMNU Accounts Receivable Aging Reports
  26. ARAPLYCR Accounts Receivable Re-Apply CR/DR Memos
  27. ARCALFCH Accounts Receivable Finance Charges Processing
  28. ARCNTMNT Accounts Receivable County Tax Code File Maintenance
  29. ARCRCMNT Accounts Receivable Credit Card Transacting Handling
  30. ARCRDSCN Accounts Receivable Credit Card Log Report
  31. ARCSHENT Accounts Receivable Cash Receipts Processing
  32. ARCSHSCN Accounts Receivable Cash Projection Report
  33. ARCTLMNT Accounts Receivable A/R Setup
  34. ARDBEXPS Accounts Receivable Export D&B Customer File
  35. ARDISSCN Accounts Receivable A/R Distribution to G/L Report
  36. ARECIMNT Accounts Receivable Customers and Contacts Import Utility
  37. ARHSTMNU Accounts Receivable A/R History Report
  38. ARINVSCN Accounts Receivable Print Service Invoices
  39. ARJBASCN Accounts Receivable Job Analysis Report
  40. ARJOBMNT Accounts Receivable Job Code File Maintenance
  41. I Can Only Enter A/R Cash Receipt for Cash or Check
  42. ARCUSMNT Accounts Receivable Customer File Maintenance
  43. ARLTRMNT Accounts Receivable Customer Mail Merge
  44. Feature - ACH Deposit Effective Date
  45. AROLOAD Accounts Receivable A/R Open Item File Maintenance
  46. ARPRDEND Accounts Receivable Clear A/R Accumulators
  47. ARPRGSCN Accounts Receivable Purge Closed Open Items
  48. ARRECENT Accounts Receivable Recurring Sales Processing
  49. ARSAMENU Accounts Receivable Sales Analysis Report
  50. ARSETBAL Accounts Receivable Set Customer Account Balances
  51. ARSHPMNT Accounts Receivable Ship Via Code File Maintenance
  52. ARSLMMNT Accounts Receivable Salesman File Maintenance
  53. ARSLSENT Accounts Receivable Sales and CR/DR Memo Processing
  54. ARSRCMNT Accounts Receivable Payment Source File
  55. ARSRVENT Accounts Receivable Service Invoice Processing
  56. ARSRVMNT Accounts Receivable Service File Maintenance
  57. ARSTMSCN Accounts Receivable Print Statements
  58. ARTAXMNT Accounts Receivable Tax Code File Maintenance
  59. ARTRMMNT Accounts Receivable Terms Code File Maintenance
  60. ARTYPMNT Accounts Receivable Customer Type File Maintenance
  61. ARSTLSCN Accounts Receivable Sales Tax Liability Report
  62. Incorrect Opn Ord Pick/Inv Amount in Customer File
  63. ARCOMDUE Accounts Receivable Commission Due Reports
  64. Feature - Customer Account Inquiry Reference Search
  65. Feature - Tax Freight Setup User Messages in COP Setup and Tax Code Maintenance
  66. ARFRMMNT Accounts Receivable Invoice Form Setup
  67. Feature - Customer Highest Balance YTD, Last Year, and Year Before Last Year
  68. Feature - Ship Via Group Support
  69. Feature - Scheduling ACH Payments
  70. How to Print A/R Aging Report by Salesman
  71. Feature - A/R Expanded Aging Report - Add "Show Open Items Only" Option
  72. Feature - Add Acct Name to ACH Account Detail Screen
  73. Feature - ACH Add and Change Event
  74. Feature - Import A/R Cash Receipt Detail -- Add Ability to Process Multiple Customers for One Check
  75. Feature - A/R Commissions Due Reports - Additional Fields and CSV Support
  76. Feature - Age Customer Accounts When Cash Receipts Are Posted
  77. Feature - Validate Collector Against Salesman File

Feedback and Knowledge Base