web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Detailed Reports of Wa...
Supply chain | Supply Chain Management, Commerce
Suggested answer

Detailed Reports of Warehouse transactions

(2) ShareShare
ReportReport
Posted on by GB-15042054-0 8
Could you please help to have detail reports of pending put-away and picking in WMS? Need number of lines by SKU.
 
Thank you
Categories:
Dynamics 365 Supply Chain Management
I have the same question (0)
  • GB-15042054-0 Profile Picture
    GB-15042054-0 8 on at
    Detailed Reports of Warehouse transactions
     
    Thank you very much for your response. Will follow given the steps.
     
  • Jonas "Jones" Melgaard Profile Picture
    Jonas "Jones" Melgaard 4,798 Super User 2025 Season 2 on at
    Detailed Reports of Warehouse transactions
     
    When I last implemented D365 SCM we made a workspace with tiles that provided these pending pick lines. I'd try to see how far you can come with that approach. What is your needs exactly?
     
    I don't recall any reports readily available out of the box, maybe @Holly Huffman can correct me?
  • Suggested answer
    Holly Huffman Profile Picture
    Holly Huffman 6,518 Super User 2025 Season 2 on at
    Detailed Reports of Warehouse transactions
    Good morning, afternoon, or evening depending on your location!
    To generate detailed reports of warehouse transactions, including pending put-away and picking lines by SKU in Warehouse Management Systems (WMS), you can follow these steps:
    1. Set Up Reporting:
      • Ensure that your WMS is configured to track inventory transactions at the SKU level. This includes recording details for put-away and picking operations.
    2. Use Built-In Reporting Tools:
      • Most WMS platforms, including Dynamics 365 Supply Chain Management, offer built-in reporting features. Navigate to the Warehouse Transactions section to access detailed data.
      • Filter the data by transaction type (e.g., put-away or picking) and group it by SKU to get the required breakdown.
    3. Custom Reports:
      • If the built-in tools don't meet your needs, you can create custom reports using Power BI or SQL queries. Extract data from the WMS database and design a report that displays the number of lines by SKU for pending transactions.
    4. Automation:
      • Set up automated workflows to generate these reports periodically and send them to relevant stakeholders.
     
    Hope this is helpful :)

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 159 Super User 2025 Season 2

#2
Yng Lih Profile Picture

Yng Lih 150

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 104 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans