Pricing in formula based

[Former Member]

Dear all,

I am trying a pricing procedure in formula based.  ( I have not worked in TAXINJ ).  I need input on the following senario:

Client wants to sell an  X material from one plant to another plant  ( Doing a normal sales i.e. Order- Deliver -Billing).

There will be a Basic price    say                        1000

Then The user will input  BED   manually               90

                                        ECess  manually               8

                                       SHCess manually              9 

                                        SAD     manually             30

total value of tax                                                  137

( +of BED+ECess+SHcess                                 

  +SAD)

Total Value                                                         1137

( +Basic price+Ecess+Shcess+

    SAD )

How Can this be worked out in Formula based.  What are the settings need to be done.  ?

How the GL account  are maintained for  the excise part ?

Client wants that during Billing in VF01  the excise entries should go to  ( Ed recv on product) and automatically there should be  corresponding contra entry  for the excise part i.e. ( BED,Ecess and SHCess payable  )  Is this the same setting which we do during TAXINN  "Excise Inv during billing" and where are the GL accounts for this payable should be maintained ?

Kindly guide me on this scenario and how to configure.

[Lakshmipathi · Accepted solution]

First of all, I dont understand why the user should key in the ED values manually which should have, ideally been automated.

With regard to FI postings, first check your pricing procedure what Account Key is assigned to these three condition types.  It would be EXD, in normal circumstances.  So go to OB40, double click this Account Key and assign whatever G/L Account client requires.  Of course, you may have to check with your FI consultant also as they are the one, who should take care of this.

G. Lakshmipathi

[Former Member · Accepted solution]

Thanks Lakshmipathi for your reply.

The reason behind the Value should be manually becasue  the value of the BED , Ecess,  Shcess and SAD are not fixed means based on the materail value they would input manually it is not the standard  percentage. and that is the reason the user does not want a percentage . He wants a fixed amount.

That is the reason.

Moreover Right now I have made some changes for an existing pricing procedure and I have inculded the JMAN (MANUAL excise)  condition type. So the user will add manually what ever the amount based on the assessable value that will include the (BED , Ecess and Schess and SAD).  This is an alternative requirement which is given to the user.

Now my doubt is

If I do not input the condition for ECess and Shcess  will the document be passed on to accounting? 

( Becasue the amount of this condition type will be zero)

[Lakshmipathi · Accepted solution]

means based on the materail value they would input manually

Hope you are aware of the option in J1ID to maintain the Assessable Value and if you maintain the value here, irrespective of your selling price, system will consider ED, Cess & HECess based on this assessable value only.  So still I feel, you can ask user to maintain here.  If not, as you said, user can key in manually the ED alone.  Let the other two condition types be automated.

G. Lakshmipathi

[Former Member · Accepted solution]

Thanks lakshmipathi for your reply.

Ya I am aware of that. 

As you said earlier that in OB40  there  you the Acct key called EXD.  right... I have checked the pricing procedure there they have inputed the EXD account key. But what I also found is that . They are mainting a condition record  for UTXJ based on a set of combination.  for that a TAX code is assigned. 

Based on the tax code if you go to FTXP and check based on the chart of accounts it is showing a different key  i.e. MW1  , ZSC and ZS1 for the respective percentage. and the  desired GL account has been assigned  .

Now my question is what is the use of EXD , and why role does it play. And is this the normaly way in formula based calculation ?

[Former Member · Accepted solution]

Dear  Lakshmipathi .

Thanks for your input.

I have got some idea on the UTKJ  as I mentioned above.  The GL account is not maintained for EXD. It is mantained  MW1, ZSC and ZS1. Thanks for giving suggestions.

Regards,

K