Skip to main content

Notifications

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 Microsoft Employee

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

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,428 on at
    RE: How to total qty of unique SKUs on Posted Sales Invoices in a date range for a specific customer

    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. 

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: How to total qty of unique SKUs on Posted Sales Invoices in a date range for a specific customer

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to total qty of unique SKUs on Posted Sales Invoices in a date range for a specific customer

    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!

  • MahGah Profile Picture
    MahGah 15,428 on at
    RE: How to total qty of unique SKUs on Posted Sales Invoices in a date range for a specific customer

    Hi

    Have you tried the following reports?

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

    Thanks 

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

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans