×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Email Invoices

Email Invoices

Email Invoices

(OP)
Progression SQL 7.8.2
Microsoft Server 2008 R2
Microsoft SQL Server 2008

A lot of customers are asking for invoices by email. We can batch a lot them together, print to file, re-run with the ICR invoice to pdf and email. But for the customers with the single invoices, if we batch together, all the invoices are together. We have to do an invoice at a time to create a pdf that can be emailed.

Have any of you partners written anything to address this need?

Thanks

Donna

RE: Email Invoices

Do you own Event Manager? This is the way to do this.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

RE: Email Invoices

(OP)
Nope...thanks for the response.

RE: Email Invoices

You need to look into Event Manager - not Exact Event Manager but Vineyardsoft. You'll never regret it.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

RE: Email Invoices

I do this for a lot of Macola customers using Ido Millets Visual Cut product.

Use a yes/no field on the Contacts screen to identify those contacts that receive emailed copies of invoices - this allows you to have multiple recipients on a single customer account.

Create or use an existing Crystal invoice form and group it by customer and contact and add criteria so that only contacts with the yes/no field checked are included.

Use Visual Cut to 'burst' the invoice and email to each individual contact - then schedule it to run each evening using Windows Scheduler.

The same concept can be used to email ACH notices to vendors, statements to customers, acknowledgements etc. etc.

Peter Shirley
Macola Consultant, PA and surrounding states.
http://www.erpessentials.com

RE: Email Invoices

Of course - you'll only find the Contacts tab in Macola ES or Macola 10. For Progression, you'll have to use a user defined field on the customer.

Peter Shirley
Macola Consultant, PA and surrounding states.
http://www.erpessentials.com

RE: Email Invoices

(OP)
Thanks for all the replies..different suggestions from what I got from Macola and WiSys...I will look into them.

RE: Email Invoices

A little late to the party, but...

We use a program called Check Factory (http://www.trans-micro.com/) to batch and email invoices and statements (written in Crystal Reports).

Email addresses are stored in a SQL table, since the accounting email contact in the AR customer record is not always where invoices and/or statements must be sent. Fields are essentially Cust_ID, email_addr, Doc_Type (I=Invoice, S=Statement, etc.) If no email address is found, it is replaced by our email address so they can be printed and faxed to our neo-luddite customers.

And Don is absolutely right. Even if you don't use it for this project, you definitely want Vineyardsoft's Event Manager!

Cheers,
Randall

RE: Email Invoices

(OP)
Thanks for all the solutions....looking into a few of them.

Donna

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close