Change values in one column of Sales Line

(0) Share

Report

Posted on by Community Member

Hi,

There is a column in Sales Line, called Location Code. In our system, there are thousands of Sales Lines with different location code values.

Now I want to change the Location Code Value from A to B. Due to the large amount of data, I can't use Configuration Package and I am not willing to use SQL statement to update value. Is there other way to make the change ? And how ?

Thanks in advance!

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Alexander Ermakov 28,096 on at

Like (0)

Report

This can be done in many ways. Personally I would do this by an SQL statement. One can do this manually by filtering by A value and substituting by B value by pressing F8 and DownArrow two thousand times (which in some 20 minutes should bring you to the result :-) ). You can use RapidStart for this - export the Sales Lines table into excel, clean the table, then substitute (CTRL-H) in Excel Value A for Value B and upload it back. Simple copypaste back and forth to Excel should also work, but it depends how many records you have.

Was this reply helpful? Yes No