Skip to main content

Notifications

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

Total Weight on Posted Sales Shipment in Word

Posted on by 3,482

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:
  • john.ellis Profile Picture
    john.ellis 3,482 on at
    RE: Total Weight on Posted Sales Shipment in Word

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

    John

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,339 Super User 2024 Season 2 on at
    RE: Total Weight on Posted Sales Shipment in Word

    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

    pastedimage1681259264942v1.png

    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

  • john.ellis Profile Picture
    john.ellis 3,482 on at
    RE: Total Weight on Posted Sales Shipment in Word

    @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.

  • john.ellis Profile Picture
    john.ellis 3,482 on at
    RE: Total Weight on Posted Sales Shipment in Word

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

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Total Weight on Posted Sales Shipment in Word

    unfortunately in this case you can't avoid that.

  • john.ellis Profile Picture
    john.ellis 3,482 on at
    RE: Total Weight on Posted Sales Shipment in Word

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

    John

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Total Weight on Posted Sales Shipment in Word

    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.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,339 Super User 2024 Season 2 on at
    RE: Total Weight on Posted Sales Shipment in Word

    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

    pastedimage1681169681615v1.png

    Hope this helps.

    Thanks.

    ZHU

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans