Sage 100

Another Crystal question - packing list customization. Client uses BOM kits (always explode). When the product is a kit, they only want to see kit components, not kit items. Picking Sheet printing gives you an option to include kit items, but there is no such option with packing lists. Both kits items and components print. What I attempted was to add CI_Item table and modify the Details A (Item line) suppression criteria to be: formula = {SO_PackingListWrk.ItemType} = ""4"" or {CI_Item.ProductType} = ""K"" or PreviousValue({@InvoiceNoLineNumber}) = {@InvoiceNoLineNumber}; result is the kit items are suppressed, but I also lose the /C comment line in my test order. I did not modify the Details B (Line type 4) suppression criteria from the standard suppression formula. Can someone correct my formula or suggest a better way?

IF {SO_PickingSheetWrk.ExplodedKitItem}=""Y"" seems to indicate a top-level item I'm using this on a picking sheet to shade the top level component. If this doesn't work let me know as I have a customer who uses BOM kits extensively with exploded components. We have shaded many of the forms in order to make them clearer for the customer to read.

The form I'm working on is is a packing list, not a picking sheet. The issue has to do with the CI_ItemProductType field. Just placing it on the form, not adding it to the Details section suppression formula, results in the /C line disappearing. There is no ""ExplodedKitItem"" field in the Packing List work file.

You should be able to add the field from the SO Invoice table via a UDF

Sorry I misread the original message. I'll look and see if we do anything with packing list.

@JeffSchwenk thanks for the idea - it works. I often forget about bringing in standard fields from one table into UDFs in other tables, Appreciate the reminder!

That is why you pay me the big bucks........ Anytime!