Customer Statement - printed vs emailed provide different ageing figures

Hi Veronika,

Thank you for your post. 

To address the issue, statement ageing is based on the terms of the invoice. As such, I would recommend reviewing the due date of that invoice. This can be done by opening the invoice and selecting the Terms before reviewing the due date. To better assist you with this, could you please send us the screenshots of the printed statement and the emailed statement so we can check and assist you further? 

We hope to hear from you soon. 

Kind Regards, 

Cel 

Hi Cel,

Thank you for your response.  The issue that is that the printed activity statement vs the emailed statement, both using the same template, identical parameters and drawing the same information are producing different figures when generated at the same time. 

I have attached a copy of the printed statement vs the emailed statement.  The figures in the printed statement are the correct figures.  The fields that are producing incorrect figures in the emailed version of the statement are 1 Month and Current.

I have worked out that for some reason the emailed version of the statement (for period 1.11.2023 to 30.11.2023, previous month) is moving the last invoice dated 31.10.2023 into the current field instead of the 1 months field, but ONLY in the emailed version of the statement.

Why is the emailed version of the statement producing incorrect figures while the printed version of the statement is reporting correctly?

HI Veronika,

Thank you for getting back to us and providing an update. Upon checking the only thing about choosing a number of days after EOM i.e., 30 or 31, is that statement aging will be affected according to the number of days in the month and the date you run the statement. The Day of the month after EOM is a common choice of business as payment is due on the last day of the month regardless of the number of days in the month, so it is easier to tell when an invoice is due. We have a Help Article: Credit terms, explains the different credit terms in more detail.  

Please let me know if you still need further assistance. We are more than happy to help. 

Kind Regards, 

Cel

Thank you Cel,

I guess what is confusing me is why the ageing settings are only affecting the emailed version of the statement.  The printed statement doesn't seem to change regardless of the ageing settings.  Also, if I change the ageing date settings to 31 days (instead of the 30 days), will this cause issue on the months when 30 days apply? 

HI Veronika,

Thank you for the update. In this regard, the issue also comes up if the terms are set to COD and thus the due date of the invoice would be set to be 11/30/2023 this does mean that when the statement is set to run for 30/11/2023 it appears as Current, but when you run for 31/10/2023 will show in the first ageing period. Due to the configuration of ageing periods and the labels., it falls into the 30 Days Overdue section. What the section showing is actually 1-30 overdue. 

Please let us know if you still need further assistance. Contact us again if you have other questions or concerns. We are happy to help. 

Kind Regards, 

Cel

Hi Cel,

I am reading through this thread with interest and note that the original question has not been answered. 

Can you please direct this to the development team to investigate why the very same statement changes depending on whether it is being printed or emailed. There should be no difference. This issue has nothing to do with the ageing set up.

Thank you.

Hi Melinda_vanDyk,

Thank you for your post. Your feedback is extremely important to us and will help us enhance our services to better meet your needs. In this matter, we are communicating with our team regarding the issue. Once we have an update, rest assured that we will notify you through this channel.  
 

Kind Regards, 

Cel