Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Reminder does not include all overdue invoices

Posted on by 145

Hi Everyone,

I have a problem when creating Reminders.

The first time I created reminders for overdue sales invoices all works well and all overdue invoices appear on the reminder. However, when I want to create a new reminder the second time (say two weeks later) for the same invoice, then it does not appear on the reminderlines.

Does anybody have a clue how to solve this?

In the reminder terms I have set the grace period formula and due date formula for the reminder levels to 0D.

When I create reminders I want all overdue invoices to appear on the reminderlines.

Your help is much appreciated!

Kind regards.

  • JR61 Profile Picture
    JR61 145 on at
    RE: Reminder does not include all overdue invoices

    Hi Martin & Katrin,

    Thank you both.

    I think what I missed was that I initially had no value in some of the fields for the 'Due date calculation' field. I left some of those field blank and had only filled in '0D' in some of the fields,  assuming it didn't make a difference. However, apparently leaving the field blank and having an actual calcultion of 0D does make a difference.

    Thank you again, it works now.

  • Suggested answer
    MartinNL Profile Picture
    MartinNL 480 on at
    RE: Reminder does not include all overdue invoices

    Hi Jelle,

    To add to what Katrin has mentioned, I have made an example in my Business Central environment. The dates are really important when working with reminders.

    Scenario:

    • Customer has 2 invoices that are posted about 2 weeks apart.
    • Customer has payment terms 14D
    • Reminder Terms are setup as you described all being 0D

    pastedimage1610621953566v1.png

    Invoice 1:

    • Document Date = 14/01/2021
    • Posting Date = 14/01/2021
    • Due Date = 28/01/2021

    Invoice 2:

    • Document Date = 29/01/2021
    • Posting Date = 29/01/2021
    • Due Date = 12/02/2021

    pastedimage1610622750643v1.png

    Reminder 1:

    • Document Date = 01/02/2021
    • Posting Date = 01/02/2021
    • Due Date = 01/02/2021

    pastedimage1610622196503v4.png

    Reminder 2:

    • Document Date = 15/02/2021
    • Posting Date = 15/02/2021
    • Due Date = 15/02/2021

    pastedimage1610622307472v5.png

    As you can see it is possible that all the open over due invoices where a reminder terms existed when posting are included in the new reminder. It should not be necessary to cancel an existing reminders (lower levels) to run the next reminder.

    I hope this provides some help, if not I am happy to assist, can also send me a private message 

    Regards,

    Martin

  • Katrin Kinau Profile Picture
    Katrin Kinau on at
    RE: Reminder does not include all overdue invoices

    Hi Jelle,

    When a reminder has been created and issued for an invoice and the invoice has not been applied in the meantime (so still remains open), then it should be suggested on a new reminder, as long as all requirements of the next reminder level are met (due dates, grace periods and such).

    It is not neccessary to undo / delete the last reminder.

    I am not aware of any issues in the standard application.

    What is the document and posting date of the last issued reminder? What is the document and posting date of the newly created reminder? The entry does not have any value in field "On Hold", correct? And the entry is also still open, correct?

    If this issue remains, I would suggest to create a support ticket for this. Then we can analyze this more in detail.

    You can do this yourself if you are a CSP / Dynamics 365 Partner or ask your reseller to create a ticket on your behalf.

  • JR61 Profile Picture
    JR61 145 on at
    RE: Reminder does not include all overdue invoices

    Hi Martin,

    Yes, it works when I remove this value for some of the invoices. However, when I create new reminders these reminders do still not contain all overdue invoices, even for invoices without a value in 'On Hold'.

    The only solution is have found is to cancel the already sent reminder and after that create new reminders. However, this causes a lot of work and can easily lead to overlooking some open invoices.

    Is there a solution which makes me able to create reminders that does always contain all overdue invoices (unless there is a value in the 'on hold' field)?

    Hope you can help me!

    Kind regards,

    Jelle

  • Suggested answer
    MartinNL Profile Picture
    MartinNL 480 on at
    RE: Reminder does not include all overdue invoices

    Hi,

    In the 'On Hold' field this is usually the users initials added when wanting to put the invoice on hold, as the field is a 3 character limit this is why initials are used and manually added. Removing the 'DSP' in there should solve the issue, but I would check with colleagues on why it was added.

    Regards,

    Martin

  • JR61 Profile Picture
    JR61 145 on at
    RE: Reminder does not include all overdue invoices

    Hi Katrin,

    Thanks for your reply. Yes in the 'On Hold' field there is a value 'DSP', I don't know what this means. My Business Central is in Dutch so I don't know whether the 'DSP' value is the same in the English version.

    Is there a way to turn of this option? I don't ever want an invoice to be 'On Hold' actually.

  • Katrin Kinau Profile Picture
    Katrin Kinau on at
    RE: Reminder does not include all overdue invoices

    Hi,

    Can you please check if the customer ledger entry for this invoice has a value in field "On Hold"? Entries will not be suggested as long as they are "On Hold".

    Thanks,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans