web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to get the financi...
Finance | Project Operations, Human Resources, ...
Unanswered

How to get the financial dimension values from vendor invoice journal

(0) ShareShare
ReportReport
Posted on by Rafia Mohammed 266

Hello everyone,

In vendorinvoicejournal form, attaching screenshot for reference

pastedimage1648819731014v1.png

If the Account type other than ledger and if account is blank, i have to pick the account  from financial dimensions drop down -> account -> select the values and assign the values 

on the form where the dimensions are created on the same form.

i think we can write the code on OK button of dimension form, any input to share the code snippet?

pastedimage1648819797236v2.png

Thank you

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 299,349 Super User 2025 Season 2 on at
    RE: How to get the financial dimension values from vendor invoice journal

    Hi Mohammed,

    Can you tell what exactly you are trying to achieve? Do you have a requirement to display dimension info in individual columns on the grid? Are these display methods or database fields? If you have chosen for fields which will store data, what is the background of this? Duplicate some data might be error prone.

    With display fields, you can use x++ logic to extract data from the dimension set reference. This had a disadvantage that filtering on display fields are not possible and with a lot of records on the form it can cause some slowness.

  • Rafia Mohammed Profile Picture
    Rafia Mohammed 266 on at
    RE: How to get the financial dimension values from vendor invoice journal

    Hello André Arnaud de Calavon ,

    The fields are not database fields, those are display methods actually, i want to assign the field values of ledgerjournaltransdimension to ledgerjournaltransvendinvoice(display method fields)

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,423 on at
    RE: How to get the financial dimension values from vendor invoice journal

    Hi Rafia,

    In case of vendor invoice journal, since the account is non-ledger, the financial dimensions are stored in DefaultDimension field in LedgerJournalTrans table. If you want to find the individual dimensions using display methods, you can use DefaultDimensionView to retrieve the values.

    public display DimensionValue dimDepartment()
{
    DefaultDimensionView    defDimView;
    
    select DisplayValue from defDimView
        where defDimView.DefaultDimension   == this.DefaultDimension
           && defDimView.Name               == "Department";
}

    However, as Andre mentioned before, this will cause performance issues for you depending on the number of dimensions you want to show using display methods on this form.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,100

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 890 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 633 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans