Solved

Simply Accounting Email PDF issue

Posted on 2013-06-04
8
591 Views
Last Modified: 2013-11-25
My client is having an issue sending invoices via the email button on Sage 50.  Sometimes the pdf is received as a pdf, but then it is received as jibberish.  This happens with different clients that she sends the invoices to.  She did some testing with me and I got it fine once and not the next.
If this could help, the subject of the email for the jibberish one looks like this:  =?Windows-1252?Q?Facture_34214_de_M=E9tal_APS_inc._Test_1

Right now, I am having my client print the invoice in PDF and send it from there, but this adds steps to the process and she has to enter the lot and invoice numbers manually in the subject.

Any suggestions would be greatly appreciated

Thank you

Jeannie
0
Comment
Question by:data-informatique
  • 5
  • 3
8 Comments
 
LVL 29

Expert Comment

by:Rich Weissler
ID: 39223430
Interesting.  The consensus would seem to be that the original subject line had unusable, unsupported characters, or it is simply too long and it's getting munged during delivery.

Any chance your client has control over the subject line used?  Excessively long subjects and apostrophes were singled out as likely culprits... but I suppose it could be any other character that might not be supported by the Windows-1252 character set.
0
 

Author Comment

by:data-informatique
ID: 39226543
Hi,
The entire PDF is jibberish, instead of being attached to the email, we get the following in the text (I just copied the beginning):
?=
Date: Thu, 30 May 2013 12:10:54 -0400
Message-ID: <001901ce5d50$433c1160$c9b43420$@apsmetal.ca>
MIME-Version: 1.0
Content-Type: multipart/mixed;
      boundary="----=_NextPart_000_001A_01CE5D2E.BC2ABF80"
X-Mailer: Microsoft Outlook 14.0

This is a multipart message in MIME format.

------=_NextPart_000_001A_01CE5D2E.BC2ABF80
Content-Type: text/plain;
      charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

 =20
Si vous =EAtes incapable de visualiser la facture ci-jointe, veuillez
communiquer avec nous imm=E9diatement.

------=_NextPart_000_001A_01CE5D2E.BC2ABF80
Content-Type: application/pdf;
      name="invoice.pdf"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
      filename="invoice.pdf"

JVBERi0xLjQNCiX/////DQo0IDAgb2JqCjw8Ci9UeXBlIC9QYWdlCi9QYXJlbnQgMyAwIFIKL01l
ZGlhQm94IFswIDAgNjEyIDc5Ml0KL0Nyb3BCb3ggWzAgMCA2MTIgNzkyXQovUmVzb3VyY2VzIDw8
Ci9Qcm9jU2V0IFsvUERGIC9UZXh0IC9JbWFnZUIgL0ltYWdlQyAvSW1hZ2VJXQovRm9udCA8PCAv
RjEgNyAwIFIgL0YyIDE1IDAgUiA+Pgo+PgovQ29udGVudHMgWzUgMCBSXQo+PgplbmRvYmoKNSAw
IG9iago8PCAvTGVuZ3RoIDYgMCBSIC9GaWx0ZXIgL0ZsYXRlRGVjb2RlID4+CnN0cmVhbQ0KeJyt
V11u5DYMPoHv4OcC61IS9QcUCyQzTg/QuUK7QNHsQ196/SUlSqI9k4wWKBLDlkfi78ePtFn/W359
M6vBDWC9/bW83hazAv2Z1aXN+DWi2aJfb+/LbwB4BdgzQESAYOi6AFig9/Ts6e5dXQfaE3a6eL1/

However, we did a test, she sent me the same invoice a second time and that time I got the pdf file and everything seemed fine.

- The version used is Sage 50 Comptabilité Supérieur (Version 2013 Lancement 2)
- The operating system is Windows 7 Professional Service Pack 2 (English)
- They do not have customized Sage form
- They do not have a logo on any custom form
- When I click on setup / company / email / invoices, the Crystal report attachment is on PDF

Please let me know what can be done to resolve this issue
Thank you
Jeannie
0
 
LVL 29

Expert Comment

by:Rich Weissler
ID: 39227553
This would also be consistent with corruption.  Are the emails going through a firewall on the outbound trip, or some other SMTP aware application before they are delivered?  Do you have any anti-malware software which scans emails before they are sent out from the system?  Are all the emails sent to a single SMTP host which forwards them to the appropriate remote host?  I'd be tempted to either test with (1) a different SMTP provider temporarily to see if the problem remains, if there isn't an SMTP aware firewall between you and the SMTP server, or (2) setting up a local SMTP server on which you can capture a copy of the messages before they go out to make certain the account software is generating the messages correctly.

Doing a little more reading, it would appear Sage doesn't allow the user to modify the subject line, so the previous line of reasoning isn't helpful.

At this point, the problem tree works out to be that the problem is either:
  1) With the email generation from within Sage, in which case I'm afraid the best solution will be from the vendor itself.
  2) Something fairly close upstream in the network is damaging some messages before they're delivered.
0
 

Author Comment

by:data-informatique
ID: 39228545
thank you for your replies, I would like to ask one question, however, wouldn't the email issue be for all emails if it was firewall or smtp related?  I had my client do a test with me where she send me the same invoice twice, the first time it was jibberish and the second time it was fine
Thank you for your help
Jeannie
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 29

Expert Comment

by:Rich Weissler
ID: 39228614
Possibly.  I suggest checking the way the firewall checks emails because once upon a time, the company I worked for had a Cisco PIX firewall.  Before encountering that PIX, I considered firewalls a fairly innocuous device that would protect me from traffic outside network, but allow my traffic out more or less undamaged.  The PIX firewall had a feature to make email more secure.  In practice, it would sometimes simply mangle messages, especially messages it didn't understand, and MIME messages certainly increase the complexity of the message.  I've heard there have been other folks who have had somewhat similar experiences with other firewalls/IDS solutions.  Could also be a virus protection solution that munges the message...  but to be honest, I'm trying to guess what could be wrong, and toss out some ideas I might try to narrow down the problem.  At this point, we're looking at a fair number of low probability causes.  I don't think it's REAL likely it's a firewall, unless you do tell me there is an old PIX involved.  

I think there is a significant probability that it's some device that is handling the mail after it leaves the computer though.  If you wanted to look over the headers of the two messages you received, and check to make certain the two messages followed the same path... any difference in servers that handled the messages?

But to the underlying question: if the client sent the identical message to you twice, and if the message followed identical paths, would I expect them to arrive in the identical condition?  Yes.  Given that they haven't, the question is why haven't they?  Again, I'd want to start by breaking the problem into pieces, and I think the easiest place to start is capturing the message as soon as possible after it leaves the Sage software.  If you can capture several messages, and confirm they aren't corrupted, you can start sending copies of a single known good message out to network and see if any get corrupted there.
0
 

Author Comment

by:data-informatique
ID: 39230712
My client does not work on Friday so I was unable to do any tests with her as she prefers to not have anyone access the accounting system without her supervision.  I have asked her to send the same invoice 4 times to 2 different email addresses.  When she does so, I will check the header and get back to you
Sorry for the delay
Jeannie
0
 

Accepted Solution

by:
data-informatique earned 0 total points
ID: 39267914
My client has decided to stay with the workaround I gave her which is to print the file as pdf and send from there
Thank you for your help
0
 

Author Closing Comment

by:data-informatique
ID: 39674037
My client has given up trying to find a solution, everything seems too complicated for her
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Find out what Office 365 Transport Rules are, how they work and their limitations managing Office 365 signatures.
Read this checklist to learn more about the 15 things you should never include in an email signature.
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now