Discount to vendor after excise

[Former Member]

Dear SAP expert,

I am configuring following pricing procedure in MM,

Gross Price                 1000

+ Tax  (2% on 1000)         20 (Tax code is used)

Total                            1020

- Discount                       20

Landed cost                 1000

For this I created new condition type & added in pricing procedure after Total. When I enter this condition in PO the system deduct the discount value from base value of tax & calculates the tax as below

Gross Price                 1000

+ Tax  (2% on 980)        19.6

Total                            1019.6

- Discount                       20

Landed cost                 999.6

I want to know is there any routine that I can use in MM pricing procedure against Discount condition so that discount value will not consider for tax base value calculation. So I can get 1000 as landed cost.

Thanks in advance

Subhash P.

[Former Member · Accepted solution]

From  where  you have   to  take  the  condition 

please  maintain  from  and  to  for condition  type   for  Z001  condition  Type  .

please check and  revert  Back .

[Former Member · Accepted solution]

Dear Anil,

The condition is manual & fixed amount, so it is not required to give From & To for that condition.

Regards

Subhash P,

[brinda_r · Accepted solution]

Hi,

Do not assign any subtotal to Z001 condition.
Ensure that no alt base routines are assigned to TAX conditions in tax procedure.

Regards,
Brinda

[Former Member · Accepted solution]

Thanks Bindra,

I used workaround,

I maintained tax code by adjusting the % of tax. So I get the desired result. But again this is not advisable as I have to create tax code every time if there is such condition.

Still I will work on this.

Thanks for your assistance.

Regards

Subhash P.

[Former Member]

Hi,

Same problem i also faced

Tax code condition type take absolute value(20) instead of 2%.

Regards,

Hanmanth

[Former Member]

Dear,

Open your condition with t code M/06 , select calculation type as A & save.

Regards

Subhash P.

[brinda_r]

Hi,

Check if there is any alt base routine is assigned to BASB condition in tax procedure.

Regards,
Brinda

[Former Member]

Dear Brinda,

Thanks

The Base type 362 is used in Tax procedure. This I can't change now. That is why I want to know any routine that I can assign to condition type in MM pricing procedure to exclude this condition from tax base price.

Kindly suggest.

Regards

Subhash P.

[brinda_r]

Hi Subhash,

Assign subtotal 6 to discount condition in MM pricing procedure and check.

Regards,
Brinda

[Former Member]

Thanks,

But it still gives same result.

Regards

Subhash P.

[brinda_r]

Hi Subhash,

No if subtotal 6 is assigned, it should work.
Can you attach screenshot of your setting?

Regards,
Brinda

[Former Member]

Hi,

Find the below screenshots of Pricing procedure & Condition type (Z001)

Regards

Subhash P.

[brinda_r]

Hi,

Cannot see any screenshot.

Regards,
Brinda

[Former Member]

Regards

Subhash

[brinda_r]

Hi Subhash,

The settings look fine.
Change subtotal to 4 and check if there will be any change.

Regards,
Brinda

[Former Member]

Thanks

No effect....... I other routins also. But no effect. How to understand the effect of these routines??

Any way you know.

Regards

Subhash P.

[brinda_r]

Hi,

In your tax procedure you have 362 alt base routine assigned to BASB right?
If yes then there will be impact with subtotals 4 or 6.

Regards,
Brinda

[Former Member]

This message was moderated.

[brinda_r]

Hi Subhash,

Your reqt is to consider PR00 value as base value instead of PR00 - discount right?
So 362 to BASB in tax procedure with subtotal 4 to Z001 condition should suffice your reqt.

Regards,
Brinda

[Former Member]

I want the following

Gross Price                 1000

+ Tax  (2% on 1000)         20 (Tax code is used)

Total                            1020

- Discount                       20

Landed cost                1000

What u are saying may be correct, but I am not getting the result that I want after doing changes as you suggested. Is there any thing else that need to check?

Regards

Subhash P.

[brinda_r]

Hi,

I though it the other way round, I thought you want tax to calculate after discount. Sorry for the mistake from end.
But you want discount to calculate after tax.
Try using JEXS condition in pricing procedure which will hold the tax value.
After that you can calculate Z001 on PR00 - JEXS.

Regards,
Brinda

[Former Member]

Hi,

There is still miscommunication.

Gross Price                 1000

+ Tax  (2% on 1000)         20 (Tax code is used)

Total                            1020

- Discount                       20 (manually entered by user- Not calculated automatically)

Landed cost                 1000

For this I created new condition type & added in pricing procedure after Total. When I enter this condition in PO the system deduct the discount value from base value of tax & calculates the tax as below

Gross Price                 1000

+ Tax  (2% on 980)        19.6 (when I enter 20 rs as discount it change t0 19.6, otherwise it is 20)

Total                            1019.6

- Discount                       20 (manually entered by user- Not calculated automatically)

Landed cost                 999.6

You said about JEXS, this condition is already there, you can see in my previous screenshot.

Regards

Subhash P.