We creating are1 report for that,we want billing document no?

[Former Member]

From j1ia103 (tc) we are running are1 by that we are getting reference document numbers of (delivery,excise invoice). to the reference of delivery document in vbfa table we are getting billing document no,but there showing 2 or 3 numbers.we want exact commercial invoice for the particular excise invoice. 

Is there any other table to get commercial invoice number from the base excise invoice no.

[Former Member]

Hi, kindly check the J_1iexchdr table where you can find the ARE1 document number as well as the excise invoice number. once you get the excise invoice number then you check with J1iin then click on document flow or go to VBFA document flow table.

Thanks

Shibu

[Lakshmipathi]

Have you checked table J_1IEXCHDR ?

G. Lakshmipathi

[Former Member]

i checked in that table. but we will get from the dlfc type. and the reference document no=exnum.

[Lakshmipathi]

Sorry you should check in J_1IEXCDTL where you input Excise TT as ARE1 and execute so that you will get the corresponding Excise Invoice reference and Billing document reference.

G. Lakshmipathi