web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Custom dim lookup when...

Finance | Project Operations, Human Resources, ...

Unanswered

Custom dim lookup when publish value excel cell turns blank and updates null in GJ line

(1) Share

Report

Report

Posted on by Karthickks

100

Dear All

Thanks in advance.

Currently, I am working on adding a custom financial dimension in an Excel template. The lookup values are appearing correctly in Excel, but when I publish the values, the data cells turn blank and update with blank entries in the general journal lines. However, for the standard dimension "Department," it works as expected, meaning the values are correctly updated in the general journal lines upon publishing. Require your help on this Thank you!

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

André Arnaud de Cal... 306,356 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Kartickks,

Can you tell us if you followed the steps for adding dimensions to data entities as mentioned on this page? Add dimensions to Excel templates - Finance & Operations | Dynamics 365 | Microsoft Learn

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04

Check out the Community Spotlight Video Series

Quick Links

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

#1

André Arnaud de Cal... 393 Super User 2026 Season 1

#2

#3

Martin Dráb 252 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans