Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Business Central forum / Web Services - Power B...
Business Central forum

Web Services - Power BI bug alert

(0) ShareShare
ReportReport
Posted on by Dave Boehm 645

Microsofter's,

In regard to object ID 132 (i.e. Posted Sales Invoice) and object ID 134 (i.e. Posted Sales Credit Memo) that show up in the Web Services screen within D365FO, there is no "Sell_to_State" field.  There is a "Sell_to_County" field.  I suppose this "Sell_to_County" field should contain the name of the applicable county.  Instead, it contains the data from the Ship-to "State" field from the "Shipping and Billing" fast tab on the D365FO "Posted Sales Invoices" screen.

It isn't much of an intellectual stretch to join this county field to state fields when managing relationships within Power BI, but this should probably be fixed.  I would post this on the Power BI forum, but I'm guessing this is something that should be addressed by the D365FO team, instead.

You may wish to review your other invoice/CM objects, as well.  At the present time, I'm just working with these two...

Categories:
Reports and Business Intelligence
  • Joost Bulsink Profile Picture
    Joost Bulsink on at
    RE: Web Services - Power BI bug alert

    Thank you for sharing a solution to your question. Hopefully this solution will help other community members. If you have more solutions and information that you would like to share please consider hosting a blog. You can find information about content guidelines and how to submit a request here.

  • Verified answer
    Dave Boehm Profile Picture
    Dave Boehm 645 on at
    RE: Web Services - Power BI bug alert

    After looking through the NAV 2017 SQL tables, I can see where this isn't a problem with what is exposed in Web Services.  This is apparently just a design short-cut taken by the NAV development team.

    Personally, I consider it to be perhaps a bit shabby, considering that several countries ( including the U.S.) have counties as well as states.  However, it looks like this process of stuffing state information into the "county" field is at least consistent throughout the solution.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

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 > Business Central forum

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans