This website is not affiliated with, sponsored by, or approved by SAP AG.

Rounding conversion

Logistics : MM and its sub-modules (WM, IM, PO, LIS)

Moderators: Snowy, thx4allthefish, svetja, Ha Tran

Rounding conversion

Postby sapmmpp on Mon May 07, 2007 6:06 pm

I have an issue in the rounding values in the PR to PO Conversion.
I have a material with the following details:

Base Unit: KG
Order Unit: LB
71.701 lb = 32.523 KG

1. Minimum Lot Size: 198.672 KG
2. Rounding Value: 198.672 KG
3. Two palnned Orders for 794.688 kg and 198.672 kg were created.
4. Plannded Orders are converted to Purchase Requisitions.
5. Purchase Requisition for 794.688 KG is converted to 2189.985 LB (This is not the actual conversion, Should be 1751.988 LB) and Purchase requisiiton for 198.672 KG is converted to 437.997 LB

why is that the first purchase requisition for 794.688 KG did not
followed the conversion. Where as the other requisition for 198.672 KG is
converted correctly to 437.997 LB.
How is the rounding takes place in the PR to PO Conversion.
Right now we are not using the rounding profiles. We are having rounding value
for the material and it is maintained as 198.672 KG.

Can you please let me know.

sapmmpp
 
Posts: 300
Joined: Fri Feb 04, 2005 12:40 am

Postby Ha Tran on Mon May 07, 2007 7:25 pm

Hi,

Were these two POs generated to the same vendor?. Were these PRs for the same material ID?. Did you check if there is any either contract or info record being influencing to the problematic PO?.

Cheers,
HT
Ha Tran
 
Posts: 28123
Joined: Sun Mar 30, 2003 8:29 pm
Location: Perth, Western Australia

Postby sapmmpp on Sun May 13, 2007 9:49 pm

Hi HT,
Thanks for the reply.

I could find the following issue with rounding value for the following details:

1. Base Unit: KG
2. Order Unit: LB
3. Rounding value: 22.679 kg = 49.998 LB (As per the conversion defined).

4. Planned Order got created for 521.617 kg.
5. Purchase requisiition, Converted from Planned Order got created for
521.617 kg.
But when PO is created from PR, Instead of converting to 1149.969576 LB (Based on the definition), SAP is converting to 1199.968 LB.

This 1199.968 LB is 49.9984241 LB greater than the should be value of 1149.969576 LB.

That means SAP is rounding off to next value in the PR to PO conversion.
But this increase in order quantity will result in extra procurement. This is unwanted.

So please let me know how to make sure that in the PR to PO Conversion, SAP Doesn't rounds off to a next rounding value.

The same issue is happening to all other materials with the above settings (That is Base Unit: KG, Order unit: LB, Rounding value is KG).

Please let me know what can be done to prevent this.
sapmmpp
 
Posts: 300
Joined: Fri Feb 04, 2005 12:40 am

Postby Ha Tran on Mon May 14, 2007 5:14 am

sapmmpp wrote:Hi HT,
Thanks for the reply.

I could find the following issue with rounding value for the following details:

1. Base Unit: KG
2. Order Unit: LB
3. Rounding value: 22.679 kg = 49.998 LB (As per the conversion defined).

4. Planned Order got created for 521.617 kg.
5. Purchase requisiition, Converted from Planned Order got created for
521.617 kg.
But when PO is created from PR, Instead of converting to 1149.969576 LB (Based on the definition), SAP is converting to 1199.968 LB.

This 1199.968 LB is 49.9984241 LB greater than the should be value of 1149.969576 LB.

That means SAP is rounding off to next value in the PR to PO conversion.
But this increase in order quantity will result in extra procurement. This is unwanted.

So please let me know how to make sure that in the PR to PO Conversion, SAP Doesn't rounds off to a next rounding value.

The same issue is happening to all other materials with the above settings (That is Base Unit: KG, Order unit: LB, Rounding value is KG).

Please let me know what can be done to prevent this.

You have confused me already with your original posting as it was clearly said that out of two PRs, only one PR was wrongly converted. Besides, you have not confirmed if both PRs were raised for the same material ID. In addition, no clarification was made on if in regard to the problematic material ID, there is any available purchasing master data such as contract or info record.

Cheers,
HT
Ha Tran
 
Posts: 28123
Joined: Sun Mar 30, 2003 8:29 pm
Location: Perth, Western Australia

Postby sapmmpp on Mon May 14, 2007 10:23 pm

Hi HT,
Sorry for the confusion.
Yes, the PR's are for the same material and to the same vendor.
There is purchasing master data like Info record and contract.
Please do not consider my previous postings. I was also confused.

But please let me know about the below findings:
I had tested for various materials for the following data

1. Base Unit: KG
2. Order Unit: LB
3. Rounding value: 25 KG

When the planned Order is created for 25kg, Than the PO converted from PR is having an exact conversion. That is the Order quantity is coming to
55.1 LB.

But when the Planned Order quantity is the multiple of rounding value, Let say, The planned Order qty is 200kg, than the conversion is not correct.

In actual, For a PR Qty of 200kg, The PO Qty should be 440.8 LB (200 * 2.204). But the order quantity is coming as 495.9 LB (440.8 + 55.1 LB or 25 KG). That means there is an increase by the rounding value.

I had checked for various materials with different rounding values and the behavior is same.

When the planned Order qty or PR qty is same as rounding value, Than the PO Qty is exactly the direct conversion. But if the PR Qty is a multiple of the Rounding value, Than the PO Qty is increased by the rounding value.

Please let me know if SAP is designed this way
sapmmpp
 
Posts: 300
Joined: Fri Feb 04, 2005 12:40 am

Postby Ha Tran on Tue May 15, 2007 2:23 am

Hi,

Did you define the scaled condition?.

Cheers,
HT
Ha Tran
 
Posts: 28123
Joined: Sun Mar 30, 2003 8:29 pm
Location: Perth, Western Australia

Postby sapmmpp on Tue May 15, 2007 10:01 pm

Hi HT,
Ther are no scaled conditions.

For the materials which have an issue in the conversion....I am receiving an warning message "Order quantity voilates the rounding value"..Message no: ME 386.

This message I am getting for those materials whose PO order qty is increased by a rounding value.
sapmmpp
 
Posts: 300
Joined: Fri Feb 04, 2005 12:40 am

Postby Ha Tran on Tue May 15, 2007 10:54 pm

Hi,

How did you create your Rounding Profile? Was it defined as 'Static'?.

Cheers,
HT
Ha Tran
 
Posts: 28123
Joined: Sun Mar 30, 2003 8:29 pm
Location: Perth, Western Australia

Postby svetja on Wed May 16, 2007 1:46 am

Have you seen the OSS notes 301105, 154203, 207351, 328894 ?
Search before posting: http://www.sapfans.com/forums/search.php
svetja
 
Posts: 13942
Joined: Mon Oct 21, 2002 1:42 am
Location: Germany

Postby sapmmpp on Wed May 16, 2007 10:00 pm

Hi,
Thanks for replying.

We are not using rounding profiles. We are only using rounding value.

Today also I had checked that for a material with Rounding value 22.679 kg, If the PR Qty is 68.037 kg, The PO Qty came correctly according to the conversion factor ( 71.701 LB = 32.523 KG) defined as 149.953548 LB.

But, For another material, The rounding value is defined as 50 KG, PR Qty as 350 KG, But when converted to PO came as 881.6 LB instead should have been 771.4 LB.

Both the PO's are for the same vendor. They have the info record.
Both have the base unit as KG and the Order unit as LB.

For the material, Which is getting converted wrongly, There is a message "Order quantity voilates rounding value". Message NO:ME 386.

But for the material which is converted correctly no such message.

Please give your inputs on this.
sapmmpp
 
Posts: 300
Joined: Fri Feb 04, 2005 12:40 am

Postby svetja on Wed May 23, 2007 9:45 am

I tested your case and get exact the same as you have.
I think it is always based on the same problem: SAP recommends that the base unit should be the smalles unit, smaller as the alternative units; in your case the base unit is a bigger unit than the order unit.

In this case SAP has to convert back and forth. let me give an calculation example:
SAP uses this conversion: 71.701 LB<=>32.523KG
But the Lb is resticted to 3 decimals.
50 Kg will be 110.231221 lb which will be 110.231 lb rounded to 3 decimals
350 kg will be 771.618547 lb

Now SAP rounds like this: 771.618547 lb (reguested quantity in order unit) divided by 110.231 LB ( converted rounding value with 3 decimals )results to 7.0001403 .

7.0001403 is bigger than 7 , so SAP has to round up to 8.
And so you get the 881 lb instead the 771.

This is just an abbreviated form of the real conversion. But you can debug the programs to see that SAP uses this kind of way.
Search before posting: http://www.sapfans.com/forums/search.php
svetja
 
Posts: 13942
Joined: Mon Oct 21, 2002 1:42 am
Location: Germany


Return to Logistics MM

Who is online

Users browsing this forum: No registered users and 9 guests



This website is not affiliated with, sponsored by, or approved by SAP AG.