4,090
Hi,
Where is the AVG days in the customer payment summary inquiry comes from?
I have a scenario where this field for a customer is showing empty
Thank you,
*This post is locked for comments
Check links did not change anything. However I cam across the following post for Vaidy Mohan where he posted SQL script to mimic the calculation of ADTP:
vaidymohan.com/.../average-days-to-pay-calculation-sql-code
I tried it the same script against the subject customer, and the result was negative
It seems that most of the invoices has been paid earlier to the due date
I guess GP then does not show the value unless it above 0, Is that assumption correct?
Receivables documents don't automatically move to history when paid. You have to use Paid Transaction Removal Routine to move them to history tables. So no, the fact they are still in the open tables should not affect the ADTP calculation. I think you have some data corruption.
Have you tried running Check Links on the receivables tables as Babu suggested?
I'm not sure if any of the following has anything to do with that issue:
The last payment fully applied to multiple invoices but both payment and invoices still showing in Open tables, Are not they supposed to move to the history tables?
Is ADTP recalculated anytime an invoice fully paid?
Hi,
Have you tried the checklink against receivables that might fix this.
That Reconcile utility was the first thing I tried earlier but did not make any change
Hmmm, interesting. If that's the case, then try running the Reconcile utility in that customer.
I forgot to mention this happen only with one customer, all others looks fine
Have you EVER closed it? You can tell by looking at the Last Closed Date in the Year End Close window. If not, that could be the reason you are seeing no ADTP in your system.
No Sir, We are in the mid-year
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,307
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
