| Change ship to organization for approved PO [message #305140] |
Sun, 09 March 2008 03:07  |
Abeer30
Messages: 110
Registered: March 2007
|
Senior Member |
|
|
hello,
I have an approved PO that had been shipped to master organization (of items) by mistake. As we cannot receive the PO in the master organization, can i change the "ship to org" for an approved Po and how?
This issue is urgent please advise.....
|
|
|
|
| Re: Change ship to organization for approved PO [message #305157 is a reply to message #305140] |
Sun, 09 March 2008 10:02  |
jyoti.bubun
Messages: 8
Registered: March 2008
Location: Chennai
|
Junior Member |
|
|
Hey Abber,
This can not be done through the form as the PO is already been approved, but can be done through the data base update. Do you have access to toad?? update the correct ship to org code in po shipment & ship to org is in po distribution so as resolve the issue? Please let me know if you are still facing any issue.
Regards,
Jyoti
|
|
|
|
|
|
| Re: Change ship to organization for approved PO [message #305555 is a reply to message #305515] |
Tue, 11 March 2008 04:49 |
|
|
Hi,
po_headers_all -- segment1 [ po number ] @ Header Informations
po_lines_all -- po_header_id @ Line Informations
po_distributions_all -- po_header_id @ Distributions Info
I hope now u can move further and let me know whether your problem is solved or not.
Cheers
Shakti..
|
|
|
|
| Re: Change ship to organization for approved PO [message #306122 is a reply to message #305140] |
Wed, 12 March 2008 22:50 |
jyoti.bubun
Messages: 8
Registered: March 2008
Location: Chennai
|
Junior Member |
|
|
Hi Abeer,
Please check in the po_line_locations_all & po_distributions_all table which are the columns which is related to the ship to organization. e.g. ship_to_organization_id in po_line_locations_all & destination_organization_id in po_distributions_all table. You need to update these 2 columns in these 2 base tables so as to update the correct ship to location code in the PO shipment for an approve PO. Please let me know if you are still having any issue.
Regards,
Jyoti
|
|
|
|
|
|
| Re: Change ship to organization for approved PO [message #306291 is a reply to message #305140] |
Thu, 13 March 2008 10:09 |
jyoti.bubun
Messages: 8
Registered: March 2008
Location: Chennai
|
Junior Member |
|
|
Hi Abeer,
The ship to organization in PO shipment can not be changed using the form hence this is the solution through which you can easily change the ship to organization. If you don't want any data inconsistency between the base table & the archive tables then you can update the specified columns in the archives tables also along with the base tables
Regards,
Jyoti
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
