Why Are Customer Last Aging Date and Amounts Not Updated?
Release Date: 08/31/2018
Q - Why is the last aging date and aging amount for each period not updated in the customer master file? Because the customer aging information is not up-to-date, it causes difficulty for my credit manager when he/she uses the COP "Release Held Order" application.
A - The customer aging (4 periods aging, field # 77 to 81) info in the customer file are database fields and they may not be updated automatically. See sample screen below:
Generally speaking, they will be updated automatically when you:
(1) Print Aging Report
(2) Print A/R Statements
(3) Post Cash Receipts
If a customer does have any of the three activities above, then that customer's aging information in the customer database stays static. To get that customer's aging up-to-date, you need a separate process to calculate it, and preferably on a daily basis.
The calculation process can be found in A/R -> Processing -> Age Customer Accounts. See sample screen below:
This process can update the customer fields 77 - 81 for you. In addition, it can re-calculate the customer fields "64. account balance" and "76. Opn Ord Pick/Inv Amt." Generally speaking, these two fields will be updated automatically and the recalculation is not a requirement. But since you are spending the computer CPU time to recalculate aging, you might as well recalculate these two fields.
You can have someone manually run this "Age Customer Accounts" application every morning without printing the report. Because potential customer record locking conflicts can take place, you want to do this calculation first thing in the morning before your users start to actively use Elliott.
If you would like to automate this process -- so that it takes place every night when there are no Elliott users in the system, for example -- you may use Defer Processing to do so. To defer this process, you will need to answer "Y" to "7. Print To Report ?."
Please also see the following KB article related to this subject:
EMK
Related Articles
Feature - Add Age Days and Last Calculated Date to Stock Status Inquiry
Release date 1/9/2021 Version 8.5 & Up This feature adds "age days" and "last calculated date" to the Stock Status inquiry screen. These fields come from Item File Maintenance field 27: Age days is a good way to indicate what your inventory turnover ...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 ...Feature - A/R Aging Report by Collector Customer Name Option
Release Date: 1/12/16 When printing the A/R Aging Report by Collector, entry of a new field "Sort By Customer No./Name (C=Customer Number, N=Customer Name)" has been added. The default is "C" for customer number, which is the current report sort ...Feature - Add "F2 = System Date - 1" to Release Held Orders
Release Date - 11/15/18 This feature is related to the following KB article: https://support.netcellent.com/portal/en/kb/articles/feature-auto-release-held-order-utility In this change, we added a new option to the Customer Last Payment Date >= field ...Aging Shows Differently After Database Rebuild
Q - After the database rebuild on A/R Open Item File (AROPNFIL.BTR), the A/R aging shows differently than before. For some reason, the payments are showing before the invoices. Also, they are not in any logical order that we can see. Here are the ...