web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Create a wave template...
Supply chain | Supply Chain Management, Commerce
Answered

Create a wave template that queries for "big" shipments

(0) ShareShare
ReportReport
Posted on by J_Tedsjo 30

Hi,

We would like to catch "big" shipments on a specific wave, for example shipment that have more then 10 lines should be on its own wave.

Is it possible to add for example "Shipment lines" in the query for a wave template?

Thanks!
Johan

Categories:
Warehouse Management
  • J_Tedsjo Profile Picture
    J_Tedsjo 30 on at
    RE: Create a wave template that queries for "big" shipments

    Hi Sagar,

    Thanks for your answer! I guessed that it would not be possible to filter on Shipment lines, thanks for confirming that!

    Br,

    Johan

  • Verified answer
    Sagar Suman Profile Picture
    Sagar Suman 5,774 on at
    RE: Create a wave template that queries for "big" shipments

    Hi,

    Sadly, you cannot filter shipments based on the field Shipment lines.

    The field is a calculated method and cannot be added to the query. 

    For a similar requirement we created a custom field to stamp the shipments lines on Shipment table which was added to query to filter shipments based on size. 

  • J_Tedsjo Profile Picture
    J_Tedsjo 30 on at
    RE: Create a wave template that queries for "big" shipments

    Hi,

    Yes, I know about the Edit query option :) The questions is if it's possible to join a table that holds the information about number of Shipment lines?

  • GuyUK Profile Picture
    GuyUK 28,343 on at
    RE: Create a wave template that queries for "big" shipments

    Hi Sagar & Hana,

    How do you suggest Johan should setup the wave template query to find Shipments which have more or less than 10 lines?

  • Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    RE: Create a wave template that queries for "big" shipments

    Hi Johan,

    To set up a wave template, follow these steps:

    • Go to Warehouse management > Setup > Waves > Wave templates.
    • Select New to create a new wave template.

    For more detailed settings, you can refer to the following documents:

    Wave templates - Supply Chain Management | Dynamics 365 | Microsoft Learn

    And as Sagar's screenshot shows, you can follow the screenshot to set.

    Best Regards,

    Hana

  • sagar_patil Profile Picture
    sagar_patil 331 on at
    RE: Create a wave template that queries for "big" shipments

    Please try this.

    pastedimage1686715295000v2.png

    Use edit query option on wave template.

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard > Supply chain | Supply Chain Management, Commerce

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans