265
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
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
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
Check the function FilterCustLedgEntries and FilterCustLedgEntriesReminderLevel in the same codeunit.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (