Excise Invoice number and Internal Number

[Former Member]

Hello Friends

I have some queries ,I will be thankful to you if you could guide me, in understanding themu2026

1) When we see the document in J1IEX ,in excise invoice tab, we see two fields :Excise invoice number and Internal Number.

For Internal number we define the range in object J_1INTNUM, but how do we define range for Excise invoice number

2) Where do we maintain the relation between GRPO (Excise Transaction type) with the Excise Invoice number

3) When do we require updating of register ,is it done on daily bases, and how can we see the entries of RG23A part 1.

4) We have excise invoice number range of posted ,in process and cancel documents which is assigned to GRPO transaction type, while running J1I7 though we select last option part 1 posted and part 2 not posted, still the system shows the cancelled documents, How can I avoid the cancel documents

Thanks

Siddharth

[amit_choudhary6 · Accepted solution]

Excise Invoice number or Vendor excise invoice number does not have a number range object. Excise Invoices are received from vendors and the numbers are externally put. Thus there is no number range for them. System automatically generates an Internal Number.

[Former Member]

1) When we see the document in J1IEX ,in excise invoice tab, we see two fields :Excise invoice number and Internal Number.

For Internal number we define the range in object J_1INTNUM, but how do we define range for Excise invoice number

-->> Ex inv nbr will be entered based on the vendor ex invoice .. this is external nbr assignment

2) Where do we maintain the relation between GRPO (Excise Transaction type) with the Excise Invoice number

--->> there is no relation between grpo vs. ex inv nbr

3) When do we require updating of register ,is it done on daily bases, and how can we see the entries of RG23A part 1.

-

---

>> u can see in J1I7 or thru table J_1IPART1

4) We have excise invoice number range of posted ,in process and cancel documents which is assigned to GRPO transaction type, while running J1I7 though we select last option part 1 posted and part 2 not posted, still the system shows the cancelled documents, How can I avoid the cancel documents

-

---

>> wait for others answers..

[Former Member]

4) We have excise invoice number range of posted ,in process and cancel documents which is assigned to GRPO transaction type, while running J1I7 though we select last option part 1 posted and part 2 not posted, still the system shows the cancelled documents, How can I avoid the cancel documents

-

---

>> its a work around.. u can find the diff in the table J_1IPART2, here u give the internal nbr what it has in grpo for doc. while reversing system is not creating another internal nbr , its overwriting on the same nbr,, and u can see two line items one will have the debit indicator and other will have cr indicator..

[Former Member]

Raju,

1) My question is : What steps should i take ,so that while running T-code J1i7,I dont see the the cancelled documents ,when i select the last option ( Part one posted and part 2 not posted)?

We have not given the excess of T-code se11 to endusers,so it will not be possible for the enduser to excess the table,and to check out the cancle documents.

Enduser does not want to see the cancel documents in the j1i7 T-code,Tell me how can one can solve the problem?

2) When we run T-code j2i9,we can see the details of the documents,which tell about the excise amount,documents number,in short it tell about the part 2 register,similarly how can i see the details of part 1 register in which i want to see the updated material quantity against the PO number.

hope now my both requirements are more clear