Topic Options
#39810 - 01/10/14 08:42 AM Salesperson Code Change in AR
Clint Offline
Adagio Fan

Registered: 07/15/13
Posts: 38
Loc: Seattle, Washington
Hi All,

I was recently given the task of changing the Salesperson codes for all our customers. I added the new Salesperson Codes in AR (via edit>salespersons). I exported the data in AR, made the changes and imported it back in. Everything looked like it worked fine. When you go in and look at the customers in AR or OE the new salesperson code is what you get. The problem is that when an order is entered it is booked to the old salesperson code. So my question is did I miss something when making these changes. How do I get the orders to reflect the new salesperson code without making the change in every order.

We are on AR version 9.1A and OE 8.1F

Thanks,

Clint

Top
#39811 - 01/10/14 08:45 AM Re: Salesperson Code Change in AR [Re: Clint]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11520
Loc: Vancouver, BC Canada
Hi Clint,

Do you use Ship-to Codes? Salesperson codes can be entered there and override what is on the customer record.
If you just want to use values from the customer on orders, leave the fields on the ship-to address record blank.


Edited by Softrak Support (01/10/14 08:46 AM)
Edit Reason: more info
_________________________
Regards,
Softrak Tech Support

Top
#39813 - 01/10/14 09:23 AM Re: Salesperson Code Change in AR [Re: Softrak Support]
Clint Offline
Adagio Fan

Registered: 07/15/13
Posts: 38
Loc: Seattle, Washington
We do use ship to codes. I have looked at them in order entry and they are in fact the old salesperson codes. Do you know where I can edit these codes. I have exported the OE and AR data dictionary but cannot locate the table that corresponds with the ship to information. I have gridview RW so its just a matter of locating the data

Thanks,

Top
#39814 - 01/10/14 09:35 AM Re: Salesperson Code Change in AR [Re: Clint]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11520
Loc: Vancouver, BC Canada
Hi Clint,

Ship-to address codes can be exported and re-imported in AR. This is the 'safer' route to resetting salesperson codes.
The table name would be Contacts, as both ship-tos and contacts are stored in the same file. To do this kind of inquiry, you can use the DataDictionaryExporter.exe utility in the \softrak\system folder to create a table and field list as an Excel workbook.
_________________________
Regards,
Softrak Tech Support

Top
#39815 - 01/10/14 09:48 AM Re: Salesperson Code Change in AR [Re: Softrak Support]
Clint Offline
Adagio Fan

Registered: 07/15/13
Posts: 38
Loc: Seattle, Washington
Great! Thanks for the help. I will be going the import route!

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 81 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14449 Topics
70594 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30