How to restrict two items in one sales order.

[Former Member]

Hi ,

My client wants that in one sales order two material say Mat -A and Mat-B should not go together. It should go in seprate sales order due to chemical nature both product should go seprately.

Kindly advise me how to configure it. Give full details

Regards,

Balu

[Lakshmipathi · Accepted solution]

If I am correct, your requirement is to split the billing of material A and B separately rather in sale order. If this is what your requirement is, then it is better you maintain a different item category for these so that automatically, your invoice will split.

Alternatively, you can also try with other option already suggested like having different shipping point.

thanks

G. Lakshmipathi

[Former Member]

Hi,

Is it for only these two materials(ur example) or for the entire range of materials.If it is for all the materials then we have a control in the sales document type "order quantity=1" if u check this field then u can enter only one item in the sales order.

Regards,

Ramesh.

[sarthak_mohantysd]

Hello Balu,

You can also try out the following approach if the two Material belong to different Material Types.

Approach # You can use a User exit that will prevent the creation of a Sales Order when these Material are used and a sales order is tried to be confirmed. Please take the help of a ABAPer and put logic in the code that will use Material type as validation point.

USER EXIT --> 1. USEREXIT_MOVE_FIELD_TO_VBAK

2. USEREXIT_SAVE_DOCUMENT_PREPARE

Hope this really helps in resolving this issue.

Regards,

SARTHAK

[Former Member]

Hi All,

What I understand from balu's query is that, he wants to have a control in Sales order itself, so that, if he selects a material A in one line item, then he should not be able to select material B in the same sales order and vice versa... Is there any way to do like that???

[Former Member]

Dear

Can we change their divisions . i.e. for A material code division is 01 and for B material code is 02

we can try this as we also faced this problem we have overcome by this .

if any other solution please do update in this thread.

Thanks & regards,

Manu

[Former Member]

Hi Ashok,

You are right, this is our requirement

Thanks

Balu.

Edited by: Balu Sajja on Aug 30, 2010 1:04 PM

[Former Member]

Hi Balu,

If that is the exact requirement please use the SAP std functionality of material exclusion functionality.

Hope this helps..

[Former Member]

Hi Vijay,

We don't want to exclude any material for the customer.

regards,

Atul

[Former Member]

Hi

Chemical in nature will have reaction when the some chemical composition are similar or opposite group this logic will apply to maintain the inventory for those materials at storage location level

If A and B materils should not be in one deliver means we should nt put them closer same will apply at the time of inventory and same wil be different storage locations, provided that if we worst case producing same in single plant

Hence if any customer may order for the above two materials those two are determining different shipping points in the Order and subsequently delivery split will take place but in order to achecive this we need to maintain the different shipping points for those nature chemicals.

Regards,

Ram.

[Former Member]

Hi,

You can do delivery separately by giving different delivery date at Item level of Material -A and Mat-B. Either one day difference, Required delivery date also need to change here.

Or else If you can do shipping in different shipping point also possible by entering another shipping point and do delivery on same date with different shipping point. For this shipping point to be assigned into shipping point determiantion as alternate shippint point manually.

Hope this helps

Regards

Harish

[jpfriends079]

Why don't try with Delv. split? As anyhow, you have to bill those chemical from delv doc and deliver according to your delv doc.

You can achieve this by maintaining different SHIPPING CONDITION.

And accordingly determine the shipping point ( Shipping point determination, Plant u2013 Shipping condition u2013 Loading group = Shipping point).

Thus, as delivery document is created on the basis of shipping point and the delv will be split into.

Hope it can assist you in understanding.

Thanks & Regards

JP