topic Re: Excise Reverse for goods return from customer? in Application Development and Automation Discussions

Excise Reverse for goods return from customer?

avinash_p1 — Mon, 07 Sep 2015 09:42:48 GMT

Hello Experts,

Our client done billing for Quantity 10 and posted the accounting document then excise also captured like below Illustration.

Illustration 1: Excise duty payable A/c CR 100

Excise Duty paid A/c DR 100 (it is correct)

Then customer returned goods for 2 Quantity for that return delivery done and accounting documents posted. But excise is not reversed.

for that when we use the J1IH transaction the excise accounting entries going wrong.

Actual reverse entry should be Excise duty payable A/c DR 20

Excise Duty paid A/c CR 20

But when we try to post the document it is taking wrong way : Excise duty payable A/c CR 20

Excise Duty paid A/c DR 20

Not stopping there, when we proceed further, it is picking other GLs like below.

PLA BED CR 20

Excise duty paid DR 20 though we try to post the docuement the following error triggering.

No control parameters exists for actual postings in COAr 1500 and year 2015.

Message no. KM075

Diagnosis

You have not maintained control parameters for controlling area 1500 in year 2015.

Procedure

Maintain the necessary parameters in Customizing under Actual postings -> Control parameters.when we click on the same it's taking to menu path as below.

SPRO--> Profit Center Accounting--> Basic Settings--> Controlling Area Settings--> Activate Direct Postings--> Set Control Parameters for Actual Data.

Please let me know what is the exact reason for the above error.

Re: Excise Reverse for goods return from customer?

Lakshmipathi — Mon, 07 Sep 2015 10:42:03 GMT

Moved from SAP ERP SD Billing to Internationalization and Unicode. Post all your CIN related queries here.

G. Lakshmipathi

Re: Excise Reverse for goods return from customer?

Lakshmipathi — Mon, 07 Sep 2015 10:53:25 GMT

when we use the J1IH transaction the excise accounting entries going wrong

Which option you have used in J1IH? For taking excise credit, you should click "Additional excise".

G. Lakshmipathi

Re: Excise Reverse for goods return from customer?

avinash_p1 — Mon, 07 Sep 2015 11:07:06 GMT

Hi, I have to reverse the excise which is captured excess earlier. so i have used J1IH, other adjustment option

Re: Excise Reverse for goods return from customer?

Lakshmipathi — Mon, 07 Sep 2015 11:42:17 GMT

Many times, this topic has been discussed in SCN and all you have to do is to search SCN or Google with the text "Excise Return". Many threads have explained as to how to excise credit has to be taken. Needless to mention, you cannot account quantity but account the value in J1IH.

G. Lakshmipathi

Re: Excise Reverse for goods return from customer?

binoy_vargis1 — Mon, 07 Sep 2015 11:48:08 GMT

Alternately You can use J1IS for this purpose. This will solve your issue. If else please let us know.

Regards

Binoy

Re: Excise Reverse for goods return from customer?

avinash_p1 — Tue, 08 Sep 2015 08:48:26 GMT

Hi I'm not able to post thru J1IS.

Did you understand my requirement?? I have to reverse the excise duty for Rs. 6125 which is earlier captured now the goods returned hence i have reverse the same. It is sales transaction. please let me know.

Re: Excise Reverse for goods return from customer?

former_member192897 — Tue, 08 Sep 2015 09:16:56 GMT

You must use J1IH only. Regarding Error Message KM075, you can check it with your FI team and they will be able to explain you why the Error is appearing and how it can be fixed.

Re: Excise Reverse for goods return from customer?

avinash_p1 — Tue, 08 Sep 2015 09:52:30 GMT

Hi Ashok, J1IH Addtl. excise or Other Adj.????

Re: Excise Reverse for goods return from customer?

Lakshmipathi — Tue, 08 Sep 2015 10:16:30 GMT

I have already told you which one you need to choose in J1IH and without noticing that, you were posting the same query.

G. Lakshmipathi

Re: Excise Reverse for goods return from customer?

PhanikumarV — Tue, 08 Sep 2015 10:43:25 GMT

Normally Both sales & return orders happening in same sales area-System has to stop where the original invoice stopped--what was the actual sales area vs returns order??

If sales area differs-then what was the default excise group & series group assigned(IMG>>Logistics General>>Tax on Goods movement>>India>>business transactions>>Outgoing excise invoices>>maintain default excise groups & series groups)

Later for this series group have you maintained any Utilizations active??(IMG>>Log:General>>Tax on Goods Movement>>India>>Basis settings>>maintain series groups)

Also Both the excise invoices are having same Excise transaction type?? if not what was the Cr/Dr indicator says for this ETT in Table J_1ITRNACC?

As discussed--Why still you haven't tried J1IH with additional excise option by Mr Lakshmipathi..

Phanikumar

Re: Excise Reverse for goods return from customer?

avinash_p1 — Tue, 08 Sep 2015 11:35:23 GMT

Hello Lakshmipathi,

I'm finally proposing following procedure to my client.

Step-1: Actual entry at the time of billing:

Excise Duty Paid A/c DR 100

Excise Duty paid A/c CR 100

Step-2: Reverse thru J1IH (Additional Excise option)

BED Inputs A/c DR 20

Cenvat Clearing A/c CR 20

Step-3: Adjustment entry thru FI:

Cenvat Clearing A/c DR 20

Excise Duty Paid A/c CR 20

J2IUN: Step 1 will be shown in liability, Step 2 will be shown in utilization hence the excess duty is nullified.

Step3 is to nullify the Clearing a/c & reduce the balance in expense a/c .

You may give any inputs may or let me know your views.

Regards

Avinash

Re: Excise Reverse for goods return from customer?

avinash_p1 — Tue, 08 Sep 2015 11:37:41 GMT

I'm finally proposing following procedure to my client.

Step-1: Actual entry at the time of billing:

Excise Duty Paid A/c DR 100

Excise Duty paid A/c CR 100

Step-2: Reverse thru J1IH (Additional Excise option)

BED Inputs A/c DR 20

Cenvat Clearing A/c CR 20

Step-3: Adjustment entry thru FI:

Cenvat Clearing A/c DR 20

Excise Duty Paid A/c CR 20

J2IUN: Step 1 will be shown in liability, Step 2 will be shown in utilization hence the excess duty is nullified.

Step3 is to nullify the Clearing a/c & reduce the balance in expense a/c .

You may give any inputs may or let me know your views.

Regards

Avinash

Re: Excise Reverse for goods return from customer?

PhanikumarV — Tue, 08 Sep 2015 14:56:20 GMT

Please check your step-1 entry--Is it right???

have you checked the my earlier suggestion here--if so what has been identified here??

Phanikumar