Sage 100

Looking for suggestions on the best way to print picking sheets to multiple warehouses and only show the items from the appropriate warehouse without printing anything in the warehouses that don't have any items from that order. Have a client where most orders have line items from multiple warehouses on them.

The only thing I can think of would be to have separate forms for each warehouse that only include items from that warehouse but that would mean printing them individually and selecting the appropriate warehouse printer??

Pretty sure there's an ES for this. Check DSD. Looked at an bought but never implemented for a customer. Not saying there isn't another workaround - just that this is one possible option.

You could use the shadow text on the multi-part setup as a warehouse indicator. You'd suppress items that didn't match the warehouse/shadow text.

On Picking Sheet printing (not the print-button on Order Entry), you can select the WH lines to be printed - but you would have to re-select the order once for each warehouse.

@Brett - That's a great idea! Is there a way to use that to suppress the entire form if there are no items for that warehouse on the order?

Hmmm. That would be trickier. You might have to have a subreport at the top of the form that returns a global variable that would indicate whether or not there are any items to print and then that variable could be used to suppress every report section. Might be fun to try, anyway.

I have not found a way to entirely suppress printing a specific form when using mutli-form.

@MyronStevenson : Now i'm going to have to try it myself, LOL! Out of curiosity, what would happen if I suppressed every section on a form based on some shadow text value? Nothing would print, right?

Would you get a blank sheet of paper?

@ThereseLogeais - That's the million dollar question!

My prediction is that a blank page will print. That is want my results were two weeks ago.

You will still have a print job out there so even if you suppress every section, it just means nothing will print on it IMHO.

yep, I just did it and it's a blank page.

I have done the subreports for the various warehouses incombination to send to various warehouses via the multi-part printing using the shadow text.

Have they rsolved the issue about invoicing the SO from multiple warehouses. Last I knew, you could only generate one invoice at a time for the SO, thus making multiple warehouses a PITA to process.

What I did there is put a note at the top of the main warehouse picking sheet - so that when they go to ship - they put this in a batch by itself so they can hold that batch until the other warehouses process their shipments. In this case the other warehouses do not speak to Sage 100 so it is invoiced manually.

@CYNTHIAHAY and I got the blank page to not print by selecting ""Suppress Printing if no records"" in Report Options plus selecting warehouse in warehouse group. This is for quick print of picking sheets for one specified warehouse when order contains items in multiple warehouses.

At the risk of feeling dumb in a minute, doesn't Sage 100 already do this? My ABC company has as many picking sheets come out as there are different warehouses on the lines. And each has only its own items. Are you talking about a scenario where the warehouse hasn't been picked at the line level?

I **think** the question is to print the form to different printers in separate warehouses with each warehouse only printing what is theirs?

Yes, correct, Wayne! the mission was to Quick print a picking sheet for only for items in one specificwarehouse for one form code to go to one remote printer. Standard sage form wants to print for all warehouses with a page break. Quick print does not have a warehouse selection and getting crystal to behave properly without printing an blank page when you suppress the other warehouses was problematic. Attempted it from several angles and nothing worked well. The suppress printing if no records and selecting warehouse in group seemed to work but still troubleshooting as it may still send something to the printer as started getting xps format error. Talked them into using picking sheet printing off the menu so they can select warehouse and do in batches instead of having order entry people do it when they print the order but will not default the warehouse in selection. Anyone know how to get picking sheet printing to default to a warehouse for a specific form code.

Here's where Visual Cut or Sage Alerts might come in handy. I would print the pick lists outside of Sage 100 where you have more control. I would create a report that mimics the pick list for each warehouse then create an event for each warehouse. This is so you could specify a unique folder for each warehouse (you might be able to achieve this with one event). The report would print the 'pick list' and deliver the PDF to a hot folder where auto-print software (many on the market) would print the PDF to any designated printer (determined by folder). I would typically create a trigger (UDF checkbox) on the order that indicates the order is ready to pick so the events don't grab something not ready to ship. The event(s) would run every few minutes. Once everything is set up it would be a hands-off system. I've never done this myself so just thinking of ways it could be done.

I mentioned a process for automated printing picking sheets using Visual Cut during the Webinar. The only difference here is that the VC report would need a warehouse parameter, with different printers on the batch file command line for each parameter value.