Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Sales Report by Customer and Item

Posted on by Microsoft Employee

Hello,

I would like to print or view a sales report that lists all of my customers and the items they have purchased.  It does not appear that there is a way to do this.  I can see how to do a list for each customer individually, but it seems rather ridiculous that you would have to print 100 lists.  In my old system I could generate a list that had each customer and the items they purchased in my selected time frame.  Is there any way to do this in NAV?

Thanks.

*This post is locked for comments

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Sales Report by Customer and Item

    And you might also want to upgrade to the recent version of Business Central. The options for reporting in the new version are way better than the version you are using now.

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: Sales Report by Customer and Item

    hi

    look this

    community.dynamics.com/.../sales-report-by-customer-and-item

    Daniele

  • Suggested answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Sales Report by Customer and Item

    Check Customer/Item Sales report.

    If you require additional fields you can always contact your Microsoft Dynamics NAV partner and ask them to modify it according to your requirement.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Report by Customer and Item

    Hie,

    you can use Jet reports. it comes with standard sample reports that can be of great use. you can customize them to suit your needs. its really a great reporting tool. you can try the free version Jet express. www.jetreports.com

  • mmv Profile Picture
    mmv 11,465 on at
    RE: Sales Report by Customer and Item

    Hi,

    You may try "Inventory - Customer Sales" report too (if you are looking for Item Customer wise).

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Sales Report by Customer and Item

    Check Report Item Sales By Customer report / Customer - Item Statistics report

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans