Why is the Days Overdue field on a customer record sometimes 0 and sometimes empty/null?

AI generated answer (using internal Slack threads):

The 'Days Overdue' field on a customer record in NetSuite is a system-generated field that calculates the number of days an invoice is overdue. If an invoice is paid in full, this field should ideally be 0. However, there are instances where this field might be empty or null. One such scenario is when an invoice is created with a zero dollar amount. In this case, even if the invoice is marked as 'Paid in Full', the 'Days Overdue' field might not be updated to 0. This could be due to the fact that NetSuite does not consider a zero dollar invoice as a transaction that needs to be paid, hence it does not update the 'Days Overdue' field. Another scenario could be when an invoice was initially created with a non-zero amount and later edited to be zero. If the invoice was overdue when it was edited, the 'Days Overdue' field might not be updated to 0, even after the invoice is marked as 'Paid in Full'. In both these scenarios, the 'Days Overdue' field might appear as empty or null because NetSuite does not update this field for zero dollar invoices. Please note that these are system behaviors and might vary based on the specific configurations and customizations in your NetSuite account. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******