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

Total Weight on Posted Sales Shipment in Word

(0) Share

Report

Posted on by john.ellis

3,518

Hi:

I have modified the Word template for the Posted Sales Shipment report to show the Unit Net Weight field from the Item Unit of Measure window.

I need to take this a step further, however, and have the report multiply the Unit Net Weight times the Quantity of the line item on the Posted Sales Shipment to show a Total Weight.

Can the Word template accommodate such a calculation, without the use of Application Language (AL) code?

Thanks!

John

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

YUN ZHU 98,014 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, you can try the following, but I'm not sure if it will work.

https://www.youtube.com/watch?v=QVajFjDslUM

https://support.microsoft.com/en-us/office/use-a-formula-in-a-word-or-outlook-table-cbd0596e-ea8a-485e-a35d-b2cb2c4f3e27

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,786 Moderator on at

Like (0)

Report
Copy link

Link copied!

To modify the calculation field in word layout you have customize the report with AL code. I am not sure it will workout directly in the word layout.

Was this reply helpful? Yes No
john.ellis 3,518 on at

Like (0)

Report
Copy link

Link copied!

Thanks, Nitin. But, I'm trying to avoid programming.

John

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,786 Moderator on at

Like (0)

Report
Copy link

Link copied!

unfortunately in this case you can't avoid that.

Was this reply helpful? Yes No
john.ellis 3,518 on at

Like (0)

Report
Copy link

Link copied!

It's disappointing that you have to be a computer programmer to conduct the simplest modifications.

Was this reply helpful? Yes No
john.ellis 3,518 on at

Like (0)

Report
Copy link

Link copied!

@Zhu: Thanks! Yes, unfortunately, it doesn't work.

I really don't understand why you have to be a computer programmer to conduct what should be a simple modification. It's not fair to those who don't have the time to learn AL.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 98,014 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

What unfortunate news.

Yes, but I feel like Microsoft is trying to improve this.

First of all, in June this year, Microsoft will release the feature of adding fields on the page without Page Extension.

Add existing table fields to optimize your pages

https://learn.microsoft.com/en-us/dynamics365/release-plan/2023wave1/smb/dynamics365-business-central/add-existing-table-fields-optimize-pages

I think the next step is the DataItem of the report and the fields of the APIs.

Perhaps a few major releases later, these issues will be resolved. Think about it, before the BC18 version, there was no Report Extension, and partners had to recreate the report if they wanted to modify the standard report, even just add a field.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
john.ellis 3,518 on at

Like (0)

Report
Copy link

Link copied!

Thanks, Zhu! Yes, that is all good to know! :)

John

Was this reply helpful? Yes No