I have created a BAQ Search that pulls in all quoted quotes from Jan 1, 2010 through today. I need to Print Preview all 30,900 Quote Forms and save to a file. I was thinking I could filter off the print screen with the BAQ Search, but there is no filter there, and I do not know how to add one to a print screen.
So what is the easiest way to do this? Any suggestions are appreciated.
The QuotForm doesnāt allow for batch printing. Meaning you canāt give it a list of Quotes to print. It can only print one at a time.
What you may have to do is make a BPM on UD table with one of the fields to hold the quote number of the quote to print. Use an Auto Print widget to print the quote. Youāll have to pass that field to the Print widget.
Then use DMT to update that UD table with the quotes to print.
You donāt need to add a row for each quote. Just a single row in the UD table that prints quotenum that matches UDxx.Number01
Iām heading over to Epicor Ideas real quickā¦they should add batch printing for quotes, like with invoices and soās.
Why???
The ERP system will keep them for ever why print them to a PDF or a fileā¦
Because not everyone keeps their ERP system forever?
Or maybe subpoenaed/evidence for a legal matter?
Well, for instance, to hand over to a Public Information request?
Actual crystal or SSRS report can change over time. If company uses multiple report styles, you have to know which report style to use. That being said, you can create custom form that will create reportform dataset for quote, and submittoagent for quote form, in a loop for each quote number found.
Thanks, Calvin. Iām going to give your suggestion a try right now.
Happy Friday, Calvin!
Iāve been trying to follow your suggestion, and I have a question. In another of your posts, you mention that youād changed the Setup Auto Print > Report Parameters > PackNum field from the default āThe 0 Constantā to āThe specified expressionā¦ā but you said it used custom code. For the QuoteHed table, what should this field say? Iāve never set this up before, so Iām learning as I go.
This is the post Iām referring to:
Here is mine, so far:
DMT is running now in Third updating UD04. My plan was to enable the BPM and see what happens once they all load. You donāt have to refresh the data model with the UDxx tables, right?
Is there anything I need to change? Am I doing this correctly at all?
I did open a case to help me, fyi, and they suggested I get back in touch with you. 
Thank you,
Erin
What you want to be be used for the QuoteNum field is an expression using the column from your UD table that the DMT updates in order to force a new autoprint. Off the top of my head something like
UD04.Number01
Then your DMT file would be
Company Key1 Number01
MC EXPORT 12345
MC EXPORT 12346
MC EXPORT 12350
Make sure that you use Update mode in DMT. You might need to first create that UD04 record with Key1=āEXPORTā, in order for updates to work. If so, just make a DMT file with just the first row, and processes with the Add box checked.
Hereās how I think it would go:
the above are repeated for rows 2 and 3 of the DMT for quotes 12346 and 12350.
One thing you need to be clear on is that this makes a separate task for each quote. Youāll get a separate printout (or emailed PDF) for each quote. So youāll need a way to manage them.
What I would do is make a Break Route that emails the quote to me, setting the Attachmentās name to the QuoteNum. Like: QUOTE-<quotenum>. Make the subject line something specific to identify these emails. Make a rule or script in Outlook that automatically saves the attachment for any received email that has that special subject line.
Youāll still end up with an individual PDF for each quote, but theyād be autmatically named and saved in a specific location.
Some things I missedā¦
In the āSet up Auto Printā dialog, set SSRSEnableRouting to true. If you go with the break/route idea of emailing them to yourself.
No Regen is required when using UD tables - unless you add a column to it. Some folks prefer to add columns so they have meaning fulnames, instead of just relaying on Number01 meaning QuoteNum.
Thanks, Calvin
Iām stuck at the most important part - need to link the UD04.Number01 to the Quote Number - Iām not seeing how to do this correctly. I tried to follow your instructions, but I donāt see how to link them.
I believe my error is in the top row QuoteNum - System.Int32 - The 0 constant
Am I supposed to select the Expression option or the Table/Field option? I could not get an expression to work, and when I select the ttUD04 table in the Table/Field options, I get zero fields to choose from:
Which selection do I choose from the dropdown menu? I think Iāve got the rest correct, but this part is catching me up. And thank you in advance for any assistance, I know itās Friday and you might just have a life. (Not me lol.)
Iām on the east coast and had already left for the day. 
I think youāre real close. I donāt have access to E10 at the moment, so I canāt tell definitely what to do. But things Iād double check
Was the choice in the Execution Rule the default one? Try the āFor Each Matchingā option and then see if that makes the table/fields dialog show the UD04 fields.
If you use the āexpressionā option for QuoteNum, does it show any datasets or tables you can choose from? If not just try making the expression ttUD04.Number01
Okay, thanks, I will check all that out. Maybe this weekend, but I just got my first freelance project so Iām likely going to be chained to that all weekend. Iāll let you know how it goes as soon as I take another look.
Iāll be here all weekend!
Perfect, me too. Iāll pop over if I break from this other project now and then. I really want to figure that BPM out before Mon am.
Try setting that Constant 0 to an actual quote number, just to test the triggering and printing/generating aspects.
Then tackle the part of making the quote number dynamic.