Addition of the sale order multiple line item quantity through the variant configuration.

[Former Member]

Hi Gurus,

I have a configurable material – Ex:- glass sheet. Created a sale order for configurable material –Glass sheet of quantity - 1 EA, with the line item number-10. Based on the configuration values (by the characteristics values and dependencies) new material-Ex:- Tape is triggered from the sales BOM and the material – Tape of quantity -1 EA (For 20 Mts of tape = 1 EA) is created in the line item-20 . But 12 Mts of tape is enough for this type of glass sheet .

Now one more line item -30 is created with the material – Glass sheet , based on the configuration values of the characteristics a new line item 40 with material –Tape of quantity 1 EA is created.

But this type of glass sheet requires only 8 MT’s . So totally 2 EA Tape material are created in the sale order but the requirement is the characteristics values for the configurable material – Glass sheet for the line item has to be added (EX:- 12+8 = 20 mts , which is equal to 1 EA , Instead of 1 EA of tape material 2 EA of material is issued) Now need to sum up the characteristics value for the tape in different line items of the sale order and create a single line item for the Material tape with the cumulated quantity .

Thank you ,

[Jelena · Accepted solution]

Maybe others know of better options but IMHO in plain SD this is not feasible without some heavy ABAP and then you'll be shooting yourself in the foot with all processes other than just a simple sale. Somehow people never think about this but this is just from the top of my head:

- What if the customer later decides not to order the second glass? You'd have to "recalculate" tape back and somehow get back whatever was there.

- The customer was buying one glass for one job and another glass for another job at another site. But they were given just one tape. The customer is not happy.

- Customer returns one glass because it's defective. What about the tape?

- The bean counters in Accounting want to see the reports with the cost analysis on how much they're spending on tape for each glass type. Now it's not feasible because the tape went out with the order and there is no telling what belongs where.

As I said, this is just a tip of the iceberg. If you want to go this way I'm guessing you really need to start selling tape by the meter but that's probably not possible (e.g. if we're talking about the Scotch tape type).

You might want to think about all the possible consequences and do an ROI estimate. Technically, it is feasible and there might be some special third-party solutions for this but I'm afraid there is no "easy button" if that's what you've envisioned.