Average Days to Pay is wrong once Zero Dollar Invoices are Processed

(0) Share

Report

Posted on by Richard Wheeler

75,848 Moderator

I was asked to look into why some customers had an average days to pay of zero days while most customers were correct. What I discovered was that if the customer ever had a zero dollar sales invoice the RM30101.DINVPDOF was set to '19000101' resulting in an extremely large negative number which when added to all their other invoices resulted in a negative average days to pay which ultimately returns a zero value for average days to pay. Is this a design flaw or is there a setting that controls this? These zero dollar documents need to be excluded from the computation or the DINVPDOF needs to be set to the document date.

*This post is locked for comments

I have the same question (0)