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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Customer history by ar...
Small and medium business | Business Central, N...
Suggested answer

Customer history by article and pricing

(0) ShareShare
ReportReport
Posted on by Community Member

Hi, 

I am looking for a report or an overview in BC where I can see following:

History of a customer sales by product number. But with the price that he payed. 

So for article X I want to know for a certain customer when he bought this product, how many pcs and at what price it has been invoiced. 

Is there such a report/overview in BC?

Thanks, 

Belinda 

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    MahGah 15,529 on at
    RE: Customer history by article and pricing

    Hi

    Maybe try "Cust./Item Stat. by Salespers." report.

    Or try to access Posted Sales Invoice Lines (table 113) using the method described in below article link will be something like: businesscentral.dynamics.com/

    Then filter by customer and export to excel and go from there.

    www.waldo.be/.../

  • Suggested answer
    Andrey Baludin Profile Picture
    Andrey Baludin 3,941 on at
    RE: Customer history by article and pricing

    Hi!

    You could open Items List, then Actions -> History -> Entries -> Value Entries

    At this view you could set filters like:

    Document Type = Sales Invoice

    Source No. = Your customer code

    Adjustment = false

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Customer history by article and pricing

    Belinda,

    Item Sales by Customer

    pastedimage1631647029205v1.png

    Hope this helps.

    Thanks,

    Steve

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 93,147 Super User 2025 Season 2 on at
    RE: Customer history by article and pricing

    Hi, you can try Inventory Customer Sales.

    pastedimage1631661817252v2.png

    pastedimage1631661777922v1.png

    Hope this will help.

    Thanks 

    ZHU

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 3,761

#2
Sumit Singh Profile Picture

Sumit Singh 2,611

#3
YUN ZHU Profile Picture

YUN ZHU 1,975 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans