Condition Round Up Issue

[former_member287204]

Hi Experts,

For the Selling Price / Purchase Price, suppose SAP is getting 2 decimal places by default, like a SO example as below -

SO#	Item	QTY	Req. Price	Req. Amt	Price in SAP	Per	Amt in SAP
4202421	10	1008	0.613	617.904	613	1000	617.90
4202421	20	1008	0.613	617.904	613	1000	617.90
4202421	30	1008	0.66	665.28	66	100	665.28
Total				1901.088			1901.08

For the above SO example, Price of items 10 & 20 is 3 decimal places but it is already round up in item level of SAP for 2 decimal places. Compared with the Total of Req. Amt and that of Amt in SAP, the Amt in SAP will be less $0.01.

Accoding to other threads like below, decimal place can be changed for currency in config. (e.g. OY04) but it might invlove large impact in the whole system if the currency is alrady in use -

http://scn.sap.com/thread/3353179

Therefore, could you advise the simpler way to solve our above issue ?

Many Thanks,

KH Fong

[Former Member]

Hi,

Please check Calculation type in your pricing procedure with condition type it should be 17 Rounding as per T001R.

Regards,

Vikas

[Lakshmipathi]

Please post your thread with either a different font or bigger in existing font size as it is very difficult to go through your post.

Coming to your requirement, please clarify what do you mean by "Req.price" and "Price in SAP".   How you have maintained your pricing condition ?  Is it per 1000 ?  

G. Lakshmipathi

[former_member287204]

Dear G. Lakshmipathi,

"Req.price" means the price for customer (not inputted in SAP).

"Price in SAP" means the price actually inputted in SAP.

"Per" means price unit inputted in SAP.

Also, some amendment on my above example -

SO	Item	QTY	Req. Price	Req. Amt	Price in SAP	Per	Amt in SAP
4202421	10	1008	0.613	617.904	6.13	10	617.9
4202421	20	1008	0.613	617.904	6.13	10	617.9
4202421	30	1008	0.66	665.28	0.66	1	665.28
Total				1901.088			1901.08

Pls let me know if you need more info. on this.

Tks,

KH Fong

[Former Member]

Hello,

Check the rounding rule for condition type in SAP V/06

[eduardo_hinojosa]

Hi

Try with the VOFM formula 017 (table T001R)  for rounding up the amount. See also SAP Note 80183 - Rounding

I hope this helps you

Regards

Eduardo