Project Financial Dimension Report – D365 Finance & Excel

In this video, we look at building a report based on project financial dimensions using the excel data connector.

Some Concepts:

  • Master data reporting through listpage views
  • Export to excel vs Open in Excel
  • Financial dimension configuration for OData connections
  • Mediocre usage of text-to-columns in Excel
  • Financial dimension and chart of accounts delimiter
Continue reading

D365 Finance | Missing Data Entities – Refresh Entity List

Note to future self:

In the data management workspace, if you don’t see a data entity that you expect to see, try refreshing the entity list. This is particularly the case when a new data entity is created, or a trail environment is first spun up.

Go to Data management workspace

Continue reading