Skip to main content

Notifications

Dynamics 365 general forum
Answered

Setting up the Default Value for the country on account is picking up wrong Id

Posted on by 22

We got a business rule that sets the default value for the country on the account form on create.

Basically the country value is set to 'Australia' as a default value. Country is a look up field.

Now when I try to create a new account, the value for country on the form is showing as Australia but when I try to save the record I'm getting an error saying -

Record Is Unavailable

The requested record was not found or you do not have sufficient permissions to view it.

The actual error when I download the log file is

pastedimage1662335625705v1.png

I'm getting the similar error when I try to navigate to country from account (by clicking on Australia). but the strange thing is Australia does exist when I query the country .

pastedimage1662335722090v2.png

so why is the business rule picking up the wrong Id value?

  • Akshay AEMO Profile Picture
    Akshay AEMO 22 on at
    RE: Setting up the Default Value for the country on account is picking up wrong Id

    Yes! deactivating the business rule and resetting the country kinda solves the problem. I tried clearing cache but that did not work.

    so hopefully deploying the updated business rule(s) to Prod will resolve the issue because can't really do this in prod.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Setting up the Default Value for the country on account is picking up wrong Id

    Hi Akshay,

    You mentioned that you got a business rule to set default value, right?

    You can try to deactive it and then set country lookup field manually, Check if the error still occurs.

    Or you can try clear browser cache or change other browser to test again.

  • Akshay AEMO Profile Picture
    Akshay AEMO 22 on at
    RE: Setting up the Default Value for the country on account is picking up wrong Id

    Thanks for the reply. So guid for the country in the url is different than the one in the error message. In the url I can see it's 9198cb07-b02c-ed11-9db1-002248114b1f

    "&pagetype=entityrecord&etn=aemo_country&id=9198cb07-b02c-ed11-9db1-002248114b1f" but the Id in the error message is different. Which is "2cd9b145-cc61-eb11-a812-000d3a6a49c3".

    It is same for any other country I select, the error message got the same id. In terms of permission I'm trying to create an account using sys admin access still the same error.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Setting up the Default Value for the country on account is picking up wrong Id

    Hi Akshay,

    Have you check the guid of the Australia record through clicking it in the country view(your second screenshot)?

    You can view the guid in the url after openning the record form:

    pastedimage1662349698729v1.png

    The guid from the URL is the same as the ID of the error message?

    Will you get the same error message if you select other country records?

    Perhaps you can check that the country table privilege for the security role assigned to the current user are sufficient.

    --Microsoft has added a new button on the records called ‘Check Access’ using which user can easily check out their access to the records.

    https://www.inogic.com/blog/2021/02/check-access-to-a-dynamics-365-crm-record-using-check-access-button/ 

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

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,129 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans