Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Schedule Recurring Sales Lines the 1st each month possible?

(1) ShareShare
ReportReport
Posted on by 21
Hi all

I was playing with the Job Queue for Recurring Sales Line Invoices, and it seems like the functionality is lacking, or I'm not understanding something.
 
You can create a job queue entry to run report 172: Create Recurring Sales Line Invoices. The issue is that the report requires both an order date and posting date:
1. If you enter i.e. 01-01-25 for both order date and posting date
2. Include a code filter
3. Set Next Run Date on job queue to be CM+1D
4. Run the report today (13-01-2025)
 
The job queue will run now and create the required invoice(s) with date 01-01-2025, and set next run date to 01-02-2025 - and here is my issue. The report is saved with dates 01-01-2025, so in february it will create the invoices again as intended - but with the wrong dates.
 
Is there any way, out of the box, for this to actually work? If this doesn't work, they might as well remove the Schedule button from this report..
  • Kenneth Q Madsen Profile Picture
    Kenneth Q Madsen 21 on at
    Schedule Recurring Sales Lines the 1st each month possible?
    That makes sense. Although it is unfortunate. I wish there was a way for the date to be updated with the date variables also.
     
    Thank you.
  • Verified answer
    Yi Yong Profile Picture
    Yi Yong 1,589 Super User 2024 Season 2 on at
    Schedule Recurring Sales Lines the 1st each month possible?
    Hello,
     
    The schedule button is to schedule the report ahead of time.
    For example, you can start making the schedule job queues (11 of them) for Feb to Dec 2025 with their respective starting date/time.
     
    The next run date is meant for the next job queue session with the same dataset. Not meant for the report's dataset filter date.
  • CU13010737-0 Profile Picture
    CU13010737-0 on at
    Schedule Recurring Sales Lines the 1st each month possible?
    Balancing online gaming with drive mad other responsibilities can help develop time management skills.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans