PGI Error "Material must be represented in UoM of Box"

[prakash_parikh]

Dear Experts,

I have Base UOM KG in Material Maser. Sales unit is Box (BX). Delivery unit =Blank. In additional data 1 BX= 10 KG is maintained.

If my salesman put sales order in KG (not as BX sales order unit maintained in SO), Delivery is in KG and PGI gives above error message.

"Material must be represented in UoM of Box"

System Response

Prevents saving of record

Procedure

"Please change to the appropriate containerized UoM

DOT regulations requirethe hazardous material to be listed on the

BoL to show the number of containers"

There is no WM managed system so no picking required. I could see in delivery pickied qty is showing 00

While for some other material its working finr. Thus material tyoe is ABF Waste Product sold out.

If I put sales order in other UoM, should not delivery be created in BX But here its in KG.

What am I missing here? I know we have to change delivery unit as BX then PGI could be done. Is there any standard functionality? Or userexits required?

This system is  old done so I do not have any idea if Ztype program is made. Error message is ZZ0909

Please suggest how to resolve this.. Appreciate your valued time

Thank you in advance.

[prakash_parikh · Accepted solution]

Dear Experts,

I need soluion so that if user enter any unit of measurement other than Sales Unit (BOX-as maintained in MM), it should automatically convert into Sales Unit. No manual changes allowed. OR

How to prevent sales order to save if user do not enter Sales Unit and error message should pop up "please enter Sales Unit of Measurement as "BOX" I think I should write logic in UOM in Sales Order that if UOM is other than Box throw error & get pop up Error Message and sales order can not be saved. Please suggest in detail if you know this is workable.

I tried in this way but did not work.

Go to V/06 --> select your condition type --> click at details --> in the calculation type --> Maintain " C - Quantity" --> in the control data of same screen --> check the box "quantity conversion"

Now create the condition record VK11 for the same condition type (ZR00) with new UOM as KG (New UOM which is entered by the users) But its not helpful.

Thanks Prakash P.

[prakash_parikh · Accepted solution]

Can we do incompletion log? Yes it can stop order from savings. But it will not automatically convert any unit of measure to Sales Unit.

My requirement is to convert automatically any od unit of measure to Sales Unit only. So please suggest process step by step if anyone has idea.

Thanks

[former_member184080 · Accepted solution]

Hi Prakash,

Have you tried checking  Variable Sales Unit Not Allowed under Sales: Sales org :1 of your material master. It is next to sales unit. If you check this system will not allow other than sales unit maintained in material master

I hope this is what you are looking for.

Regards, Sai Krishna.

[prakash_parikh · Accepted solution]

Hi Sai Krishna,

Yes you are right. Just mark checkboxin MM02 and sales order is giving error message if wrong UOM is used. I have rewarded points to you please confirm.

I appreciate all other experts for your valued inputs with which other functionality I came accross to use & will be helpful to allreaders as well.

Thanks

Prakash

[former_member184080 · Accepted solution]

Hi Prakash,

Happy to hear that your issue has been resolved and got the points as well.

Regards, Sai Krishna.

[Shiva_Ram · Accepted solution]

Once I get resolved I shall publish remedy and also award points.

I have rewarded points to you please confirm.

Please avoid these kind of statements, in the forum postings. Many of the members posting in the forum are volunteering their time and trying to help others. Indicating a response as helpful answer/resolved would help other identify which response, helped to resolve particular issue. So don't further ask for confirmation/provide offerings. Try to help the forum to be a professional place. If you feel that you have got help from others, then you can also try to contribute/share knowledge in the forum. I feel that is proper appreciation of others work.

Regards,

[prakash_parikh]

Hi Sai Krishna/Warren,

Many thanks for prompt reply. In MM02 I checked No unit of issue is maintained. I also tried to put Box as unit of issue but not taking Box in delivery.Only if I put manually Box in delivery then can do PGI. I need to convert from KG in sales order to Box should appear in delivery.

Yes its hazardous material and seems user exits which prevent further conversion of UoM. I have requested ABAPer to check enhencement and once he reply I shall post the outcome. Many thanks for your valued inputs.

Thanks

Prakash P.

[former_member184065]

Dear,

I request you to Debug the Transaction VL01N  .You should get exactly whats the Problem and from where it is coming easily find out .

Thanks,

Naren

[prakash_parikh]

Hi Warren/Narendra,

I have requested ABAPer to debug in SE91 for delivery as some program might be stopping conversion of UoM from conversion of KG to Box.

Quick question-->If we use Sales Unit (in MM) as Box is it mandatory to put as Box in sales order? Should we remove Box as sales uniot? But client is saying no. Any other thoughts?

Appreciate for your quick reply. I shall inform the outcome of debugging soon.

Thanks

Prakash P.

[former_member184080]

Hi Prakash,

If i understand your question: You are going to keep BoX as Sales UoM in Material master. Now, in SO, if you change the UOM from BoX to Base Uom, does system allow you are not? Yes, system will allow you to change it.

You can try in your client quality system you will get to know the results.

But check how the prices are getting determined in your SO. Please cross the condition values.

Regards, Sai Krishna.

[Shiva_Ram]

You can easily find answer for your question by just doing a test in the system. Alternatively, you can also read the help by pressing F1 button on the field sales unit in the material master. The use portion of it clearly indicates the sales UOM can be changed in the transactions/events.

Regards,

[prakash_parikh]

Hi Sai,

If I use Base Unit it is working This is not the issue.

I need other UoM which is neither Box nor KG. That unit should work.

During debugging I found that for Non Hazardous Material (T code DGP2/3) in Classification tab under heading "PERMISSIBLE" Non-DF Full is marked as "X" means Non Dangerous Goods" Bottom of this check box is Non-DG Empty is also marked "X" means Non Dangerous Goods"

Whilst for dangerous goods its Blank. So conversion of UoM is not happening. Now E&HS group maintain Material Master Data. So they can not change it as per statutory requirements.

I am now trying to put in check box another word as "D" = dangerous goods and apply same logic as X may work.Any other suggetions?

Thanks to all especially Sai & Warren,Once I get resolved I shall publish remedy and also award points.

Prakash

[prakash_parikh]

Hello Sai/Warren, & Experts,

Now there is issue with users. If I put UOM Sales unit as Box and check mark in MM Variable Sales Unit Not Allowed under Sales: Sales org :1 of material master for Dangerous Goods its only working for Box. User says that sometimes they also sell less than a box say half quantity of box i.e. in KG. So billing should be in KG & not box as customer wants to know what is price per KG and how much they bought..

There is userexit progrm in Tcode DGP2 which is maintained for DG material master. So here we have to get solution in DGP2 in classification tab under heading "permissible"there is value "X" means non-dangerous goods which allows conversion of units. For dangerous goods it is blank so UOM is not allowing conversion and exits the programme. Master Data team informed thaat they can not change this field. So what change is required in the program so that UOM is done & for DG UOM should convert? Any suggetions for this ABAP program as I do have little knowledge on this subject.

[Former Member]

Thsi message is going to come possibly from a userexit.

Goto SE91 and enter you message ID and number and then do a "where used" search and then contact your ABAP specialist or the user manual / BPP.

Regards

Waza

[former_member184080]

Hi,

Seems to be its a hazardous material. Please check your WM view for your material and see if any unit of issue is maintained.

y looking at your message, seems to be its Z message, there could be an enhancement done for your client. Please sit with your ABAPer and see if any enhancements exists.

Let us know if you need any help on this.

Regards, Sai Krishna.

[prakash_parikh]

Hi All,

In DGTMD table field DGNHM is set to X for non-hazardous material so it is converting UoM.

Hazardous material is not set to X so logic will exit out and UoM is not working as per ABAPer.

DGNHM is Non-dangerous goods. So I believe DG goods can not be set to X

So what could be solution now?

Thanks