Skip to Content

Need Depot Excise Invoice Date (J1IJ) in Z Report

Dear All,

We have prepared Z report for depot sale for our client.

This report is capturing all the details but the we are not able to fetch date for depot excise invoice which we create through J1IJ.

As depot excise invoice details are taken from J_1IRG23D table which does not contain any date.

At the same time this depot excise invoice doe not get updated in table J_1IEXCHDR.

Now I want to know in which table date for depot excise invoice gets updated & how to bring that date in the report against particular depot excise invoice?

Need logic for the same.

Immediate help on the same would be highly appreciated.

Regards,

Balaji

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 09, 2012 at 06:45 AM

    1) When Depot do MIGO, excise values will get updated in J_1IEXCHDR

    2) When doing J1IJ, excise values will get updated in J_1IEXCDTL

    3) The balance unutilized quantity and value will be in J_1IEXCDTL

    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 09, 2012 at 06:33 AM

    hi

    balaji,

    excise detail for date wise table J_1IEXCDTL IT is for item detail for excise data,

    please check this table dates will available

    Add comment
    10|10000 characters needed characters exceeded