Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print multiple historical invoices at once

Status
Not open for further replies.

barbola

Technical User
Feb 27, 2003
1,132
CA
Is there a way to print a range of historical invoices? We need to print about 400 invoices from history and the only way we know is to print one at a time by viewing it in inquiry.

Thanks!
Barb E.
 
You could use a macro to automate the single printing process. You can use word to mail merge to create the macro if you have specific numbers you need to print.

David Musgrave
Senior Development Consultant
MBS Services - Asia Pacific

Microsoft Business Solutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
 
We had the same problem here about 5 months ago. We have a custom historical invoice made by Crystal Reports and I simply modified the crystal report select formula so that it will just pick up the invoices for the one account during a specific date range. I just happened to walk into the AR manager's office while he was calling up individual historical invoices and asked him what he was doing. It took me 25 minutes to alter the invoice and ran all 375+ invoices in 15 minutes. This would have taken him days to do.

I don't know if you invoice is customized with crystal or the canned invoice with GP.

Mark
 
Thanks for the info. I just went into Report Writer and put the range into restrictions. We ended up printing a few more than we needed, but no biggie!



Thanks!
Barb E.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top