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.

  • Suggested answer
    IB-29041624-0 Profile Picture
    1,191 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,851 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 710 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 387 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 385 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans