Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

You must select a value in the field in account structure

(0) ShareShare
ReportReport
Posted on by 1,424

We are getting an error message while posting a vendor invoice journal:

You must select a value in the CostCenter field in account structure: <account structure name>. The combination was not validated beyond the CostCenter financial dimension.

80257.Error.png

GST is being calculated correctly:

6661.Image-6.png

I can confirm this balance sheet account structure is attached to the ledger, the account structure itself is active, advanced rule structure containing an entry for this combination of financial dimensions is attached to this balance sheet account structure, main account is active for this company (not suspended) and all other financial dimensions in this accounting string are active for this company.

Ledger. Account structure is attached to the ledger.

3755.Image-2.png

Account structure is active itself.

1385.Image-3.png

Advanced rule structure is attached to the account structure.

7024.Image-4.png

Advanced rule structure contains an entry for the financial dimensions combination.

4643.Image-5.png

However, still the system is throwing this error message. Please advise how this could be resolved.

Thanks!

  • M Anas Khan Profile Picture
    1,424 on at
    RE: You must select a value in the field in account structure

    Hi Ludwig,

    I agree with you however, this is the way customer has configured their system to achieve the financial reporting requirements. They require to have cost center attached to every transaction being entered in the system irrespective of a P/L or balance sheet main account being used.

  • M Anas Khan Profile Picture
    1,424 on at
    RE: You must select a value in the field in account structure

    Hi Sourav,

    Thanks a lot for your response! This has fixed the issue. Default financial dimensions for the company were missing on the vendor summary account of the vendor posting profile.

    Thanks a lot for being an active and knowledgeable community member :)

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: You must select a value in the field in account structure

    Hi Muhammed,

    I think Sourav is right that the cost center is missing for the vendor account that is included in the journal.

    Assuming that this fixed your issue, can you let us know why you need a cost center for a balance sheet account?

    That is something that I don't see often.

    Many thanks and best regards,

    Ludwig

  • Verified answer
    SouravDam Profile Picture
    11,723 on at
    RE: You must select a value in the field in account structure

    Hi Muhammad Anas Khan ,

    Can you check if you have selected Cost center dimension value for account type 'Vendor' or not. Because summary account for vendor is also mapped in the structure.

    6232.JPG

    Best regards,
    Sourav Dam

    Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

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

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,157 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,930 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans