When we consider the transaction that appears in the customer statement one behavior that we have seen is that when we investigate the invoice system notes, we can see the paid-in-full status date is today.
but when we run the report on today the invoice is paid in full and it is not appearing in the correct customer statement.
but when we run the report on yesterday’s date still the invoice is not visible but in the system notes it has been paid in full on today’s date so the user expect the invoice to be appearing yesterday and this was the issue raised by either user.
so based on further analysis, we have concluded that the payment record that was created today have a trandate setters yesterday. NetSuite considers the transaction’s trandate to decide how those transactions need to be displayed in a statement it is not based on the date created but instead the date field in transaction records.
and this payment have a date of yesterday and that is why our NetSuite considered the invoice to be paid in full as of yesterday that’s why in both of these days this invoice was not appearing and this is the functionality of the customer statements with respect to the statement date.
This statement date follows the as of date concept so as of the statement date whether the invoice was open or not NetSuite calculated that correctly along with the aging table displayed beneath the customer statement.