costing lot size and price unit in material master

[Former Member]

dear gurus,

I created one finished product.in that i gave

costing lot size = 100

price unit=100

so the standard price = 6109

but while creating sales order, it is taking 1 unit price = 61.09??

can anyone tell me , what i need to do?

thx in adv...............

[Anupam1143 · Accepted solution]

HI

In your case if price unit =100 and is equal to 6109, then as simple mathematic says price of 1 unit or BUM is 6109/100=61.09 and the price for customer is maintained in VK11 which reflects in Sales order.

Regards

Anupam Sharma

[Former Member · Accepted solution]

Dear Rupesh and Anupam,

Thanks for reply.

I have attached screen for my issue.

how to resolve the issue??

thx in adv...........

[Anupam1143 · Accepted solution]

Hi

In Material master . since price unit is 1 so price is 61.09. while in running cost estimate you have given costing lot size as 100 then it becomes 6109.but material master will update only by 61.09 per unit. also in ck13n you can change the costs based on =user entry then enter 1 then you will get 61.09 as 1 pc price.

Check and revert

Regards

Anupam Sharma

[Former Member · Accepted solution]

Dear Anupam,

Plz tell some soln to resolve the issue......

what i shud do to get 6109 per qty.

thx in adv..........

[Anupam1143 · Accepted solution]

Hi

What is your BUM,system will update price according to that. if it is pc then system will update price per pc in MM whatever be your costing lot size.In your case it is NOs and your costing lot size is 100 Nos so standard cost per NO will be updated in MM after cost estimate run.

Check at your end and correct me if am wrong.

Regards

Anupam Sharma

[Former Member · Accepted solution]

Dear Anupam,

Plz check the screen shot and tell me what to do.

[rupesh_brahmankar3 · Accepted solution]

Dear,

Increase the price unit in the material master in accounting to the costing lot size of product costing. Currently it is one make it 100 and then try the same . I hope it will solve this issue.

Else I am not sure but please try Pass on Lot Size setting OKKN

You have to selecte costing variant for the costing run. The Pass on lot size indicator is set in this costing variant

Please refer this link for details,

http://help.sap.com/saphelp_46c/helpdata/en/b2/9d466f0e18d311ae620060b03c9bbe/content.htm

Regards,

R.Brahmankar

[Former Member · Accepted solution]

Dear Rupesh,

If i increase the price unit as 100, again am coming back to the starting point

is ter any soln to get out from this??

[rupesh_brahmankar3 · Accepted solution]

Dear,

Price Unit = 1 does not lead to any complications.To avoid the  rounding differences if you used for example materials having a low price and a high price unit. For instance, a price of 0.40 and a price unit of 1000 for the material are rounded to a price of 0.00 and price unit 1.

So better to go ahead with unit price as 1 .

Regards,

R.Brahmankar

[Former Member · Accepted solution]

Dear Rupesh,

Thanks for ur reply.

But if i make rounding rule ,

E.g: 61.09 leads to 62 only.

y the price is showing like this in mat master?

can u tell me some soln ??

thx in adv...............

[Anupam1143 · Accepted solution]

Hi

This is because of  decimal places defined in currency INR in Global settings.

Check in SPRO.

Regards

Anupam Sharma

[rupesh_brahmankar3 · Accepted solution]

Dear,

If you have the unit price as 1 or 100 it doesn't make any differences in sales order costing.

Apart form that just do small test If you have already taken the cost run for current period please delete it. After that maintain the Unit price as 100 save the material master and then take a cost run and try to update the price in material master.

Regards,

R.Brahmankar

[Former Member · Accepted solution]

Dear Rupesh ,

For Material Master it is no problem.

But the amount is gng to sales order.

what u said is,

100 unit = 6109

but if i do sales order for

1 unit = 61.09 will come.

but i want

1 unit = 6109

how to overcome?

[sundaresan_velayudam · Accepted solution]

for manufacturing 100 unit - 6109 rs

means

one unit =61.09 only

System will show one unit Price = 61.09 only  in VPRS condition

In PR00 you can maintain a Sale value

Dis you have any issue in costing/ value

one unit =61.09

[rupesh_brahmankar3 · Accepted solution]

Dear,

This requirement is quit strange and I don't think it is logical too.

Could you please elaborate this requirement?

Regards,

R.Brahmankar

[Former Member · Accepted solution]

Dear Rupesh,

I think some prob with BOM.

in BOM i have maintained 24KG,but in costing run it is taking 0.24kg?

[former_member1042151 · Accepted solution]

Have u checked your BOM Base Quantity??

[sundaresan_velayudam · Accepted solution]

Check the base qty in BOM Header

It will be 100

for 100 qty of Header material

it requires

if the base qty is correct (1)

then check the user parameter in SU3

Decimal Notation

Is the decimal notation is as per your country standard

generally for india   decimal notation  is  1,234,567.89

for us  1.234.567,89

[Former Member · Accepted solution]

Dear Sundar,

both are correct.

is ther anythg missing?

[sundaresan_velayudam · Accepted solution]

is the base qty is 100?

Means no problem in BOM

Then cost of Goods Manufacture for your product is 61.24

In sale order in VPRS condition system will update 61.24 only

[Former Member · Accepted solution]

Dear Sundar,

In BOM am using 24 KG RCPAD.

But in Costing Run it is showing = 0.24 KG.

[Anupam1143 · Accepted solution]

HI

In BOM if your base qty is 100 and your costing lot size is also 100 then it will show as 24 kg but when you do your costing lot size as 1 as in CK13n then it will be 24/100 as shown by system.

Regards

Anupam sharma

[sundaresan_velayudam · Accepted solution]

Dear,

  Yes for costing run of 1 qty system is taking the Value as  0.24

If you check the BOM base qty in Header it would be 100 qty

so that for 100 qty of header  RC PAD requirement is  24.010

for  1qty as per the  ratio RC pAD requiremny is 0.240

If the base qty of header is 1

Then check the SU3 setting

[former_member184655 · Accepted solution]

Dear mmboy,

Can you post the BOM base quantity for this material's BOM?By seeing the screen shot,I guess the

BOM base quantity must be set as 100.

Check and revert back.

Regards

Mangalraj.S

[Former Member · Accepted solution]

Dear Mangalraj,

can u plz tell me, how to make

1 no = 6109 in sales order?

[former_member184655 · Accepted solution]

Dear mmboy,

When comes to standard costing of a product,its purely based on the lot size defined in the

BOM,BOM components quantity ,routing and the overheads defined.

In your case since the BOM defined is for a base quantity of 100,then when the cost estimate is

carried out for costing lot size of 1,then the system calculates the BOM components and its value

accordingly,since the BOM base quantity is equal to 100.

There is no logic in just expecting for a quantity of 1 the price has to come as 6109 in the sales

order.

If the BOM defined is for a base quantity of 1,then the value will be coming automatically as 6109.

Other than this I don't think there is some other possible means.

Regards

Mangalraj.S

[sundaresan_velayudam · Accepted solution]

Production price is 61.09 means

in sale oder system will show 61.09 only in VPRS condition

If the 61.09- cost of goods manufacturing  price is wrong

Then check with your client planning department and get the correct BOM details

[Former Member · Accepted solution]

Dear Mangalraj,

Thank u so much for ur reply.

For my scenario, shal i make the BOM base qty as 1?

Am closing this thread after ur answer.

[Anupam1143 · Accepted solution]

Hi,

In my understanding, In any case system will update Standard price per BUM as 61.09. when you do BOM base qty as 1 then again accordingly your components qty will change that will lead to again change in standard cost, so its better to ask your client PPc and costing deptt for per BUM price and do the setting accordingly.

Regards

Anupam Sharma

[former_member184655 · Accepted solution]

Dear mmboy,

In order to bring or in order to make the product price in the sales order as 6109,you should not

change the standard BOM (used for MRP,Production,costing) base quantity or the BOM component's

quantity which is not the correct practice.As per your master data setup the system derives the cost

values.

So I don't agree in changing the BOM base quantity in your case.

Regards

Mangalraj.S

[rupesh_brahmankar3 · Accepted solution]

Dear,

Base quantity of BOM will be applicable for all components if you have the problem with one BOM component then change  quantity or price of that item it self to get correct costing. If you change base quantity of BOM so you will have incorrect component quantity order for all BOM components. So if you have correct quantity of component in BOM with base quantity as 100 then please don't change it.

Apart form that this cost will be for standard cost for this finish product. For sales order please have look on your condition type and access sequence unit price and value.

I hope that will solve your issue.

Regards,

R.Brahmankar

[rupesh_brahmankar3]

Dear,

Costing lot size and price unit will be useful fro costing purpose. For sales order it will be driven by condition type.

Go to V/06 check condition type setting there.

You can maintain selling price in material master.  Select Sales: sales org.1 view there there is a field "Conditions".

Regards,

R.Brahmankar

[Former Member]

Dear Rupesh,

Thank u so much for ur reply.

but in sales order it is taking, the cost of  100 units = 6109 & 1 unit = 61.09

i dont know , what to do

[rupesh_brahmankar3]

Dear,

Please check the condition type in sales order and price unit setup for that condition type VK11 also check sales UoM tooo

Regards,

R.Brahmankar