Printing large number of Quotes/Sales Acknowledgements?

10.2.200.35
I have a need to print a large number of quotes and acknowledgements based on a set of quote numbers and order numbers. Usually, this is done one at a time through Quote Entry and Order Entry, however I want to generate a single PDF file for all quotes and acknowledgements selected. Has anyone done this before using the existing reports? How did you go about doing it? Or do I need to create BAQ reports that looks like the quote form and order acknowledgement to accomplish this? Any help would be greatly appreciated!

You can use the Mass Print Sales Orders. You can paste in the list of SO numbers if you have them. Or there is a filter function you can use. Creates a single PDF with them all.

image001.png

Chadd, I don’t see the Demand Management submenu in 10.2.200. Is that an add-on module, on a later version, or am I missing something?

John

Might be a later version thing. We are on 10.2.400. I don’t have our 10.2.200 or 10.2.300 environments still running to check.

There is a “Mass Print Sales Order Ack” function on 10.2.300 under
Sales Management -> Order Management -> Reports

And FWIW - it looks like the QuoteForm printing was only ever designed to work on a single quote.

I took a look inside the Auto Print widgets available in a Data Directive, and see that the OrderAck printing can accept a single Order number or a list of orders to print.

image

While the QuotForm only accepts a single Quote number

You could do something to cycle through all the desired quotes (like a DD on a UD table) that passed the QuoteNum to the widget. But that would make individual PDF for each Quote. You’d have to then combine them yourself.

Thanks, Calvin! I was afraid of that… I did find the Sales Order Acknowledgement DLL and added it to a menu item, so I can paste insert a list of order numbers to it.

You can use a BPM to autoprint based on setting a value and use DMT to set that value.
Breaking and Routing can ensure each report is separate, but the this process would not require that Module.

1 Like

Thanks to everyone for responding! Great ideas for handling Quote print. I do have a follow-on question: We don’t use Server printing, and I want to direct the PDFs to a subfolder under my Epicordata\Reports<Username> folder. I’ve tried entering File:\Quote{sequence}.pdf in the Report Options on the report style I’m using, but it won’t write or save the file. Do I need to set up server printing first, or am I missing something else?

I think any of the ways that create a PDF and store it to the server are fairly code intensive.

If you have Adv Print Routing, you could setup a Break Routing (B/R) that will email the document to yourself. Then use an Outlook Rule (takes a bit of VBA - link below), to automatically save the attachment to a folder. B/R is better than the built-in emailing of a report, because B/R will allow you to specify the attachment’s name.

Here’s a link to how to setup Outlook to save the attachment

If you don’t have B/R, you could still use the built-in emailing of a report. But the attachments would all have the same exact filename. You’d have to generate unique filenames in the VBA for the Outlook rule.

I think I might have misled you. You can use the Style options to specify the location of the PDF. Try taking out the \ betweenFile: and Quote

edit: Also change{Sequence} to {Counter}

I created a Report Style and added the following to the Report Option field:
File:{Company}\{ReportId}{Counter}.pdf

That file ended up as:
C:\EpicorData\Reports\manager\MC\SessionAudit00001.pdf

The C:\EpicorData part is from the System Agent setting:

image

The \Reports\<userid>\ is automatically generated at runtime

The MC\SessionAudit00001.pdf is from the {Company}\{ReportId}{Counter}.pdf

If a user can’t directly access that location on the server, then they’ll have to use the Server File Download program. Select Reports from the Directory Type, then use Select file to browse to the file.

image

@ckrusen Yes, I use this option to generate PDF files.