Welcome, Guest. Please Login.
05/15/25 at 01:22:38
News:
Home Help Search Login


Pages: 1 2 3 
Send Topic Print
New contacts - how do they work? (Read 8252 times)
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: New contacts - how do they work?
Reply #30 - 06/25/15 at 11:42:16
 
James,
 
Thanks for the info and further detail by phone/email. Will try to update for the board what we did and how it's working.
 
Best,
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: New contacts - how do they work?
Reply #31 - 06/25/15 at 13:02:28
 
We clean our tables daily with an script and have our own system to select the proper email.
 
Here is our little system
We select the email by editing the Customer Contact Information
Enter "I" on the Primary Contact Field.
 
On the Print window, once you have selected email
We check mark "Use Contact Prim Code"
and Enter "I"
 
Where "I" stands for  "Invoice", you can have "P" for Packing List, etc etc etc
work like magic.....
 
Here is how we keep our tables clean
DELETE FROM BKCMACCN WHERE ASCII(LTRIM(RTRIM(BKCM_ACCN_CODE))) = 0;"
DELETE FROM BKCMACCN WHERE ASCII(LTRIM(RTRIM(BKCM_ACCN_PRIM))) = 0 AND ASCII(LTRIM(RTRIM(BKCM_ACCN_EMAIL_1))) = 0 AND ASCII(LTRIM(RTRIM(BKCM_ACCN_CON))) = 0;"
DELETE FROM BKCMACCN WHERE ASCII(LTRIM(RTRIM(BKCM_ACCN_PRIM))) = 0 AND ASCII(LTRIM(RTRIM(BKCM_ACCN_EMAIL_1))) = 0;"
DELETE FROM BKCMACCN WHERE BKCM_ACCN_PRIM = 'Y' AND BKCM_ACCN_CON = 'PRIMARY CONTACT' AND  BKCM_ACCN_EMAIL_1 = 'N/A';"
UPDATE BKCMACCN SET  BKCM_ACCN_EMAIL_1 = 'N/A' WHERE BKCM_ACCN_EMAIL_1 = '.F.';"
 
Have fun ....
 
 Cheesy
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: New contacts - how do they work?
Reply #32 - 06/26/15 at 05:12:56
 
Quote from Kelloggs on 06/25/15 at 13:02:28:

Here is our little system
We select the email by editing the Customer Contact Information
Enter "I" on the Primary Contact Field.

On the Print window, once you have selected email
We check mark "Use Contact Prim Code"
and Enter "I"

Where "I" stands for  "Invoice", you can have "P" for Packing List, etc etc etc
work like magic.....

 
Yes, that is the same principle we used to set up our contacts.  
 
However, during more extensive testing we found it wasn't necessary to use the letter codes UNLESS there is a different person for one type of document than another. For instance, if you have a customer that has only one contact and/or one email address for the entire company, you can leave the Primary field as blank or Y, and still put your I or S in the print dialog. If there is no matching primary code it just uses the first email address it finds.
 
The biggest trouble I had in coming up with a strategy is figuring out how to process orders when some people get emailed invoices and some don't. This is primarily because of two factors -  
  • We have a lot of "cash" (mostly credit card) type customers. If a Cash customer doesn't have an email address, we send the invoice with the order - no Packing Slip required.
  • We do processing as orders are done throughout the day, so we can't just release orders and print PSs throughout the day and invoices at the end of the day, or we would get multiple copies of PSs (this may be because of the way we do our order processing, which maybe can be changed, but we've been doing it this way for 15 years and it works great).

So, what I've done is create customer classes that specify first of all whether a customer gets emailed docs or not, and then whether the customer is a Cash account or Net X Day account. To allow any combination to be entered in alphabetical order (to use the Class filter in print docs options) I had to use a two letter code, i.e. MC for Mail/Cash and M/A for Mail/Net X Days.
 
So the process is (BTW, we print Pick Lists for every order as it comes in, when the order is ready to ship - sometimes the same day, sometimes not for weeks - it's turned in to order processing/shipping):
  • Release SOs
  • Print PS for EA to MW. This will print for all customers except Cash customers with no email address.
  • Print ALL Invoices to screen, get invoice amounts for CC orders, mark NOT printed, process CC payments.
  • Print MA-MZ to printer - MA invoices get mailed, MZ invoices are sent with package. Mark printed.
  • Print ALL invoices (will only be ones that have not already been printed) to Email, AutoSend - Code I. Mark printed.

I actually have two codes for those with Net X Day accounts - one for "normal" ones, and one for those that get weekly emailed statements.
 
So, weekly, we email EW (Email, Weekly) AutoSend to Code S.
 
Monthly, we print MA (Mail, Net X Day) to printer, and mail. Then print EA (Email, Net X Day) to email, AutoSend Code S.
 
One other thing to note.
 
We are in the process of doing away with our normal fax line because we are converting to Hosted PBX on VoIP. So we will be using an Fax-2-Email (F2E) service. It's really cool how it works for sending from Evo. You enter an email address to the Contact using their fax number, i.e. 19998887777@faxservice.com and it gets treated in Evo as if they have an email address. Evo sends the email with attachment and the F2E service converts the email header, subject and body as a cover page, and the attachment as content pages.  
 
The receiver has no idea that it came from an email other than the fact that the bottom of the cover page has the name of the fax service on it. Note that if you have no subject or body in the email no cover page is sent, so if you send a lot you may want to set up a user that has a profile without that since the F2E services charge by the page (or - up to X pages). I like MetroFax at $8/month for up to 500 pages.
 
I think we are going to get rid of our postage meter if we can get the Contacts cleaned up and use Evo the way we should be able to. I figure we will be sending 5% or less of our invoices/statements by snail mail because we have an email address or fax number for almost everyone. I figure we should be able to save at least $3000 per year between postage, envelopes, paper and meter rental.
 
Quote from Kelloggs on 06/25/15 at 13:02:28:

Here is how we keep our tables clean
DELETE FROM BKCMACCN WHERE ASCII(LTRIM(RTRIM(BKCM_ACCN_CODE))) = 0;"
DELETE FROM BKCMACCN WHERE ASCII(LTRIM(RTRIM(BKCM_ACCN_PRIM))) = 0 AND ASCII(LTRIM(RTRIM(BKCM_ACCN_EMAIL_1))) = 0 AND ASCII(LTRIM(RTRIM(BKCM_ACCN_CON))) = 0;"
DELETE FROM BKCMACCN WHERE ASCII(LTRIM(RTRIM(BKCM_ACCN_PRIM))) = 0 AND ASCII(LTRIM(RTRIM(BKCM_ACCN_EMAIL_1))) = 0;"
DELETE FROM BKCMACCN WHERE BKCM_ACCN_PRIM = 'Y' AND BKCM_ACCN_CON = 'PRIMARY CONTACT' AND  BKCM_ACCN_EMAIL_1 = 'N/A';"
UPDATE BKCMACCN SET  BKCM_ACCN_EMAIL_1 = 'N/A' WHERE BKCM_ACCN_EMAIL_1 = '.F.';"

Have fun ....

 
Can that be run in Preview mode to see what's going to happen? Because I'm afraid that will delete some things I don't want deleted; for instance, we have quite a lot of legitimate contacts that have no Primary code and no email address - if I'm interpreting the script correctly it would delete those(?) Of course, I would make sure I had a good backup first but I don't like relying on those...
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: New contacts - how do they work?
Reply #33 - 06/26/15 at 06:40:07
 
Yes, you can "preview" the query results
change the DELETE FROM to SELECT * FROM
 
DELETE FROM BKCMACCN WHERE ASCII(LTRIM(RTRIM(BKCM_ACCN_CODE))) = 0;"  
SELECT * FORM BKCMACCN WHERE ASCII(LTRIM(RTRIM(BKCM_ACCN_CODE))) = 0;"
 
 Tongue
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: New contacts - how do they work?
Reply #34 - 06/26/15 at 06:46:21
 
This one UPDATE BKCMACCN SET  BKCM_ACCN_EMAIL_1 = 'N/A' WHERE BKCM_ACCN_EMAIL_1 = '.F.';
 
would be:
 
SELECT * FROM BKCMACCN WHERE BKCM_ACCN_EMAIL_1 = '.F.';
 
As an extra precaution run all the queries on your play company.
 
Enjoy
 
 Grin
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: New contacts - how do they work?
Reply #35 - 07/30/15 at 06:25:00
 
An update
 
Quote from David Waldmann on 06/26/15 at 05:12:56:
However, during more extensive testing we found it wasn't necessary to use the letter codes UNLESS there is a different person for one type of document than another. For instance, if you have a customer that has only one contact and/or one email address for the entire company, you can leave the Primary field as blank or Y, and still put your I or S in the print dialog. If there is no matching primary code it just uses the first email address it finds.

 
I don't know if the program was updated, but when we tried going live with it we found the above is NOT TRUE. If there is no matching Primary code it puts in the Auto email failure address (if you've set one up).
 
In preface, I should say that I had previously spent hours upon hours using Maintain Database to clean up duplicate Contacts (as many as 50 or more in some cases IIRC) and contacts assigned to the wrong company. I suppose the duplicates could probably have been eliminated with some script, and/or exporting and cleaning up in Excel, then reinitializing the table and reimporting, but you'd still have to find the bad links. It was pretty easy to find them among the duplicates, where almost all of them were.
 
So I spent most of a day selecting and exporting contacts (I used CR) and extensive use of Formulas and Subtotaling, Sorting and Filtering with Excel to prepare new files to import*.  
  • First separated those that get only invoices from those that also get statements.  
  • Then I assigned a value of 1 to any contact who had a Primary code that was blank or Y, and 10 to an I or S.  
  • I then Subtotalled by Customer ID.  
  • Any Invoice-Only customer with a 10 or higher already had an I and needed no more attention.  
  • Any Invoice-Only customer with a 0-9 didn't have an I, so I Replaced the Primary Code with an I
  • On the Net customers, the ones with a 20 or higher already had both the I and S and needed no more attention.
  • The Net customers with a 10-19 had one or the other. There were only about a dozen, so I manually went into AR-A and added the necessary contact.
  • The Net customers with a 0-9 needed both, so I created a file with the necessary fields and Appended it to the contacts file.

 
The important thing is that I now have and "I" contact to send Invoices for everyone that has an email (or fax # that I've made into and email address), and all our Net X days customers also have an "S" contact for Statements.
 
The only thing I'm not real thrilled with is that I ended up Appending any additional contacts needed, so some customers (about 100) have a duplicate [blank] or [Y] contact in addition to the I and S ones. I'm sure I could run a script of some sort to clean them up, but it's not that big of a deal.
 
Anyways, I think I am finally there. We are using it today for Invoices, and Monday will be another big test with Statements.
 
BTW, I believe there were only about 10 Net X Day customers that we don't have a fax or email address for (and they are very low frequency), so I expect the USPS is going to be getting a LOT less of our $$.  Grin
 
Quote from David Waldmann on 06/26/15 at 05:12:56:
We are in the process of doing away with our normal fax line because we are converting to Hosted PBX on VoIP. So we will be using an Fax-2-Email (F2E) service. It's really cool how it works for sending from Evo. You enter an email address to the Contact using their fax number, i.e. 19998887777@faxservice.com and it gets treated in Evo as if they have an email address. Evo sends the email with attachment and the F2E service converts the email header, subject and body as a cover page, and the attachment as content pages.

The receiver has no idea that it came from an email other than the fact that the bottom of the cover page has the name of the fax service on it. Note that if you have no subject or body in the email no cover page is sent, so if you send a lot you may want to set up a user that has a profile without that since the F2E services charge by the page (or - up to X pages). I like MetroFax at $8/month for up to 500 pages.

 
Per fellow user Burr King, I found out that if you put {nocoverpage} in your signature the F2E service eliminates the cover page. Pretty slick. Would be even slicker if Evo did HTML mail - you could make the text white so it couldn't be seen...
 
One last note. Probably most of you who've played with this already know, but for some reason I didn't figure it out until yesterday.
 
When you click Email in the print dialog the box comes up asking how you want to send the email. I was under the mistaken assumption that the "Use Contact Name" and "Use Contact Number" were only valid selections if "Auto Send Email" was checked off. They're not! So, you can still select "Use Contact Number" and put in the "I" or "S" but NOT check off "Auto Send". This will allow you to see what it wants to use, and make adjustments if necessary. So for now we are not going to Auto Send, until we've tested for a while and make sure it all works the way we expect it to.
 
Of course, now that we've gone through all that, they will probably enable the checkboxes...
 
*I used the T7GENIMP utility. A couple of tips - the only required fields for this purpose are Customer ID, Email Address and Primary Code. I also assigned a Contact of "Statement" to the S code contact and "Invoice" to the I code one. Two notes related to that -  
  • 1) the field for the Contact Name is BKCM.ACCN.CON, NOT BKCM.ACCN.CONT[array 1-10].  
  • 2) If you don't put in a Contact Name, or put it in .CONT[array*], Evo will assign "No Name    X"...

 
Hope this helps someone have a bit less pain than me. If anyone has any questions about any of this, please let me know - I'd be glad to help.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Pages: 1 2 3 
Send Topic Print