Small and medium business | Business Central, N...

Totals per Item Category code or Dimension code

(0) Share

Report

Posted on by Melissa Guillemyn

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

Categories:

Dynamics 365 Business Central

All responses (2)

Answers (0)

Suggested answer

JAngle 89 on at

Like (0)

Report

RE: Totals per Item Category code or Dimension code

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.
Marco Mels on at

Like (0)

Report

RE: Totals per Item Category code or Dimension code

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.