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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Sales Reports

(0) ShareShare
ReportReport
Posted on by 10

Hello Folks,

I want to be able to run a regular sales report which will show me the item quantity and value sold month by month over a given date range and be able to filter the report by Salesperson and/or Country/Region. Something like the inventory sales statistics report although this wont allow me to filter by ship to country/region nor will it provide a month by month view over a given date range.

I had a look at the MS Create Analysis Reports but it seemed pretty complicated and didn't make much sense to me.

Thanks for your help.

Ben.

I have the same question (0)
  • Mohammed Marhoon Profile Picture
    12 on at

    Hi Ben,

    Analysis Reports can achieve that, since out of the box there is no straight sales report will allow you to do that.

    Good Article to Create Analysis Views Reports

    docs.microsoft.com/.../bi-how-create-analysis-views-reports  

    Also i can suggest to user Jet Reports which its integrate it with Business Central and you can create solid reports.

    Jet Reports

  • Ben Moon Profile Picture
    10 on at

    Thanks for your reply. I read that MS help article before I posted this question and have re-read it a few times since and I don't really understand what it means. Is it possible to get some online help with setting these reports up?

    Thanks,

    Ben.

  • Suggested answer
    Marco Mels Profile Picture
    Microsoft Employee on at

    Hello,

    If this does not exist out of the box, you can either ask your partner to develop it for you or considering taking a look at Power Bi or consider using the other suggestions from Mohammed.

    Thanks.

  • Suggested answer
    Community Member Profile Picture
    on at

    Ben,

    Adding to other replies... Analysis Views all you to slice and dice certain transactions with filters and dimensions. To help you here I am attaching a Manual on Analysis Views. Its from NAV 2013 but the process and concepts are the same. It will produce the report you want.

    Now if you are more an Excel person, Jet Reports can accomplish this easily. I am attaching a sample one.

    Hope this helps.

    Thanks,

    Steve

    80535_5F00_NAV2013_5F00_ENUS_5F00_ReportAnalysis.pdfNAV059-_2D00_-Enterprise-_2D00_-Item-Sales-and-Profitability-v3.0.xlsx  

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May 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,028 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,366 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 1,175 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans