D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Data entity - ship date?

  • 1.  Data entity - ship date?

    TOP CONTRIBUTOR
    Posted 13 days ago
    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
    ------------------------------


  • 2.  RE: Data entity - ship date?

    TOP CONTRIBUTOR
    Posted 13 days ago
    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
    ------------------------------



  • 3.  RE: Data entity - ship date?

    D365UG/AXUG ALL STAR
    Posted 13 days ago
    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
    ------------------------------



  • 4.  RE: Data entity - ship date?

    TOP CONTRIBUTOR
    Posted 11 days ago
    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
    ------------------------------



  • 5.  RE: Data entity - ship date?

    Posted 8 days ago
    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
    ------------------------------



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