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 / Small and medium business | Business Central, N... / Repeating report
Small and medium business | Business Central, N...
Suggested Answer

Repeating report

(1) ShareShare
ReportReport
Posted on by KBH 7

Hi

I hope one of you can help me. Each month I am doing the same report, the only thing that changes is the end date. I have to make Report number 1316 Customer Statement to one of our customers every month but up until now I have made 12 reports, because I am not sure how to make et repeatetly. Every report has to start at January 1st, and end of the last day of a current month.

I can see, that I might have to use unitcode, but then I can not find 712 Inventory Sales Statistics and nighter 1316 customer Statement

I have severel of these reports, so I really hope one of you could help me make it easier.

Thanks a lot in advance for your time

Karin

I have the same question (0)
  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,708 Moderator on at

    Hi,

    Can you brief it more? What you do with this report, this is a customer statement report which act as a Reminder to customer.

  • KBH Profile Picture
    KBH 7 on at

    Hi,

    Yes the statement is send to the customer. But the Inventory Sales Statistic I export to an Excel file, to compaire fx with the same periode last year.

    If you could help me with this so the new report will show the posts from last time the report was run and up until a certan date. So the first run of the report will show from fx April 1st until April 15th, and the next time the report runs it will show from April 16th up until April 30th.

    Is this enough extra info?

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,729 Super User 2025 Season 2 on at

    Hi, have you tried the Report Scheduler feature?

    More details:

    https://learn.microsoft.com/en-us/dynamics-nav-app/ui-schedule-report

    https://www.youtube.com/watch?v=S-9dSv0qbx8

    You can also consider customizing, for example, customize a program that automatically sends emails.

    Hope this helps.

    Thanks.

    ZHU

  • KBH Profile Picture
    KBH 7 on at

    Hi Zhu

    This is not quet what I need, as the start and end date need to be dynamic, so on a statement it will only be may if I make the report now, and in July, when I make the report, it will only be June.

    The reson I need these reports is because I have a lot. And as it is right now, I have 12 ongoing statements to one customer, so I have a lot of reports to keep an eye on.

    But mayby there is no other way than doing all of these reports one by one.

    Thanks for your reply.

    Best regards

    Karin

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans