Has anyone noticed any changes in NetSuite recently with regards to the 'AmountDue' value on Statements?
I initially thought this was a 'leap year' problem, but it seems more widespread.
Looking at Statements we sent dated 31st January, they showed any Invoices dated 31st January, and included those amounts in the 'Amount Due' value on the statement.
Statements sent dated 29th February still show the Invoices dated 29th February, but don't include the value of these Invoices in the amount due.
If I reproduce a Statement dated 31st Jan (as per the first test) then this will now print showing the 31st Jan Invoices, but not including them in the Amount Due. The same happens if I generate an Invoice dated on any given day - the Invoices dated on the same day will show in the list of invoices, but not in the amount due total.
The problem doesn't appear on the standard Statement template, but that is because the total shown at the bottom is ${record.agingbal} instead of ${statement.amountDue}. (We have had to customise our statement template to show aging in calendar months instead of 30/60/90 days - because we work in calendar months).
Regardless of the template used, I can still see the statement sent on a customer 31st Jan showing the correct amount due, and if I regenerate that same statement it shows the incorrect amount due. Nothing has changed with our statement template, so I believe that something has changed in NetSuite in the way that 'Amount Due' is being calculated.
Statement sent 1st Feb dated 31st Jan:
Statement regenerated today (had to untick 'Show Only Open Transaction'):
Clearly something has changed.....