Changing the Status of a Transfer

Question:
I have a Service Transfer that has multiple lines, some are shipped and some are not. I am removing some open transfer lines that were duplicates. All that is remaining on the transfer are shipped lines. The status of the Service transfer remains partially shipped. How do I get it to update the status to complete and have it move to history?

Answer:
The first step is the update this record in the SVC00700 to a 6. After you have updated the record to a status of 6, you can run two stored procedures to move the record to the history table. Here are the two scripts:

UPDATE SVC00700 SET STATUS = 6 WHERE ORDDOCID = 'TransferNumber'

exec SVC_Transfer_TransferToHistory 'TransferNumber'



This article was TechKnowledge Document ID: 21738

DISCLAIMER 

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE(THE “MATERIALS”) FOR ANY PURPOSE. 

THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.