Excise invoice number in J1IJ

[Former Member]

Hi All,

We assign the number range for depot invoice in object J_1IDEPINV. Lets say we have given number from 1-1000.

When I save the invoice in J1IJ it says Depot invoice 1 is created. The question is where will this number store.

I tried J_1IRG23D, J_1IEXCDTL. These table gives only the int excise number which we put manually. And excise invoice number which is done in J1IG.

Where can I find this number. It is required to print the excise number in the print out.Please Help

[Lakshmipathi]

I think, you were checking the field DOCNO in table J_1IEXCDTL which is Internal number.  Have you checked the field EXNUM in which the Excise Invoice number gets stored ?

On your comments

 int excise number which we put manually

can you reconfirm whether this is being entered manually ?  I dont think so

G. Lakshmipathi

[Former Member]

Hi Sir,

Yes it is being entered manually. When check with the users they told it asks for int exc number and they enter manually.

[brinda_r]

Hi,

The number range that you maintain in SNRO for J_1IDEPINV will get updated in J_1IRG23D tableunder field DEPEXNUM when J1IJ is run

Regards,

Brinda

[bsivasankarreddy_reddy]

hi

go to NRIV table this for number for objects, here give you object and execute , then it will come ,all number.

please check his

[Former Member]

Hi,

NRIV gives only the from and to numbers. I want to know all excise invoice number with reference to delivery or billing.

[bsivasankarreddy_reddy]

hi adi

please check the  t code , J1IDEPOTSTOCK1 , this is report for depot excise invoice , i can use for  program print out here depot invoice printed , tables as  j_1irg23d, j_1iexcdtl , tables only

as for lakshmipathi ans can fallow