D365 Finance & Operations and Dynamics AX Forum

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
------------------------------

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
------------------------------

Original Message:
Sent: Feb 17, 2021 11:56 AM
From: Jeffrey DiOrio
Subject: Actual Ship Date Data - Power BI Accessible

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
------------------------------

Thanks for the insight @Juan Sebastian Grijalba, very much appreciated.​

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

Original Message:
Sent: Feb 19, 2021 04:00 PM
From: Juan Sebastian Grijalba
Subject: Actual Ship Date Data - Power BI Accessible

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

Original Message:
Sent: Feb 17, 2021 11:56 AM
From: Jeffrey DiOrio
Subject: Actual Ship Date Data - Power BI Accessible

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
------------------------------