D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Data entity - ship date?

  • 1.  Data entity - ship date?

    TOP CONTRIBUTOR
    Posted Mar 25, 2020 04:27 PM
    Hi,
    We have a fairly simply power bi report that is connected to the Sales Order header and lines via oData connection. I've noticed that is seems to be missing the "ship date" field, though - which from my understanding, is the date when the packing slip is created.

    Has anyone else run into this and possibly know of another entity that contains that information?

    ------------------------------
    Thank you,
    Justin Cooper
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Data entity - ship date?

    TOP CONTRIBUTOR
    Posted Mar 25, 2020 06:59 PM
    From a functionality point of view, a single line can have multiple partial shipping attached to it, so by definition I don't think the Ship Date can reflect these multiple dates (and you can probably test that by partially shipping a sales order and seeing if that field on the line changes value)

    I think you should looking for an entity with Packing slip data, and filter on the rows related to the particular order line.

    ------------------------------
    Zvika Rimalt
    Functional Consultant
    Vancouver BC
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Data entity - ship date?

    D365UG/AXUG ALL STAR
    Posted Mar 26, 2020 09:35 AM
    It is very important to sort of understand the entities, based on which entity you use depends on what you can get to, Zvika is right, you will more likely get what you are looking for  by starting with the customer packing slip entity. It would contain the data for all shipments

    ------------------------------
    Paul Martin
    Production Program Manager
    Elite Comfort Solutions, LLC
    Rutherfordton NC
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Data entity - ship date?

    TOP CONTRIBUTOR
    Posted Mar 27, 2020 02:08 PM
    thank you both for the response. That is understood that it could have multiple ship dates.When looking around in the available oData entities, there doesnt appear to be an entity that is available that contains any packing slip information. Or at least in the version we are on - 10.0.7.

    ------------------------------
    Thank you,
    Justin Cooper
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Data entity - ship date?

    Posted Mar 31, 2020 05:20 AM
    There is no sales packing slip entity as of 10.0.8. I dearly wish there was. This seems a major oversight as MS seem to think invoice creation indicates shipment, which it most certainly does not in all cases.

    ------------------------------
    Jonathan Howe
    IT Manager
    Cross Manufacturing
    Bath, UK
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Data entity - ship date?

    Posted 6 days ago
    Hello,

    Do we know if Microsoft plans to publish this entity or will we need to create a custom one?  Any update would be greatly appreciated!


    ------------------------------
    Sarah Poe
    Luck Stone Corporation
    Richmond VA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 7.  RE: Data entity - ship date?

    Posted 5 days ago
    I'm not aware of any plans to provide a data entity based on custpackingsliptrans. However, the new functionality coming soon to sync tables to Azure Data Lake looks like it might offer a solution for this and other info for which there is no entity. However, consuming the data from the data lake is to my mind not going to be quite a simple as using odata or sql. Fingers crossed.

    ------------------------------
    Jonathan Howe
    IT Manager
    Cross Manufacturing
    Bath, UK
    ------------------------------

    Academy - Online Interactive Learning from Experts


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