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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Business Central forum

Ability to report on items purchased by Customers by Location

(0) ShareShare
ReportReport
Posted on by

How would it be possible to either customize or create a new report that will generate a list of items purchased by Customers by Item Location. I reviewed the POWER BI Data Sets and don't see LOCATION as an option and I cannot figure out how to export an existing report to *.RDL to add additional fields.  For example, I would like either have a Sales Line Items report by Location or a Items by Location by Customer report that will show each Item on an Invoice and where it was purchased from and by who. 

Is this possible? Am I missing something on how to export other reports besides those in the Custom Report Layout window?

I have the same question (0)
  • Lisa Sorensen_SGS Profile Picture
    on at

    I think I have the preliminary steps figured out using the Report Layout Selection option and Custom Report Layouts using the help files but it does not look like it is possible to group by Location as I do not see it as an option in the *.RDL file Dataset.

    I don't see an option to report Items by Customer By Location that can easily be created.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans