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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

Sales report with Margins

(0) ShareShare
ReportReport
Posted on by 172

I am having a difficult time find a report that will allow me to choose a date period for a month and show me the sales with my COGS to see the margin either by business unit, grouping or some category. Any help would be appreciated.

I have the same question (0)
  • Suggested answer
    IB-29041624-0 Profile Picture
    1,187 Moderator on at

    I think you have to create you own report for that using Financial reporting - what used to be called account schedule.

    Maybe you can find some inspiration here:

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

  • Suggested answer
    KasparsSemjonovs Profile Picture
    4,832 Super User 2026 Season 1 on at

    Customer / Item Sales - show sales amount, and profit for each sold item to each Customer.

    Try creating "Inventory Analysis Report" - it is similar to Inge's mentioned Financial Reporting, where You define Rows and Columns - You can create needed rows and then provide the filter how values are calculated - it can be Item or Item Group with a filter to global dimension. In columns You can set to show value beginning balance Balance at end date, net change, year to date and others and for this period show Quantity, Sales Amount, Cost amount, Unit Price,  Unit cost and others.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

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

#2
YUN ZHU Profile Picture

YUN ZHU 1,279 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,192

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans