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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Suggested Answer

Pick List Cancelled Date

(0) ShareShare
ReportReport
Posted on by 131
Hello,
 
From D365 F & O, I'm building a report to extract details of cancelled pick lists and the associated lines.  Try as I may, I cannot locate the actual date the pick was cancelled?  Where is this in D365?  Or more specifically, which table does it reside in?  I've looked in [WMSPICKINGROUTE] and [WMSORDERTRANS] but I cannot seem to find it?
 
Also, is their an out-of-the box report that would give me cancelled pick details?
 
 
 
  • Suggested answer
    Hana Xue Profile Picture
    Microsoft Employee on at
    Hi,
    I also checked the related tables (WMSShipment WMSPickinglistRoute WMSPickingListRouteLink WMSOrderTrans) and no information about the picking list canceled date field was provided. It should not be a field in the system standard table. You may need to use a custom query to join multiple tables to extract the necessary details.
    In addition, the system has a picking list report that can filter the data on the report. You can refer to it.
    Picking list report (ProdPicklist) | Microsoft Learn
    Best Regards,
    Hana
  • Michael Hutcheson Profile Picture
    131 on at
    Thanks for the reply - every time I run that report it just states 'There is no data available'?  I've tried playing around with the different filters but it won't produce any results.  Strange as I can see data when I query [WMSPICKINGROUTE] \ WMSORDERTRANS
     
     
     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 131 Super User 2026 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 120 Super User 2026 Season 2

#3
Aayush Tiwari Profile Picture

Aayush Tiwari 54

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans