Skip to Content
0

How do I tell if a material has been blocked for selling?

Jan 26, 2017 at 10:37 PM

56

avatar image

Is there a view or report that will tell me all the materials that have been blocked for selling?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Shubha N R
Jan 27, 2017 at 04:51 AM
2

Hi Jerry,

Adding to Arun's answer as a work around it is possible to look the Sales and Purchasing status of Materials using the Mass Change functionality following the steps below

1.Go to Product Data work center and select materials view
2.Select a certain amount of Materials that you want to see (use the key SHIFT from your keyboard to select a large range)

3.Press the button Mass Change.
4.On tab General you will find the Purchasing status of the Materials
5.On tab Sales you will find the Sales status.

Regards,

Shubha N R

Please mark this thread as answered, if it is helpful.


2rhmj.png (126.7 kB)
Share
10 |10000 characters needed characters left characters exceeded
Arun Mavinahally Lakshmikantha
Jan 27, 2017 at 04:27 AM
1

Hello Jerry,

If a material is blocked for Sales or purchasing, it will throw an error message while creating Sales Order / Purchase order.

Error - Item X: Product ABC not valid; it is blocked.

Coming to the reports, the below data sources will provide the material information's on each tab & hope you can use it.

MAT_GENERAL - Provides material general data and UoM characteristics

MAT_GENERAL_MULTI - Provides material general data and UoM characteristics with multiple lines

MAT_PLANNING - Provides Material Planning Data.

MAT_LOGISTICS - Provide material logistics information

MAT_PURCHASING - Provides material purchasing data.

MAT_SALES_GEN - Provides material sales general data

MAT_VALUATION - Provide material valuation information

Can you please try to create a report based on these Data Source and try if you get the relevant information?

Best Regards,
Arun ML

Please mark this thread as answered, if it is helpful.

Share
10 |10000 characters needed characters left characters exceeded