Purchase requisition generated through mrp has decimal places, i need it to round off value..

[aninigade]

I have scenario in which I require 1 raw component for 1000 FG material. Raw material is procured in NOS. so in material master i maintained base unit as KG and in purchasing view order unit as NOS. So in BOM for 1 NOS of FG material i maintained 1 KG of raw material. this solve my reservation problem for Goods Issue.

But when PR is generated for raw material through MRP for less than 1000 NOS of FG material (suppose 800 nos) it takes decimal places quantity as 0.888 NOS . I maintained rounding profile in MRP1 as 0.001=1. still PR does not take round off quantity.

My requirement is I need round of quantity in PR. e.g. for 1 to 1000 kg of raw i require PR quantity as 1 NOS. for 1001 kg to 2000 KG PR quantity should be 2 NOS.

[Caetano · Accepted solution]

Hello

Is your Order Unit equal to the Base Unit of measure? MRP will consider the base unit of measure during the planning run, so the requisition will be created with not decimal places in the base unit.

If you are using a different order unit, then the value will be converted and then you may have decimal places again.
Regards,

Caetano

[aninigade · Accepted solution]

Hello,

yes. my base unit is kg. Initially I kept it base unit as NOS/EA. but for 888 NOS of FG material, reservation created in MRP taking round of value as 1 NOS but as per BOM it should be 0.888 NOS, It causes variance in costing. So I kept base unit as KG and purchasing order unit as NOS. And maintain conversion as 1000 kg = 1 NOS, now my reservation created is OK (e.g. 888 kg).

but when PR is created it has quantity in KG(e.g. 888 kg but when i convert PR to PO order quantity changes to 0.888 NOS). My requirement is that this PO quantity should round of to 1 NOS.

Regards,

Aniket

[rupesh_brahmankar3]

Hello,

Remove the rounding profile just set Rounding value = 1 in MRP1 view of material master.

Then rerun the MRP Planning mode 3-Delete and recreate and check the outcome.

Best Regards,

R.Brahmankar

[Caetano]

Hello

You may try to simply use a rounding value of 1, so that the requisition is always rounded to the next whole number, as mentioned by Rupesh, but make sure that the setting "last lot exact" is not set in the lot sizing procedure customizing (transaction OMI4).

Regards,

Caetano

[rupesh_brahmankar3]

Hello,

You might have allowed decimal places for unit of measure NOS in CUNI.

You can use rounding profile in the purchasing info record or in material master maintain Rounding value = 1

Or you can use the unit as EA- Each without decimal and then test the same scenario.

Best Regards,

R.Brahmankar

[aninigade]

Hello Caetano Almeida,

right. I kept rounding value as 1000 then it gives me correct PR as I want.. thanks for answer..

one more query is it possible if I keep Base UOM as NOS and issue unit as KG (1NOS= 1000kg), then reservation created through MRP should be as per BOM.

I tried with same scenario but reservation created through MRP is taking Round off value.

e.g. for 1 NOS of FG, I have maintained 1KG in BOM and conversion factor as (1NOS= 1000 kg in material master). If my production order is of 888 NOS then reservation created should be 888 kg, but it is taking as 1000 kg.

Regards,

Aniket.

[aninigade]

Hello,

yes. my base unit is kg. Initially I kept it base unit as NOS/EA. but for 888 NOS of FG material, reservation created in MRP taking round of value as 1 NOS but as per BOM it should be 0.888 NOS, It causes variance in costing. So I kept base unit as KG and purchasing order unit as NOS. And maintain conversion as 1000 kg = 1 NOS, now my reservation created is OK (e.g. 888 kg).

but when PR is created it has quantity in KG(e.g. 888 kg but when i convert PR to PO order quantity changes to 0.888 NOS). My requirement is that this PO quantity should round of to 1 NOS.

Regards,

Aniket

[Caetano]

Hello

This is the system standard behavior. MRP calculation will always happen according to the base unit of measure, therefore, it will always round up to the next whole number in KG.

An option here would be to round to the value in KG that is a multiple of NOS. For example, use a rounding value of 1000 KG, so that it is always rounded to 1 NOS.

Regards,

Caetano

[aninigade]

Hi,

After MRP run PR is generated,In MD04 I just double click on PR no. and click on convert to purchase order then this value comes..

[rupesh_brahmankar3]

Hello,

What is the quantity of purchase requisition?

Have you rerun the MRP Planning mode 3-Delete and recreate?

Best Regards,

R.Brahmankar

[rupesh_brahmankar3]

Hello,

When was this PO created? Has it been converted from purchase requisition?

MRP does not create PO it create purchase requisitions for external purchasing material.

If you have ran the MRP then check the outcome in MD04 of purchase requisitions.

That's why I requested you for MD04 screen shot.

Best Regards,

R.Brahmankar

[aninigade]

PO output

po.jpg

mrp1:

mrp1.jpg

[aninigade]

hello,

I checked with rounding value still it is creating PO with decimal places..

[rupesh_brahmankar3]

Hello,

Please share the screen shots of MPR1 view of material master and MD04.

Best Regards,

R.Brahmankar

[aninigade]

hello,

I tried with rounding value of 1 in MRP1 view, its not working.

also i maintained rounding profile(static rounding profile as 0.001=1) as mentioned in question but still PR quantity comes in decimal places.

in OMI4 settings check "last lot exact" is not set..