Welcome, Guest. Please Login.
05/14/25 at 22:47:26
News:
Home Help Search Login


Pages: 1
Send Topic Print
Salespersons global edit (Read 414 times)
EMI Ann
Full Member
***


Non calor sed umor
est qui nobis
incommodat.

Posts: 123
Gender: female
Salespersons global edit
08/12/14 at 12:55:05
 
We have just split a large sales territory into two parts, and need to change half the customers in the old zone to reflect this change. Is there a global edit that will allow us to do this by zip code (the way we happen to make the territory determination) or do we have to do a thousand customers one at a time? Thanks for your help!
Back to top
 
 

EMI FILTER COMPANY
Clearwater, Florida
EVO-Erp 2015.1, Win 8.1 Pro, Win 2008 network
  IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: Salespersons global edit
Reply #1 - 08/13/14 at 15:25:58
 
There are + 44,000 zip codes in the US. They are arrange from east to west, and they are not sequential due to population grow.
Wouldn't it be easier to assign territories by State?
 
"UPDATE BKARCUST SET BKAR_TERRITORY = 'Number Uno' WHERE BKAR_STATE = 'FL';"
Where 'FL' is Florida and 'Number Uno' its territory.
 
If that does not work for you guys, what about this?
 
The first three zip digits are the code for the main sorting center, which distributes mail to the post offices (which are identified by the last two digits).
 
"UPDATE BKARCUST SET BKAR_TERRITORY = 'Number Uno'  WHERE LEFT(BKAR_ZIP,3) = '123';"
Where '123' is the sorting center and 'Number Uno' its territory.
 
Have fun   Wink
 
Kelloggs
 
PD: you can use Evo's SQL Editor  
System Manager TAS-R
T7SQL.RWN
 
 
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Pages: 1
Send Topic Print