How do you change the "Ship to" address on a Purchase Order?

(0) Share

Report

Posted on by Community Member

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 have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Redbeard 12,931 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No