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.
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=''"
}
}
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,524 Super User 2024 Season 2
Martin Dráb 228,469 Most Valuable Professional
nmaenpaa 101,148