web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums 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) Share

Report

Report

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:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

Suggested answer

Ramiz 637 on at

Like
a
(1)

Report
Copy link

Link copied!

You can achieve it by creating a query object.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-query-totals-grouping

Was this reply helpful? Yes No
Suggested answer

Andy Wingate 328 on at

Like
a
(1)

Report
Copy link

Link copied!

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...

GitHub - andywingate/RegWhseActLine

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

Was this reply helpful? Yes No
Suggested answer

LANESALES 16 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 677 Super User 2026 Season 1

#2

Gerardo Rentería Ga... 447 Most Valuable Professional

#3

YUN ZHU 366 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans