Emailing from history option lost in BV2018?

Not really sure the best way to put the subject title, but consider the following process done I ran in the demo company on a BV2017 install and a BV2018 install:

1. Create a new customer with no email

2. Go to order entry and post an invoice to new customer (#1)

3. Go back to the Customer screen, add a main email address, and change the form settings to form and email, and save.

4. Create and post a new invoice in order entry (#2)

5. Back in the Customer screen, bring up the Sales history and open both invoices

In BV2017, the option to email the invoice is available for both invoices. In BV2018, the email option is only available in the #2 invoice, created after an email address was added, but not invoice #1.

Now I understand that there's two tables for address here, ADDRESS and HISTORY_ADDRESS. Addresses for the Customer module are stored in ADDRESS, and when posting an invoice a snapshot of that address is taken and stored in HISTORY_ADDRESS. If the customer address later changes, the bill to/ship to address in the invoice history doesn't change with it because it's in HISTORY_ADDRESS. 

So I thought maybe BV2018 changed things around so that the option to email an invoice from history is tied to the history, so if there was no email at the time it stays greyed out. This isn't entirely the case though, as I did a 3rd test:

6. Change the customer email address

7. post a new invoice in order entry (#3)

Now looking in this customer history, the email option is available for invoice #2 and #3 but not #1. However when I email invoice #2 and #3, it pulls the email address from the ADDRESS table and both go to the same email address updated in step 6. 

Does that all make sense? I had one client bring this up with me today, who often gets customers who provide an email address later but then want their older invoices emailed to them. I upgraded over the weekend, so on Friday he could send these with one click, but today the button is greyed out and he has to go through the manual export option for each one. 

Is this something that can be corrected? If BV is going to email history from the address saved in the main ADDRESS table, then the button shouldn't be greyed out if there's no email in HISTORY_ADDRESS. And I did verify this, with invoice #1 I went into pervasive SQL and added an email to the HISTORY_ADDRESS bill to line, and that was enough to switch the option back on in BV.

  • Phew... Thank you Randy!

    I thought maybe BV had taken a step back to 1999 for a moment there and I couldn't understand why it was doing this.

    At the moment this issues has added approximately an hour a day to my client's workload as she has to:

    - stop what she's doing

    - Make the changes to the Customer account with the new email information 

    - Go to the AR Tab, find the invoice and open it

    - Print to screen and save as a PDF

    - Go to Outlook and retype the new email information (switching back to the customer module and hitting the email button doesn't work. The email window pops up with no email address in it!!!) and attach the PDF invoice.

    I would like to be informed as soon as there is a fix for this issue as this client is not a happy camper!


    James Mitchell

    CSI International (On behalf of my client)

  • I see this isn't fixed yet. Even in the new January Payroll update...
    Or, however unlikely, it is fixed and I don't know what I'm doing...



Reply Children
  • Make sure you are on v7.91, if so then go into Customer Details, load the customer in question and make sure:

    1) An email address exist.

    2) Click the Details tab and invoice is set to Email or Form & Email.

    When that is verified, go into Sales Analysis, recall an invoice that was create when an email address was not on file for the customer, and the email button should light up.

  • Yup!
    I don't know what I'm doing...
    Thanks for your help!