How to restrict low value part in RE order.

[prashant_sharma21]

Hello Experts,

I want to restrict some parts/material in RE order. the business logic behind this is, we have some low value/price materials and company does not wants to take return from customers so we want to restrict such items to return.

We have categories low value material using material group in MMR.

I don't want to use material listing/exclusion because once I use material exclusion then I have to make the list of all the material which can be sold through RE else system does not consider it.

Whenever user try to return such parts/material system should popup / message that material# XXXX is low value part and can not be returned.

Awaiting your reply.

Thanks

[Former Member · Accepted solution]

Hi Prashant,

Solutions provided by Moazzam and TW will work.

And your concern about Moazzam's reply:

"X-distr.chain status is relevant for Sales organisation and if I maintain as you explained then It will impact to normal sales order as well and system will not allow me to create normal sales order also."

I would say that even though X-distribution status is relevant for Sales Organization but you would maintain the status for low value part in their material masters.

You need to define a 'Low value part' status under Logistics General > Material Master > Settings for Key Fields > Data Relevant to Sales and Distribution > Define Sales Statuses. Choose 'B' against 'Block f.returns' and rest all fields can be blank

Now, assign this Sales status to your material in MMR (Sales: Sales org 1) in conjunction with 'Valid from' date.

Now, while creating the returns for this material, you will get following error message and will not impact if same material you are using in any other sales document.

Regards

SD

Message was edited by: Samier Danish

[former_member182378 · Accepted solution]

Samier,

Nicely explained! Thanks!

TW

[former_member182378 · Accepted solution]

Samier,

What the sales document type for which you tested the RE process? (and got this error message)

Prashant,

Do you have custom (Z) RE order types and how many? Test if this works for your RE order types.

TW

[jobis]

Hi all,

Solution has been got for this question.. I have a doubt on the following

PRASHANT SHARMA wrote:


I don't want to use material listing/exclusion because once I use material exclusion then I have to make the list of all the material which can be sold through RE else system does not consider it.

If we use an exclusion list, is it necessary to maintain an inclusion list to make sales order for remaining materials..? For my understanding , its not required, we can exclusively maintain an exclusion list of materials as per the requirement.

Could anyone give more idea on this.

Thanks for your time

Jobi

[Former Member]

Hi Jobi,

Your understanding is correct. If we are using exclusion, we need to only maintain the materials which needs to be excluded.

Regards

SD

[former_member182378]

Jobi,

This is a perfect example where you could test and get the answer.

TW

[jobis]

TW,

I have tested listing and exclusion many  times in the past.  For that only I had posted my understanding here. Mostly in requirements as in the subject question here, we normally go for Exclusion, and since nobody has suggested it here in the beginning, but got into the material , I wanted to make sure my understanding was correct .

Thanks

[prashant_sharma21]

Hello Jobi,

As I remember few months back I tested Material Listing and Exclusion. I maintain a material XXX in material exclusion and did not maintain any Material in Material Listing. Later when I tried to create the sales order with another material (YYY) which was not exist nether in material Exclusion nor Material List. I was wondering system was throwing the error that material (YYY) is not maintain in material listing.

[jobis]

Hi Prashant,

I have experienced the same with material listing. It's with material listing. So, when you maintain a listing of materials, normally, for materials which are not in the list, when you try to create sales order, it will throw error, " material is not listed". So once you have a list, then you have to maintain list for all materials that has to be sold.

If you just maintain an exclusion list and no material listing (inclusion list), then you can sell all the materials which are not in the exclusion list. And you can assign the exclusion list to a sale doc type (Ex: RE).

Thanks

Jobi

[former_member182378]

Prashant,

With functionality Material Exclusion you are on the right track!

Condition records can be created at material level but these can also be created at material group level, it depends upon the condition table in your access sequence. Create a new condition table with fields: material group and document type. Then business needs to create only 1 record (material group, RE).

During return order creation, when user tries to create with the materials with this MARA-MATKL (material group) order will not get created and there will be a standard error message. This functionality will not affect any other process.

TW

[moazzam_ali]

Hi

For this you can go to material master data and Sales data 1 and create a Cross-distribution-chain material status. Create status with texct "low value part material" and block it for sales returns only. You can do this in Logistics General > Material Master > Settings for key fields > data relevant to SD > Define Sales statuses.

Test this and update.

Thank$

[prashant_sharma21]

Thanks MoazzaM,

X-distr.chain status is relevant for Sales organisation and if I maintain as you explained then It will impact to normal sales order as well and system will not allow me to create normal sales order also.

Thanks,

[moazzam_ali]

Hi PRASHANT SHARMA

No it won't impact normal sales. It'll work only for return sale order. Everything has explained by Samier Danish in details. Please test this in your system and update your findings.

I would say this is the most simplest solution you could suggest to your client.

Thank$

[former_member182378]

X-distr. chain status is at MARA level (not at sales organization level)

MARA-MSTAV

That mean if you set this for a material, then it will be applicable for all the sales organizations.

Prashant,

Does business have multiple sales organizations or company codes using the same material? Does business want to restrict Low value products in RE process only for some specific sales organizations and not for others? If yes, then I don't think this is the solution.

TW

[Lakshmipathi]

One simple approach comes to my mind is for those Item Category Groups assigned in material master, dont assign REN in VOV4 against RE.  Of course, this will not give the exact error message what you had indicated but it will definitely, prevent creation of return orders.

G. Lakshmipathi

[prashant_sharma21]

Thanks Lakshmipathi,

We are using Item category Group NORM for all the finish goods material (include normal parts and low value parts), if I don't assign combination RE + NORM + It usg+ HLIt Ca = REN it may impact to all those material which are also able for return.

If I define and assign new Item Category Group then I have to do lot of changes in system even though it does not fulfill my requirement.

Thanks.