Automate

 View Only

  • 1.  Populating multiple bank accounts to one vendor master record OR multiple VAT id's to one customer record

    Posted 08-31-2021 04:32

    Hi,

     

    Can somebody share the knowledge with me how to populate multiple bank accounts to one vendor record without overwriting them ?

     

    OR

     

    Adding multiple VAT id's (field name: KNA1-STCEG) to one customer master record

     

    Thanks

     

    Andy

     



  • 2.  RE: Populating multiple bank accounts to one vendor master record OR multiple VAT id's to one customer record

    Posted 08-31-2021 08:39
    Hi Andy -

    Do you happen to know what version of the Winshuttle Function Module (WFM) that may be installed on your SAP system(s)?  There is actually a custom FM that Winshuttle created that is contained within the WFM that allows you to update vendor payment info. Provided you have a more recent WFM installed, you could use a Direct-based script to use that FM to do your updates. 

    https://support.winshuttle.com/hc/en-us/articles/360045521991-RFM-WINSHTLQ-TRN-VENDOR-BANK-with-two-options-by-bank-creation-for-XK02  <- there's an example .Txr file with this KB article.
    https://docs.winshuttle.com/winshuttle-function-module-en-online-help/FM-vendor-payment-transactions-20-2.pdf
    http://winshuttle-help.s3.amazonaws.com/support-info/vendor-payment%20transactions.htm

    Thank you

    ------------------------------
    Jennifer Hwang | SE
    Winshuttle North America
    ------------------------------

    Original Message


  • 3.  RE: Populating multiple bank accounts to one vendor master record OR multiple VAT id's to one customer record

    Posted 08-31-2021 09:27

    Hi Jennifer,

     

    Thanks – the issue is that whenever e.g. I want to add (lets say) 3 new bank accounts to an existing vendor record (which has already 1 bank account) by using winshuttle – at the end of the exercise only 1 of the newly to be added bank accounts is there (the first 2 are being overwritten)

     

    How can I tell winshuttle to create NEW (bank account) records instead of overwriting them ?

     

    Andy

     

    Andy Njoo
    Master data manager, General Master Data
    Business Transformation & IT
    Mobile: +31 6 5524 7630

    andy.njoo@outokumpu.com

      
        


    Outokumpu PSC Benelux B.V.

    Broekstraat 12

    7122 LC Aalten
    Netherlands

     

    Always on the move to help YOU

     




    Original Message


  • 4.  RE: Populating multiple bank accounts to one vendor master record OR multiple VAT id's to one customer record

    Posted 08-31-2021 09:37
      |   view attached
    Hi Andy -

    I know exactly the scenario you are describing, which is why this custom FM was created. It has functions for add, change, as well as delete. You can use the Add function in your case. It will not overwrite anything. Add means it will add new entries, whether you have 0 existing banks, 5, or 50. Were you able to take a look at the links I sent?

    Feel free to try the attached. 

    Thank you

    ------------------------------
    Jennifer Hwang | SE
    Winshuttle North America
    ------------------------------

    Attachment(s)

    Txr
    WINSHTLQ_TRN_VENDOR_BANK_ADD.Txr   112 KB 1 version
    Original Message