How to Get All Credit Memo Documents in AR Open Item File
Release Date: 12/24/2020
Version: 7.0 & Up
Q - How do we get a list of all credit amount documents in the AROPNFIL that are not applied to anything? Is there a way to get just these documents using the Expanded Aging Report?
A - You can use one of the following two methods:
Method 1 - Use Expanded Aging Report
This method is suitable to your users since no special security is required. You can get all credit memo documents by going to A/R -> Reports -> Aging Reports -> Expanded Aging Report with CSV. View the exported CSV in Excel. To narrow down to those credit memos is actually pretty easy. All you have to do is to use the "Sort" function in Excel as follows:
Sort by "Tp" Order A to Z
Then by "ApplyTo" Order A to Z
See sample screen below:
The result is the following in Excel, which will show "Credit Memo" with no apply-to in the top section:
The "Tp" column refers to the document type, which can have the following values:
- C = Credit Memo
- D = Debit Memo
- F = Finance Charge
- I = Invoice
- P = Payment
As for "ApplyTo" column, all open credit memos' apply-to will be zero.
Method 2 - Use SQL Statement
Alternatively, you can use the following SQL statement in PCC (Pervasive Control Center), Crystal Reports, Excel Query, Web Services or any third-party tools:
If your database is converted to allow alphabetic document numbers, use the following SQL statement:
select * from aropnfil where ar_opn_doc_tp = 'C' and
ar_opn_apply_to = '000000'
If your database is not converted, then your document numbers are still in numeric format. Use the following SQL statement:
select * from aropnfil where ar_opn_doc_tp = 'C' and
ar_opn_apply_to = 0
EMK
Related Articles
How to Offset an Open Invoice and Open Credit Memo in the AP Open Item File
Release: 11/30/2022 Version: 7.x & Up Accounts Payable has an Open Item file that contains all the vouchers, checks, credit memos, and adjustments. AP does not have a reapply utility like Accounts Receivable, so you are unable to reapply an open ...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 ...Feature - Automatically Reapply Credit Memo to Charge-Back Debit Memo
Release Date: 3/23/22 Revised: 3/29/22 Version: 8.5 and Above This feature will reapply an existing open credit memo to a debit memo the system just created during cash receipt posting. This will reduce the user’s database entry burden involved in ...Feature - Credit Memo Warning When Fully Paid
Release date: 9/14/2019 Version 8.5 & Up Users can enter a new Credit Memo using COP, Order Entry, Change Mode, and pressing F3 or F4 at the Order Number field. When using the F4 option, the application allows the user to pick the invoice to apply it ...Feature - Elliott AR ACH Processing
Article Transfer Tracker Article Transfer Tracker 100% C86 Release Date: 1/27/2015 Introduction Elliott AR ACH Processing is designed to debit a customer's bank account through ACH debit transaction by using NACHA (National Automatic Clearing House ...