Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸
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

(1) ShareShare
ReportReport
Posted on by GB-15042054-0 6
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
  • GB-15042054-0 Profile Picture
    GB-15042054-0 6 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 3,435 Super User 2025 Season 1 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 5,510 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

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,095 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,866 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans