ssolberg
VIP Member
I've been chewing nails trying to understand the calcs used for determining the Average Days Late (as seen via Account Status Summary and recalced by P03830) and have come to a plausible (but not liked) conclusion that I'm hoping someone can confirm. There is a KG document on JDE that explains P03830 but it doesn't answer my question so don't bother looking at it. I also have a call into JDE but they haven't been able to answer either. Here's the details:
My example would be a vendor that shows a Avg Days Late of 23 yet in looking at their summary, they have lots of outstanding invoices anywhere from 30 days to over 210 days for large $ amounts in relation to the entire account. (remember that ADL is a weighted avg based on $). If you only look at the invoices that this vendor has paid (or paid some portion), then the 23 days late seems likely. So my conclusion is that P03830 ONLY looks at invoices that have been paid on, not on any OPEN AND NEVER BEEN PAID ON invoices. True? Seems to make this field unreliable (if you look at my example) because it would be showing someone is fairly good customer (when they pay) but actually a very poor customer because they aren't paying at all! Any thoughts? Any solutions?
Programmer/Developer/Anything-They-Give-Me
World A7.3 11 (quite stable and usually happy)
Attempting CO with Xe, AS/400, V4R5 (not happy)
My example would be a vendor that shows a Avg Days Late of 23 yet in looking at their summary, they have lots of outstanding invoices anywhere from 30 days to over 210 days for large $ amounts in relation to the entire account. (remember that ADL is a weighted avg based on $). If you only look at the invoices that this vendor has paid (or paid some portion), then the 23 days late seems likely. So my conclusion is that P03830 ONLY looks at invoices that have been paid on, not on any OPEN AND NEVER BEEN PAID ON invoices. True? Seems to make this field unreliable (if you look at my example) because it would be showing someone is fairly good customer (when they pay) but actually a very poor customer because they aren't paying at all! Any thoughts? Any solutions?
Programmer/Developer/Anything-They-Give-Me
World A7.3 11 (quite stable and usually happy)
Attempting CO with Xe, AS/400, V4R5 (not happy)