Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Data Entities for sale...
Finance | Project Operations, Human Resources, ...
Answered

Data Entities for sales margin report

(0) ShareShare
ReportReport
Posted on by Hendo 582

Hi. I'm new to D365 Finance having spent many years working with AX2009/AX2012.  We have a need to create a Sales margin report in D365 and in particular it must include

  • Sales order invoices - Item level
  • Project invoices - item and category
  • Free text invoices. 
  • Financial dimensions data for each line
  • Measures must be sames amount and cost (being average cost).

I've spent too much time looking for an appropriate set of standard data entities with very little success. 

Am I correct in assuming that I would need to create a custom data entity(s) to achieve this report?   Am I misunderstanding something about D365 and data entities?

Cheers

James

Categories:
Financial Management
Data Integration
Other
  • Hendo Profile Picture
    Hendo 582 on at
    RE: Data Entities for sales margin report

    Hi Pete. May thanks.  "Reporting D365" ... Given the requirement for data interaction, PowerBI or Excel.  

  • Verified answer
    Satish Panwar Profile Picture
    Satish Panwar 14,637 on at
    RE: Data Entities for sales margin report

    Hi James,

    You are looking for lot of details from standard entity. You would need custom entity for this. Prior to creation try to see if standard entity has the fields /logic that you can leverage. E.g. for magin check sales line/customer invoice entity.

  • Verified answer
    Pete Alberts Profile Picture
    Pete Alberts 3,538 on at
    RE: Data Entities for sales margin report

    Hi James

    Here is a summary: Data Entities on docs In this context you only need to read the Overview and Capabilities sections.

    Data Entities are used to present a normalised table structure as a single unit (hence "data entity") and then to expose that encapsulated unit (import/export and integrations).

    I assume that with "report in D365" you mean an SSRS Report. In that case Data Entities are not what you are looking for.

    I do not have experience in AX2012, but I have heard that building a report in D365 is basically the same as in AX2012.

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

Dynamics 365 Community Update – Sep 16th

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

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Last month Overall leaderboard

Featured topics

Test Comment 26-09-2024 16:14pm

Product updates

Dynamics 365 release plans