MxLoader

 View Only
  • 1.  Cannot pull Reorder Point or Safety Stock field info, even though included in MXSheet Wizard.

    Posted 07-19-2024 14:31

    Good afternoon More Maximo community,

    I tried using the MxSheet Wizard and it has the SSTOCK field included for MXINVENTORY, but when I try to pull the info for MINLEVL and SSTOCK they are blank.

    It is under the Reorder Details.  

    Is there something else I need to do to be able to pull/edit these fields?

    Thank you in advance,



    ------------------------------
    Danny Richardson
    Maximo Administrator Manager
    Technimark LLC
    ------------------------------


  • 2.  RE: Cannot pull Reorder Point or Safety Stock field info, even though included in MXSheet Wizard.

    Posted 07-19-2024 15:10

    Hi @Danny Richardson!

    Have you checked the storeroom? Remember that inventory is the combination of ITEMNUM + STOREOOM. For example, if you look at the Query that I have executed, it also happens that it does not bring values, since nothing has been loaded for that store. But in another storeroom yes.

    Regards!



    ------------------------------
    Martin Fabra
    ARSAT S.A. - Actively seeking employment
    ------------------------------



  • 3.  RE: Cannot pull Reorder Point or Safety Stock field info, even though included in MXSheet Wizard.

    Posted 07-19-2024 17:01

    @Martin Fabra Thank you for responding.  

    I have checked, but unfortunately, that is not the issue.

    It has a value in Maximo, but MxLoader will not pull the data for those fields.

    Is there a relationship or something similar that needs to be set up?

    Thank you



    ------------------------------
    Danny Richardson
    Maximo Administrator Manager
    Technimark LLC
    ------------------------------



  • 4.  RE: Cannot pull Reorder Point or Safety Stock field info, even though included in MXSheet Wizard.

    Posted 07-21-2024 12:31

    Danny, Check that the "Exclude" check is not applied.

    MXINVENTORY is a OS managed by MaxInvProcess (class). I would try creating a new OS including only the INVENTORY table to see if the same issue appears. Because if in my Maximo don't append the same, in yours there must be some configuration that filters that output. If you create a new structure and no filter appears and it shows you MINLEVEL and SSTOCK, it is because it exists and at least you will have some basis to know where to look.

    Regards!



    ------------------------------
    Martin Fabra
    ARSAT S.A. - Actively seeking employment
    ------------------------------



  • 5.  RE: Cannot pull Reorder Point or Safety Stock field info, even though included in MXSheet Wizard.

    Posted 07-22-2024 12:47

    @Martin Fabra thank you so much.  That was the issue, the exclude box was checked.  It also required me to add the SITEID to be able to change the value.

    Thank you again.



    ------------------------------
    Danny Richardson
    Maximo Administrator Manager
    Technimark LLC
    ------------------------------