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

Totals per Item Category code or Dimension code

(0) ShareShare
ReportReport
Posted on by 67
Hello everyone
For a customer in the food sector, I was asked whether, in addition to the different lines of the goods sold. 
A total can be given per category on the sales invoice.
When I want to customize the sales invoice report, both Word and RDLC, I don't have any fields such as item category or dimensions.
How do I best handle this? Define the article categories per article or add a dimension per article?
And how do I get the totals on the sales invoice?

For example, 3 articles with the category / dimension of drinks were sold for a total of 1000 euros.
The sales invoice should then show a total: Drinks: 1000 euros.

Thanks for the help
 
I have the same question (0)
  • Marco Mels Profile Picture
    Microsoft Employee on at

    Hello,

    If this is not to be found in standard, I think this can only be done via customization. Ask your partner to write that for you.

    Thanks.

  • Suggested answer
    JAngle Profile Picture
    159 on at

    Certainly custom only. It is similar to VAT in that you might have multiple rates on one invoice and you have to show a breakdown of this by VAT category (gb requirement). Would require a modification to the report object to expose the required fields and then work on the RDLC to produce a matrix table with the required aspects.

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 June Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 695 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 422 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 328 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans