We're moving our facility and need to update the "Ship to" address on all our purchase orders with our new location. How and where do you go to update the purchase order ship to address? Please advise. We'd like the "Ship to" address on our PO's to be defaulted to one location.
*This post is locked for comments
I found the easiest way to do this is to change the location card, go to locations - setup and change the address on the card.
I guess it depends how you have your system set up
If you go to Tools->Setup->Company->Company>Address you can set up a new Company Address ID, thereby leaving the Company Address alone. On your POs you can now specify this new Ship To Address ID.
Hi Richard.. thank you for your reply. We only have one "ship to" location, and only one site ID. All our PO's need to default to the same location regardless of the vendor ID.
If we went through the path you stated above, will it only change the PO "ship to" address? The Ship to address is different than our company address so I wasn't sure if that makes a difference, and if we followed your path, it would change our default company address. Please advise.
Just to add a little note. If you go to Tools->Setup->Company->Company and click the Address button, this will write the new address to the SY00600 table. Now you have two choices. If you only have a few POs you can pull up each PO and on the header change the ship to address ID. You will then get a prompt about rolling down the address change. Select Yes to this option. If you have many POs you can then create an update script based on the SY00600 table and Redbeard's suggestion.
support2.microsoft.com/.../887113
Each line of any open purchase order will contain the information you're looking for and will have to be edited at the line item level. You can get at this information using SmartLists or SQL fairly easily. I have included a SQL query to get you started.
select
SHIPMTHD,
LOCNCODE,
ADRSCODE,
CMPNYNAM,
CONTACT,
ADDRESS1,
ADDRESS2,
ADDRESS3,
CITY,
STATE,
ZIPCODE
from POP10110
#1
André Arnaud de Cal...
292,468
Super User 2025 Season 1
#2
Martin Dráb
231,287
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
