Feature - Order Number Support Expanded Aging Report CSV File

Feature - Order Number Support Expanded Aging Report CSV File

Release Date: 5/19/25
Version: 8.5 and Above

This feature adds the Customer Order Processing order number to the CSV export file when printing the Expanded Aging Report. This column is only available if Customer Order Processing is enabled. 

To explain the reason for this feature, you need to understand the following:

In the Elliott A/R Open Item file, there is an "Allocated Amount" field for records of the Payment or Credit type.
In the COP Order Payment Window, when a real-time payment is added (such as cash, check, credit card, or gift certificate), the corresponding A/R payment record is allocated by updating its "Allocated Amount" field. This allocation ensures that the payment is reserved for the specific order and cannot be applied to other orders or invoices.

The same principle applies to open payments or credits (i.e., A/R open item records where the Allocated Amount = 0). In such cases, the COP Payment Window may choose to apply the open payment or credit to the order.

While we can view corresponding A/R open payments or credits in the COP Payment Window, the A/R side only records the "Allocated Amount" without indicating which order it is allocated to.

Therefore, when printing the A/R Expanded Aging Report, payments or credits with an allocated amount are shown—but without the associated order number.

The primary purpose of this feature is to provide auditing information for payments or credits that have an allocated amount by displaying the corresponding COP order number.

For payments or credit memos with an allocated amount, we retrieve the associated order number from the CPORDPMT table (i.e., data from the COP Payment Window). For invoices, we attempt to retrieve the order number from the CPINVHDR table (i.e., COP Invoice History Header). There will not be order numbers for invoices not created from the COP module.  Also, if the invoice has been purged from COP invoice history, the system will not be able to retrieve the order number.



Programs Modified: ARAGEEXT.CBL
CLS

    • Related Articles

    • Feature - Add Ship Via and Tracking Number to Expanded Aging Report CSV

      Release date: 7/27/2021 Versions: 8.5 & Up The purpose of this feature is for payment collection. There's a need to find outstanding unpaid invoices with shipment tracking numbers to follow up the trading partners for payments. Two new columns, Ship ...

    • Feature - A/R Expanded Aging Report - Add "Show Open Items Only" Option

      Release Date: 7/6/2016 A new selection field has been added to the Expanded Aging report screen. Before this change the report only included Open Items. The report may now be created that includes closed items. Enter "N" in field 8 to include closed ...

    • AR Aging Report - What's the Difference Between Py and Px Payment Type ?

      Q - Our accounting staff has noticed that in the V8 AR Aging reports, payments are tagged with both a "Py" and a "Px." The "Px" seems to be new as of V8. See sample from the AR Aging Report below: 355747 08/06/15 C 355901 08/06/15 5.82- .00 356330 ...

    • ARAGEMNU Accounts Receivable Aging Reports

      Reports Aging Reports Application Overview The Aging Reports are reports that can tell you a great deal about the state of a customer's account. It will tell you how much the customer owes you, and how old these owed amounts are. In A/R Setup, you ...

    • ARSLSENT Accounts Receivable Sales and CR/DR Memo Processing

      Sales & CR/DR Memo Processing Application Overview Sales & CR/DR Memo Processing is an application that you will use very often. You will use it whenever you want to record in your Accounts Receivable new transactions that have occurred. For example, ...