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

Announcements

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... / CUSTOMER ITEM HISTORY ...
Small and medium business | Business Central, N...
Suggested Answer

CUSTOMER ITEM HISTORY PER DATE

(0) ShareShare
ReportReport
Posted on by Patrick Sijs

Hi all,

Hope someone can help? I don't see an option to get the right information on Customer Sales History...

I would like to see when, what item and at what price a customer bought goods. I can put a date filter, but that totals the qty of items and the total price... I can of course calculate the average, but what when prices have changed a few times??  Is there a report that gives me an overview of history per customer, per item, per posting date?

Looking forward hearing from you :-) Many thanks in advance!

I have the same question (0)
  • Patrick Sijs Profile Picture
    Patrick Sijs on at

    ADD: We used to work in Dynamics 8.0, very old system, but there were so many possibilities.....

  • Suggested answer
    IB-29041624-0 Profile Picture
    IB-29041624-0 1,191 Moderator on at

    You can use the customer/Item sales report or you can customize a report f.ex. in Power BI.

    Then you can have the detail level that you like.

  • Suggested answer
    NAV_with_Narang Profile Picture
    NAV_with_Narang 2,390 Moderator on at

    There still are endless possibilities, it depends on how you extract your data. As suggested by Inge M Bruvik, you can utilize the OOTB report of Customer/Item sales or construct one of your own in Power BI.

  • Patrick Sijs Profile Picture
    Patrick Sijs on at

    Hi Inge,

    Many thanks for your response. For as far as I know POWER BI does not work here in the Netherlands? Any other options?

  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,842 Super User 2026 Season 1 on at

    If it is for specific Customer You want to re-check, just open Item Ledger Entries list, and put filters:
    Source Type = Customer,
    Source No.=Customer No
    Posting Date = period You are interested in

    If it is for all customers, then You would need to skip the Source No. filter.

    From these data, You can see all Items customer has Purchased, export to Excel for more reporting option. In case You are using latest BC versions, then it offers some Pivoting options directly in BC client.


    Another option within NAV/BC is to create "Sales Analysis Report", create Lines as Quantity Sold and Sales Amount - and here You can add Customer Filter and move between periods (day, week, month etc) and see the data.

  • Suggested answer
    IB-29041624-0 Profile Picture
    IB-29041624-0 1,191 Moderator on at

    I am 100% sure that Power BI works in the netherlands.

    If you do not want to use Power BI you can customize a report for example using an Excel layout.

    There are so many reportinng options in Business Central these days, the possibilities are almost limitless.

  • Patrick Sijs Profile Picture
    Patrick Sijs on at

    Hi Kaspars,

    MANY THANKS! The Item Ledger Entries option worked out the best! I have more questions, can I ask you?

  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,842 Super User 2026 Season 1 on at

    Sure.
    I would suggest to keep the questions here, that way others can confirm or add to my answers/suggestions (best with a new post to get attention :) ) But You can also reach out to me in LinkedIn or FB

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

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 649 Super User 2026 Season 1

#2
Gerardo Rentería García Profile Picture

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

#3
YUN ZHU Profile Picture

YUN ZHU 388 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans