Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / How to Generate a Repo...
Business Central forum
Suggested answer

How to Generate a Report with Item No and it's count on Registered Pick Docs.

(1) ShareShare
ReportReport
Posted on by LANESALES 16
Looking for a report that shows how many times an item appears on a Pick Document.
The item turn over report shows item "sales qty" which is not precise. 
 
We need to know how many times a month an item appears on a Registered Pick doc. The "sales qty" in EACHES is not the value we require.
We need to know what items are picked the most to reduce travel pick time.
Categories:
Integration to Power BI, Power Apps, Power Automate and Dataverse
  • Suggested answer
    LANESALES Profile Picture
    LANESALES 16 on at
    How to Generate a Report with Item No and it's count on Registered Pick Docs.
    Thanks for the replies Andy and Ramiz.
    I've been able to export the data via Configuration Template.
     
    I will give the Analysis Report a run through.
    I'm not an expert on queries.
     
  • Suggested answer
    Andy Wingate Profile Picture
    Andy Wingate 316 on at
    How to Generate a Report with Item No and it's count on Registered Pick Docs.
    Hello
     
    I have created an example app for you for the query that was suggested. You can use PowerBI to read this query and go from there.

    But I also added a new example list page in the app called "Registered Warehouse Activity Lines" - so you can do the analysis inside BC also - just search for a new page called "Registered Warehouse Activity Lines" you can use the built in analysis action...
     
     
     
    Hope that helps!

    If you want to easily make these kind of small apps - try out the Simple Object designer app https://www.hougaard.com/designer/
     
    Andy
  • Suggested answer
    Ramiz Profile Picture
    Ramiz 238 on at
    How to Generate a Report with Item No and it's count on Registered Pick Docs.

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

Replay: Dynamics 365 Community Call ERP Edition | October 9, 2024

Another great gathering of our Community!

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,815 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans