Open Forum

Expand all | Collapse all

Custom Word Layout Sum a Field or add total quantity

  • 1.  Custom Word Layout Sum a Field or add total quantity

    Posted Apr 09, 2019 01:59 PM
    I would like to add the total quantity on a sales order to the custom word layout template so that the total quantity prints on the sales order confirmation.  NOT the total amount $ but the quantity.  The total fields that are available in teh xml mapping all relate to amount.
    What is the best way to do this?
    Total quantity is available on the statistics page for the sales order but my understanding is that the field for quantity in that report is not a table value but a calculation so I can't add it as an available field to the word doc template.
    I understand that once the data is in word it is converted to text and therefore cannot be used in a sum formula unless you somehow convert it back to numerical.
    I see this tutorial but I'm not sure how to incorporate that into the table in the custom report


    #nav2017 #technical ​​

    Ruth Entwistle
    Customs Broker/Vendor Relations
    Heron Point Seafood
    Newmarket NH

  • 2.  RE: Custom Word Layout Sum a Field or add total quantity

    Posted Apr 11, 2019 03:16 PM
    I'm pretty sure you would need to write code to add this to the data set so that it is then available for you to use in the layout. This can be a little tricky to get right, especially if you are printing multiple copies of a document at the same time. There are a lot of "depending ons" as for how to write that code. I'd suggest splitting the workload with your partner. Have them add it to the dataset and then you can add it to the layout.

    Matt Traxinger
    NAV Developer
    ArcherPoint Inc.
    San Antonio TX

If you've found this thread useful, dive deeper into User Group community content by role