Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Jarrod Matheson]

Hi there,

Can someone assist me in preferably providing a list, if not determining how to find a list of D365FO data entities relating to financial reporting.

I am required to offer a list of robust financial reports to a new client using D365FO prior to engagement. I have no visibility of what tables i have to select from. 
If i have a list then i can figure out what i can offer based on the availability.

Thank you in advance

Jarrod

——————————
Jarrod Matheson
BusinessDataAnalytics
——————————

[Arush Kuthiala]

Hi Jarrod

I don’t know any way to find entities related to Financial Reporting, the one I use for a GL transaction dump is called “General Journal Account Entry”.

Thanks, 

——————————
Arush Kuthiala
Western Computer
Toronto ON
——————————
——————————————-

[Jarrod Matheson]

Thank you kindly for your reply.

I’ve since found this page which where i can download what appears to be all of the structures

https://mbs.microsoft.com/customersource/UK/AX/downloads/reports/axtechrefrep

The zip file is located here

https://mbs.microsoft.com/files/public/CS/AX/TechnicalReferenceReports_V10_0_2.zip

This gives me some good insights into what im looking for. 

——————————
Jarrod Matheson
BusinessDataAnalytics
——————————
——————————————-

[Mark Bailey]

Hi Jarrod,

So short answer – there are no data entities you can access using DataManagement or Excel Add-In tools.  However within the entity store in system administration->Set up there are a number of different entites based around the old 2012 cubes (flattened). Recommend looking into the BudgetvLedger activity measure/ Financial reporting transaction data version 2. These entities are exposed to PowerBI and used in the workspace analytics.

Your other option is good old management reporter oops sorry “Financial Reporting” to give it it’s new name. Lot’s of standard reports in there also.

——————————
Mark Bailey
Application Consultant
Annata
Portsmouth
——————————
——————————————-

[Ian Deynzer]

Based on experience, Management Reporter 2012 (renamed Financial Reports in D365) is the best financial reporting tool. It is easy to use and powerful once you have mastered the basics which are similar to most legacy financial report writers but now has an Excel style interface.

It is just a re-write of the old Frx product used extensively by SAP, Oracle, AX, etc. There is no need for standard templates, just create some basic column and row layouts which you can mix and match, and re-use. When migrating from AX 2009 to D365, you can do a partial migration of existing reports then patch the coding as there are structural changes in the D365 GL chart of accounts.

If you use an Excel Add-in, it will be slow because they all interrogate the database one cell at a time. That said, we do use an Excel Add-in for certain tasks like inventory planning to do clever stuff like re-ordering based on only full rolls of flooring products thereby ignoring the partial (cut) rolls from “available” stock on hand.

The best Excel Add-in is Atlas XL which we have used for 10 years

https://insightsoftware.com/atlas/

——————————
Ian Deynzer
CFO
Jacobsen Creative Surfaces
Auckland
——————————
——————————————-

[Jarrod Matheson]

Thank you Ian for the information.

I will add that to my list to test out as soon as possible.

——————————
Jarrod Matheson
BusinessDataAnalytics
——————————
——————————————-

[Jason Carter]

Hi Ian,

Thanks for mentioning Atlas. You mention the database being interrogated one cell at a time. I just wanted to reach out to make sure you are using a cache in your reporting to overcome this issue. If all of your cells are direct queries to AX/D365 they will get the data on cell a time. If you use a cache Atlas can go grab all the data you need in a single query, then populate the cells based on the data held in memory…much, much faster.

It looks like you are on Atlas 6.2. I’d recommend looking at the latest version, Atlas 6.7, when you have a chance. We’ve added a utility that will convert existing reports to be cache-based, so you can get that big performance gain without having to do a bunch of report redesign. With that version you also get file based caching with incremental updates, for another performance gain.

I’m in the US in Minnesota so time-zone math would be a bit tricky for you and I to jump on a Webex, but email me at jason.carter@insightsoftware.com and I can get you on touch with the right people in your region.

Regards,

Jason

——————————
Jason Carter
Solutions Enablement – Atlas
Insightsoftware + Jet Global
Fargo ND
——————————
——————————————-

[Jarrod Matheson]

Thanks for the intel Mark.

Based on your advice i was able to retrieve the entities for ‘BudgetVsLedgerActivityMeasure’

——————————
Jarrod Matheson
BusinessDataAnalytics
——————————
——————————————-

[Samantha Moore]

Hi Jarrod,

If you are just looking for a list, there is a Chrome Extension that enables you to see the tables and entities in Dynamics. 

Table Browser Caller for D365FO:
https://chrome.google.com/webstore/detail/table-browser-caller-for/nahbldacmaibopfiiaoboloegpobpccn?hl=en-US

Thanks,

——————————
Samantha Moore
Mansfield Oil Company
Gainesville GA
——————————
——————————————-

[Jarrod Matheson]

Thanks Samantha. I’ll give this a go 🙂

——————————
Jarrod Matheson
BusinessDataAnalytics
——————————
——————————————-