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

A Word Calculator…What is GPT?

How Will It Improve the World? How Will It Not?


a humanoid computer from the 90’s playing chess digital art, DALL-E

When I was 12, my dad took some math classes at our community college.  The advanced material required a new calculator.  One night, he pulled me over to his homework table, “Look at this!”  He typed an equation, pressed enter, and a squiggly line darted from left to right like when the patient gets zapped back to life in an ER episode.  “Ba-Bump, Ba-Bump” my dad made sound effects as the line bent up and down across the screen.

At the time, I didn’t know what a sine curve was.  It didn’t matter.  The output was exciting.

Y=sin(x^2) …exciting was relative, pre-YoutTube

Years later, I took those same classes. The green LCD screens had become as ubiquitous in math as pencils.  Now I know what sine is.  I still don’t know how a TI-83 calculates it.  What happens in that black box when you press enter?  

If cryptocurrency was the conversation of 2022 (is that finally behind us?), GPT will be the conversation of 2023.  Perhaps you need a primer: GPT is a calculator for text.

What is GPT?

GPT (short for “Generative Pre-training Transformer”) is a type of artificial intelligence model that is used for natural language processing tasks such as language translation, summarization, question answering, and language generation. It is a deep learning model that was developed by OpenAI, and it is designed to be able to learn and generate human-like text.

I didn’t write that.  I typed “What is GPT?” into OpenAI’s ChatGPT, and it generated that output. 

Continue reading

Hotkey Highlights (and Happy Holidays) – Tips for Efficient Journal Entry

Not sure what to get that special D365 accountant in your life? Waited till the last minute and now you don’t have time to buy a gift? Show your appreciation by passing along this list of journal entry tips. Better yet, send a link to our whole series on shortcuts.

#D365Blogs: the gifts that keeps on giving – even during the holidays.

These example screenshots will be from the general ledger journal form, but are applicable across journal types in D365.

Alt+N – Create a new journal

Alt+N can create a new journal header, and also create new journal lines once the journal lines are opened.

Continue reading

Win+V: Super Cut & Paste

“Manual data entry builds character,”
Joel Leichty
“Character gives us qualities, but it is in our actions–what we do–that we are happy…or the reverse,”
Aristotle

If you need to paste multiple values into multiple places, WIN+V should be your new best friend. Where regular CTRL+C copies something and CTRL+V pastes that last thing you copied, WIN+V allows you to select from your history if previous items copied.

Continue reading

Navigating ERP Environments: DEV, TEST, & PROD

Multiple environments are necessary during ERP implementations. An ERP implementation usually involve at least three environments, though additional environments might be added depending on implementation project requirements. DEV, TEST, and PROD, are the most common names for these three environments

PROD (May also be called GOLD)

After implementation, PROD refers to the live ERP environment. Prior to implementation, this is a transaction-less environment where tested configurations are setup. Transaction-less because ERP systems don’t have a “delete posted transactions” button, so you want to keep this environment clean from test transactions. So where does transaction testing happen?

TEST (May also be called UAT for User Acceptance Testing)

During the implementation, subject matter experts and end-users will setup sample configurations and model business processes with test transactions in the TEST environment. The desired, approved configurations will then be setup in the PROD (GOLD) environment.

DEV (Mostly just called DEV)

DEV environments are necessary as ERP projects frequently require customizations. A developer can build and deploy his developments to the DEV environment without interrupting the flow of user testing. Once any technical bugs are smoothed out, the customized code from the DEV environment can be promoted to the TEST environment, where it will be validated/approved by subject matter experts or other functional users.

Continue reading

Why Does Daddy Have to Work?

Working from home with kids is full of distractions. 

Lawrence has been walking for a couple months now. He likes banging on my office door a few times per day. Very determined for his age, he won’t stop until I open the door. When I do, his little grunts turn into a big smile.  He takes me by the hand to lead me into the living room, or into the kitchen, or just back-and-forth to nowhere in particular. If I leave my office door open in the evening, Lawrence likes to slip in and press a button on my keyboard to flash on the sleeping monitors.

The other night, while wrestling Calvin into bed, he hopped up into my office chair and started hacking away at my keyboard, “I’m working Daddy!” He even put on my headset and let me take a picture. I have to lock the office door while I work because, unlike Lawrence, Calvin can reach the handle and feels at liberty to barge in anytime he wants to play.

In April, I left a salaried job to start freelancing.  One reason for the change was to work on my own terms, to spend more time with the kids. More time with the kids isn’t all time with the kids though.  There are still trade-offs. The freelancing still needs to be done. It’s hard to say “No, Daddy can’t play right now. Daddy has to work,” but it’s necessary at times.

Calvin and I have this script: I ask “Why does Daddy have to work?” and Calvin responds, “To make money.” I ask “Why does Daddy have to make money,” and Calvin responds, “To buy Calvin toys!” 

This is a partial and inaccurate truth. I’m not sure how to best correct it.

Continue reading