configuring the pricing procedure

[Former Member]

Hi Experts,

My requiremnt is,

1. configure the price inclusive of sales tax = X(Gross Price)

2.calculate the vat of 4% in that = X*(104/100)=y(tax amount of 4%).

3.Net price which is exclusive of tax =X-Y=z(net price).

This is the scenario of the pricing procedure,.

can u help me how to configure the pricing procedure as per this scenario.

Gross price which has to be entered ,while creating the sale order. From that vat 4% output tax which has to be calculated and finally give the net price excluding the tax amount..

I dono on what basis i should select my condition tables.I knw only the basic procedure of pricing .

pls help me urgently.

Regards,

Divya.

[Former Member · Accepted solution]

Hi Divya,

Am assuming you've valid business reasons to have the PP that way..

suggestion:

1) Your list price condition records should be "priced" at net value+ tax.

2) A tax cond type which is defined as "minus" in V/06 definition and condition records are maintained as 4%. If you want it be calculated automatically.. then the condition type has to be defined as "minus" and add a routine in base value with the required logic.

3) Net price = from as step 1 and to as step 2. It'll automatically derive the required net value as step 1- step 2.

for 1) condition tables is purely business decision i.e. ask them on what basis do they decide the sales price?

I hope this helps.

[Former Member · Accepted solution]

Hi,

Thanks a lot for taking ur time and answering me.. I understood ur answer, As per you told I ve maintained the condition record for my tax to be calculated at 4%.

But what about my gross price. For that i need to maintain condition type PR01, conditon record to calculate my vat 4%, and how i will arrive my net price. My condition tables are based on sales office as per the business requirement. And i dont knw how to use the routine with the base price in pricing procedure.

can you pls guide me on this step by step as am a fresher ,

Regards,

divya.

[Former Member]

step Ctyp frm to

10 PR00 tick statistical

80 ZVAT 10 79 tick required caln typ is 80 acc key is mws

90 10 89 tick statistical

120 ZREV 90 119 acc key is erl

Now maintain the records for PR00 and Mainain ZVAT i.e. your condition record as 4%. In V/06 for cond typ ZVAT put the calculation type as H. ZREV is Your final revenue amount, it is a discount condition type and maintain it as 100 % in the condition record.

Hope this is wht you wanted to do.....

Regards

Denish Patel

[Former Member]

Pricing procedure RVAB01(Tax Included in Price) in the standard system for your reference.

Flex Yang

Edited by: flex yang on Mar 27, 2010 3:12 PM

[Former Member]

Hi divya,

This may be helpful for u..

15 0 ZPR0 FACT PRICE STD DOM

200 0 JEXP IN: A/R BED %

405 0 Copy of base value 15

410 0 JEXT IN A/R BED total 15

420 0 BED + AED + SED+CESS 200 202

422 0 ZECP IN A/R % ECess 410 419

426 0 BED + AED + SED+ CESS 420

428 0 copy of Base Value 420

430 0 BASIC + ED + ECESS 10

440 0 JA1X A/R Secondary&Hr ECS 424 429

445 0 BASIC + ED + ECESS+HSCess 420

430 440

550 0 ZIVP IN A/R VAT Payable 445

600 0 Base + ED + ST 445 560

810 0 Net Value 600

Regards,

Dippy

[Former Member]

Hie,

If you open your tax condition type in IMG customizing, then you can see there is a field "calculation type", you select there as "H" i.e.inclusive of tax. This will fulfill your required formula.

Thanks & Regards

Denish Patel

[Former Member]

Hi,

when configuring pricing procedure in vok0 you need to maintain "net price= from step to to steps

exampls

cntyp from to

10 proo

20 koo4 10 20

30 net price 10 20

40 vat 20

50 tax 20

gross price 30 50

I HOPE THIS SOLVE YOUR PROBLEM

Regards

SRINIVASYADAV

[Former Member]

Hi,

You explained me about Maintain pricing procedure from where we make the calculation step wise:

can you explain me briefly about

1. how to choose the gross price(inclusive of vat)

2. net price(exclusive of vat)

3. vat 4%( gross price-net price).

How to select the condition tables on what combination for gross price , for net price and for vat 4%.

Regards,

divya

[sidi_reghioui]

Hi Divya

what special requirement should push you to setup a pricing procedure the opposite way?

just to undertsand