J1IG issue- Excise entries are getting updated to factory but not depot

[Former Member]

Hello everyone,

We are configuring Depot sales scenario for our client

Where stock is moved from factory to depot and then sales from the depot. we have followed the following process for excise processing for the same

1. Purchase order from receiving plant

2. Outbound delivery referring to PO

3. Stock transfer invoice

4. Excise Invoice

5. Goods receipt at receiving plant

6. Capture excise invoice at Depot(J1IG) ( RG23D is getting posted)

Sales from depot

1. Sales order

2. Outbound delivery

3. Select Excise invoice for delivery (J1IJ)

While doing J1IJ, the system is not displaying any mother invoices to be selected, I have searched well, before posting this query here but could not find solution to our problem anywhere

     

Note: 1. We are using only one batch and J1IG and J1IJ are being done for the same batch( No batch split also as of now)

         2. We have tried with various selection criteria also in J1IJ, to pick mother invoice.

One thing that we observed is a problem with Table updation- 1020 is our supplying plant ( factory ) and 4001 is receiving plant (Depot), the following are the table entries for the same.

Excise item table is not getting updated with receiving plant

Table entry for J_1IRG23D

Table for J_1IEXCDTL

Table entry for J_1IEXCHDR

we have checked all the basic configurations but we could not make out the reason for this strange system behavior

Please help us out

Thanks in advance

Krishna P

[phanikumar_v3]

please provide the SAP Note number which corrected your issue???

Phanikumar

[binoy_vargis1]

Hi,

Have you solved this issue. please update. If solved close the issue

If any issue please let us know.

Regards

Binoy

[Former Member]

Hi Binoy

This issue has been solved now, on applying a note specially released from SAP, I am closing this thread now

Regards

Krishna

[Lakshmipathi]

Why don't you share the note reference?

[arnabsarkar2601]

Hi Krishna,

may be the problem exists due to the wrong updating of table. So just try out one activity. Please run the program SAPMJ1IJ and check after that what is the value in the table.

Regards,

Arnab

[Former Member]

Hi Krishna,

The values in the screen shot that you have shared are quite confusing.

I believe the excise group 14 is depot excise group. Check all the depot related settings for plant & excise group in the CIN customization.

The plant in the J_1IRG23D table is 1020 but it should be 4001 depot then only that excise invoices will be displayed in J1IJ.

Once again cross check all the relevant settings & process the cycle.

Regards,

S.Himavanth.

[Former Member]

Hi Himavath

Thanks for your response

That is what the issue is , the reason for mother invoices not getting displayed is due to table updation to supplying plant instead of receiving.

We have checked all the configuration settings ( excise groups, series groups, Excise registers and their assignments etc) they all seem to be fine.

But we could not find out the reason for this system behavior,

Is there anything else that is to be done specifically for this process Other than the standard excise settings , let me know

Regards

Krishna

[binoy_vargis1]

Think your basic settings are incorrect. Check which plant you have maintained as depot.

SPRO--> Logistics General--> Tax on goods movement--> India-->Basic Settings--> Maintain Plant Settings

SPRO--> Logistics – General--> Tax on Goods Movements--> India--> Basic Settings--> Maintain Excise Groups

Check whether you have maintained the depot check against right plant and Excise group.

Change the settings and check again

Regards

Binoy

[Lakshmipathi]

Might be a silly question.  Has that plant (depot) is checked for Depot in Maintain Plant Settings configuration?

G. Lakshmipathi

[Former Member]

Hi Binoy

Thanks for the response

but

These were the first things that we checked for, they have been correctly maintained

We have given the same Excise register no s in the concerned Excise groups

Please let us know, if there is anything else that could be checked for

Regards

Krishna

[Former Member]

Hi Laksmipathi

Thanks for your response but that was the first thing we have checked ,

that seems to be fine

Regards

Krishna

[Former Member]

Hi Krishna,

Share the screen shot of J1IG with details in the first screen.

S.Himavanth.

[Former Member]

Hi Himavath

All that seems to be fine 14, is the depot excise group , Material document number is also the document number of the depot