Discussions
Activity
Best Of...
Sign In
·
Register
Home
›
Navision Attain
Howdy, Stranger!
It looks like you're new here. Sign in or register to get started.
Sign In
Register
Quick Links
Categories
Recent Discussions
Activity
Best Of...
Unanswered
Categories
All Categories
73
General
73
Announcements
66.6K
Microsoft Dynamics NAV
18.7K
NAV Three Tier
38.4K
NAV/Navision Classic Client
3.6K
Navision Attain
2.4K
Navision Financials
115
Navision DOS
854
Navision e-Commerce
1K
NAV Tips & Tricks
772
NAV Dutch speaking only
615
NAV Courses, Exams & Certification
2K
Microsoft Dynamics-Other
1.5K
Dynamics AX
310
Dynamics CRM
109
Dynamics GP
10
Dynamics SL
1.5K
Other
993
SQL General
384
SQL Performance
34
SQL Tips & Tricks
34
Design Patterns (General & Best Practices)
Architectural Patterns
10
Design Patterns
5
Implementation Patterns
53
3rd Party Products, Services & Events
1.7K
General
1.1K
General Chat
1.6K
Website
79
Testing
1.2K
Download section
23
How Tos section
260
Feedback
12
NAV TechDays 2013 Sessions
13
NAV TechDays 2012 Sessions
Changing salesperson code?
yuppicide
Member
Posts:
410
2008-04-07
edited 2008-04-08
in
Navision Attain
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.
0
Comments
AdamRoue
Member
Posts:
1,283
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.
The art of teaching is clarity and the art of learning is to listen
0
yuppicide
Member
Posts:
410
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.
0
Savatage
Member
Posts:
7,142
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.
Harry Ruiz
http://www.BiloBeauty.com
http://www.autismspeaks.org
0
Alex_Chow
Member
Posts:
5,063
2008-04-08
Did you also try Find and Replace?
Confessions of a Dynamics NAV Consultant
= my blog
AP Commerce, Inc.
= where I work
Getting Started with Dynamics NAV 2013 Application Development
= my book
Implementing Microsoft Dynamics NAV - 3rd Edition
= my 2nd book
0
Sign In
or
Register
to comment.
Comments
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.
http://www.BiloBeauty.com
http://www.autismspeaks.org
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book