want the Excise invoices list utilized through the j2iun

[jayakumarkb_81]

I want the list of excise invoices utilized throught j2iun for the respective document number. kindly suggest how to do this.

I have an idea ,

connect the document number to part2 and from there to excise header and CENSTAT = 'C'.

but i am confused with the date options.

Edited by: jay on Jan 9, 2009 7:42 AM

[Lakshmipathi · Accepted solution]

Dear Jay

Go to J1IIN -> Utilization tab (F6). If the excise details figures (BED, ECES etc) are same as the total of Balance Utilization, then excise utilization is NOT yet done for this invoice

But the best way is go to J2IUN, to click the Display Last Utilization Date and Display Pending Invoice and execute.

thanks

G. Lakshmipathi

[jayakumarkb_81 · Accepted solution]

Dear Lakshmipathi,

Thanks for your replay.

I have the document number which is generated while saving the utilization.

and what i want is list of excise invoices which are utilized aganist that perticular document number not the pending list.

the pending list is taken according to the censtat = ' P ' according to the date range int he j2iun screen from excise header table.