web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Create Reminder
Microsoft Dynamics NAV (Archived)

Create Reminder

(0) ShareShare
ReportReport
Posted on by Rikarddo 273

Hello all,

In NAV 2016 we use the Report Create Reminder to create a letter with customer ledger entries and its details.
In the report filters we have not to calc and show some docs like Document No. : <>NCVS*&<>VD*&<>FTVS*

What i want now is to not show <>NCVS*&<>VD* and the FTVS only show those that due date - posting date >180.
Where in code it calcs the custledgerentries?
I know it calls a function in codeunit Reminder-Make

can someone help?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,243 Super User 2025 Season 2 on at

    Check the function FilterCustLedgEntries and FilterCustLedgEntriesReminderLevel in the same codeunit.

  • Rikarddo Profile Picture
    Rikarddo 273 on at

    So i've made this..

    LOCAL FilterCustLedgEntries(VAR ReminderLevel2 : Record "Reminder Level")

    CustLedgEntry.SETFILTER("Document No.",'<>%1|<>%2','VD*','NCVS*');

    IF COPYSTR(CustLedgEntry."Document No.",1,4)='FTVS' THEN

     IF (Today-CustLedgEntry."Posting Date" >180) THEN...

    (It should skip those invoices)

    But it keeps me showing and calculating some Invoices that doesn't respect the 180 days condition

  • Rikarddo Profile Picture
    Rikarddo 273 on at

    It was easier in the MakeReminder Function alter the code to

    {IF (CALCDATE(ReminderLevel."Grace Period",ReminderDueDate) < ReminderHeaderReq."Document Date") AND
    ((LineLevel <= ReminderTerms."Max. No. of Reminders") OR (ReminderTerms."Max. No. of Reminders" = 0))}//OLDCODE

    NEWCODE
    //Roliveira 2019-07-11
    IF ((CALCDATE(ReminderLevel."Grace Period",ReminderDueDate) < ReminderHeaderReq."Document Date") AND
    ((COPYSTR(CustLedgEntry."Document No.",1,4)<>'FTVS'))AND
    ((COPYSTR(CustLedgEntry."Document No.",1,2)<>'VD')))
    AND
    (((LineLevel <= ReminderTerms."Max. No. of Reminders") OR (ReminderTerms."Max. No. of Reminders" = 0)) AND
    ((COPYSTR(CustLedgEntry."Document No.",1,4)<>'FTVS'))AND
    ((COPYSTR(CustLedgEntry."Document No.",1,4)<>'NCVS')))
    OR ((COPYSTR(CustLedgEntry."Document No.",1,4)='FTVS') AND (TODAY-CustLedgEntry."Posting Date" >180))
    AND
    ((COPYSTR(CustLedgEntry."Document No.",1,2)<>'VD'))
    AND
    ((COPYSTR(CustLedgEntry."Document No.",1,4)<>'NCVS'))

    Thanks for the help

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans