Sage 100

Anyone add an item # UDF to Picking Sheet Printing (MAS 90 4.4)? Did it work? Client wants to define item # as selection criteria in order to print picking sheets for a backordered item.

you can feed CI_Item udf's through to SO_Picking SheetWrk directly using the data source option. Works fine. If you're trying to change the selection criteria that crystal uses to generate the work table, I believe that would be very tricky. If you just want to use formulas and suppress sections based on the udf after the data is pulled into the work table, that should be pretty easy.

Thanks Eric. I've created the UDF, pulling from Sales Order Detail, but now trying to establish it as selection field. Client wants to only print picking sheets for a specific item(s), rather than for all orders.

Since the Pick Sheet selection selects from the SO Header - I don't think the Item UDF would appear as a selection option.

I've tried adding a parameter to SO pick sheets before and hit a dead end. The grouping and parameters built into the report don't seem to allow you to add an additional standard crystal parameter. In my case, if the client pushed harder I would have turned it over to our developers . If you figure it out I'd love to know what the trick is.

The SO-1099 Enhancement does this beautifully. After PO Receipt of Goods update, user is prompted to print the Backorder Fill Report. The enhancement then dumps this information into a data entry file where the backorders are displayed. They user can re-organize who gets what if items are still not available to fill all orders. The user is then lead to Print Pick Tickets for one or all items.

Thanks Kathryn! Was just trolling through DSD's enhancements and came across it.

also check out the back order fill utility. We use this at a client's, let the lines get pushed to back order when not in stock (most of their items they don't stock regularly), then after ROG run the back order fill utility and it takes the lines off Back Order (oldest to newest) - we are able to dump out a file at that time with SO numbers with lines that have been filled, and we import that to re-check the pick sheet flag. just went live in January but seems to do the trick. DSD's S349.

Thanks Eric. Was looking at that as well, but it appears to only scan Standard Orders. Is this accurate? I imagine users want to scan back ordered lines on Standard AND Backorders.

yeah, that was an issue we had as well - tried to get DSD to look into a modification to it, but eventually just wrote our own script to take everything off Back Order (at the header level) once per day. So we use the HOLD option, everything is a standard order, and we only have Back Ordered lines.

oh, and we hit a UDF that says partial ship and can still show the last invoice# (like the back order type shows)

@EricAnderson Even though I didn't think it would work, I added an item code parameter to picking sheet printing and it appears to work. Granted, I'll probably create a separate form for this purpose, but it does work. Initially tried adding a dynamic parameter, but that didn't display items, even though it prompted for login credentials.