web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to total qty of un...
Small and medium business | Business Central, N...
Suggested Answer

How to total qty of unique SKUs on Posted Sales Invoices in a date range for a specific customer

(0) ShareShare
ReportReport
Posted on by Community Member

I need to pull a report for each customer which shows all SKUs totaled in qty sold during a specific timeframe.  These items would be on the posted sales invoices.

It doesn't matter to me if it is for all customers at one time - I can separate them out in Excel afterwards, but I do need the total of the individual items invoiced (shipped).

Thanks

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • MahGah Profile Picture
    MahGah 15,613 on at

    Hi

    Have you tried the following reports?

    1. Customer/Item Statistics
    2. Item Sales by Customer

    Thanks 

  • Community Member Profile Picture
    Community Member on at

    On Customer/Item Statistics is there a way to break down the items by variant? It gets me the total qty of each item, but not each SKU/variant.

    Item sales by customer is one way to do it, but there is no way to look at one account en masse - filter does not work because each item is separated.

    Any ways to correct these issues?

    Thank you!

  • Suggested answer
    JAngle Profile Picture
    JAngle 159 on at

    Item ledger entries makes the most sense. Set the necessary filters to show sales shipments only and a date filter.

    If you want it in excel use a web service. Query object 265 is for item ledger entries. You can use the url to do a power query in excel and set your filters.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,613 on at

    Hi

    In this case Josh's recommendation is the way to go. You can use both Excel or Power BI.

    Or you can develop a new report based on any of those report to address the issue. This way users can run those reports in BC. 

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

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,334 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,717 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,470

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans