Sage 100

Anyone know what flags an item on Sales Order Detail as an exploded kit component vs regular item? I'm thinking it's QTY Per Bill but am not sure. I have a customer that uses DSD SO-1068 to convert kit components to items and need to supply info on how to tell between a component and the main kit item.

ExplodedKitItem? Field 23.

I think the enhancement may set that value to N

Easiest thing is to just add all the possible fields to a custom report for analysis.

Join to SO_SalesOrderDetail to IM_SalesKitDetail and examine fields ItemType and ComponentItemCode.

I look for a value in the field ""SalesKitLineKey"" if there is a value in it then that tells me it is a component item on a kit. If it is null it is not a component. The field explodedKitItem would tell you if this is the actual KIT (as apposed to a component) but only if it is an exploded kit.