Automate

 View Only
Expand all | Collapse all

International Ship-To Address Change - BAPI_SALESORDER_CREATEFROMDAT2

  • 1.  International Ship-To Address Change - BAPI_SALESORDER_CREATEFROMDAT2

    Posted 10-07-2024 13:49

    Hi Everyone,

    I'm looking to update the international ship-to party address at time of order creation, rather than after the fact. I am using BAPI_SALESORDER_CREATEFROMDAT2 so we can avoid all the pop-ups that could potentially happen through a recording. 

    I am stuck when it comes to updating the international ship-to party address. I have uploaded a copy of the existing order creation script & template in case it helps. Current process, we have 2 scripts chained together to accomplish this. HOWEVER, updating the address after the order has been saved creates inaccuracies in the confirmation email that a customer receives. 

    Any insights are greatly appreciated.



    ------------------------------
    Vanessa Kutasi
    Foundation Admin./Application Analyst II
    Idexx Operations, Inc.
    USA
    ------------------------------


  • 2.  RE: International Ship-To Address Change - BAPI_SALESORDER_CREATEFROMDAT2

    Employee
    Posted 10-09-2024 11:12

    Hi Vanessa

    Am trying to understand your request, so I have a lot of questions :)

    Can you please describe what isn't working when you try to do this in one step? So that means the BAPI can update it but not in one go?

    Also, are you trying to update the Ship To at the header address?

    When you state it's the international address that's giving you trouble, does that mean you can update the address if it's in the same country but not if it isn't?

    Does the Customer/BP Customer/Ship to have an international address setup for these locations?  I have used a BAPI to set/update these addresses, but not yet on sales orders

    Thanks for any additional info you can provide :)

    Sigrid



    ------------------------------
    Sigrid Kok
    Precisely Software Inc.
    ------------------------------



  • 3.  RE: International Ship-To Address Change - BAPI_SALESORDER_CREATEFROMDAT2

    Posted 10-09-2024 11:52

    Hi Sigrid

    Can you please describe what isn't working when you try to do this in one step? So that means the BAPI can update it but not in one go?

    VK - The BAPI is unable to create the order and update the international ship-to address in one go. Or at least I have not yet figured out how to to it.

    Also, are you trying to update the Ship To at the header address?

    VK - Correct, ship-to address at the header level, but ONLY the international version of the address, not the standard address. 

    When you state it's the international address that's giving you trouble, does that mean you can update the address if it's in the same country but not if it isn't?

    VK - I have not found a way, at all, to update the international address through BAPI_SALESORDER_CREATEFROMDAT2, regardless of if the country is the same or different. 

    Does the Customer/BP Customer/Ship to have an international address setup for these locations?  I have used a BAPI to set/update these addresses, but not yet on sales orders

    VK - Yes, the Customer/BP Customer Ship-To already has an international address in place. 

    I hope this helps clarify. 

    Thank you!



    ------------------------------
    Vanessa Kutasi
    Foundation Admin./Application Analyst II
    Idexx Operations, Inc.
    USA
    ------------------------------



  • 4.  RE: International Ship-To Address Change - BAPI_SALESORDER_CREATEFROMDAT2

    Employee
    Posted 10-09-2024 15:29

    Hi Vanessa

    So I had a Direct script to create a sales order and changed up the partner section.  I used an IF to only overwrite the address if the name field is not blank, and I used item "0000" which in this bapi means header.  I overwrite the address for the Ship to.

    Excel

    Script section where I added partners - prior I had them hard coded - with the loop, IF and fields

    SAP loaded this:

    Note my BAPI is pointing to ECC, but I think this should work in S4, as well.  I also have a sales contract I refer to in my example, but you can ignore that.

    Hope this helps!

    Sigrid



    ------------------------------
    Sigrid Kok
    Precisely Software Inc.
    ------------------------------



  • 5.  RE: International Ship-To Address Change - BAPI_SALESORDER_CREATEFROMDAT2

    Posted 10-10-2024 16:19

    Hi Sigrid

    I added the outlined details into my script, and it works great to update the standard ship-to address, but did not update the international version.



    ------------------------------
    Vanessa Kutasi
    Foundation Admin./Application Analyst II
    Idexx Operations, Inc.
    USA
    ------------------------------



  • 6.  RE: International Ship-To Address Change - BAPI_SALESORDER_CREATEFROMDAT2

    Employee
    Posted 10-10-2024 16:29
    Edited by Sigrid Kok 10-10-2024 16:32

    Hi Vanessa

    I guess I'm a bit confused about that.  I get on a BP/Customer record there are standard and international addresses.

    On a sales order, what is the purpose of the international address?  Aren't you just overriding the default address for the ship to?  Or is there more to it? :)  

    For example if I drill into the Ship to partner and choose international address and tweak it, it's what is is shown - just like in my prior example

    Thanks, in advance, for enlightening me.  I can look into it a bit more tomorrow.

    Best Regards,

    Sigrid



    ------------------------------
    Sigrid Kok
    Precisely Software Inc.
    ------------------------------



  • 7.  RE: International Ship-To Address Change - BAPI_SALESORDER_CREATEFROMDAT2

    Posted 10-10-2024 16:52

    Hi Sigrid

    For our accounts the standard address is in EN for every customer. The international address is in the local language. I've just posed your same question back to the requestor. I'm not quite sure why we can't just override the standard address on the order as it's a 1 time change. I'll let you know what their response is. My guess is it either has something to do with the order confirmation the customer receives, or invoicing. Stay tuned!



    ------------------------------
    Vanessa Kutasi
    Foundation Admin./Application Analyst II
    Idexx Operations, Inc.
    USA
    ------------------------------



  • 8.  RE: International Ship-To Address Change - BAPI_SALESORDER_CREATEFROMDAT2

    Employee
    Posted 10-10-2024 18:54

    Got it, Vanessa.

    I'm not sure the SO BAPI distinguishes them.  But I know the BP one does - and I have a Direct script for that. :) (created in S4 1909)

    Please let me know what they say.  

    Best Regards,

    Sigrid



    ------------------------------
    Sigrid Kok
    Precisely Software Inc.
    ------------------------------



  • 9.  RE: International Ship-To Address Change - BAPI_SALESORDER_CREATEFROMDAT2

    Posted 11-07-2024 12:12

    Hey Sigrid

    Just as a follow up as I had mentioned I would. The international address needs to be updated at the time of order creation as that is the address that is added to the invoice as well as the order confirmation email that the customer receives. So, in the process I have already created for the end user, updating the address after the order is saved doesn't work for them as the order confirmation email has already been sent. IT is not wanting to add any sort of delays in the email confirmation side of things as it's a global process on the SAP side and so the impact would be quite large. 

    So, in the end, I'll have to create a new script via a Transaction recording since the BAPI's, as currently designed, can't handle it (confirmed by my IT team).

    Thank you for your help on this one!

    Have a great day!



    ------------------------------
    Vanessa Kutasi
    Foundation Admin./Application Analyst II
    Idexx Operations, Inc.
    USA
    ------------------------------



  • 10.  RE: International Ship-To Address Change - BAPI_SALESORDER_CREATEFROMDAT2

    Employee
    Posted 11-07-2024 13:14

    Hi Vanessa

    Thanks for getting back to me/us. Sorry to hear it won't work.

    One thought - what if you put a block on the SO until you updated it?  IDK enough about the output conditions on when it sends the output, though.

    Best Regards,

    Sigrid



    ------------------------------
    Sigrid Kok
    Precisely Software Inc.
    ------------------------------



  • 11.  RE: International Ship-To Address Change - BAPI_SALESORDER_CREATEFROMDAT2

    Posted 11-07-2024 13:23

    That's a good thought! They do have delivery block as an input on the template. I'll check with IT to see what the email timing looks like if there is a delivery block. Stay tuned!



    ------------------------------
    Vanessa Kutasi
    Foundation Admin./Application Analyst II
    Idexx Operations, Inc.
    USA
    ------------------------------



  • 12.  RE: International Ship-To Address Change - BAPI_SALESORDER_CREATEFROMDAT2

    Posted 11-11-2024 10:24

    Ok so I have confirmed that as soon as the order is saved (with or without any order blocks), a confirmation email goes out. Sadly, in this situation, my only option is to recreate the script using Transaction. I will also be requesting IT update the BAPI if possible. Thanks for your feedback/thoughts on this on Sigrid!



    ------------------------------
    Vanessa Kutasi
    Foundation Admin./Application Analyst II
    Idexx Operations, Inc.
    USA
    ------------------------------