D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

BYOD Data Entity for Inventory By Location

  • 1.  BYOD Data Entity for Inventory By Location

    Posted Sep 17, 2020 12:40 AM
    Hello,

    Does anyone know what data entity(s) I can export via BYOD that has inventory by location?  I am currently exporting the Inventory on-hand by site entity, but I would like to get inventory by location if possible.

    Thanks in advance.
    Tim

    ------------------------------
    Tim Stutzman
    Pure Archery Group
    Eugene OR
    ------------------------------
    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 2.  RE: BYOD Data Entity for Inventory By Location

    SILVER CONTRIBUTOR
    Posted Sep 18, 2020 02:04 AM
    I seems Microsoft only deems it necessary to export by Site or Warehouse. No sign of on-hand by location that I can find.

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

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 3.  RE: BYOD Data Entity for Inventory By Location

    Posted Sep 18, 2020 09:26 AM
    Check the Inventory On-hand Report Storage, added in Platform Update 35, I think. You define which data to include and when the summary process should run, ending up with a timestamped snapshot. The available fields include Location. The results are available via an entity, so you can sync to the BYOD.

    https://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave1/dynamics365-supply-chain-management/inventory-on-hand-report-storage#:~:text=Users%20can%20browse%20any%20stored,format%20supported%20by%20data%20management.

    ------------------------------
    Brent Hawthorne
    Sr Manager of Application Development
    Daisy Brand
    Dallas TX
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 4.  RE: BYOD Data Entity for Inventory By Location

    SILVER CONTRIBUTOR
    Posted Sep 18, 2020 09:40 AM
    Brent, that looks very useful. Needs enabling in Feature Management even if you are on pu35.

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

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 5.  RE: BYOD Data Entity for Inventory By Location

    Posted Sep 18, 2020 10:27 AM
    Hi,

    We are on pu365.  Could you tell me how to enable?  We are currently implementing so I am still learning.

    Thanks,
    Tim

    ------------------------------
    Tim Stutzman
    Pure Archery Group
    Eugene OR
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 6.  RE: BYOD Data Entity for Inventory By Location

    SILVER CONTRIBUTOR
    Posted Sep 18, 2020 10:39 AM
    You need to find the "Feature Management" workspace and enable from there. If you are implementing you should seriously consider turning on features relevant to you region as it is a lot harder once you are live to go through the necessary testing. However, I can appreciate that during an implementation you may have your hands full already. Good luck.
    Inventory on-hand report storage


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

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 7.  RE: BYOD Data Entity for Inventory By Location

    Posted Sep 18, 2020 11:19 AM
    Thank you for your help!  I enabled the feature and tried to export via data management to both excel and BYOD and it exported 0 lines.  Is there something else that I have to do?

    Thanks,
    Tim

    ------------------------------
    Tim Stutzman
    Pure Archery Group
    Eugene OR
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 8.  RE: BYOD Data Entity for Inventory By Location

    Posted Sep 18, 2020 12:23 PM
    You're actually scheduling a batch job when you set this up. Generally, you'll want it to be recurring. Once the job runs, it will have rows available. One nice thing with this is you can sculpt different data sets of interest, and set them up to run. Each will be it's own set of rows (you'll see a report set name as one column).

    If you are just getting started, you should take a look at the release notes for each PU as it comes along and consider the optional features, and whether they are of interest. I try to do a review and summarize items of interest for our business owner to review. There is a read-only permission for the feature management workspace, and we've given that to our business owner so they can see the list as well.

    ------------------------------
    Brent Hawthorne
    Sr Manager of Application Development
    Daisy Brand
    Dallas TX
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 9.  RE: BYOD Data Entity for Inventory By Location

    Posted 25 days ago
    Hi Brent,

    I got the report to run in a recurring batch and now able to export the data entity populated.  One last thing it seems that when the report runs it appends to the data entity???  So after the report runs more than once, I get duplicate data in the data entity.  I went and manually deleted the output reports and that removed the duplication, but is there a way to automatically just keep the latest snapshot only?

    Thanks,
    Tim

    ------------------------------
    Tim Stutzman
    Pure Archery Group
    Eugene OR
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


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