SageForum for UK versions of Sage 50- Help and support.

Just wondered whether anyone has had, and resolved, a similar problem to the one I'm currently experiencing.

I use Transaction Email with Sage 50 Accounts Professional 2011 (version 17.0.15.208) and have a problem whereby, everytime I open it (transaction email that is), Transaction Email kindly duplicates and re-sends a previous document in the list. I've got clients and suppliers who are receiving 4 or 5 copies of the same document.

It seems to stay on the same document for a while and then start on a new one.

This seems to have started occurring since I had a "Not Responding" issue in Transaction Email and had to shut down. This then caused another problem where Sage thought T-Mail was continually logged in and I couldn't back-up or enter Configuration etc. This I resolved by re-creating the queue.dta file but ever since I have suffered with above.

Any help or advice would be greatly appreciated.

Regards,

Nick

I have encountered only few people using tmail.

I have many contacts who need to do EDI, but tmail just isn't up to it for Tesco and big cos, so they end up using a 3rd party product such as Freeway Commerce

Most people just want to email documents and tmail does an ugly job of that so they just email pdfs.

So whilst tmail was hailed as revolution, it just doesn't seem to have proved very popular, I think if it didn't require outlook and could have editable templates to make the rendered xml look better it might have got a better reception.

Having said that the people who do use tmail, are not having duplication issues you describe.

You could wipe tmail and reinitialise it, but if you have been using it long time that might not be a good idea as you will loose all the associations you have built up a bit of a drastic way to fix it.

What do you mean by "It seems to stay on the same document for a while and then start on a new one."

How have you configured it?
Are incoming orders working okay?
Is this issue happening only on sending edi purchase orders and edi invoices?

>>>BACKUP FIRST<<<

Sounds like it could be an indexing issue, use the MS Access ODBC driver to repair and compact the access database.
Control Panel>Administrtive Tools>Data Sources (ODBC) (if you are on 64 bit then you have to find the 32 bit ODBC) Select MS Access Database Driver>configure>Repair> Point to tmail Database in tmail subfolder of the ACCDATA folder> name file (you will need to swap the names so the original file is called something else and the repaired file has the original file name)

repeat the process on use Compact instead of Repair.

You may find repair then compact works, or compact alone or repair alone or compact then repair. Do some trial and error on it to find a combination to fix it.

>>>BACKUP FIRST<<<

Thanks very much for your response. Apologies for my delay in replying but the problem seemed to resolve itself soon after I posted on this forum.

I had just run a large batch of invoices and assume it couldn't cope with the volume. During the month we send individual orders and invoices out and only at the end of the month will the batch re-send, so I will have to review it again at this time.

In answers to your questions:-

What I mean by by "It seems to stay on the same document for a while and then start on a new one." is that it resent the same invoice when I opened up Transaction Email on 3 or 4 seperate occasions. Then it seemed to start sending a different invoice/order the next time. To explain, if I sent 1 invoice to Tmail, it would tell me there are two waiting to be sent and re-send another one from the list.

Configuration has Transmission as email (Basic) for outgoing and nothing in folder (Basic). Frequency is set not to check for incoming messages as we do not have any customers/suppliers using the same facility, which answers your next question.

Yes it is only happening on edi invoices and orders although this is all we use tmail for.

I actually prefer the idea of sending .pdf attachment invoices and I have had some turned up noses from clients since we adopted tmail sending. Our last system did this and was designed specifically for batch sends. As we are a contracting company we have 50 or so recurring invoices each month and the process for sending these in Sage seems a little long winded to me (maybe I am not using the correct process?).

I appreciate your help, I will wait and see what occurs at the month end (or at any time before if it reoccurs). If you feel there is a more streamlined process in Sage (which is fairly simple to setup) for sending my invoices via pdf I would welcome your advice.

Many Thanks,

Nick
Enterprise Complete Services Ltd

Sending repeat invoices is easy

1 create a recurring invoice by memorising an existing one and setting how often you want it to reoccur.
2 process any recurring invoices that need raising.
3 select the range of invoices to email, press the email button.

I'm also having problems with TE. When I have a purchase order highlighted and chose to send by TE it duly sends it off and tells me when I open TE it will go. When I open TE I find that its not sent the one I chose, but picked an order, from 2005 usually, and sent that instead.

I've tried using your guide on 'How to set up emailing reports', but some of the screens don't match mine and when I press 'test' it tells me the email has failed, but no idea why or how to fix it.

Help!!