To exclude a pricing condition in net value calculation

[Former Member]

Hello,

How do I exclude a pricing condition (surcharge) in the sales order net value? 

Eg.

Selling price = $100

Surcharge (percentage based) = 10% = $10

Net value shown in the sales order overview screen should show $100 instead of $110

Thanks in advance.

Regards

[prabakaran_gurusamy2]

why don't u try exclusion indicator in condition record and it can be set at condition type level as well

Regards,

Prabakaran Gurusamy

[Former Member]

hi,

as moazzam said, you can keep stastical check box checked it will not include to net price, what is the business requirement to exclude this condition surchage from net value?

warm regards,

jagadiish

[Former Member]

The surcharge is actually an interco mark up.  Users do not want it to be added to the order net value.

If I tag the pricing condition as 'statistical', it will not post to FI. 

[moazzam_ali]

Can you share the complete accounting entry for this scenario?

Thank$

[Former Member]

The accounting entry should be:

Dr Customer a/c

Cr Revenue

Cr Interco AR

Cr Tax a/c

[Former Member]

If we consider Accounting Entries, then what amount should be Credited to Revenue Account $100 /$110 or $90. Who will Pay additional $10 (Customer or Revenue Account).

If Customer is not liable to pay additional $ 10 then Accounting Entries should be -

Dr Customer - $100

Cr Revenue - $100

Dr Revenue GL Account - $10

Cr Interco AR -$10

If you want above entries to hit accounting document in this manner, then you have to Configure 2 Condition types

1. Surcharge Condition Type ZSUR = $ 10

2. InterCo Condition type ZINT ( Make it Discount Condition and refer Condition ZSUR) = $10-

Your Pricing Entries will Look

Pr00=100

ZSUR = 10

ZINT = -10

Net Price = 100

Try this,if it helps

Regards

Amit

[moazzam_ali]

Dear

You can try with making this condition as accrual. In V/06 Control Data 2 tick the accrual field and try with maintaining respective G/Ls in VKOA. It will not add amount in net value but post it in FI.

Thank$

[Former Member]

Yes I am looking into this option.  But the accounting entries don't seem right.  It is posting to both revenue a/c (as from the AccKey in V/08) and the accrual a/c (as from the Account Keys Accrual in V/08)

[Former Member]

Sorry I make a typo.

The accounting entries should be:

Dr Customer a/c

Cr Revenue

Cr Interco Revenue (not Interco AR)

Cr Tax a/c

Eg.

Selling price for the material = $100.  We add 5% to it.

Dr Customer (our affiliated company)

Cr Revenue a/c $100 (for material)

Cr Interco Revenue a/c $5 (5% intercompany markup)

Cr tax

Customer will pay $100 + $5 = $105

[moazzam_ali]

Dear

In VKOA you have to assign both debit and credit G/Ls with one account key in one line. Did you try this?

[Former Member]

Yes I did. 

If I specify both G/L account and Provision acc. in VKOA, the entries look like this:

Dr Customer a/c

Cr Revenue $100

Cr Interco Revenue $5

Dr Acrrual a/c $5

Cr Tax a/c

The results I am trying to achieve is:

Dr Customer

Cr Revenue $100 (for material)

Cr Interco Revenue a/c $5 (5% intercompany markup)

Cr tax

[Former Member]

Correct me, if i am wrong ,if customer is liable to pay $105 then Don't you think our accounting entries should be

Dr Customer $105

Cr Revenue $100 (for material)

Cr Interco Revenue a/c $5 (5% intercompany markup)

Cr tax

I am still not clear about the purpose of not showing additional Surcharge in Order/Billing.

Amit

[Former Member]

Yes the accounting entries you mentioned is what I want.

Sorry I should have said the surcharge is actually the interco markup. 

[Former Member]

Don't you think we can achieve above entries through Standard process

PR00- $100 Revenue Account through Account key

ZINT -$5   Intercompany account through Different account Key.

Why do you want to Exclude  $ 5  Surcharge Condition when customer has to pay this amount.

Regards

Amit

[Former Member]

Amit,

There is no surcharge.   I configured the interco markup as 'discount/surcharge' in V/06 so I conveniently called it 'surcharge'.  I am not excluding anything either. 

We sell material to our affiliated company, so on top of the material cost, we charge them a markup (5% of the material cost).  But the user do not want to include the markup in the sales order net value.

Hope this clarifies.

[former_member184065]

Dear,

First of all ,Do what I say .this way ,you can accomplish this with standard way in SAP .

If you don't want to add any Condition type amount to Net Value and wants post that amount to FI  then don't check the Box " Statistics " for that Condition type in Pricing Procedure and also maintain two keys as Account Key and Accrual Key after that just check the Accruals for that Condition Type in V/06 under Control Data 2 and Maintain G/L accounts for  two keys as Account key and Accrual Key  in VKOA ,then raise Sales order and Billing and after check the Accounting entries .

Thanks,

Naren

[Former Member]

Thanks Naren.

I have already done what you have mentioned.  The interco markup (surcharge) was not included in the sales order value => Good.  However the accounting entries were not correct.  It posted one more entry to the accrual.  I need it to go to the revenue a/c.

[former_member184065]

Dear ,

One thing wants from your side is Tell me How you want Accounting Entries in Accounting Document .Based on thats ,User will be followed on this query to give inputs ( Clarity ).

Thanks,

Naren

[Former Member]

I have posted in my earlier thread.

Here you go:

After config change,

Dr Customer a/c

Cr Revenue $100

Cr Interco Revenue $5

Dr Acrrual a/c $5

Cr Tax a/c

The results I am trying to achieve:

Dr Customer a/c

Cr Revenue $100 (for material)

Cr Interco Revenue a/c $5 (5% intercompany markup)

Cr tax

[former_member184065]

Dear,

The results I am trying to achieve:

Dr Customer a/c

Cr Revenue $100 (for material)

Cr Interco Revenue a/c $5 (5% Inter Company Markup)

Cr tax

Note : If you want accomplish your requirement then go for Creation of New Routine for that Condition Type ( We have to explain as Dont want add that condition amount to Net Value in Sales order ) then only I think might be possible .

If you have any doubts please let me know.

Thanks,

Naren

[moazzam_ali]

Tick the static check box in V/08 for Surcharge condition type.

Thank$

[eduardo_hinojosa]

Hi

See also SAP Note 201830 - Calculation of the net price of an item

Regards

Eduardo