Avg Days Pay YTD in Customer File Calculation Issue

Avg Days Pay YTD in Customer File Calculation Issue

It is a known issue that the "Avg Days Pay YTD" field in the customer file may not be correct. There are various reasons for the average days pay not to calculate correctly. One reason is that this field, as it was originally designed, does not support decimals. So if you have a customer that you do a lot of business with, the calculation will start to become inaccurate because of the rounding problem. The good news is there is a utility to address this issue. You can go to Main Menu -> Util-Setup -> Global Setup -> Utilities -> Generate Statistic Info -> Generate -> Recalc Customer Avg Days Pay.

If you do not feel comfortable making a global change, you can just recalculate one customer at a time and see if the new value makes sense for you. When it comes to choosing between Fiscal or Calendar Year, most of you will use "C" for calendar. However, if you are indeed using the Fiscal year, then enter "F" and then enter the "Current Fiscal Year Start Date."  This utility will review records in both A/R Open Item File and A/R Open Item History when calculating this number. This utility will print the details of A/R Open item to show the calculation basis. Some of our users choose to make this a deferred process that runs every night. The following information will be updated in the customer file after you run this utility:

* Avg Days Pay YTD
* Avg Days Pay Last YR
* Invoices Pd Ytd

Before you run this utility, there is a global setup flag related to this utility that you should check. Go to Main Menu -> Util-Setup -> Global Setup -> Acct -> A/R Global Control,
20. Calc Avg Days Pay YTD Base on Inv or Due Date. The default is "I" (Invoice Date). You have the option of changing it to "D" (Due Date). If it is based on due date, then the Avg Day Pay YTD may contain a negative value. If a customer pays their invoice before the due date, then the field will show negative days. You might want to consider using Due Date if you often negotiate with customers regarding terms on an individual order basis. 






    • Related Articles

    • Customer Account Summary Inquiry Age Days Calculation Logic

      Release Date: 07/07/2021 Version: 8.5 Q - In A/R Customer Account Summary Inquiry, what is the logic on a partially paid invoice? See example below: In the above example, invoice number AXI990 was partially paid on 6/18/21. That is 49 days after the ...

    • Feature - Average Days Out of Stock Calculation in One-Location Buyer's Desk

      Release Date: 8/6/24 Version: 8.5 and Above This feature added a new filter criteria to the two-location version of Buyer's Desk. The option "Avg DOS/Mon Value > Avg of # of Month" allows the user to choose if items should be filtered based on a ...

    • Feature - Exclude Debit Memos from Updating Customer Sales Ptd/Ytd

      Release Date - 11/21/17 This feature allows the user to control whether the customer sales period-to-date and year-to-date are updated when a debit memo is posted from Sales & Cr/Dr Memo processing. This feature is enabled through a new A/R Global ...

    • AP2300 Accounts Payable Clear Vendor YTD Accumulators

      Clear Vendor YTD Accumulators Application Overview The Vendor File contains fields that show you the total year‑to‑date purchases, amount paid, and discounts taken. If the Purchase Order and Receiving package is in use, there are also fields showing ...

    • ARCUSMNT Accounts Receivable Customer File Maintenance

      Customer File Maintenance Application Overview The Customer File is a very important file. It stores the basic information about every customer you do business with. Almost every major application in the A/R package uses the Customer file to ensure ...