Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to Generate a Repo...
Small and medium business | Business Central, N...
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:
Business Central
  • 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 320 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 344 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans