Price Rounding

[Former Member]

Hi Gurus,

Basic Price PR00- rounding up 1 Rupee more.

And similarly for JCEP and ZSEC its rounding 1INR less.

It is behaving strangely. In one case, it is calculating all values perfectly. Second case only Ecess is rounding 1INR more and Third case, Basic Price is Calculating 1 INR More and Cess is calculating 1 INR Less.

I have checked the various posts and even tried to capture the difference amount.

Step Condtpe Description From To Subtotal Reqt Calculationtype Bas type

100 PR00 Basic Price

101 ZDIF Differential Price 100 13 16 2

105 ZCAD Less:Cash Dis@ 5% 100 17

110 Assessable Value 100 105

200 JEXP Add BED@ % Advalorem 110 17

300 JCEP Add: CESS @1/8% 110 17

310 BED+CESS 200 300

350 JECS Add: Educess@2% 310 17

352 ZSEC Add: S/H Edcess@1% 310 17

400 Assessable Value 110

410 JEXT IN A/R BED total 200

412 JCET IN A/R CESS total 300

414 JECT IN A/R Ecess TOT 350

418 ZSHT IN A/RS/H Ecess TOT 352

420 Gross Total 400 419

430 ZOTH Less:Oth Dis Rs450/T 420 17

500 TAXABLE VALUE 420 499

570 JIVC ADD CST @ 2% 500 17

580 JIVP ADD VAT @ 4% 500 17

590 ZINS Add:Insurance @0.11% 500 580 17

591 Final Invoice Amount 500 590

Please correct me.

Thanks in Advance.

Sri

Edited by: Sri on Nov 25, 2008 12:38 PM

Edited by: Sri on Nov 25, 2008 12:42 PM

[Lakshmipathi · Accepted solution]

Dear Sri

I have gone through the attachment sent to mail and I would like you to check whether you have done the following:-

For the net value field, you need to give Routine 16 in the Alt. Cal. Type in the pricing procedure. Addition to the above setting, add Routine 17 to Netvalue in your Pricing Procedure.

Additionally, in table T001R such rounding data should be maintained. For this goto SPRO - SAP NetWeaver - General Settings - Currencies - Define rounding rules for currencies here maintain: Company Code + Currency = 100

Have you done all these. ??

Also in the attachment sent, I have observed that you have not assigned routine 1 in "Subtotal" for PR00 which we normally used to have that. Knowingly you have done this or by oversight, it is missed ??

thanks

G. Lakshmipathi

[Former Member · Accepted solution]

Dear Lakshmipathy,

I have gone through your post now.

As per that:

A. I have maintained in Table T001R.

B. I have to maintain Routing 16 for NetValue Field in Alt.Calculation type and Routine 17 for NetValue in Pricing Procedure

give me some more clarity on this.

C.I have forgotten to Put 1 in Sub total for PR00.

And the major problem We are facing is like this:

All the Conditions are Item Conditions and and in the concerned Condition types for BED, CESS,ECESS and SECESS, I have maintained the rounding rule as Commercial. And in the Pricing Procedure 17 Routine in Alt. Cal.Type.

So it is rounding at Item Level this way:

Item 1. Ex: ECESS 173.25 rounding to 173

Item 2. ECESS 173.25 rounding to 173

Item 3 ECESS 173.25 rounding to 173

So overall when we look at Header level, there will be loss of 1 Rupee for Excise people, which they wont accept.

How to overcome this problem.

Thanks in Advance

Regards

Sri

Edited by: Sri on Nov 26, 2008 12:22 PM

[Lakshmipathi · Accepted solution]

Dear Sri

In fact, rather applying routine 17, why dont you try with routines like 366, 367 which are India specific routines meant for Excise. Right now, I dont have access to SAP, I could not go through these routines and hence, am unable to provide additional information.

thanks

G. Lakshmipathi

[Former Member · Accepted solution]

Dear Lakshmipathy,

I am very sorry for late reply due to various reasons.

Coming to the 366 and 367 routines.

When I used 366 routine, its not rounding and actual values ex: 345.32 is shown

and with 367 routine the excise values are becoming Zero.

Thanks & Regards

Sri

[Former Member · Accepted solution]

Hi All,

Thanks for your valuable inputs.Our client finally agreed to go with Price Difference account. So the issue of Rounding is resolved. And special thanks to Laxmipathy for the same.

Thanks&Regards

Sreekanth

[Lakshmipathi · Accepted solution]

Happy to see that atleast you had the courtesy to update the forum which is missing from many members

By the by, please ensure that the names are spelled correctly

thanks

G. Lakshmipathi

[Former Member]

hi sri,

iam not talking about header conditions, in item conditions, u check the header condition.....for this u will be having access sequence na....

regards,

ram.

[Former Member]

Hi Sri,

You can solve this problem in two ways,

1) in condition type details , group cond.tab page, round diff comp. , field, if u check that field , the difference between header and itemwise will be added to the largest item.

2) in the condition type , check the header , uncheck the item, so that the header value will distribute to all the items.

i havent tried it, but hope u will get the solution.

regards,

ram.

[Former Member]

Hi RamPrasad,

It wont work, as Header conditions you will not have access sequence. It is condition record based item conditions.

Thanks

Regards

Sri

[Former Member]

HI SRI,

TO BE MY KNOWLEDGE, ITS BCOZ WE WILL GET THE DIFFERENCE IN HEADER ROUNDOFF AND ITEMWISE ROUNDOFF.PLZ CHECK IT.

REGARDS,

RAM

[Former Member]

Dear RamPrasad,

Thanks for your answer.

It is only the problem.

Tell me how to proceed now to address the same.

Thanks&Regards

Sri