Order Entry treating Kit Components as Line Items

It was brought to my attention that the Sales Order Entry is taking our kits and treating each component of the kit as a line item. Anyone else have this happen or notice it? How do we fix this?

Yes. That’s how it’s implemented. What were you expecting?

Well… sales order KITS are actually exploded into multiple lines in OrderDtl. but those lines are typically marked special as a Kit Child.
Are you saying that it is doing something different than it used to?
Example, when you add a kit parent, it SHOULD be exploding the children into the order as well.

It is exploding, but I never noticed, or maybe it didn’t before, cause it to print out as multiple lines. Used to just be the parts under the Kit line.

Note: I noticed this particular Kit, in the engineering, didn’t have the material tied to the Operation. Maybe this caused the result we have been seeing. And, maybe, its only in a handful of kits…something I am checking on.

Under Part | Sites | Sales Kits, you have the option on how things are printed. Compare to a sales kit that was working.

image

2 Likes

Well, just looked at several other kits and they are all doing the same thing as stated above. I could just uncheck the Print Components on Pack Slip, but it would be interesting to know why the kit components are printed as Order lines and not just components and if it could be turned off.

I was told this is a WAD. So, my final question is, how do you restrict lines that are kit components in a report?

When Sales Kits came out, the convention was each item got its own line BUT there is a Display Order Line that matches the parents Order Line - and if I recall there’s a decimal on it.

Line  DisplaySeq      Description
001   1.00            Sales Kit Part
002   1.01            Component 1       
003   1.02            Component 2
004   1.03            Component 3

To exclude the sales kits components, just make sure the OrderDtl.DisplaySeq is a whole number.

1 Like

How would you put that into SSRS? The whole number part. It is alluding me.

I assume the kit parts are on their own section of the report. If so, then create an expression under the Display when section. Instead of using the whole number trick, I looked in the Data Dictionary and there’s a field called KitFlag:

A character flag field used to differentiate between regular sales order line, Sales Kit parent order line and Sales Kit component order line.
P = Sales Kit Parent line
C = Sales Kit Component Line
Null = regular line

Just make the expression to hide the ‘C’ records.

2 Likes