How to change Part Numbers in a Sales Order using SQL

(0) Share

Report

Posted on by Community Member

We have a few hundred sales orders, that have not been posted, with a stock Part Number that we need to change. This new part number is a non-stock item, but if it makes it easier we can always add it to stock. As of now, the clearest way to do this is create a macro that changes the part number for a single sales order. However, that still requires someone going in and changing sales orders one by one.

If I wanted to run an update query in the database to change the part numbers, what GP tables would I need to alter in order to make sure the database does not get corrupted? Is there a stored procedure that I would be able to run to help me with this task?

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Cheryl Waswick Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi Metsales,

I understand you are trying to change Item Number on orders. The only supported method would be delete the item off the order and add the new one. It is too risky if costs change to get it all changed in the right places (allocations, inventory, etc).

If you are only trying to change the Item Number name, then you can install Professional Services Tools library (PSTL) and in a TEST company, use the 'Item Number Modifier' tool to see if that works for you.

Thanks,
Cheryl
Microsoft Online Community

Was this reply helpful? Yes No