Automate

Welcome to the Automate community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  VA02 Script - error no line items found- make loop optional?

    Posted 01-24-2019 09:45
    Hi all,

    Is it possible to make a loop optional?  For example for multiple orders we want to change order quantities. For some orders we only have to change 1 line item for other orders multiple. So it would look like this

    Indicator  Order  Item    Quantity
    H                  123      10         5
    D                                20        7
    H                  124      10         9
    H                  125      10         8

    Before it used to work fine when not adding a line item. But now when we do not incert a D (line item) we get the error message "No Line Items Found". 

    Thanks for advising!

    ------------------------------
    Marissa
    ------------------------------


  • 2.  RE: VA02 Script - error no line items found- make loop optional?

    Employee
    Posted 01-25-2019 05:36
    Hello Marissa,

    For such case you can follow two approaches,

    1. Create two similar script ,
         a. 1st script with a condition which IF Indicator Column = H and this script will have no loop
         b. 2nd Script with a condition which will Run if Indicator Column = D and this script will have Loop around Indicator H and D

    here in this case, if any order having single lines will execute 1st script to update lines with H. If any order having multiple lines will execute 1st script for Line with H and 2nd script for Line with D.

    2. One single script with to handle both H and D
         Divide one single script into two sections (two section will have same set of code to update quantity)
         a. section one - Having script to update quantity with a condition which IF Indicator Column = H
         b. section two - Having script to update quantity with a condition which will Run if Indicator Column = D and this script will have Loop around Indicator H and D

    So this case, Section one will Run if any order having single line and both section one and section 2 will Run if any order having both H and D lines.

    Hope this will answer your query.

    Kindly try and share your feedback.

    Thank you,

    Santhosh BK

       
    ------------------------------



  • 3.  RE: VA02 Script - error no line items found- make loop optional?

    Employee
    Posted 02-07-2019 11:32
    Hi Marissa,

    You mentioned that it used to work and now you are getting an error that says "No Line Items Found." 

    This is a known bug in Studio 12, and it's being addressed by our support and engineering team. This should be fixed in our next patch release, but I don't currently have an estimate on a release date.

    Once the release date is determined, I can try to reach out to you to let you know.

    Have a great rest of the day!

    ------------------------------
    James Lofgren | Solutions Engineer
    Winshuttle North America | [City] |
    ------------------------------



  • 4.  RE: VA02 Script - error no line items found- make loop optional?

    Posted 02-08-2019 04:24
    Thanks for your reply. We will use two scripts until there is a fix.

    ------------------------------
    Marissa Boom-van Druten | S&OP Analyst
    Harman Lifestyle | 0031 20 563 0849
    ------------------------------

    Original Message