Skip to main content
Business Central forum
Suggested answer

Customer/Item statistics based on receiver of the items

editSubscribe (0) ShareShare
ReportReport
Posted on by

Hello,

we have following topic. 

We have customers which have several subsidiaries. Therefore we create 1 customer for each subsidiary. In the subsidiaries we fill in the customer no. of the parent company in the field "Bill-to Customer".
Each sales order is created for the subsidiary. 

Now we want to track how many items and how much income we created for each subsidiary. But the value entries only include the source no. of the parent company. The standard customer/item statistic reports does not show the name of the subsidiaries. 

Does anybody know how we can achieve this. We need this also for all saled items in the past. 

Any hint is helpful.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,395 on at
    RE: Customer/Item statistics based on receiver of the items

    Hi

    I tried some built in report and seems like when you select Bill-To it does not produce the report (at leas in my environment). One method is to create filter for all subsidiary then add them to Customer/Item Statistics and select Print in Excel and do some manual task after that (use vlookup from account no to find the name, etc)

    Other possible methods are

    1) User Power BI Desktop. Then publish Posted Sales Invoice and then link entries to invoice and from invoice determine the Bill-To customer and create a report. 

    2) You can try to use ODATA and Excel. Publish Posted Sales Invoice and Value in Web Service then go to Excel and use this method to access ODATA. Then user Power Query to built the report. https://thatnavguy.wordpress.com/2021/12/20/getting-d365-business-central-data-to-excel-using-odata-feeds/  or https://www.youtube.com/watch?v=zr5FVLmkNu8

    3) Custom Report is another option but you need to work with your partner and developer. They can use current customer/item statistic and modify it to add a missing data. This way you can run it in BC. 

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,066 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,585 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans