There are instances wherein the customer record indicates that a customer has Overdue Days of XXX even when there are no open Invoices for that customer or even if the Overdue Balance of that customer is 0.00.
This may be problematic for some users that has the Customer Credit Limit Handling set to Enforce Holds(Setup > Accounting > Accounting Preferences > General tab) and when the Credit Hold is set to On or Auto on customer record > Financial tab since the user will not be able to create further Invoices (or SalesOrders if Customer Credit Limit Includes Orders is True) for this Customer.
Also, it will create an issue if the Customer record involves uses Customer Dunning Procedure. This will result to an inaccurate result for the Dunning Level or the Dunning Letter that will be sent to Customer.
This concern is actually a defect that has been reported multiple times in NetSuite, one of the reported Issue is : Defect #350288 Lists > Relationships > Customer > Under Customer record with a zero dollar ($0.00) invoice > Financial tab > Displays 'Days Overdue' = xx but the 'Overdue Balance' = 0.00.
You may resolve the concern through indicating what Invoice is being pertained to by the Overdue Days:
- Navigate to Lists > Search > Saved Searches > New
- Choose Transaction
- Under Criteria tab, add:
- Name for the Customer with issue
- Days Overdue : equal to XXX
- Under Results tab, add:
- Document Number
- Applying Transaction
- Click Preview
The Applying Transaction is the Payment/Journal is the record that is applied to the Invoice. What we can do is to unapply and then apply again the Payment/Journal.
- Edit the Payment/Journal record
- Unmark the Invoice checkbox for the Invoice indicated
- Click Save
- Edit the Payment/Journal record again
- Mark the Invoice checkbox
- Click Save
Result: This should now refresh the Overdue Days and Consolidated fields of the Customer record