D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Actual Ship Date Data - Power BI Accessible

  • 1.  Actual Ship Date Data - Power BI Accessible

    SILVER CONTRIBUTOR
    Posted 9 days ago
    Hello, and thanks in advance for any help the community can provide....it is very much appreciated!

    I am trying to build a simple 'Days Late' report within Power BI from our D365 Fin Ops data.  I have successfully found the tables SalesOrderLines and SalesOrderHeadersV2, but neither table has Actual Ship Date information, only Requested and Confirmed Shipping and Receipt dates.

    Does anyone know where I might be able to find a Power BI natively accessible table that should have an Actual Ship Date filed in it, relating to Sales Orders?

    ------------------------------
    Jeffrey DiOrio
    Vice President of Finance
    The Heico Companies
    Azusa
    ------------------------------


  • 2.  RE: Actual Ship Date Data - Power BI Accessible

    GOLD CONTRIBUTOR
    Posted 7 days ago
    Hello,

    Unfortunately you have to develop a custom entity for that. The issue that you will run into is that one sales order line could potentially have multiple Shipping dates. If you are familiar with the the table SysTableBrowser functionality you could get that info from the actual custPackingSlipTrans table, the field DeliveryDate is in this table(no data entity for this) and export the data to excel or cvs periodically and use it in your powerbi report.

    ------------------------------
    Juan Sebastian Grijalba
    Berkowitz Pollack Brant
    Miami
    ------------------------------



  • 3.  RE: Actual Ship Date Data - Power BI Accessible

    SILVER CONTRIBUTOR
    Posted 2 days ago
    Thanks for the insight @Juan Sebastian Grijalba, very much appreciated.​

    ------------------------------
    Jeffrey DiOrio
    Vice President of Finance
    The Heico Companies
    Azusa
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role