Net value calculation in pricing

[Former Member]

Hi Experts,

Net value in SO and customer gross in billing showing incorrect value

Base price inclusive of duty - 100

So excise base value u2013 90.66 statistical condition

ED- 9.07

ECESS- .18

SHECESS- .09

The issue is net value in SO showing 109.34 (1009.07.18.09) instead of Rs.100. The same value is passing in accounting for customer gross also. I need to arrest 9.07.18+.09 to be calculated in net value and customer gross account.

May you pls advise?

Regards,

Deepu Pillai

[Former Member]

Hi,

Try Maintaining ur basic price in VK12 as 90.66 rather than 100. the net total will come out to be 100.

[Lakshmipathi]

As already indicated, all your tax and CIN condition types should have "D" against the field "Condition Class". So check in V/06

thanks

G. Lakshmipathi

[Former Member]

Hi thank you for your reply.

If condition class is D, then system will post the value in tax. This means system wont show in net value field but show in tax field. Again customer recievables get wrong updation.

The amount i mentioned is all inclusive(ED, ECESS, SHE CESS). Hence the Duty break up shouldnt show in tax field or net value.

Regards,

Deepu

[reazuddin_md]

To achieve this, you have to do backward pricing, means- After entering Total value i.e.100 in your eg. You have to derive the base price.

like Total value ( Incl:Duty) = 100 = Base price + Duty( EdECSSHECess)

Assume Base price = X

100 = X + (10% of X)+(2% on 10% of X) +( 1% on 10% of X)

--- = X + (X/10) + (2X/1000) + (1X/1000)

Then , you will find Base Price i.e. Base price = (Total * 1000)/1103

If your Total = 100, then base price = (100 * 1000) / 1103 = 90.66

-

---

ED = 10% on Base price = 10% on 90.66 = 9.07 ( 2 decimal rounding)

-

---

ECS = 2% on ED = 2% on 9.06 = 0.18

-

---

SHECess= 1%onED=1% on9.06= 0.09

-

---

Total = 100( Price Incl:Duty)

So to achieve this you have to write new calculation routine & assign it in alt cal type.

( Create Statistical cond, type called "Total Price" & assign this cond type above the base price).

Note: Discounts have not been taken into account, if you want discount should be taken into account, then the base price you have to assign this New routine in "Assesble value" condition type)

Hope it helps.

Regards,

Reazuddin MD

[ajitsingh6]

Dear,

Please make your TOTAL VALUE in Pricing Procedure as given below,

Step Condition Type Discription From TO

10 PROO BASIC PRICE

20 ZPR1 BASE VALUE

30 JEXP E.DUTY 20

40 JECP E CESS 30

50 ZECP SE. CESS 30

60 PRICES 10

70 TAX VALUE 30 50

TOTAL 60 70

Regards

AJIT K SINGH

[Former Member]

Hi Deepu,

The conditions what u have mentioned are SD condition types means where the condition class is not "D". If the condition class(V/06) is "D" they will be considered as taxes and they will not be included in Net Value. So check whether u maintianing any repication of Tax conditions as SD conditons.

In some cases we maintian Tax conditions as SD conditions to post the revenues in our accounts rather than in Tax Ledgers.

Thanks

Prasad