How to handle Different excise amounts?

[phanikumar_v3]

Dear All,

Please help for the Following scenario.

Whenever users are creating billing--in Background Excise will be created--that is the Procedure we are following now.

But The billing Document will be blocked for FI postings(Posting Block in VOFA)

Now the issue is whenever user wants release this bill to accounting ---they can change the Excise amounts(JEXP-BED,JECP-Cess,JS&H-SH.Cess)

will be in editable mode--so they can change  condition value for these Condition types.

At The time of Billing through VF01--suppose Excise amounts are 1000Rs(JEXP)+ 20 Rs(JECP)+ 10Rs(JS&H) (10+2+1 on a total of net value 10000 Rs)---So Excise invoice will be created for these amounts in Background.

Now Through VF02--when they are releasing to FI--User may change this amounts to 1100+22+11.(due to All these are editable mode due to the Field Condition amount/value is active)--- Then the amount for Cenvat suspense in Billing varies with Original excise created in Back ground.

How to Control this?

Unfortunately users are not agreed to keep all these excise condition types in display(by using the Condition value/Amounts fields in V/06--If i do then these amounts cannot be changeable even in sales order creation time itself)

My Question here is when the excise amounts in Excise invoice differs with Billing--then system should throw an error and it should not be released to accounting--How??

Pl help in this regard.

Phanikumar

[former_member185462]

Does Excise duty indicator 3 i.e Nil is maintained against customer.

Pradeep.M

[phanikumar_v3]

yes sir--may be my approach need to be corrected at configuration level and let me come back if any issues raised...

thanks for your patience sir and high regards for your helping nature to the people like me.

Regards

Phanikumar

[phanikumar_v3]

Sir--unfortunately my client following this from the past 4 years(creation of Condition records by taking material as a condition)

As mentioned in my previous post i maintained JEXP,JECP,JS&h as 10+2+1 for my material number 20009999.see the screen shot sir.

My question is if i maintain by

1.taking Customer+material as a condition for Excise condition types and also

2. i maintained 3+1=3 in J1ID (Excise indicator for plant and Customer)

But why sytem is fetching the Excise condition amounts(In TAXINN i strongly feel no need to maintain the said combination of Plant+customer--even though maintained will not have actual impact)

Pl clarify sir.

[Lakshmipathi]

I am sorry to say, this thread is dragging like anything though I have very clearly answered to all your queries (How / Why).

Unless you try in your system the logic whatever I have suggested, it will be very difficult to explain again and again.  If you want to achieve via standard configuration, then you should go for configuration change and no other alternate is there.  Please test in your system and update here if you still have any issue. 

G. Lakshmipathi

[phanikumar_v3]

sir-Firstly again thanks for your patience(might be i am testing your patience-- sorry for that sir)

As mentioned i cannot use the Condition of Customer/Material (due to every day there will be creation of 50-100 excisable materials--so every day i need to maintain the Pricing master data and it can't be possible.

My question is If i maintain this Customer+Material combination in pricing master for JEXP and

i maintained  3-nil duty for my customer+plant in j1ID--but still why system is picking the excise amounts(This J1ID have no impact in TAXINN-i think so)

Pl clarify sir..

Phanikumar

[Lakshmipathi]

If i maintain this Customer+Material combination in pricing master for JEXP

As per your screen shot, as I said already, you have not considered customer in condition record though in customer master, it is maintained.  While creating sale order and billing, system will consider condition record first and since in your case, you have maintained for a different combination by not considering customer (definitely, this is not the right approach), system is fetching the excise duty based on material.  Please note ED and Tax should always be with the combination of Customer and Material.

If you are not able to go for creating a new access sequence, then you have to try with the exit I originally suggested above.

G. Lakshmipathi

[phanikumar_v3]

Sir-At billing system find condition record for the Condition material(Pl See the screen shot)

"""""No even ED values would be assigned in tax code against that ED condition type"""---But i think we will not maintain tax codes for excise condition types in TAXINN. If my understanding is wrong pl help--then where we will assign tax codes for excise condition types in TAXINN.

Also see my JEXP(BED Condition type in Billing---no tax code assigned for this Condition type)

Pl Clarify me sir...

[Lakshmipathi]

Just double click again on JEXP so that to your right, system will show for what combination, ED values are populated.  Share that also.

G. Lakshmipathi

[phanikumar_v3]

Sir

Pl see as suggested--system finding condition record for the Condition of Material.

Pl help--find the screen shot.

[Lakshmipathi]

You have not understood my post.  What I said was for some combination, you would have maintained the excise condition type.  You have to select that combination in the Analysis screen.

G. Lakshmipathi

[phanikumar_v3]

Sir--I done like below.

1.Go VF02--go to Item conditions---select JEXP(BED)--Gone into analysis--Expand the JEXP condition type and It's conditions----Click on material Condition--Double click.

pl see the screen shot again and help me sir.

[Lakshmipathi]

The combination what you maintained is wrong since excise is applicable to both customer and material but the combination shows only material.  That is why, you are facing the issue.  Consider adding customer code also in the above combiation, so that your issue would be solved

G. Lakshmipathi

[phanikumar_v3]

Sir--thanks again for your help.

But once after giving this assignments(  Excise Indicator 3 for Customer+Excise Indicator 1 for plant=3 Nil duty in J1ID)--But while creating the new sales order again system is fetching excise amounts--i think this will not have any impact--but due to condition records are fetching from VK11--I used Material as condition for all of my excise condition types)

But sir--normally we maintain tax codes only for Taxes(JCST/JLST due to condition category Tax--so we get Tax code column in VK11--But for JEXP/JECP/JS&H we will never maintain tax codes if it is TAXINN--you can't even see tax code column in VK11 maintenance)

Pl help.

Phanikumar

[Lakshmipathi]

we maintain tax codes only for Taxes

No even ED values would be assigned in tax code against that ED condition type.  That is why, I asked you to check whether different tax codes are there but before that check in billing document what tax code is flowing.

G. Lakshmipathi

[Lakshmipathi]

Also check the billing document condition tab for excise condition type, after clicking the Analysis for what combination, system has fetched the ED.

G. Lakshmipathi

[phanikumar_v3]

Sir Pl find this screen shot..

Thank you sir for clarifying my second query.

Normally all of Customers are not be having any value in this field in CIN details of CMR.

Thank you sir for your patience in helping.

Phanikumar

[Lakshmipathi]

Definitely system should not consider excise value as per the screen shot shared by you.  Ensure that users have not changed that in customer master after creation of sale order in which case, system will consider ED in billing. Check the change log.  Also, for information, there should be a separate tax code for this.  That is for ED & Tax, you should be having one tax code.  Similarly, for Nil ED & Tax, you should have one more tax code.  So ensure that system is considering different tax code in both the cases.

G. Lakshmipathi

[phanikumar_v3]

Sir-Thank for your nice help and also for your valuable suggestion.

Let me try my level best not- to go for any enhancement for this requirement.

But sir--i tried to keep excise indicator in CMR and Plant(I kept 3 in Customer master and 1 for Plant--final excise is 3 in J1ID)But does not work in my case-Still excise amounts are coming to sales order for my customer-we are using TAXINN)

Pl help in this regard..(as far as my understanding-- this J1ID --customer+plant combination is not needed in TAXINN--Pl correct me sir if any)

Phanikumar

[Lakshmipathi]

Not sure where you have maintained 3 and what is the text for that 3. In customer master, you can see CIN tab on top.   Normally, for nill duty, I think, it is a different value.  SAP have given provision to have nill duty for customer.  You have to maintain that.

Coming to your other query, yes if your client are into TAXINN, then it is not necessary to maintained in J1ID but as I said above, you need to have some value in customer master.

G. Lakshmipathi

[phanikumar_v3]

Sir--Firstly thanks for giving your hand in helping me.

yes-- ideally these should be in Fixed values and non-editable.

But here users are asking me if i kept in display--for some customers they have to change these amounts to ZERO( Some customers will attract No excise--i tried to help by using the Condition customer/Material--here the Issue comes is we need to update this  condition material wise--also every day there will be 50-100 new materials will be created which are excisable)

Hope you understood --any more Info pl let me know sir.

Phanikumar

[Lakshmipathi]

Some customers will attract No excise

In that case, via CIN tab of customer master, this can very well be controlled.  There should be some user discipline as far as SAP is concerned and you should not go for user exit to control such users' ignorance.  Still if you want to try with exit, you can try with J_1I7_USEREXIT_EXCISE_BEF_SAVE but again, please discuss with clients' finance team and ask them to pass on the message that it is not a Best Practice but should be controlled by users' SAP knowledge.

G. Lakshmipathi

[Lakshmipathi]

First of all, I am not sure why the excise condition types are in editable mode which ideally should not be.  Secondly, for what purpose, users are changing in billing document.  Ideally, excise values are fixed percent and has to be arrived automatically

G. Lakshmipathi

[Lakshmipathi]

Moved from SAP ERP Sales and Distribution (SAP SD) to Internationalization and Unicode.  As already indicated, please post all your CIN related queries here.

G. Lakshmipathi

[phanikumar_v3]

Oh-its My mistake...

I think this was moved to right place by you sir--pardon me for inconvenience caused.

Pl help in this regard...

Phanikumar