Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

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

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

Categories:
  • Suggested answer
    MahGah Profile Picture
    MahGah 15,419 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,155 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,419 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

Quick Links

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…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,647 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans