Tax Problem in pricing procedure

[Former Member]

Hi,

I define the pricing procedure to sell material.

In the pricing procedure:

1- First I define sales price

2- Discount (condition subtotal = A)

3- and Output Tax / subtotal (condition subtotal = 2)

but when create sales order, system only calculate the sales price, and it did not calculate discount and Tax in the net value.

I want to know that Is it some configuration remained that I forgot?

Thanks.

[Former Member · Accepted solution]

did you maintain the condition records for discounts and tax ,and in the you defined pricing procedure did you include the discounts and Tax condition types in calculating the net price.

[Former Member · Accepted solution]

No , I did not maintain the condition records. How I can maintain it?

I set pricing procedure as follow:

Step____/ Condition Type_____/Description_______/ From_____ / To_____/ Condition Subtotal

10_____ / ZSPR ___________/ Sales Price_______________________________

70_____ / ZSDC_____________/ Discount________/ 10

80________________________/ Net Value________/10 _______/ 70______/ 2

90______/ MWST___________/ Out put tax______/ 80

100_______________________/ Subtotal_________ / 80_______/ 90______/ A

110_____/ VPRS____________/ Cost_______________________________/ B

120_____/ EK02_____________/ Calculated Costs__________________________

130_______________________/ Profit Margin______/ 100______/120 _______________________

in the sales order , it calculated Tax but in net value just put the sales price.

Thanks.

Edited by: Lida Navabpour on Jun 30, 2009 12:16 PM

Edited by: Lida Navabpour on Jul 1, 2009 7:43 AM

[Former Member]

---

[Former Member]

Hello,

Please ensure the discount condition and Tax condition records are maintained.

Please check the condition types are included in the pricing procedure.

in the item level, goto the Analysys and there you can find the why the conditions are not picking.

please revert back it you still face problem

regards,

[Former Member]

I maintained condition record but the problem still remained.

[Former Member]

Please open your sales order, go to ' item conditions' and then go to' analysis' and see what is the issue, why your condition record is not getting picked and let us know.

[Former Member]

Hi Ravindra,

I maintained pricing procedure that I mentioned above. in the sales order screen system calculated Tax, and just show the tax and show the sales price + Tax in the condition tab , but not calculate Tax in the net value. It means that system shows the net value just by sales price + Discount.

I put pricing procedure above, Is it some problem or some configuration that I should set?

Thanks.

[Former Member]

Hi ,

Net price is always without tax, its the net price on the basis of which tax is calculated, final price is the price that takes tax into account, if see the output of your sales order, it will give you more clarification.

Rgds

Ravi

[Former Member]

Hi Ravindra,

Thank you for your reply.

my condition screen in the sales order set as follow:

1- ZSPR---Sales Price Agreement--/1.000

2- ZSDC---- /Discount--

---

/2,000-%----- 20-

3- Total _____980

4- MWST___Output Tax____3,000 %____29

5- Net Value ____1.009

6- VPRS____Cost____1

7- profit margin

as you see, system shows the net price without Tax at line 1, and calculate discount at line 2 .

Out put Tax set in line 4 , it calculated and show the result at line 5.

but in the Net Value just show the total value (line 3 , ZSPR and ZSDC), I want to set the calculation with Tax (I mean result at line 5) in the Net Value.

Is something wrong or not?

Thanks.

[Former Member]

Hi Ravindra,

Thank you for your reply.

my condition screen in the sales order set as follow:

1- ZSPR---Sales Price Agreement--/1.000

2- ZSDC---- /Discount--

---

/2,000-%----- 20-

3- Total _____980

4- MWST___Output Tax____3,000 %____29

5- Net Value ____1.009

6- VPRS____Cost____1

7- profit margin

as you see, system shows the net price without Tax at line 1, and calculate discount at line 2 .

Out put Tax set in line 4 , it calculated and show the result at line 5.

but in the Net Value just show the total value (line 3 , ZSPR and ZSDC), I want to set the calculation with Tax (I mean result at line 5) in the Net Value.

Is something wrong or not?

Thanks.

[Former Member]

Hi Lida,

There is nothing wrong with your procedure, nor with your calculation. It's just that on the basis of Price, discounts and rebates you calculate Net Price and on the basis of Net Price and Tax you calculate Total Price.

For Ex :

ZPR0 Price- Test 1,500.00 INR 1 EA 1,500.00

Gross Value 1,500.00 INR 1 EA 1,500.00

ZTK3 Promo Discount % 3-T 3.000- % 45.00-

Discount Amount 45.00- INR 1 EA 45.00-

Rebate Basis 1,455.00 INR 1 EA 1,455.00

Net Value for Item 1,455.00 INR 1 EA 1,455.00

Net Value 2 1,455.00 INR 1 EA 1,455.00

Net Value 3 1,455.00 INR 1 EA 1,455.00

ZZWR Down Pay./Settlement 0.00 INR 0.00

ZTST Output Tax-Test 2.000 % 29.10

Total 1,484.10 INR 1 EA 1,484.10

SKTO Cash Discount 0.000 % 0.00

VPRS Internal price 980.00 INR 1 KG 980.00

Profit Margin 475.00 INR 1 EA 475.00

Rgds

Ravi

[Former Member]

Hi Aravind,

Thanks for your useful reply.

In my understanding, when system calculate the price, sales price and discount will calculated and put the result in Net value.

But system calculate Tax but it does not put the result of that in the net value.

I create invoice from VF01, in this Tcode, system show the Net price, sales price, Tax, etc.

but my questions are :

1- How and where we can calculate Total price (Sales priceDiscountTax)?

2- is it possible to put Discount in the VF01?

Thanks.

[Former Member]

Hi Lida,

I think you wan to see the Net value + Tax = Total Value.

For this in the pricing procedure, please add the Field TOTAL in the Pricing procedure.This will not require any Condition type.

Just introduce a Step in the Priicng procedure total with the basis of calculation FROM and TO Step.

It will suffice your requirement.

Regards

Montee

[Former Member]

Hello,

Please ensure the discount condition and Tax condition records are maintained.

Please check the condition types are included in the pricing procedure.

in the item level, goto the Analysys and there you can find the why the conditions are not picking.

please revert back it you still face problem

regards,

[Former Member]

Hello,

Please ensure the discount condition and Tax condition records are maintained.

Please check the condition types are included in the pricing procedure.

in the item level, goto the Analysys and there you can find the why the conditions are not picking.

please revert back it you still face problem

regards,

[Former Member]

Hello,

Please ensure the discount condition and Tax condition records are maintained.

Please check the condition types are included in the pricing procedure.

in the item level, goto the Analysys and there you can find the why the conditions are not picking.

please revert back it you still face problem

regards,

[Former Member]

Hi,

Just a common check, if ,you have maintained the condition records or not.

You can also check whether any condition exclusion is maintained.

For tax you can maintain Print : S

Rgds

Ravi

[Former Member]

In case of Discount,maintain the Step Number of Sales Price Condition Type in front of From Column.

After that in the last ,maintain a Text - Net Value without any condition Type and then write the Step Number from IstCondition Type to the last one in front of From Column.

Hope it will help you.

Best Regards,

Ankur