Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Change values in one c...

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

All responses (1)

Answers (1)

Verified answer

Alexander Ermakov 28,094 on at

Like (0)

Report

RE: Change values in one column of Sales Line

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.