Announcements
Hello Everyone.
I am creating a custom report layout for sales invoice on dynamics 365 business central.
I was asked to ensure the Quantity_Line automatically totals.
Kindly help with solution.
Best regards.
Hi Austin360 ,
In the marked column there is always Qty. comes for the corresponding lines of that particular item, do you mean that if you have same items multiple times in the report, and so you want to display the total Qty?
Thanks.
Hello Nitin Verma , yes
So the 'Quantity_Line' is a tag that holds the number of line items requested, at the end of the day, the invoice should be able to sum(Quantity_Line) with the total at the bottom.
Hi,
you can use =Sum(Fields!Quantity_Line.value) in expression property.
Wonderful!
but how do I locate the expression property section..
Please I you provide a steps .
Best regards
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 607 Super User 2026 Season 2
YUN ZHU 421 Super User 2026 Season 2
Grigorios Mavrogeorgis 375 Super User 2026 Season 2
