Consolidation Materials on delivery

[JBO_DK]

Hi all

We have some sales orders where the same material might be represented more than once. In order to optimize the picking process i would like these materials to be consolidated on the delivery.

Scenario on the order

Mat11 - 2 pce

mat11 - 4 pce

On the delivery i would like these to be combined into one line with Mat11 - 6 pce

Is that at all possible

Hope someone can help answering this

Kind Regards

Jens Olsen

[former_member182378]

Good discussion between you and Veselina.

I only need the lines to "consolidate" when they are matching. Eg, same shipping point, shipping date, conditions etc etc . The rest should stay split since they all need different handeling. 

Before saving of the sales order, have a popup which is an information message to the order entry user that e.g.

#10 and #20 could be consolidated because material.....are identical

The consolidation will be done by the user at the sales order creation stage.

For the popup, you can enhance program MV45AFZZ, USEREXIT_SAVE_DOCUMENT_PREPARE

[VeselinaPeykova]

Isn't it cheaper and easier just to explain to the sales clerks not to enter the same material twice in the sales order, unless there is a very good reason to do so?

A popup message might help, but very often users press enter or select whatever is set as a default answer without reading and then start complaining 🙂

[former_member182378]

Veselina,

I understand your point. But I am not sure if "explaining" would lessen this occurrence. Ofcourse, on a grand scale, everything comes down to the engagement and handling of the system by the users (whether you do a little enhancement or a lot or none).

The OP is thinking of doing some custom coding in the copy control settings! In comparison to that, the popup message - either warning or error - would be a safer and better option.

...going back to the "grand" 5000 feet level,

The OP or client's his keyusers are in the best position to see what method would work. We can just throw some darts in the dark. 🙂 😉

[JBO_DK]

You are right about the reasons for this happening in the first place.

I will try to investigate further, maybe something can be done in the copy routine between the sales order and the delivery.

I only need the lines to "consolidate" when they are matching. Eg, same shipping point, shipping date, conditions etc etc . The rest should stay split since they all need different handeling.

Thank you for helping clarify a few things, if i find a solution i'll update the note.

/Jens

[VeselinaPeykova]

I don't think, that even with matching shipping points, item categories etc. that this is possible without a really heavy set of developments, which will most likely break the whole order-to-cash process. LIPS (delivery item) has fields for referenced document number and item (VGBEL, VGPOS). LIPS-VBELN and LIPS-POSNR form the key, so how would you keep the references, if you have a single delivery position for two order items? And this will be just the top of the iceberg...

I suppose, that some external warehouse solutions may not handle well pack optimization across delivery items, but we have never considered modifying how SAP handles delivery item creation.

[VeselinaPeykova]

As far as I know, this is not possible even with development, sorry.

Speaking from my limited experience, sales clerks might enter the same materials more than once in the same order for the following reasons:

• One item is paid for, the other is free (different item categories);

• The same material needs to be delivered from different plants (e.g. full pallets are delivered from plant A, picking can be done in plant B);

• Insufficient training, poor UI design or user mistakes (duplicated items).

• Different addresses, etc.

Maybe, instead of grouping materials onto the same delivery item, you could use different printouts, which sort products per product groups and material number?

Or, if you use external applications for pack optimization and picking - probably the vendor already has a solution (having the same material more than once in a delivery is not uncommon).