News and Announcements icon

Dynamics 365 CommunityForums Supply Chain Management forum Pick List Cancelled Date

Supply Chain Management forum

Suggested answer

Pick List Cancelled Date

(0) Share

Report

Report

Posted on by Michael Hutcheson

125

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?

Categories:

Inventory and warehouse management

All responses Img

All responses (2)

Answers Img

Answers (0)

Michael Hutcheson 125 on at

Like (0)

Report

Pick List Cancelled Date

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
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report

Pick List Cancelled Date

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,349 Super User 2024 Season 2

#2

Martin Dráb 228,212 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans