Automate

 View Only

  • 1.  Formula result on next row not picked up as run too fast - tco.MM01

    Posted 05-19-2022 03:35
    Hi community, I'm hoping for some help on an issue I am facing. 
    I have created a script which is to create a new material (MM01) and then it has subsequent rows for the same material with plant data as it needs extending also to additonal plants. I have created a formula in a separate column to populate the material number that is returned in the log column (of the row before) for the extension rows but it is only successful for the first extension row and then it fails with the message 'No external number assignment possible...' and this is because the column which has the formula and displays the newly created material number from the log column of the row before isn't read as it must be running before it is populated so misses the new material number.
    I have tried using the 'Upload delay ms' but this does not work. 
    Please can you let me know if I can get around this without having to chain a 2nd extenstion script, thank you.

    ------------------------------
    Kelly Nicholson
    Yara
    ------------------------------


  • 2.  RE: Formula result on next row not picked up as run too fast - tco.MM01

    Employee
    Posted 05-20-2022 19:21
    Hi Kelly

    For MM01, you can actually download the material number.  It gets populated early on as you navigate the tabs.

    • Go to Expert view
    • go to the View tab on top
    • check the Disabled fields


    back on the MAP tab, you can click find


    search for MATNR - the technical field name of the material number


    I usually go to one of the last views, so near the bottom of the script.  Enable the field and choose download


    then you can go back to the Basic tab and map it to download it.  You won't have to use a formula.

    Hope that helps,
    Sigrid



    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message


  • 3.  RE: Formula result on next row not picked up as run too fast - tco.MM01

    Posted 05-23-2022 03:30

    Hi Sigrid,

     

    Thanks for your response much appreciated. Please can I ask how I get solve the issue of the script not reading the new material number which is being populated in the next rows? This is the issue I am facing as we create the new material on row 3 for example, then that new number is populated on row 4 but the script seems to sun too quick and doesn't pick up the new material number.

     

    Kind regards,

    Kelly

     




    Original Message


  • 4.  RE: Formula result on next row not picked up as run too fast - tco.MM01

    Employee
    Posted 05-23-2022 16:46
    Hi Kelly,
    That may happen when there is a mismatch on the row number of our data and the row numbers in the formula.  Can you please check that?
    For example, my data starts on row 4,  I should use a =mid(a4,.......) and make sure the output goes to B4 or whatever column you specify.
    Hope that helps,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message


  • 5.  RE: Formula result on next row not picked up as run too fast - tco.MM01

    Posted 05-24-2022 00:28

    Hi Sigrid, the formula is ok and for the first extension it works (first row after row which creates the new material number) but then subsequent rows fail as it seems to be running too fast and before the number is populated.

     

    Kind regards,

    Kelly

     




    Original Message


  • 6.  RE: Formula result on next row not picked up as run too fast - tco.MM01

    Employee
    Posted 05-24-2022 17:52
    Hi again Kelly,

    I'm not 100% sure.  I gave you a workaround, which I know works without a formula.  I also gave you one idea on what could be wrong.

    If you think it is a speed issue, then you can try to use this setting on the RUN tab in the Developers Settings

    If that is not sufficient to answer you question, I hope someone else chimes in - or - you can open a support ticket.

    Best Regards,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message


  • 7.  RE: Formula result on next row not picked up as run too fast - tco.MM01

    Posted 05-25-2022 01:15
    Thanks Sigrid, if anyone else can help if they've experienced this issue, otherwise I'll open a support ticket. Thank you.

    ------------------------------
    Kelly Nicholson
    Yara|
    ------------------------------

    Original Message


  • 8.  RE: Formula result on next row not picked up as run too fast - tco.MM01

    Posted 05-25-2022 09:02
    I avoided that issue by creating a separate script to get the new material numbers.
    So when making new materials, I firstly run a very small script just to get new SAP-codes, and then afterwards I run a large set of chained scripts to populate the different parameters in all plants for these material numbers.

    hope that can help ?
    best, Jan

    ------------------------------
    jan ketele | Sr engineer release mgt
    Xeikon Manufacturing NV | +3234431875
    ------------------------------

    Original Message


  • 9.  RE: Formula result on next row not picked up as run too fast - tco.MM01

    Posted 05-26-2022 05:25
    Thanks Jan for sharing, I also created another script to solve this. Ideally I was wanting to keep within the same one and not have to create a 2nd script and then chain it. Thanks again.

    ------------------------------
    Kelly Nicholson
    Yara
    ------------------------------

    Original Message