Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Excise Reverse for goods return from customer?

avinash_p1
Participant
0 Likes
1,743

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.

13 REPLIES 13
Read only

Lakshmipathi
Active Contributor
0 Likes
1,687

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

G. Lakshmipathi

Read only

Lakshmipathi
Active Contributor
0 Likes
1,687
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

Read only

0 Likes
1,687

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

Read only

0 Likes
1,687

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

Read only

0 Likes
1,687

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

Regards

Binoy

Read only

0 Likes
1,687

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.

Read only

0 Likes
1,687

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.

Read only

0 Likes
1,687

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

Read only

0 Likes
1,687

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

Read only

0 Likes
1,687

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

Read only

PhanikumarV
Active Contributor
0 Likes
1,687

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

Read only

avinash_p1
Participant
0 Likes
1,687

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

Read only

0 Likes
1,687

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