Small and medium business | Business Central, N...

CUSTOMER ITEM HISTORY PER DATE

(0) Share

Report

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)

All responses (8)

Answers (0)

Patrick Sijs on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

NAV_with_Narang 2,294 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Patrick Sijs on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

KasparsSemjonovs 4,764 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Patrick Sijs on at

Like (0)

Report

Hi Kaspars,

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

Was this reply helpful? Yes No
KasparsSemjonovs 4,764 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No