Changing salesperson code?

yuppicide · 2008-04-07

Is there a way in Navision 3.10 to change all customers with salesperson code SH to say HOUSE instead?

I'd rather not do it one by one if I don't have to. I have three diffferent salespersons I want to take all them and turn them into HOUSE.

AdamRoue · 2008-04-07

You can rename SH to HOUSE, this changes the history as well though. To keep the history you would need a modification.

yuppicide · 2008-04-07

I figured out a quick enough way for me. Customer Quick Entry. I just did a table filter and then pasted HOUSE in them all.

Savatage · 2008-04-07

You can also go to the customer table & use Find & Replace on that column as long as you don't filter on it.

Or

You can create a report based on customer

Onaftergetrecord

"Salesperson Code" := 'HOUSE';
Customer.MODIFY;

NOw filter The report for the salespeople you want to change & run.

Alex_Chow · 2008-04-08

Did you also try Find and Replace?

Changing salesperson code?

Comments

Categories