Purchasing Raw materials in different packaging size

[Former Member]

Hello,

We have a scenario where we procure materials in different packaging size (25kg bag, 50 kgs etc) from different vendor.

Different packaging size has different rates. Presently while creating PO's we enter the rates manually and change the description of the material in PO.

Please suggest is there any functionality in SAP wherein we can select required packaging size and system picks up the respective price in the PO.

Waiting for a reply.

Thanks in advance.

[Prasoon · Accepted solution]

Hi,

   If you can maintain different order UOM for 25 kg, 50 kg etc, it will be easy. You may go to CUNI transaction and create new order unit for 25kg bag (say 25K) and new order unit for 50 kg bag (say 50K). Now, in material master - purchasing view, you can maintain order unit as any of the newly created order unit and maintain the variable order unit as 2 (Active with its own price).

   Now, go to the info record in ME11 / ME12. Maintain the variable order unit as 2 and then click on conditions tab. Now, system will ask you the order price unit. Thus, you can maintain the order price based on this unit and the same will be reflected in PO. If you want different order unit in PO, maintain the corresponding order unit in info record or change it in PO manually. In both cases, price will be defaulted, if its maintained in info record correctly.

Regards,

AKPT

[Former Member · Accepted solution]

Hi AKPT MM,

Thanks for your reply. I think this would be a good option.

I tried replicating this scenario with existing UOM in system.

I maintained the material master for Var.Or.Unit as "2"

Maintained the Info record as "2" and maintained the different rates in the conditions for different Order unit

But while creating PO rate is being picked from the Order Unit in Info record. If i change the Unit manually in the PO it does not pick the new rate.

Please help.

[Former Member · Accepted solution]

While consumption of raw material for different packaging material is the rate same for your final FG or it differs based on Raw material consumed against your production order.

Better you need to have separate Material codes based on different sizes.

[former_member183424 · Accepted solution]

It will work.

Check the info record correctly..

Can you see the both unit of measure in Info record, when you click on Condition tab..

Suppose you are using BAG and KG,

You can see the two OUM when you click on the condition tab.

Click on one by one and maintain the price for condition type PB00.

1st double click on BAG, then maintain the price

Then press back and click again on condition and maintain the price for KG

Also check the validity period.

It will change in PO, which you have maintained in info record.

[Former Member · Accepted solution]

Hi Dev Patra.

I have checked and all the above you mentioned have been correctly maintained.

But while creating PO, system by default take the rates of Order unit maintained in the General Data tab. Once changing the Order unit in PO, the respective rates do not pick. Is there anymore settings required ?

[ashish_tilak · Accepted solution]

Hi Shailesh,

How about making material batch managed; attaching a Variant class (300)?

Keep the base unit in KG (or TO).

Then maintain info-record for each vendor (as you said, each vendor will supply different sizes, so basically you are maintaining a size wise info-record).

While creating PO, the purchaser will input size as batch number (for e.g., "25KG" / "50KG" etc) in PO itself.

GR will be posted with same batch as PO:

you can obtain Stock (and all other reports) batch-wise:

Just give this a thought...

Regards,

Ash

[former_member183424 · Accepted solution]

Share the condition tab setting's screen shot.

I am sure something happens wrong in there.

I am doing this, its working perfect.

Its for BAG

Its for KG

Share the screen shot like this.

Message was edited by: Dëv Päträ

[Former Member · Accepted solution]

While consumption of raw material for different packaging material is the rate same for your final FG or it differs based on Raw material consumed against your production order.

Better you need to have separate Material codes based on different sizes.

[former_member183424 · Accepted solution]

Please check the blog, and maintain the price as it is maintained in this blog.

FYI

Create Info Record for different Order Unit

[Former Member · Accepted solution]

Hi Dev,

Thanks for the information and blog.

I have done all the similar settings in MM & Info record. But unfortunately prices are not changing in the PO w.r.t. Order unit. I guess some config is required in price determination. Can you please help what am i missing.

[former_member183424 · Accepted solution]

There are no other configuration at all.

That's all which I have mentioned in my blog.

You can share the screen shot for info record-condition tab, so that We can see the difference.

Same as I have shared in my previous comment.

[Former Member · Accepted solution]

Hi Shailesh,

As per my understanding you will be receiveing the item in bags of different weights ( in KGs ) if I am not wrong. If it is the requirement, could you please test the scenario by maintaing Scales with unit of measure as KG?

for example:

1-25KG = X price

26 - 50KG = Y price..and so on..

Just an idea..hope it might be helpful...

Regards

Sesha

[Former Member · Accepted solution]

Hi Dev, Please see the below screen shots and advise

[former_member183424 · Accepted solution]

When you entered the all information in PO, Is the price for default order unit is coming as your info record?

Like I can see you have used KG as default order unit, When you create PO, then the order unit will be KG,

Is the price comes automatically for order unit KG with regards to info record?

Just do one test, change the order unit in info record, then create a new PO.

[Prasoon · Accepted solution]

Hi,

   Go to MEK3 transaction and insert the condition type PB00 and press enter. Select the key combination and press enter. Now, enter the vendor, material, purchase org and plant and execute. Check whether both the prices are displayed there with order unit.

   Please check whether the price is maintained correctly along with correct validity date. Please check the same.

   Now, create a new PO for the material and plant and vendor combination. The order unit maintained in material master - purchasing view (as shown below) will be defaulted in PO along with the price maintained in info record for the order unit.

   Change the unit manually to any other alternate unit. Now, the system will bring the price in PO as maintained in info record (and as shown in MEK3).

   Please check and revert back.

Regards,

AKPT

[Former Member · Accepted solution]

Hi APKT,

Yes i have seen the MEK3 transaction and i can see both the rates there with PB00.

Still when i am trying to change the Order unit, rates are not picking automatically.

[Former Member · Accepted solution]

Hi Dev,

Yes the default order unit is coming in the PO along with the price.

Also i changed the Order unit in the Info record and created a new PO but on changing the Order unit manually, rates are picking automatically from the info record. Really dont understand why is this happening.

[former_member183424 · Accepted solution]

In MEK3, Is there any price exists for order unit??

What is your key combination?

Amount field will be 0. Rate will be only in info record.

[Former Member · Accepted solution]

Hi Dev,

Below is the MEK3 screen for key combination.

I can see the amount though.

[Prasoon · Accepted solution]

Hi,

   This seems fine. Could you please check whether any custom development /user exit is preventing the standard functionality? You may debug and find it.

   Alternatively, please share your SAP release with EHP version.

Regards,

AKPT

[former_member183424 · Accepted solution]

Your setting seems absolutely okay.

Which access sequence you are using for PB00??

is it 0002?

[Former Member · Accepted solution]

Hi Shailesh,

Just a small question. As you said that you have changed Order unit, but still the problem exists. While creating PO if you change the order unit in PO, are the prices picking correctly as per the info record? I have run the scenario with another example and it seems to be clear for me.

Regards

Sesha.

[Former Member · Accepted solution]

Hi Dev,

Thanks a ton. The issue is resolved.

Regards,

Shailesh Panchal.

[JL23]

If the size matters, then you have to use different material masters per package size in a core ERP system.

Often the package size of a raw material that is just used internally as a component for production does not really matter. And it is just usual that one vendor may deliver it in a bag with 25 kg and another one in a bag with 30 kg. if you use different material numbers per size, then you need to have those material numbers as well in your bill of materials and they will be used in MRP, so it will then not be easy exchange from one material to the alternative in a different size.

There are many pros and cons for and against a common number in case of raw materials. e.g.  numbers could lead to an increased inventory of that product.

if you could explain why you need different sizes, then there may be alternative solutions.

e.g. you could use contracts which have different items per size with an individual price.

[Former Member]

Hi Jurgen,

Thanks for your reply,

Different sizes of a particular raw material is procured from different vendor depending upon the requirement of the month. Moreover different pack size comes with different rates. For e.g 25 kgs cost differs from 1Ton Bag or container. Hence for audit purpose for the purchase department they need to know how many 25kgs bag have been ordered and how many 50kgs or 1 Ton ordered etc.

[Former Member]

Hi Shailesh,

I think only in AFS solution you can differentiate material using grid in the Material master.

For example you can differentiate the size as 25 , 50 and 75. Otherwise you create separate master record for each material in short text you can differentiate the size.

If you want price to pickup in PO, you have to maintain info record for vendor,material combination in

ME11.

Hope this is helpful.

Regards,

Subbu.

[former_member182489]

Could i know - The Material Type used  and does your material has value ?

[Former Member]

Hi,

      You should open different material code for different packging size as description will be changed for each size.

Regards

Abhishek Tiwari

[former_member183424]

Why don't you use different material for different description.

Or you can use different material group for different types of material description..

For auto price picking, you can use info record and for info record, you have to use material or material group.

[Former Member]

We cannot use different material as those materials are used in the BOM for backflushing. Hence it will not be advisable to change the BOM frequently.