Price(Net Value) Caluculation at Sales Order

[Former Member]

Hello Experts,

We have requirement as shown below, I have calculated price & discounts

But calculation haven’t done (9794.87)

Example:

PR00-11600,

Discount-80 & 60(Cash & Other),

=11600-80-60=11460.

Calculation=11600-80-60/1.17= 9794.87,

Tax=9794.87*17%=1665.13,

Net value=9794.87.

Tax=1665.13.

If I derive the (9794.87) I will calculate the tax based on (9794.87).

Kindly help me on this, I will be appreciated.

Are there any possibilities in standard?  Because I don’t want to use customized routines or requirements.

Thanks in Advance.

Regards

Shankarappa H L

[Former Member]

Hi,

I think you can try to use tax condition type MWSI,not MWST to realize it.

[Former Member]

Hi,

Thanks for replay. Using condition type MWSI, How can we do the below calculation?

Calculation=11600-80-60/1.17= 9794.87,

[bsivasankarreddy_reddy]

hi

what is the Value of 1.17 , pl explanin

[Former Member]

Hello Reddy,

1.17 is the value which i wanted to be used for dividing the after discount value (11460).

Example: After discount value 11460/1.17= 9794.87

or

Please help me,how can i get the net value (9794.87), If you have any other ways please let me know. But i should get the net value as 9794.87 based on this value i need to calculate the tax.. I hope you understood.

Thanks in Advance.

[Former Member]

Hi,Shankarapp:

I have do your requirement in my IDES system,You can take this as reference:

Result like below:

and the pricing procedure used is below:

i just test it roughly,I think you can adjust them according to your customer requirements.

It is a typical price including tax scenario.

[Former Member]

Dear Fengwei,

Thank you so much replay. But how you got the value 9794.87, have u maintained value directly in the sales order or its automatically determined? if Yes how its got determined. For same thing already tried manually, but i don't want manually , its should come automatically 9794.87(1.17).

Regards

Shankarappa H L

[Former Member]

Hi,Shankarappa:

Yes,of course it is calculated automatically,It's value is calculated by Routine 25(KZWI1 minus tax);

In my pricing procedure configuration:

KZWI1 is the sum of (Gross value + Discount amount) ;

and tax is save in KOMP-MWSBP by Subtotal 10 .

[Former Member]

Dear Fengwei,

Thanks for information, but i have done the pricing procedure setting as like you have done.

but net value is 9654.87 & tax is 1948.20, but it should come as 9794.87 and tax is 1665.13.