Automate

 View Only
  • 1.  How to manage the case of optional field

    Posted 11-24-2021 10:39

    Hello,

    I'm new user of Winshuttle.
    I have to create a script for Quotation creation (VA21).
    When we create a quotation on SAP, the field INCOTERM is pre-filled from customer master data (standard way of working of SAP).

    On my script, I have put the field 'INCOTERM' in order to fill this data from the xls sheet => the purpose is to manage the case when the data to be used for the quotation has to be different than the data coming from customer master data.

    My issue is that, when I put blank value on the xls sheeet, the value coming from customer master data is updated by this blank, and I lose the data coming from customer.
    My expectation is be to be able to use the value from xls sheet, only if it is not blank.

    Do you know how I can manage it?

    Regards



    ------------------------------
    Olivier Ouvrie | IPA Sales SD
    ROQUETTE-FRERES | 0761826331
    ------------------------------



  • 2.  RE: How to manage the case of optional field

    Posted 11-24-2021 11:02
    Olivier, I would try using the Skip Indicator in stead of using blanks in you XLSX file.
    hope that helps, Jan

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



  • 3.  RE: How to manage the case of optional field

    Posted 11-24-2021 11:20

    OK, thank you Jan

    It is working fine :)

    Thanks again, I will be able to goahead



    ------------------------------
    Olivier Ouvrie | IPA Sales SD
    ROQUETTE-FRERES | 0761826331
    ------------------------------



  • 4.  RE: How to manage the case of optional field

    Employee
    Posted 11-29-2021 09:11
    Hi Olivier
    Another way is to use an IF statement - IF field is not blank, upload, otherwise do nothing.
    It will end up looking like this

    It will only upload a delivery date (in your case incoterms) if not blank.

    HTH,
    Sigrid

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



  • 5.  RE: How to manage the case of optional field

    Posted 11-29-2021 10:56

    Hi Sigrid,

    Thank you for your response.
    I understand better how the condition are managed on Winshuttle, it will help me, for other topics I have to manage :)

    Thank you :)



    ------------------------------
    Olivier Ouvrie | IPA Sales SD
    ROQUETTE-FRERES | 0761826331
    ------------------------------