Skip to main content

Notifications

Microsoft Dynamics NAV forum
Suggested answer

Odata 404 error

Posted on by 138

I have exposed the Sales Invoice Statistics page (Object ID 10041) as an Odata web service.

When I attempt to query the URL for the service in Power BI and other applications, I receive a 404 error.

Below is the response I receive.

{
"error": {
"code": "Internal_RecordNotFound",
"message": "The Tax Area does not exist. Identification fields and values: Code=''"
}
}

I have exposed many other pages as Odata web services and have not had issues.

Looking for advice on how to go about fixing this issue.

I need to query the Sales Invoice Statistics page for some Power BI reporting.

Categories:
  • drew777777 Profile Picture
    drew777777 138 on at
    RE: Odata 404 error

    Thanks. I have learned that Page 10041 is not compatible with Odata Web Services. When attempting to open the same page in NAV 18 CRONUS, I run into the same issue.

    I'm still confused by the error message and why it is referencing the "Tax Area". I cannot locate a Tax Area field on Page 10041. I will query a different page for my Power BI report.

    {

    "error": {

    "code": "Internal_RecordNotFound",

    "message": "The Tax Area does not exist. Identification fields and values: Code=''"

    }

    }

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 69,612 Super User 2024 Season 2 on at
    RE: Odata 404 error

    Hi, you can try to open the Sales Invoice Statistics page (Object ID 10041) directly in the development environment. As far as I know, this page must be opened from the Sales Invoice page, and there is no data when it is opened directly.

    So unfortunately, this page cannot be used in Power BI, you need to develop another page.

    Hopefully other experts can give you better advice.

    Thanks.

    ZHU

  • Suggested answer
    Manan_Shah Profile Picture
    Manan_Shah 1,457 on at
    RE: Odata 404 error

    Hi,

    I am not too sure where you can create a webservice page for Sales Invoice Statistics as I think it's temporary data page. And each time of open it will calculate date. 

    Also as per error message i think on Invoice header it's not have Tax Area code value. You can fill it on Customer card and it will flow to Sales Invoice Header. 

    Put filter on Invoice list page. for Tax Area code which document have value of Tax Area try to check your web service with that document. 


    Hope this will help.

    Many Thanks,
    Manan

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,469 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans