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 forum / Profit and Loss Report
Finance forum

Profit and Loss Report

(0) ShareShare
ReportReport
Posted on by maober56 95

Hi all,

I need to build a Profit and Loss report, based on GeneralJournalEntry and GeneralJournalAccountEntry tables, joining it with financial dimensions tables (DimensionAttributeValueCombination...). I created an Data Entity to export this information to an Azure SQL database using BYOD, but when I exported the data, I recieved an error message, because my entity don't has an unique key, But I don't know which fields combination can make an unique key for this two tables.
How I am using Financial Dimension tables, I tried to use the LedgerDimension field from GeneralJournalAccountEntry, but didn't work either.

Categories:
Development / Customization / SDK
Data Integration
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Profit and Loss Report

    Hello Mauricio,

    Many thanks for your reply.

    The currently available financial report designer does not have an excel integration available that allows you importing data from sources other than D365FO.

    If you want to use the financial reports then postings in D365FO are required.

    Those postings can be made in a separate company or in an existing one on separate / statistical accounts.

    Before trying to develop something, I would consider those workarounds first.

    Best regards,

    Ludwig

  • maober56 Profile Picture
    maober56 95 on at
    RE: Profit and Loss Report

    We have an ISV solution in Dynamics 365, this solution is for a heavy equipment dealer, we need that the P&L reports contains information of some ISV modules, because we need to extract the information to a Datawarehouse, I´m using data entities to make it throught BYOD, but I'm having problems with Staging table indexes. We evaluate Financial Report, but didn't meet with all our requirements

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Profit and Loss Report

    Hi Mauricio,

    Can you elaborate on the specific financial requirements for P&L reports that you mentioned? What are those specific requirements?

    Also can you let us know in more detail what you mean by saying that other functional areas join with their own information? Do you mean that new companies are acquired or something else?

    Would be great if you could clarify.

    Many thanks,

    Ludwig

  • maober56 Profile Picture
    maober56 95 on at
    RE: Profit and Loss Report

    I understand, but we have a specific financial requirement for P&L reports and also that information is used for other functional areas that join it with their own information. Our plan is make available many entities, financial including, for end users reports design.

  • maober56 Profile Picture
    maober56 95 on at
    RE: Profit and Loss Report

    Eugen and Ludwig thank you for your answers.

    I understand, but we have a specific financial requirement for P&L reports and also that information is used for other functional areas that join it with their own information. Our plan is make available many entities, financial including, for end users reports design.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Profit and Loss Report

    Hi,

    Agree with Eugen

    Why don't you use the financial report designer that even ships with pre build templates for the P&L statement?

    Best regards

    Ludwig

  • Eugen Glasow Profile Picture
    Eugen Glasow 6,357 on at
    RE: Profit and Loss Report

    Do you know that you are re-inventing the wheel? P&L reports are made in the Management Reporter.

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,978 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,821 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans